Normalization Exercise BIS 422 Database Management Systems T

Normalization Exercise BIS 422 Database Management Systems The following table contains data about procedures performed on patients: PatientProcedure Charge PayzicianID PeysicianSpecialtyd 32968 Mary Len/2008 111-1 Examination 3500 100 102 Internal 409s? Emery L912/200s 111.1 910/200s 222.1 Ray. 32968 Baker, May 3104 32968. 924/2008 111.1 Eurasinatiaa 3500 102 Latemal Medicine 1. Use arrows to show the functional dependencies in the table. 2. Convert the table to 3NF

Solution

Functional Dependencies

Tables after 3NF

underlined are primary keys and Italicized are foreign keys.

PatientID is the foreign key in table PATIENTPROCEDURE which refers to primary key PatientID in PATIENT table

ProcID is the foreign key in table PATIENTPROCEDURE which refers to primary key ProcID in PROCEDURE table.