Cloud Database Development and Management

Table Normalization and Windows Azure SQL Database  ◾  81

e table FACULTY uses the column FacultyID as the primary key. Since there is only

one nonkey column in the table, this means that there is no transitive dependency in the table.

erefore, the table FACULTY is in 3NF.

In general, a table has no transitive dependency if each nonkey column except the foreign key

column in the table directly depends on the primary key. is means that even if we add the for-

eign key column FacultyID to the table STUDENT_CLASS (Table 3.6), it is still in 3NF.

Now, if you want to change a faculty name, you can do it in the FACULTY table displayed in

Table 3.