Assignment 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 1683004

Assignment 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.