Assignment - Consider the following relation definition and sample data (PROJECT)
|
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
|
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: ProjectID → EmployeeName. T or F
B: ProjectID → EmployeeSalary T or F
C: (ProjectID, EmployeeName) → EmployeeSalary T or F
D: EmployeeName → EmployeeSalary T or F
E: EmployeeSalary → ProjectID T or F
F: EmployeeSalary → (ProjectID, EmployeeName) T or F
G: What is the primary key of PROJECT?
H. Does this table contain partial dependency and/or transitive dependency?
I. Describe two modification anomalies from which PROJECT suffers.
J. In what normal form is PROJECT?
K: Redesign this relation to eliminate the modification anomalies. Please give the table (structures) with data.
Attachment:- Assignment File.rar