📄
EBIS3003-2021
  • Introduction to the Course
  • Preliminaries
    • donorschoose.org
    • Installing Software
    • Sequel Pro Local Access
    • Import donorschoose.org Data to MySQL Server
    • MySQL Setting for Client Software
  • SQL
    • Class Activity 2 - Creating New Tables (Week 2)
    • Inserting Table
    • Select / Functions
    • Grouping
  • PYTHON
    • Installing Anaconda
    • Running Jupyter Notebook
    • Connecting MySQL via Python
  • Assignments
    • In-class Activity - ER (Week 5)
    • Homework Assignment 1
      • Solutions
    • Homework Assignment 2
    • In-Class Activity - Python (Week 11-12)
    • In-Class Activity - Normalization (Week 14)
Powered by GitBook
On this page

Was this helpful?

  1. Assignments

In-class Activity - ER (Week 5)

Week 4

PreviousConnecting MySQL via PythonNextHomework Assignment 1

Last updated 4 years ago

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.

Suggested Answer:

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.