1. Identify the normal form, then normalize the following database table: Hospit

Question

1.      Identify the normal form, then normalize the following database table:

Hospital(Patient, Insurance, Doctor, {Test, Result})

Functional dependencies include:

Patient --> Insurance, Doctor
Patient + Test --> Result

Sample Data
Patient    Insurance Doctor     Test        Result
Tweety     Red Cross Livingston Brain Scan Not Found
Tweety     Red Cross Livingston Blood work Yes and red
Sylvester Red Shield Kilder     Cat Scan    Yes he is a Cat
Sylvester Red Shield Kilder     X Rays      No broken bones
Sylvester Red Shield Kilder     Flea check None

2.      Identify the normal form, then normalize the following table:

Faculty(FacID, FacName, Office, Phone)

Functional Dependencies include:

FacID --> FacName, Office, Phone
Office --> Phone

Explanation / Answer

1)

Patient(PatientId, Doctor, Insurance )

Diagnose(PatientId,Test,Result)

Hospital( Doctor, Department)

2)

Faculty(FacID, FacName)

Details(FaccID, Office, Phone)

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.