Discuss the below:
Q: Consider the following relation definition and sample data:
EmployeeName PeojectID TaskID Phone TotalHours
Don 100A B-1 12345 12
Don 100A P-1 12345 12
Don 200B B-1 1345 12
Don 200B P-1 12345 12
Pam 100A C-1 67890 26
Pam 200A C-1 67890 26
Pam 200D C-1 67890 26
PROJECT-HOURS (EmployeeName, ProjectID, TaskID, Phone, TotalHours)
Where EmployeeName is the name of an employee
ProjectID is the name of a project
TaskID is the name standard work task
Phone is the employee's telephone number
TotalHours is the hours worked by the employee on this project
Assuming that all of the functional dependencies and constraints are apparent in this data, which of the following statements is true?
A. EmployeeName > ProjectID
B. EmployeeName >> ProjecID
C. EmployeeName > TaskID
D. EmployeeName >> TaskID
E. EmployeeName >: Phone
F. EmployeeName >: TotalHours
G. (EmployeeName, ProjectID) > TotalHours
H. (EmployeeName, Phone) > TaskID
I. ProjectID > TaskID
J. TaskID > ProjectID
Answer these questions:
K. What are all of the determinants?
L. Does this relation contain a partial dependency? If so, what is it?
M. Does this relation contain a multi-value dependency? If so, what are the unrelated attributes?
N. Redesign this relation to eliminate the modification anomalies. How many relations did you use? How many themes does each of your new relations contain?