Given the schema SCHEDULE (Prof, Office, Major, {Book}, Course, Quarter) along with: F: fd1: Prof {Office,

Question:

Given the schema SCHEDULE (Prof, Office, Major, {Book}, Course, Quarter) along with:
F: fd1: Prof → {Office, Major} and D: mvd: Prof --->> Book
a. Identify the primary key of SCHEDULE such that SCHEDULE is a first normal form relation schema.
b. Normalize SCHEDULE to fourth normal form.
c. Indicate the entity integrity and referential integrity constraints.