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



Source link

Leave a Reply

Your email address will not be published. Required fields are marked *