Write candidate keys and referential integrity constraints

Assignment Help Database Management System

Reference no: EM1368712

Consider the table:

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 at most once per day. Also assume that only one employee represnts a given project, but that employees can be assigned to multiple projects.

A. state the functional dependancies 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.

Reference no: EM1368712

Questions Cloud

Economic profit and break even : Will the firm realize an economic profit, break even, or incur an economic loss and how much will the profit or loss be - also how much will the profit or loss be

Show reproductive processes of the organization : What kind of actions might you look for in your organization that lead to good strategic practice

Prepare appropriate training progam : Find an issue at Wal-Mart that can be improved by developing a training program. How might the training be delivered?

Essential components of an effective training program : new employee training for the call center customer service representatives of an investment management firm.

Write candidate keys and referential integrity constraints : Transform the tables into one or more tables in BCNF. Write the primary keys, candidate keys, and referential integrity constraints.

Leverage and power in nogotiation : Leverage and Power in Nogotiation - Describe how you think power and influence tactics interact with gender during negotiations.

Important information about population-ecology model : Identify three writers/researchers who are associated with the Population-Ecology model describing their contributions. Then relate this model (benefits and/or problems) to one real-work experience.

Quantative analysis network models : Briefly explain the steps of the shortest-route technique as well describe the minimal-spanning technique.

Legality of risk management : what would you do if you were in charge of the issue and what could the organization have done to avoid the event

User Account

All Pages