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 |
|
phpgirl
Starting Member
1 Post |
 Posted - 2012-02-25 : 17:24:54
|
Hello everyone.I started studying for php web developer this year, and one of my classes is Databases. To be sincere with you, i was not paying attention at classes too much, and now i have to do my first assigment, and im as good as clueless about how to do it. Can you provide me with some tips about it?Here is assigment: quote:
Create model of database for hospital (one relations diagram is enough). This database needs to have data about staff and patients. Staff can be nurse, doctor, etc. Every patient can be tied for only one doctor. One doctor can have many patients. Every patient owns a chart(idk if chart is a right translation, the book/paper where all of his data and data about illness is stored) where data about his medical condition is stored (this chart can contain more than one disease, but it is not necessary).After creating model of database , make SQL orders for creating database tables.Make commands for entering and updating staff and patients in database.Result should be given in 2 formats:text file for commandspicture or PDF for diagram
Sorry for bad translation, my English is not perfect.Thanks in advance for your help. Jovana |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-02-25 : 18:07:54
|
| Show us what you have done so far and say where you are stuck. We're not going to do it all for you.--Gail ShawSQL Server MVP |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-25 : 18:19:00
|
| or learn the basics of data modeling and make a start------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Assigment for school