Use the database tables below to answer the following questions.
-By using an intersection table, which field can be removed from the TimeSheet table?
A)Total Hours
B)Week Ending
C)Project ID
D)EmployeeID

Question

Use the database tables below to answer the following questions. 
-By using an intersection table, which field can be removed from the TimeSheet table?
A)Total Hours 
B)Week Ending 
C)Project ID 
D)EmployeeID

Quizplus · Accepted Answer

Since the intersection table will hold the relationship between the TimeSheet and Project tables, the Project ID field can be removed from the TimeSheet table to avoid redundancy and promote data normalization. The Total Hours and Week Ending fields are unique to each employee's timesheet and should be retained in the TimeSheet table. The EmployeeID field is also essential for identifying which employee the timesheet belongs to.

Use the Database Tables Below to Answer the Following Questions