The figure below shows a table called GRADE REPORT for a university.
|
StudentID
|
Student_
Name
|
Campus_
Address
|
Major
|
CourseID
|
Course_
Title
|
Instructor_
Name
|
Instructor_
Office
|
Grade
|
|
16830045
|
Williams
|
208 Brooks
|
IS
|
IS 350
|
Database Mgt
|
Codd
|
B 104
|
A
|
|
|
|
|
|
IS 465
|
Sys. Analysis
|
Parsons
|
B 317
|
B
|
|
54329107
|
Baker
|
104 Philips
|
Acctg
|
IS 350
|
Database Mgt
|
Codd
|
B 104
|
C
|
|
|
|
|
|
Acct 201
|
Fund Acctg
|
Milier
|
H 310
|
B
|
|
|
|
|
|
Mkgt 300
|
Intro Mktg
|
Bennett
|
B212
|
A
|
Assume that students can take multiple courses and has only one major; also assume that one course is taught by one professor.
1) Describe deletion, update, and insertion problems for this table.
2) In what normal form is this table?
3) State the functional dependencies in this table.
4) Then decompose this table into 3NF.