Question 10. Challenge Question

a) Given

EMPLOYEE [ENo, Dept] and

DEPT [DNo, Manager]

Bold is underline Where DEPT.Manager References EMPLOYEE.Eno and EMPLOYEE.Dept References DEPT.Dno

Do we add the department to the database first or the department manager? Devise a strategy for creating these tables and inserting the first set of data without violation of the referential integrity constraint.

b) Given the schema LOAN [branch, customer, loanno, amount]

where loanno amount, branch Note that one loan can have many customers and one customer can have many loans. Is LOAN in BCNF? Y/N _______ If not, decompose into BCNF relations