View Single Post
Join Date: Jan 2008
Posts: 6
Reputation: haycalmom is an unknown quantity at this point 
Solved Threads: 1
haycalmom's Avatar
haycalmom haycalmom is offline Offline
Newbie Poster

Re: need help e-r diagram

 
0
  #5
Oct 6th, 2008
If you're still looking for help....

First off, it looks to me like your data requirements are not all entities. Looking at your list it seems like you should have an entity supplies with attributes of surgical, non-surgical, pharmaceutical, etc.

Same with patient, attributes in, out, next of kin, and so on.

Once you figure these out you need to look at how they relate to each other.
i.e.--A doctor sees many patients.
However, I see a lot of many to many relationships in there and you'll have to fix those with another entity.

I'm just starting out with db design too so I can help you out with the simplified stuff.
Drink coffee--Do stupid things faster
Reply With Quote