Normalization. A college maintains details of its lecturers' subject area skills. These details comprise:
Lecturer Number
Lecturer Name
Lecturer Grade
Department Code
Department Name
Subject Code
Subject Name
Subject Level
Assume that each lecturer may teach many subjects but may not belong to more than one department.
Subject Code, Subject Name and Subject Level are repeating fields.
Normalize this data to Third Normal Form.
After 3nf normalization, give all the sql commands for creating all the tables that you end with.