Question: Assignment 2 The figure below shows a table called GRADE REPORT for a university StudentIDStudent Major ID Instructor Instructor Name ress tle Name 16830045 Brooks

Assignment 2 The figure below shows a table called GRADE REPORT for a university StudentIDStudent Major ID Instructor Instructor Name ress tle Name 16830045 Brooks IS IS 350 Database Mgt ? 104 IS 465 nalysis B317 329107 Baker104 Philips IS 350 Database Mgt ? 104 t 201 Fund Acctg Milier H 310 Mkgt 300 Intro Mktg Bennett B212 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
