Consider the Un-normalized Entities Student and Lecturer. For each case study starts with the unnormalised entity given and the business rules given, normalize the entity up to forth normal form (4NF). 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. Dependency diagrams must be drawn and entities must be written in First Normal Form (1NF), Second Normal Form (2NF) and Boyce Codd Normal Form (BCNF). 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 Crow-Foot ER Diagram for each design indication the connectivity. Give descriptive names for the Relationships. Resolve all N:M relationships. 1. STUDENT DATABASE Consider the following set of requirements for a University database that is used to keep record of students, lecturers and other personal at the University Abbreviations used: Stud-Student, Dep-Department, HOD-Head of Department, DOB-Date of Birth Student (Stud Nu, Stud_Name,_Stud_Addr, Stud_Phone, DOB, Gender, Year, Dep_Code, Dep_name, HOD_PersonnelNu, HOD_Name, Dep_Phone, Secretary_PersonnelNu, Secretary_Name, Hostel_Name, Hostel_Phone,_Hostel_Head_PersonnelNu, Hostel_Head_Name, RoomNu) Use the Business rules of a) and show all the steps to get the above Entity in 4NF. Draw an ERDiagram for your Normalized Database Designed. Use the Business rules of a) and show all the steps to get the above Entity in 4NF. Draw an ERDiagram for your Normalized Database Designed. a) The University keeps track of each student's name, number, ID-number, current address and phone, date of birth, gender, year of study. The name of the department (Dep) offering the diploma the student is enrolled for is also required. For the department information the department code(Dep_Code), Dep_name, Dep_Phone, HOD of the department and secretary is needed. It can happen that a department doesn't have a HOD or a secretary. A Department can have only one HOD and one Secretary. A staff Member can only be the HOD of one Department. If the student stays in a hostel, the name of the hostel, phone, name of the head of the hostel and the room number where the student stay is needed