. Assuming that total_hours are the hours worked by an employee on a given PROJECT (irrespective of the task), i.e. Don
Posted: Fri May 20, 2022 10:42 am
. Assuming that total_hours are the hours worked by an
employee on a given PROJECT (irrespective of the task), i.e. Don
worked 12 hours on PROJECT 100A and 12 hours on Project 200B and so
on. (different assumption than what you see in the
table)
Based on assumption in part c, convert the original
ASSIGN_HRS table into 3NF
(hint: identify the dependency first and then convert into
3rd NF)
d. Assuming total-hours are the number of hours worked
by an employee on a given task for a given project, i.e. Don worked
12 hours on task B-1 Project 100A, worked 12 hours on task P-1 on
Project 100B etc..
Based on assumption in part d, convert the original
ASSIGN_HRS table into 3NF
(hint: identify the dependency first and then convert into
3rd NF)
employee on a given PROJECT (irrespective of the task), i.e. Don
worked 12 hours on PROJECT 100A and 12 hours on Project 200B and so
on. (different assumption than what you see in the
table)
Based on assumption in part c, convert the original
ASSIGN_HRS table into 3NF
(hint: identify the dependency first and then convert into
3rd NF)
d. Assuming total-hours are the number of hours worked
by an employee on a given task for a given project, i.e. Don worked
12 hours on task B-1 Project 100A, worked 12 hours on task P-1 on
Project 100B etc..
Based on assumption in part d, convert the original
ASSIGN_HRS table into 3NF
(hint: identify the dependency first and then convert into
3rd NF)