1 Identify the normal form then normalize the following data

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

BOOKS (patron name, home phone, lib. card#, bookId#, due date, book id#, due date, book id#, due date%u2026.)

            Note that a library patron can check out up to 100 books at a time.

2.      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

Solution

1)

BOOKS (bookId# , book name, due date )

IdDetails(lib. card#, patron name,home phone,bookId#)

2)

Patient(PatientId, Doctor, Insurance )

Hospital( Doctor, Department)

Treatment( PatiedntId, Doctor, Test,Result)