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-20 : 20:27:20
|
| Hi to everyone.Can anyone help me with this project (exam) ???I really need help.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 operatorso Determinant ORDER BYo Determinants GROUP BY and HAVINGo Determinant TOP NProject :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) |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-02-20 : 21:01:30
|
Sorry, we don't do homework or projects or exam question.You can at least give it a try and ask specific question if you have any doubts
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
nairsanthu1977
Starting Member
2 Posts |
Posted - 2011-02-23 : 09:47:21
|
... And how you are expecting us to help you .? |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2011-02-23 : 10:52:14
|
quote:
Can anyone help me with this project (exam) ???I really need help.
Yup I can help you.1) Relax - the stuff you are doing isn't that hard. It probably just seems like a lot but you'll have all the stuff you need. If you don't then google is your friend and so is the SQL SERVER DOCUMENTITION. It's called BOOKS ONLINE.2) If you need help and know it then go talk to your tutor / prof / teacher / whatever - that's why they are there3) We don't answer homework questions but we (well I anyway) am pretty happy to look at code someone's produced and then answer *specific* quertions they have about that code. If you make a stab at it and then post what you've done and what you need then the specifics will be looked at.4) Remember that this is a SQL SERVER forum so if your course is using another database vendor (oracle, mysql, etc) then you may not get the best help.Good luck, chill out, talk to the tutor.Charlie.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
|
|
|
|
|
Help me with exercise