Class Number Class Name Term Spring CIS 3777 Database Spring CIS 3293 Analytics 103 Spring CS 5213 ENROLLMENT Student Student Advisor Advisor Id Name Id Name Bill Sandeep 101 Milatur 902 Goyal Tom Dave 102 Morrow 909 Thomas Sharon Cash 903 Jake Jones Sharon 103 Cash 903 Jake Jones Sandeep 104 Stan Doff 902 Goyal Sandeep 104 Stan Doff 902 Goyal Crystal 105 Ball 903 Jake Jones Crystal 105 Ball 903 Jake Jones ERPI Software Dev Spring CIS 3393 Schedule TR 11:00- 12:20 TR 2:00 3:20 MW 3:30- 4:50 TR 8:00- 9:20 TR 11:00- 12:20 MW 3:30- 4:50 MW 2:00- 3:20 TR 12:00 1:20 Spring CS 3777 Database Spring CIS 5213 ERPI Spring CS 5223 ERP II Fall CS 5233 ERP III The following functional dependencies were inferred from the data in this table shown above: Full: Student Id, Term, Class Number Partial Functional: Student Id Student Name, Advisor Id, Advisor Name Partial Functional: Class Number Class Name, Schedule (could be part of full) Transitive: Advisor Id Advisor Name a. What normal form is the ENROLLMENT relation currently in? Why? (4 points) b. If ENROLLMENT relation is not in 3NF, normalize this table so it meets 3NF. You may either draw a set of normalized relations (boxes and lines) or a "data model (ERD). You must include primary and foreign keys and how they are linked to each other. Also highlight the assumptions, if any, that you are making. (16 points)