Question 14: The university database maintains information about stud…

The university database maintains information about students, the courses they take, and the departments offering those courses. The relation is designed as follows:

Enrollment$(Student\_ID, Student\_Name, Course\_ID, Course\_Name, Dept\_Name, Dept\_Head)$

The functional dependencies applicable to Enrollment are:

$\begin{aligned} &\mathcal{F} = \{Student\_ID \rightarrow Student\_Name, \\ &Course\_ID \rightarrow Course\_Name, \\ &Course\_ID \rightarrow Dept\_Name, \\ &Dept\_Name \rightarrow Dept\_Head\} \end{aligned}$

Based on the above data, answer the given subquestions.