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?

Question

Bryant Dunlap

Computers & Technology

7 July, 08:11

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?

+2

Answers (1)

Know the Answer?

Lorelai Ross · Answer 1

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