Question: Table 2 - Book Table BookID Title Price ISBN Date Pub. Publisher Edition Language B 1 1 1 Mysteries of the Cosmos $ 2 2
Table Book Table
BookID Title Price ISBN Date Pub. Publisher Edition Language
B Mysteries of the Cosmos $ Galactic Press Second English
B Journeys Through Time $ Historical Insights First English
B Culinary Delights $ Gourmet Kitchen Third French
Is the Book table above in st normal form? If not, what changes are needed to convert it to NF
Is the Book table in nd normal form? If not, describe the changes needed to comply with the requirements for NF Be specific.
Lastly, is the Book table in NF If not, in addition to the changes you have described in questions & what additional changes would be needed to assure compliance with NF Be specific.
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
