In-class Activity - ER (Week 5)
Week 4
Last updated
Was this helpful?
Week 4
Last updated
Was this helpful?
The figure above shows a grade report that is mailed to students at the end of each semester. Prepare an ERD reflecting the data contained in the grade report. Assume that each course is taught by one instructor. Also, draw this data modeling using the tool you have been told to use in the course. Indicate what you chose as the identifier of each entity type on your ERD.
Student I D was chosen as the identifier for the STUDENT entity type as it is likely unique. Course I D was chosen as the identifier for the COURSE entity type as it is likely unique. Instructor Name was chosen as the identifier for the INSTRUCTOR entity type and it is assumed to be unique—should discussions during analysis work prove otherwise, it may be wise to create either (a) a composite identifier comprised of Instructor Name and Location, or (b) a new attribute Instructor I D that will be a unique number which can serve as an identifier (latter option would, in practice, be the most likely one).
Note: The addition of the Semester and Year attributes on the Registers For relationship allows this diagram (and resulting database) to reflect multiple semesters of data.