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.
Functional dependencies in Staff Meeting
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