Class scheduling ERD

By Amjad Azeez
$16.99
Subjects:
ERD (Entity Relationship Diagram)
Level:
Bachelors/Undergraduate
Types:
Assessment, Homework
Language used:
English

Suppose you have the following scenario:

A college of Computer Sciences has hired you to create a DBMS to help in scheduling classes. After several interviews with the president, you have come up with the following list of entities, attributes and initial business rules:

  • Room is identified by Building ID and Room No and also has a Capacity. A room can be either a lab or a classroom. If it is a classroom, it has an additional attribute called Board Type.
  • Media is identified by MType ID and has attributes of Media Type and Type Description.
  • Computer is identified by CType ID and has attributes Computer Type, Type Description, Disk Capacity, and Processor Speed.
  • Instructor has identifier EmpID and has attributes Name, Rank, and Office Phone.
  • Timeslot has identifier TSIS and has attributes Day of Week, Start Time, and End Time.
  • Course has identifier Course ID and has attributes Course Description and Credits. Courses can have one, none, or many prerequisites. Courses also have one or more sections.
  • Section has identifier Section ID and attributes Enrollment Limit.

Product preview

Product/Solution

No reviews yet.