Question

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

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.

Homework Answers

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:

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Please give me an example of a EER modeling diagram for managing instructor's schedule (office hours,...
Please give me an example of a EER modeling diagram for managing instructor's schedule (office hours, classes,etc.) at a College/University.
Design a (conceptual) EER Diagram using ERDPlus. Can you prepare a diagram based on the ErdPlus...
Design a (conceptual) EER Diagram using ERDPlus. Can you prepare a diagram based on the ErdPlus diagram? Required conditions below For the lecture Database Management System You want to establish a Student Society (i.e. IEEE Student Branch, or Robotics society). You want to develop a software to make life easier (for more than one student societies). Below are the requirement for establishing a database design for a generic Student Society management software: - System should allow arbitrary number of student...
a gymnastic school with hundreds of students. It needs a database to track all the different...
a gymnastic school with hundreds of students. It needs a database to track all the different classes that are being offered, who is assigned to teach each class, and which students attend each class. Also, it is important to track the progress of each student as they advance. Design a database for the following requirements: Students are given a student number when they join the school. This is stored along with their name, date of birth, and the date they...
[1] Please draw an ERD based on the following description. The requirements collection and analysis phase...
[1] Please draw an ERD based on the following description. The requirements collection and analysis phase of the database design process has provided the following data requirements for a company called Reliable Rentals, which rents out vehicles (cars and vans). The Company has various outlets (garage/offices) throughout Glasgow. Each outlet has a number, address, phone number, fax number, and a manager who supervises the operation of the garage and offices at each site. Each site is allocated a stock of...
Directions: Develop an E-R (or EER depending upon need) Diagram. List all assumptions. Show the version...
Directions: Develop an E-R (or EER depending upon need) Diagram. List all assumptions. Show the version 1 (entities and data only) and version 3 (entities, attributes and relationships with cardinalities and participation constraints). 20 points of the grade will be based on evaluating your assumptions - you must give a detailed list of your assumptions identifying anchor concepts, data associated with the anchor and data that has more than one anchor participating in it. Remember, we are not talking out...
Hello, can you teach me how to draw a Use Case diagram for this given scenario?...
Hello, can you teach me how to draw a Use Case diagram for this given scenario? I also need to include all the extends and includes relationships. Case Description Acme Drug Stores (ADS) which consists of a chain of retail stores across Canada wants to be able to provide a new online customer service system. Each store has an identifying store no, address, phone, and email. The company dispenses a wide range of pharmaceutical (drug) products. Each product has a...
Description In this project you will practice what we have learned in class about Design, ER...
Description In this project you will practice what we have learned in class about Design, ER Diagrams, Relational Models, DDL, SQL, CRUD (Create, Update, Delete) operations, associated queries, and mock data population. The goal is to create a realistic professional database/development experience. This assignment will describe the requirements for the database as you might receive them. You will need to fill in the details as you work on it. You will find that your work may be iterative, and you...
please can you make it simple. For example using scanner or hard coding when it is...
please can you make it simple. For example using scanner or hard coding when it is a good idea instead of arrays and that stuff.Please just make one program (or class) and explain step by step. Also it was given to me a txt.htm 1.- Write a client program and a server program to implement the following simplified HTTP protocol based on TCP service. Please make sure your program supports multiple clients. The webpage file CS3700.htm is provided. You may...
1) Describe an example of each of the following that may be found of your kitchen:...
1) Describe an example of each of the following that may be found of your kitchen: Explain how your choice falls into this category, and if there is a chemical name or symbol for it, provide that as well. Provide a photo of your example with your ID card in it. a) a compound b) a heterogeneous mixture c) an element (symbol) Moving to the Caves… Lechuguilla Caves specifically. Check out this picture of crystals of gypsum left behind in...
for the scenario below: 1) Apply the qualitative analysis by identifying at least 3 issues in...
for the scenario below: 1) Apply the qualitative analysis by identifying at least 3 issues in the above process. Analyse these issues by using a. Adding-value and Waste Analysis b. Issue register, If you find that there are more than three issues, you can focus on the three issues that have the highest impact. 2). Calculate the cycle time efficiency of the as-is process. You can assume a working week of 40 hours. In case there is missing information, you...