Functional dependencies in Staff Meeting

by | Aug 22, 2021 | Assignment

Consider the table: Staff_Meeting (Employee Name, Project Name, 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 at 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 the tables into one or more tables in BCNF. State the primary keys, candidate keys, and referential integrity constraints. C. Is your design in part B an improvement over the original table? what are the advantages and disadvantages.

We help you get better grades, improve your productivity and get more fun out of college!!

Homework Answers Online

Free title page

Free reference page

Free formatting

Unlimited revisions

Get answer to your homework