Posted - 02/19/2011 : 18:32:25
| Hi to everyone.
Can anyone help me with this project (exam) ???
I really need help.
Contact me :
email@example.com - online
firstname.lastname@example.org - 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
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)