DATABASE NORMALIZATION Improving Database Design through Normalization Continue improving the database (tables) you designed Here are your
Fantastic news! We've Found the answer you've been seeking!
Question:
DATABASE NORMALIZATION
Improving Database Design through Normalization
Continue improving the database (tables) you designed Here are your tasks:
- Discuss whether the tables you designed have satisfied 1NF, 2NF, and 3NF. Explain why or why not.
- Make changes if the tables do not meet the requirement of the 3NF.
- Write Oracle SQL statements to create the tables you have designed, and populate the tables with data.
Expectations
Fulfill the following requirements in this assignment:
- Discuss the requirement for the first, second, and third normal form.
- Present reasons why or why not the tables in the database you designed have satisfied the three levels of normal form.
- Discuss what you are going to change so that all your tables satisfy at least the third normal form standard.
- Write SQL statements to create the structure of the tables, specify primary and foreign keys, and populate the data.
Related Book For
Posted Date: