Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Project (Proj_num, Emp_Num, Proj_Name, Emp_Name, Job_Class, Chg_Hour, Hours) Functional dependencies Proj_Num? Proj_Name Emp_Num ?Emp_Name, Job_Class, Chg_Hour Emp_Num, Proj_Num ? Hours Is it in 2 NF?
Project (Proj_num, Emp_Num, Proj_Name,
Emp_Name, Job_Class, Chg_Hour, Hours)
Functional dependencies
Proj_Num? Proj_Name
Emp_Num ?Emp_Name, Job_Class, Chg_Hour
Emp_Num, Proj_Num ? Hours
Is it in 2 NF?
Convert it to the 2NF.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started