The following figure shows a grade report that is mailed to students in the end of each semester.

Prepare an entity relationship diagram (ERD) reflecting the data contained in the grade report.

Note: You do not have to provide data types. Be sure to designate the primary key of every entity and

add all foreign keys. If there is a many-to-many relationship, it must be converted into an entity with

two one-to-many relationships.

Assume the following: Instructor names are unique; multiple sections of a course are offered; a

section of course is taught by only one instructor; the combination of course id and section no is

unique within a semester of an academic year.

ABC College Grade Report Fall 2019 Name: John Johnson ID: 1234567890 Address: 2222 Drive A Major: Information Systems Class: Graduate/MS COURSE SECTION COURSE INSTRUCTOR INSTRUCTOR GRADE ID NO TITLE NAME DEPARTMENT IS350 501 Database Codd MIS A ST465 501 Intro. Stat Parsons STATISTICS B This semester's GPA: 3.5 Cumulated GPA: 3.75