Question

Can you please give me an example of an EER modeling diagram for the following description:

Consider a database in which weekly schedule of instructors is stored. For each instructor, name, title (Dr., Prof., Ms., Mr… ) email address, office phone number, semester, the day of week, time slot (e.g. 8 to 9, or 10:30 to 11:30…), availability of the instructor (lecture or lab or office hours), the location that instructor is available/ busy (class room number, lab number, office location…), course number, section number of which the instructor is busy giving a lecture on and time slot are stored. Students can see the instructor’s schedule with all information mentioned above and they can book an appointment with the instructor. Appointment data includes, the student name, time requested and instructor name. Note that this schedule database is used by all instructors in a college and not only for one instructor. That is, students can see the schedule of an instructor among all and book appointment with him/her.

Answer 1

Solution:

ER Diagram:

The entity relationship diagram represents the various entities and the relationship between them which helps us in understanding how the system works.

The entities are nothing but the real world objects.

These entities are connected using the relationships that are present between them.

Their attributes are mentioned with them and are the properties of the entities.

The ER diagram is represented as shown below.

ER Diagram: