To keep track of students and courses, a new college uses the table structure shown below.

a. Draw the dependency diagram for this table. (Draw proper diagram which is clear and correct).

b. Using the dependency diagram you just drew, show the tables (in their third normal form) you would create to fix the problems you encountered. Draw the dependency diagram for the fixed table.

\begin{tabular}{|l|l|l|l|} \hline Attribute Name & Sample Value & Sample Value & Sample Value \\ \hline StudentID & 1 & 2 & 3 \\ \hline StudentName & John Smith & Sandy Law & Sue Rogers \\ \hline CourselD & 2 & 2 & 3 \\ \hline CourseName & Programming Level 1 & Programming Level 1 & Business \\ \hline Grade & 75% & 61% & 81% \\ \hline CourseDate & Jan 5th,2014 & Jan 5th,2014 & Jan 7th,2014 \end{tabular}