Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
xp_vista007
Starting Member
6 Posts |
Posted - 2011-02-19 : 18:32:25
|
Hi to everyone. Can anyone help me with this project (exam) ???I really need help.Contact me :valon90@hotmail.com - onlinev.nuhija@yahoo.com - e-mailsProject 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) |
|
|
|
|
|
|