1. Create an Access database based on this Entity Relationship Diagram. Populate each table with at least five records (use records, rather than typing random characters into each field).
2. Create table relationships as shown in the ERD above.
3. Create a query that will display the Appointment date, the patient information the bill status and the amount. (You may or may not need to use all four tables.)
a. Run the query and display the results. Make a screen shot of the result, and include in your screen shot the lower right-hand corner of your screen which shows the system time and date.
b. Remove the relationship connections.
c. Run the query again.
d. What happens? Write a 1 – 2 paragraph discussion on the results, and explain the advantage of a relational database.
Write your answer to Question 3d, and upload it, along with your Access .accdb file.
Appointment
Bill
DoctorPatient
Appointment Date
PK
Appointment Time
Appointment duaration
Bill Number
PK
Bill date
Bill Amount
Doctor Id
PK
Doctor First Name
Doctor Last name
Patient Id
PK
Patient First Name
Patient Last Name
Appointment Reason
Doctor Id
FK
Patient Id
FK
Bill Number
FK
Bill status