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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-12-30 : 12:12:21
|
| Sid Barouni writes "Hello,Firstly, I would like to thank you for this amazing site. Honestly, it has provided me with most of the knowledge I need in order to be able to write SQL statements or even to design and model Databases.Personally, I have started learning the Database systems three months ago. I have been modelled entity relationship diagram to work with hospital environment. I wondering if you can check it for me if you have got time. I am not sure weather I have got normalised databases, and also I am not sure about the cardinality.The ERD can be downloaded from ERD: http://www.mobofone.com/erd/erd.jpgThe scenario can be downloaded from: SCENARIO Document: http://www.mobofone.com/erd/scenario.docBeofre I can start implementing this with MS SQL server I would like to make sure that I have perfect design.Look forward to hear from you soon.Regards,Sid Barouni" |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-12-30 : 12:40:55
|
| What's the diagram done in?It seems like you're missing a lot of junction tables...For example you have operation and Nurse tables...They are directly related...which means that only 1 nurse can be in on any operationYou need a OperationNurse table that carries both IDs...same with a lot of others..And I don't see any ties between the patient a visit or an operation...Kinda hard to know who getting cut up, or who to bill for waht...Doo a google on data modeling...there are some good guidlines out there..Brett8-) |
 |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-12-31 : 00:45:12
|
| Yup, he is missing nearly all the junction tables for the Operation. I guess it needs to link to maybe 5 tables: OperationSurgeon, OperationNurse, OperationEquipment, etc. The Patient table doesn't have a BedID even though there is a link there. This again should be in another table, the patient could be moved around, no? I also dont see a link between Diagnosis and VisitDiagnosis.OS |
|
|
|
|
|
|
|
|
ERD 