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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Help me with exercise

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 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)

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]

Go to Top of Page

nairsanthu1977
Starting Member

2 Posts

Posted - 2011-02-23 : 09:47:21
... And how you are expecting us to help you .?
Go to Top of Page

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 there

3) 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 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION
Go to Top of Page
   

- Advertisement -