1. The relation below stores information about students, accommodation and personal tutor. Assume that each room in the dormitory building can host more than one student. Attribute "EmailType" can either be staff or student. a. Identify the Primary key for the relation. b. Determine all functional dependencies. From these dependencies, identify which are partial (if any) and which transitive (if any). d. Normalise it to 3NF (*) C. Electricity Bill StudentName Room No Email StudentID Tutor Name EmailType 2. Normalise the following table "T" into the 3rd Normal Form, by clearly describing the normalisation process, i.e. the dependencies removed and how the table is split into sub-tables. For each of the produced sub-tables also describe the functional dependencies. A B D E F G H Attributes (A, B) Forms the primary key. The relation has the following functional dependencies: A, B -> C, D, E, F, G, H B->C D->E E->A F->G, H