SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

xp_vista007
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 :
valon90@hotmail.com - online
v.nuhija@yahoo.com - 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  
 New 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.22 seconds. Powered By: Snitz Forums 2000