Question

MedName PatientID Date RefillsAllowed PatientName Dosage ShelfLife Figure 3: Dependency diagram of a clinic (a) Identify and discuss each of the indicated dependencies. (b) What is a transitive dependency? How to remove it from a table? (c) Normalize the clinic database given in Figure 3 to 3NF, showing the dependency diagrams for each table. (d) Draw the fully attributed ERD of the database based on the 3NF in part (c).

          MedName PatientID Date RefillsAllowed PatientName Dosage ShelfLife
Figure 3: Dependency diagram of a clinic
(a) Identify and discuss each of the indicated dependencies.
(b) What is a transitive dependency? How to remove it from a table?
(c) Normalize the clinic database given in Figure 3 to 3NF, showing the dependency diagrams for
each table.
(d) Draw the fully attributed ERD of the database based on the 3NF in part (c).

MedName PatientID Date RefillsAllowed PatientName Dosage ShelfLife
Figure 3: Dependency diagram of a clinic
(a) Identify and discuss each of the indicated dependencies.
(b) What is a transitive dependency? How to remove it from a table?
(c) Normalize the clinic database given in Figure 3 to 3NF, showing the dependency diagrams for
each table.
(d) Draw the fully attributed ERD of the database based on the 3NF in part (c).

Added by Francisca M.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Tassha Calista

Step 1

- PatientID depends on Patient Name: This means that the ID of a patient is determined by their name. - Date depends on PatientID: This means that the date is determined by the ID of the patient. - Refills Allowed depends on MedID: This means that the number of Show more…

Show all steps

Thanks for your feedback!

MedName PatientID Date Refills Allowed Patient Name Dosage Shelf Life Figure 3: Dependency diagram of a clinic (a) Identify and discuss each of the indicated dependencies. (b) What is a transitive dependency? How to remove it from a table? (c) Normalize the clinic database given in Figure 3 to 3NF, showing the dependency diagrams for each table. (d) Draw the fully attributed ERD of the database based on the 3NF in part (c).