Students and the courses they are registered in Assume that

Students and the courses they are registered in. Assume that each course has only one section and one instructor, and each student has only one major. b. This database is not in 3NF. Explain why.

Solution

A table is in third normal form when the following conditions are met:

It is in second normal form.

All nonprimary fields are dependent on the primary key.

The advantages of removing transitive dependencies are mainly twofold. First, the amount of data duplication is reduced and therefore your database becomes smaller.

The second advantage is data integrity. When duplicated data changes, there\'s a big risk of updating only some of the data, especially if it\'s spread out in a number of different places in the database.

The given table is not in 3NF because each course has only one section and one instructor and each student ha only one major.