Question: Consider the following relation definition and sample data (PROJECT) Where ProjectID is the name of a work project; EmployeeName is the name of an employee

Consider the following relation definition and sample data (PROJECT)

Where ProjectID is the name of a work project; EmployeeName is the name of an employee who works on that project; EmployeeSalary is the salary of the employee whose name is EmployeeName.

Please answer:

A: Describe two modification anomalies from which PROJECT suffers.

B: ProjectID -> EmployeeName True or False?

C: (ProjectID, EmployeeName) -> EmployeeSalary True or False?

D: EmployeeName -> EmployeeSalary True or False?

E: EmployeeSalary -> ProjectID True or False?

F: What is the primary key of PROJECT?

G: List the full, partial, and transitive dependencies (if any).

H: In what normal form is PROJECT?

I: Redesign this relation into 3NF. Please give the table (structures) with data.

ProjectID

EmployeeName

EmployeeSalary

100A

Jones

64k

100A

Smith

51k

100B

Smith

51k

200A

Jones

64k

200B

Jones

64k

200C

Parks

51k

200C

Smith

51k

200D

Parks

51k

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!