Question: 3 . Consider the following relations specified in relational schema notation and data provided in Excel PROJECT ( Proj code, Proj Name, Proj Manager, Team

3. Consider the following relations specified in relational schema notation and data provided in Excel
PROJECT (Proj code, Proj Name, Proj Manager, Team Members, Hours Worked)
EMPLOYEES (Emp Num, First Name, Last Name)
- Team member numbers correspond to hours worked (e.g., team member 100 worked 1000 hours on the Database Upgrade project; team member 101 worked 235 hours on the Database Upgrade project)
- The values in the Proj Manager column and the Team Members column are employee numbers
a. If the initial data above is in 1NF then simply state "the data is already in 1NF" and explain why. If not already in 1NF, explain why and make the necessary changes to transform it to 1NF. Use Excel to create the resulting 1NF table(s) including the data. Use relational schema notation to specify the 1NF relation(s). Be sure to underline the PK in the relational schema notation.
b. If the 1NF data from part a is in 2NF then simply state "the 1NF data is already in 2NF" and explain why. If not already in 2NF, explain why and make the necessary changes to transform it to 2NF. Use Excel to create the resulting 2NF table(s) including the data. Use relational schema notation to specify the 2NF relation(s). Be sure to underline the PK in the relational schema notation.
c. If the 2NF data from part b is in 3NF then simply state "the 2NF data is already in 3NF" and explain why. If not already in 3NF, explain why and make the necessary changes to transform it to 3NF. Use Excel to create the resulting 3NF table(s) including the data. Use relational schema notation to specify the 3NF relation(s). Be sure to underline the PK in the relational schema notation.
3 . Consider the following relations specified in

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!