Transform the table into one or more tables in bcnf

Assignment Help Database Management System

Reference no: EM13772646

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?

Reference no: EM13772646

Questions Cloud

Explain the governance principles of regulatory compliance : Explain the governance principles of regulatory compliance requirements. Determine methods for managing legal risk arising from regulatory compliance issues

What are the differences among the computer forensic tools : Discuss some of the various backup tools available in the market. What are the differences among the computer forensic tools discussed within the chapter

Maximum profit margin for the company to remain competitive : The company's engineer estimated that the production of the new product has a 88% learning curve applied to labor required, and the time to complete the first unit was 54 labor hours. Assume the time required to complete the 10th unit and the competi..

What william shakespeares facebook profile : Have you ever wondered what William Shakespeares Facebook profile would look like, assuming he was alive today?

Transform the table into one or more tables in bcnf : Transform this table into one or more tables in BCNF. State the primary keys, candidate keys, foreign keys, and referential integrity constraints.

Write an essay on drifting vs the death in saudi arabia : Write an essay on Drifting Vs the death in Saudi Arabia.

Three different types of windows : What parts of a home make up the building envelope? What is the building envelope's purpose? What are the main building envelope issues that are addressed during weatherization?

Details and evaluation of the code of conduct : Details and evaluation of the code of conduct related to the case, including the ethical responsibility of the officer

The activities of the firm issues : What is the role of the vision and mission statement in driving the activities of the firm? If there is no vision and/or mission statement,

User Account

All Pages