Assignment 2

The figure below shows a table called GRADE REPORT for a university.

StudentIDStudent_
Name
Campus_
Address
MajorCourseIDCourse_
Title
Instructor_
Name
Instructor_
Office
Grade
16830045Williams208 BrooksISIS 350Database MgtCoddB 104A
    IS 465Sys. AnalysisParsonsB 317B
54329107Baker104 PhilipsAcctgIS 350Database MgtCoddB 104C
    Acct 201Fund AcctgMilierH 310B
    Mkgt 300Intro MktgBennettB212A

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.

Is this part of your assignment? ORDER NOW