Normalization means organizing data in a full database by creating separate tables and establishing relationships among them. When normalizing a table, three rules, or steps, need to be followed.
The first step includes eliminating repeating groups, creating a separate table for each set of related data, and identifying each set of related data with a primary key. For this table, it means separating sets of data that relate to instructors, courses, and regions.
The primary keys for the tables would be Student ID, Instructor ID, Course ID, and City. The second step involves creating separate tables for sets of values that apply to multiple records. In this case, it means reorganizing the instructor, course, and city tables for better data representation. The third step is eliminating fields that do not depend on the key. For this table, it means removing the Student-Code Area, Instructor-Name, Instructor-Office, and Course Name fields from the main table. Lastly, all data needs to be checked to ensure consistency.