7. 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.

Answer both question 6 and question7

6. To keep track of students and courses, a new college uses the table structure in Figure 12.3 Draw the dependency diagram for this table Attribute Name StudentID StudentName CourselD CourseName Grade CourseDate Sample Value 2 Sandy Lavw Sample Value Sample Value John Smith Sue Rogers Programming Level 1 Programming Level 1Business 61% Jan 5th, 2014 81% Jan 7th, 2014 Jan 5th, 2014 Figure 12.3 For question 6, by A. Watt