Consider the relation Student (stid, name, course, year)
Given that
A student may take more than one course but has unique name and the year of joining.
(i) Identify the functional and multivalued dependencies for Student.
(ii) Identify a candidate key using the functional and multivalued dependencies arrived at in step (b).
(iii) Normalize the relation so that every decomposed relation is in 4NF.