CSIS 4720

Task: 1. Given the following STUDENT table which contains a repeating group: STUDENT (STUDENT-NUMBER, STUDENT-NAME, MAJOR, CLASSIFICATION, TOT- CRDITS, GPA, COURSE-PREFIX, COURSE-DESC, CREDIT_HOURS, GRADE, ADVISOR-NUMBER, ADVISOR-NAME)2- For the STUDENT table perform the following:a- Normalize the table into 1NF, 2NF, and 3NF.b- List the primary keys, foreign keys, and all fields for each table you identify at each normal form levelc- Create the

20 Other / Other Fort Valley State University / CSIS 4720 18 Nov 2020