Consider the Un-normalized Entities Student and Lecturer. For each case study starts with the un-normalised entity given and the business rules given, normalize the entity up to third normal form (3NF). The business rules will indicate the functional dependencies between the attributes and the relationships between the entities. If it is not stated explicitly you can make your own assumption. The assumptions you make, must be stated in your answer. All steps in the normalization process must be indicated. Entities must be written in First Normal Form (1NF), Second Normal Form (2NF) and Third Normal Form (3NF). A Final Design must be submitted on which all keys, PK, and FK must be indicated After the normalization process, add any relationships not indicated yet. Draw a ER Diagram for each design indication the connectivity. Give descriptive names for the Relationships. Resolve all M:M/*:* relationships