Question 2 (25 marks) You are given the table: Assignment(instructorId, instructorName, coursecode, courseDescription, courseFee, studentid, studentName, dateEnrolledInCourse, assignmentRunningNumber, assignmentWeightage, assignmentScore) A course may be taught by more than one instructor and an instructor may teach more than one course. A student may enrol in more than one course, and a course may have more than one student enrolled. dateEnrolledInCourse is the date a student currently enrols for a particular course. A course has many assignments, each identified by the course code and a running number generated for each course. assignmentScore is the score a student is awarded for a particular assignment, and assignmentWeightage is the weightage that an assignment contributes to the overall course grade. ________________________________________________________________________________ State your assumption(s) for only data requirements that are not specified. (a) Formulate and list the functional and multi-valued dependencies. (9 marks) (b) Propose candidate key(s) for the table. Show composite keys in brackets. (1 mark) (c) (i) For each MVD in answer to Q2(a), explain why it is subsumed or not subsumed. (ii) Normalise the relation to BCNF and 4NF by applying the BCNF approach covered in the course text. Show how you apply the steps to arrive at the tables and explain whether each derived table at each iteration is already in BCNF and 4NF (if applicable). (8 marks) (d) Assemble your BCNF and 4NF tables clearly and include referential integrity constraint(s), if any, in the forms described below: Tables in this form: TABLE-NAME(col-name1, col-name2, ..., col-namen) indicate (PK) against the primary key and indicate (FK) against the foreign keys, if any. Referential integrity constraint(s), if any, together with the child table in this form: TABLE-NAMEx.col-namex1 ...col-namexn must exist in TABLE-NAMEy.col-namey1...col-nameyn (7 marks)