SQL:

Give all the SQL commands for creating all the tables from the 3NF normalization data.

1. 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 Subject Code, Subject Name and Subject Level are repeating fields UNF Lecturer Number, Lecturer Name, Lecturer Grade, Department Code, Department Nae, Subject Code, Subject Name, Subject Level 1NF Lecturer Number, Lecturer Name, Lecturer Grade, Department Code, Department Name Lecturer Number, Subject Code, Subject Name, Subject Level 2NF Lecturer Number, Lecturer Name, Lecturer Grade, Department Code, Department Name Lecturer Number, Subject Code Subject Code, Subject Name, Subject Level 3NF Lecturer Number, Lecturer Name, Lecturer Grade Department Code Department Code, Department Name Lecturer Number, Subiect Code Subiect Code, Subiect Name, Subiect Level a. After 3nf normalization, give all the SQL commands for creating all the tables that you end with