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 |
|
osama_fadl
Starting Member
2 Posts |
 Posted - 2011-05-07 : 00:47:56
|
| please i have a College task but it was some problems i don't know so any one can help me : the project about hospital patient care Build tables on SQL Server , draw relationship between tables then create procedure to perform these 10 SQL statements1. Perform a report that display the name of each patient and the name of his doctor.2. For each patient, how many appointments he made.3. How many doctors in each department4. Display the name of patient and his last symptoms for each patient.5. Display a list of medications for each patient6. Display the last admission date for each patient7. Display the name of each doctor, the name of the patients, and conditions of the patients he treat them8. Display the most patient’s symptoms in the hospital9. Display the name of doctor who has maximum salary10. Display the number of each patient in each department who left the hospital last month. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-05-07 : 01:41:34
|
| Homework? We're not going to do your work for you. Post what you have so far, explain where you're stuck and we'll advise.--Gail ShawSQL Server MVP |
 |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-05-07 : 09:04:07
|
| Do you have a table structure?That's the first thing to define. Look for entities (what you want to record information about, lok at nouns) in the requirements and turn them into tables for a start then think about whether that looks sensible and update it.Some of the entities can be probably derived from what you have said there.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
osama_fadl
Starting Member
2 Posts |
Posted - 2011-05-07 : 14:52:46
|
| @GilaMonster : i don't mean to do my homework < but it's aproject of 100 requirments and itis 10 of it @nierlrivett : i make it actually and i can give yuo it if you can help me |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-05-07 : 16:28:02
|
| Ok, so show what you've done so far and explain what problems you're having and where. I'm not going to do it for you. I don't need the qualification.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
how can i get it ???