Question 1: (15 points) Normalization is a data analysis technique to design a database system. It allows the database designer to understand the current data structures in an organization. Normalization is a technique for producing relational schema with no information redundancy and no update anomalies. Student Faculty Student D Date of Birth Student Address Course ID Course Name Class Faculty ID Name Faculty Address Name 3 Main Street, James 110 44 March Way. Computingin John Smith 8-Aug-91 North Boston IE 332 E1-F-02 FOI Industrial Eng. Peterson Glebe 55100 56125 16 Leeds Road, Operations James 144 March Way 111 Maria Griffin 10-Sep-92 South Boston 1E 335 E2-FOS FO1 Research Peterson Glebe 56100 56128 21 Arrow Street, 16 Leeds Road Susan Manufacturing 112 13-Jan-91 South Boston 1E 370 E1-5-02 FO2 Sarah Francis South Boston Johnson Processes 56128 56128 3 Main Street, Engineering Shane 105 Mist Road 110 John Smith 8 Aug-91 North Boston IE 343 E1-SOS FO3 Economics Cobson Faulkner $5410 56125 21 Arrow Street Susan Computingin James 112 44 March Way. 13-Jan-91 South Boston TE 332 E1-F-02 FOI Johnson industrial Eng Peterson Glebe 56100 56128 14 Milk Lane Engineering Shane 105 Mist Road, 113 Matt Long 25-Apr-92 South Boston 1E343 El-S-05 FO3 Economics Cobson Faulkner 56410 56128 After investigating the above Table, please normalize it using Student, Course, Faculty, Student Subject Enrolment tables. Draw an entity-relationship diagram of the normalized database (specify the primary key in each Table and specify the type of the relationship)