database comp sci ere diagram

Question

how would an ear diagram look like, this is what I collected from the question Entities:

1. Room

- Building ID

- Room No

- Capacity

2. Classroom

- Board Type

3. Conference Room

4. Computer

- CompType ID

- Computer Type

- Type Description

- Disk Capacity

- Processor Speed

5. Presenter

- Emp ID

- Name

- Rank

6. Seminar

- Seminar ID

- Seminar Description

- Credits

Relationships:

1. Room-Type (1 to 1)

- Room can be either a classroom or a conference room.

2. Classroom-Computer (1 to many)

- A classroom can have multiple computers.

3. Presenter-Seminar (many to many)

- A presenter can be associated with multiple seminars, and a seminar can have multiple presenters.

4. Seminar-Prerequisite (many to many)

- A seminar can have one, none, or many prerequisites.

this is the homework question for clarification

Develop an EER model for the following situation using the traditional EER notation. The EER notation can be drawn by hand on paper or on computer using word or other tools. 

Assignment must be submitted on slate assignment drop box by the deadline.

You were hired to create a database management system for scheduling seminars at XYZ university. After interviews with the staff, you have come up with the following list of entities, attributes, and initial business rules:

1. Every room has a Building ID, Room No and also has a specific Capacity.
2. A room can be either a conference room or a classroom. 
3. If the room is a classroom, it has an additional attribute called Board Type.
4. Computer has a CompType ID and has attributes Computer Type, Type Description, Disk Capacity, and Processor Speed. 
5. Presenter has identifier Emp ID and has attributes Name, Rank.
6. Seminar has identifier Seminar ID and has attributes Seminar Description and Credits. Seminars can have one, none, or many prerequisites (knowledge from attending previous seminars).
7. Seminars also have one or more sessions (one session or a series of seminars).
8. A session has identifier session ID and attribute Enrollment Limit.

After some further discussions, you have come up with some additional business rules to help you

create the initial design:

1. A presenter could teach one, none, or many sessions of a seminar in a given semester.
2. A presenter specifies preferred time slots for scheduling.
3. A room can be scheduled for one session or no session during one time slot in a given semester of a given year. However, one room can participate in many schedules, one schedule, or no schedules; one session can participate in many schedules, one schedule, or no schedules.
4. A conference room has one or more computer types. However, a classroom does not have any computers.
5. A room cannot be both a classroom and a conference room. There also are no other room types to be incorporated into the system.

Answer 1

Hi Mohammad!

I would love to help you with this question, if you would like to schedule a session. Creating ER diagrams and designing SQL databases are one of my expertise. I can help you, with rules I have written how to convert any complex dataset into ER diagram with just a few steps.