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.

You are to write a series of steps that anyone could follow to solve the following three problems: 1. even odd a. assume that someone tells you a number (an integer number) b. you hear the number and respond with the word even or odd 2. average a. assume that someone tells you between 3 and 5 numeric values. b. you hear the numbers and respond with the average is some number 3. dog or cat a. explain to a child the differences between a dog and a cat. b. your explanation could be used by a child or anyone to distinguish the difference between a dog and a cat