Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Help me with project (exam)
 Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

6 Posts

Posted - 02/19/2011 :  18:32:25  Show Profile
Hi to everyone.

Can anyone help me with this project (exam) ???
I really need help.
Contact me : - online - e-mails

Project requirementss :
- All required actions of taks must be performed using SQL Server 2005 Express
- Create a necessary DataBases
- By observing normalization forms (1NF, 2NF and 3NF) create necesary tables depending on the specifications and features of project
- Create a necessary connections (one with much, much with one and much with much) between created tables.
- Create a diagram of connections between tables
- Create at lesat 8 queries :
o Relationships between tables (INNER JOIN, LEFT JOIN, RIGHT JOIN)
o Agregate operators
o Determinant ORDER BY
o Determinants GROUP BY and HAVING
o Determinant TOP N

Project :
Realize gjeneral requirements for the following relations :
- Patient (NrPatient, Name, Surname, Age, Sex)
- Doctor (NrDoctor, Name, Surname, Specialization)
- Visit (NrVisit, NrPatient, NrDoctor, Date, NrDiagnose, NrTherapy)
- Diagnose (NrDiagnose, Description)
- Therapy (NrTherapy, Description)
  Previous Topic Topic Next Topic  
 Topic Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000