Transform the tables into one or more tables in bcnf

Assignment Help Database Management System

Reference no: EM1355425

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. trandform 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: EM1355425

Questions Cloud

Electric field strength at midpoint between the two disks : What is the electric field strength a point on the axis 5.0 cm from one disk between them.

Important information about externality : What is an externality - Why might externalities lead a firm to discharge too much pollution into a river?

Formulate and justify an investment policy statement : Mr. Jones is forty-five years old and is in good health. He is married, and has two children aged 17 and 18. He and his wife own all shares in a Limited Liability Corporation that owns a tavern and adjacent restaurant presently valued,

Difference between a demand function and a demand curve : What is the difference between a demand function and a demand curve - What signs are the cross elasticities for substitute products

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

Effective investment and financial planning strategies : Managers should learn how to use statistical techniques to time, and forecast, as accurately as possible, changes in basic micro and macroeconomic factors.

Distinguish between normal and inferior goods : Distinguish between normal and inferior goods - How can cross elasticities be used to help define the relevant firms in an industry?

By what percent does the period of oscillation change : At a large business, employees must report to work at 7:30 A.M. The arrival times of employees is approximately symmetric and mound-shaped with mean 7:22 A.M. and standard deviation 4 minutes.

General layout for a web-based source document : Suggest the general layout for web-based source document that prospective sellers could use to explain their antiques. Information must include the user ID, password, item, dimensions, origin, condition, and asking price.

User Account

All Pages