23 Emphasis Malaig Question 4: Functional Dependencies and Normal Forms [10 Marks) (CLO 4) CLO4 - Design appropriate database tables using functional dependencies and normal forms. The table below is already in first normal form (1NF). There is only one entry per field. Please convert this table to the third normal form (3NF) Students IDSt Last Name IDProf Prof Grade 1 Mueller 3 Schmid 5 2 Meier 2 Borner 4 3 Tobler 1 Bernasconi 6 4.a Identify the Functional Dependencies by showing the Full Dependecies, Partial Dependencies, Transitive Depdencies (if any). Since you cannot draw provide in descriptive approach showing which attribute has full dependencies (2 Mark) and attributes with partial dependencies. (3 Marks) 4.b Decompose the Students relation data (relation table given above) into a set of 3NF relations. Proide a detail answer such as the primary key and showing the referential integrity of each relation table