Stu_no 20231911 20222010 Course Code IE365 IE348 ClassRoom no 11234 46665 Stu_name Fatima Moza Stu_year 3 4 Grade 3 a) Why do you think that this table is not in 2nd normal form, explain in detail? Generate new tables that obeys the 2nd normal form. b) 4 This table keeps the record of student number, course code, designated room number for the course (which does not change), name of the student, number of years of the student in the university and the grade the student took in the course. (Su_no and Course_code is the composite primary key)
This table keeps the record of student number, course code, designated room number tor the course (which does not change), name of the student, number of years of the student in the university' and the grade the student took in the course. (Su_no and Course_code is the composite primary key) a) Why do you think that this table is not in 2 nd normal form, explain in detail? b) Generate new tables that obeys the 2 nd normal form.