Using Crow’s Foot notation and Visio, draw an Entity Relationship Diagram that captures the business rules given below. For each problem, you will build upon the ERD from the previous problem. As you complete each problem, make sure you take a screenshot of your diagram, and paste it in this Word file. Make sure that no lines cross each other in any of your ERDs.

Note: Make sure that your ERD shows the primary key for each entity set and each relationship is captured using foreign keys. If you have any many-to-many relationships, make sure you break them down into two 1-to-many relationships, so that you can capture them using FKs.

1: A clinic needs to record information about patients and doctors. Doctors are assigned unique IDs upon hiring. New patients are assigned unique IDs on their initial visit. The following additional information needs to be recorded about patients: first name, last name, date of birth, phone number and address. The following information needs to be recorded about doctors: first name, last name, office number, phone number, specialization.

(Hint: For this problem, you need to add two entity sets to your ERD.)

2: Every patient has one primary doctor and that information needs to be recorded. A doctor can be the primary doctor for many patients. (5pts)

(Hint: For this problem, you need to add a relationship to your ERD.)

3: A patient can make many appointments with any doctor in the clinic. A doctor can accept appointments with many patients. Each appointment is made with only one doctor and one patient. For each appointment we need to record the date and time of the appointment and whether the appointment was made over the phone, online or in person (that is, in the clinic).

Hint: For this problem, you need to add an entity set and 2 relationships to your ERD.

Answer rating: 100% (QA)

Step 1 Doctors are assigned with unique ID Where PK denote Primary Key ... View the full answer