Following report shows a grade report that is mailed to students at the end of each semester. Prepare an E-R

diagram reflecting the data contained in the Grade Report. Assume that each course is taught by one instructor.

MILLENIUM COLLEGE
GRADE REPORT
FALL SEMESTER 199X

NAME: Emily Williams ID: 2683000458
CAMPUS ADDRESS: 208 Brooks Hall
MAJOR: Information systems

COURSE TITLE INSTRUCTOR INSTRUCTOR GRADE
ID NAME LOCATION
IS 350 Database Mgt. Codd B104 A
IS465 System Analysis Parsons B317 B

To prepare an Entity-Relationship (E-R) diagram reflecting the data contained in the Grade Report, we need to identify the entities and their relationships described in the report. From the given information, we can identify the following entities and relationships:

Entities:
1. Student
2. Course
3. Instructor
4. Grade Report

Relationships:
1. Student takes Course
2. Course is taught by Instructor
3. Instructor gives Grade in the Grade Report

Based on this information, we can create an E-R diagram as follows:

```
+---------------+ +----------------+ +----------------+ +--------------------+
| Student | | Course | | Instructor | | Grade Report |
+---------------+ +----------------+ +----------------+ +--------------------+
| ID | | ID | | ID | | ID |
+---------------+ +----------------+ +----------------+ +--------------------+
| Name | | Title | | Name | | Grade |
+---------------+ +----------------+ +----------------+ +--------------------+
| Campus Addr | | Instructor ID| | | | Student ID |
+---------------+ | Location | | | | Course ID |
+----------------+ +--------------------+
```

In this diagram:
- The Student entity has attributes: ID (student ID), Name, and Campus Addr.
- The Course entity has attributes: ID (course ID), Title, and Instructor ID.
- The Instructor entity has attributes: ID (instructor ID) and Name.
- The Grade Report entity has attributes: ID (grade report ID), Grade, Student ID, and Course ID.

The relationships are represented by the lines connecting the entities:
- The Student takes Course relationship connects the Student entity with the Course entity.
- The Course is taught by Instructor relationship connects the Course entity with the Instructor entity.
- The Instructor gives Grade in the Grade Report relationship connects the Instructor entity with the Grade Report entity.

Note: Any additional relationships or attributes not mentioned in the given report were not included in the diagram. The diagram can be further expanded or modified if additional information or requirements are provided.