Medical Clinic ERD

What's the best way of doing this?

Using the Crow’s Foot notation, create an ERD that can be implemented for a medical clinic, using the following business rules:
•      A patient can make many appointments with one or more doctors in the clinic, and a doctor can accept appointments with many patients.  However, each appointment is made with only one doctor and one patient.
•      Emergency cases do not require an appointment.  However, for appointment management purposes, an emergency is entered in the appointment book as “unscheduled.”
•      If kept, an appointment yields a visit with the doctor specified in the appointment.  The visit yields a diagnosis and, when appropriate, treatment.
•      With each visit, the patient’s records are updated to provide a medical history.
•      Each patient visit creates a bill.  Each patient visit is billed by one doctor, and each doctor can bill many patients.
•      Each bill must be paid.  However, a bill may be paid in many installments, and a payment may cover more than one bill.
•      A patient may pay the bill directly, or the bill may be the basis for a claim submitted to an insurance company.
•      If the bill is paid by an insurance company, the deductible is submitted to the patient for payment.  
14th_Vermont_VolunteerAsked:
Who is Participating?
 
rrococi2Connect With a Mentor Commented:
0
 
rrococi2Commented:
This looks like a school assignment I had at Boston University.  Are you in school?
0
 
14th_Vermont_VolunteerAuthor Commented:
Yes Sir, I most certainly am and I'm not liking this course.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
LowfatspreadConnect With a Mentor Commented:
hint :

go through the business rules highlighting all nouns and verbs

these will form the basis of the entities and processes that are required...

once you have identified these order them into a set of hierarchies / related objects/subjects

then its time for a second look at the nouns in particular and see if you can identitfy
any supertypes or subtypes  - (e.g. would it make sense to identify doctors and patients as people with there many common attributes....)

then look at the verbs/processes and see what if any business/work entities you will also need to provide... e.g. what does Bill and Installment actually practically mean --- from a business audit/legal view point what will be required to enable you to track and implement these processes (bank accounts, contacts, debt recovery agencies, etc.... ) At this point it is usual to engage the "business owners" in further discussions (via a business analyst) as to what are the basic requirements of the final systems to be implemented....


Data Modelling is fun...., and a vital component of the whole system / application design process...

Good Luck
0
 
AStaCommented:
Best way paper, pencil and draw. :)))
0
 
14th_Vermont_VolunteerAuthor Commented:
Both answers were very helpful.  Thanks guys.
0
 
bruno2gCommented:
               mcsa
0
All Courses

From novice to tech pro — start learning today.