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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!