1 identify the normal form then normalize the following database table hospital pati 5346660

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