Question: 2 . Consider the following relation specified in relational schema notation and data provided in Excel PRODUCT ( Prod ID , Color, Price ) a
Consider the following relation specified in relational schema notation and data provided in Excel
PRODUCT Prod ID Color, Price
a If the initial data above is in NF then simply state "the data is already in NF and explain why. If not already in NF explain why and make the necessary changes to transform it to NF Use Excel to create the resulting NF tables including the data. Use relational schema notation to specify the NF relations Be sure to underline the PK in the relational schema notation.
b If the NF data from part a is in NF then simply state "the NF data is already in NF and explain why. If not already in NF explain why and make the necessary changes to transform it to N F Use Excel to create the resulting NF tables including the data. Use relational schema notation to specify the NF relations Be sure to underline the PK in the relational schema notation.
c If the NF data from part b is in NF then simply state "the NF data is already in NF and explain why. If not already in NF explain why and make the necessary changes to transform it to NF Use Excel to create the resulting NF tables including the data. Use relational schema notation to specify the NF relations Be sure to underline the PK in the relational schema notation.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
