Home / Expert Answers / Mechanical Engineering / stu-no-20231911-20222010-course-code-ie365-ie348-classroom-no-11234-46665-stu-name-fatima-moza-stu-y-pa115

(Solved): Stu_no 20231911 20222010 Course Code IE365 IE348 ClassRoom no 11234 46665 Stu_name Fatima Moza Stu_y ...



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)

student submitted image, transcription available below
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.


We have an Answer from Expert

View Expert Answer

Expert Answer



We have an Answer from Expert

Buy This Answer $5

Place Order

We Provide Services Across The Globe