Solved by an expert
Your boss, kelly, tells you that the users have approved your data model and that
Your boss, kelly, tells you that the users have approved your data model and that you can go ahead and create database structures such as tables. you begin developing the tables for your database and realize that you need to design your table structures so that data integrity is protected. you recall that a process called normalization is used to improve data integrity. what is the best way to normalize this data?
Show Answers
The best way to use data normalization in this example is to use a third normal form (3NF). The third normal forms is in the
second normal form and does not have a transitive functional dependency. Since
it does not have a transitive dependency, there is no data duplication and it
achieves referential data integrity