Subjects:
ERD (Entity Relationship Diagram)
Level:
Bachelors/Undergraduate
Types:
Assessment, Homework
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