Question: Consider the following relation specified in relational schema notation and data provided in Excel BOOK ( ISBN , Book Title, Num Pages, Subject, Publisher ID

Consider the following relation specified in relational schema notation and data provided in Excel
BOOK (ISBN, Book Title, Num Pages, Subject, Publisher ID, Publisher Name, Publisher City, Publisher State)
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.
Consider the following relation 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!