STAFF_Meeting(EmployeeName, ProjectName, Date)
The rows of this table record the fact that an employee from a particular project attended a meeting on a given date. Assume that a project meets a most once per day. Also, assume that only one employee represents a given project, but that employees can be assigned to multiple projects.
a. State the functional dependencies in STAFF_MEETING
b. Transform this table into one or more tables in BCNF. State the primary keys, candidate keys, foreign keys, and referential integrity constraints.
c. Is your design in part B an improvement over the original table? What advantages and disadvantages does it have?