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.