Cloud Database Development and Management

76  ◾  Cloud Database Development and Management

3.3.1 Why Table Normalization

A normalization process is a process to eliminate anomalies that occur in a database operation. To

see what those anomalies are, let us consider the CLASS_REGISTRATON_INFO table shown

in Table 3.1.

In Table 3.1, information about students, faculty members, courses, and classes are stored in a

single table CLASS_REGISTRATON_INFO. is fact indicates that the primary key has to be

a combination of several columns. Indeed, StudentID alone cannot determine the column Course.

For example, the value 11 in the StudentID column cannot determine the values in the Course

colum ...