graziazi
asked on
ERD diagram - needs checking
Hi. I want to design a simple ERD diagram.
I want a patient to be able to have an appointment. A doctor to 'hold' an appointment. An appointment to prescribe one or more prescriptions. A prescription to consist ot one or more medications. An appointment updates a patients record.
Attached is my take on this. Please could you review this and let me know if it seems integral. Thanks
Also I would like to include a many to many relationship somewhere in here
I want a patient to be able to have an appointment. A doctor to 'hold' an appointment. An appointment to prescribe one or more prescriptions. A prescription to consist ot one or more medications. An appointment updates a patients record.
Attached is my take on this. Please could you review this and let me know if it seems integral. Thanks
Also I would like to include a many to many relationship somewhere in here
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
As a general comment I find it more useful to think it through in words and think about what's actually being modelled. At every relationship in your diagram I asked myself "is there a time where this might not be mandatory even though it is currently marked as mandatory?" (Someone doesn't pay their their invoice in full and another invoice needs to be issued for the outstanding amount.) "This is currently marked one to one - is there ever a time when there'd be more than one? (A couple or family jointly attending an appointment with each of them being treated.)
Once you go through it in words like that, the diagram itself is easy. Do the diagram after the analysis, not as *part* of the analysis. :)
Once you go through it in words like that, the diagram itself is easy. Do the diagram after the analysis, not as *part* of the analysis. :)
ASKER
Things I'll need more practise