Identify candidate keys of employee

Assignment Help Database Management System

Reference no: EM132080066

Need help with sql transaction question. Please explain how to reach the solutions for the questions below.

Consider the universal relation

EMPLOYEE(ID, First, Last, Team, Dept, Salary)

with the following set F of functional dependencies:

ID à First

ID à Last

First, Last à ID

Last à Team

ID à Dept

ID à Salary

Salary à Dept

a. Identify candidate keys of EMPLOYEE.

b. Construct a decomposition of EMPLOYEE into relations in 3NF that preserves dependencies. How can you be sure that your decomposition is dependency-preserving?

c. Are all of the relations in your decomposition in BCNF? Either explain why they are, or identify one that is not and explain why it is not. (Note that for a relation to be in BCNF, the determinants of all functional dependencies in the relation must be superkeys of that relation - not superkeys of the original universal relation.)

Reference no: EM132080066

Questions Cloud

Euthyphro definition of holiness : 1. Euthyphro's definition of holiness as what is approved of by all of the gods fails because

Lease shifts more cost uncertainty to tenant than gross : A triple net lease shifts more cost uncertainty to a tenant than a gross lease

Explain example of business decision that would be unethical : Describe and explain an example of a business decision that would be unethical even though it is legal.

Compute the amount of the stock dividend : Tidwell Corporation issued a 4 percent stock dividend on 20,000 shares of its $10 par common stock. At th time of the dividend, the market value of the stock.

Identify candidate keys of employee : Identify candidate keys of EMPLOYEE. Construct a decomposition of EMPLOYEE into relations in 3NF that preserves dependencies.

Write an awk script to display the phone number : Write an awk script called activity6.1-6.awk to display the phone number of the user whose username is assigned to the variable user at the command line.

Determine how to maximize your cash on hand : At time 0, you have $10,000. Investments A and B are available; their cash flows are shown in the table below: Assume that any money not invested.

Perform the test for the non-additive join property : Perform the test for the non-additive join property (lossless join) for the relation R(A1, A2, A3, A4, A5), and the decompositions Da, Db, Dc, Dd .

Emobile technology into healthcare organization : Other considerations of implementing eMobile technology into a healthcare organization?

User Account

All Pages