As 2
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.