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
Get step-by-step solutions from verified subject matter experts
