Consider a school advising system in which a faculty advisor can advise many students, each of whom can register for one or many courses. The following is an example of an un-normalized STUDENT table for three students.
STUDENT
Student Number Student Name Total Credits GPA Advisor Number Advisor Name Course Number Course Description Course Credits Grade
1034 Linda 47 3.60 59 Smith CSC101 Computer Science I 4 B
MKT211 Marketing Management 3 A
ENG101 English Composition 3 B
CHM111 General Chemistry I 4 A
BUS101 Introduction to Business 2 A
3397 Sam 29 3.00 59 Smith ENG101 English Composition 3 A
MKT211 Marketing Management 3 B
CSC101 Computer Science I 4 B
4070 Kelly 14 3.20 23 Jones CSC101 Computer Science I 4 B
CHM111 General Chemistry I 4 A
ENG101 English Composition 3 B
BUS101 Introduction to Business 2 B
Perform the normalization process to convert the above un-normalized table to:
1. First normal form (1NF).
2. Second normal form (2NF).
3. Third normal form (3NF).
Please show all your work. Please show each step along the way and identify primary keys, if any, in each table in each step.