instruction are document – Essay Writers
September 14, 2021
xavier and karthik data science and ps discussions
September 14, 2021

3.58 Consider the table:STAFF_MEETING (EmployeeName, ProjectName, Date)The rows of this table record the fact that an employee from a particular projectattended a meeting on a given date. Assume that a project meets at most once per day.Also, assume that only one employee represents a given project, but that employeescan 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 advantagesand disadvantages does it have?

"Is this question part of your assignment? We Can Help!"

Essay Writing Service