1 identify the normal form then normalize the following database table books patron 5346659
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