Q1. Draw an E-R Diagram for the following situation. At the university system each STUDENT must be assigned an ADVISOR who counsels students about degree requirements and helps students register for classes (COURSE). Each student must register (REGISTRATION) for classes with the help of an advisor, but if the student's assigned advisor is not available, the students may register with any advisor, We must keep track of students, the assigned advisor for each, and the name of the advisor with whom the students registered for the current term. Tips: Attributes of STUDENT include Student ID (the identifier), Name, and Major. Attributes of ADVISOR include Advisor ID (the identifier), Name, and Department. Attributes of COURSE include Course ID (the identifier), Title, and Credits. Attributes of REGISTRATION include Semester, and Year. Based on your background, think of logical and standard relationships between the given entities.

Q1. Draw an E-R Diagram for the following situation. At the university system each STUDENT must be assigned an ADVISOR who counsels students about degree requirements and helps students register for classes (COURSE). Each student must register (REGISTRATION) for classes with the help of an advisor, but if the student's assigned advisor is not available, the students may register with any advisor, We must keep track of students, the assigned advisor for each, and the name of the advisor with whom the students registered for the current term. Tips: Attributes of STUDENT include Student ID (the identifier), Name, and Major. Attributes of ADVISOR include Advisor ID (the identifier), Name, and Department. Attributes of COURSE include Course ID (the identifier), Title, and Credits. Attributes of REGISTRATION include Semester, and Year. Based on your background, think of logical and standard relationships between the given entities.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Construct an E-R diagram for the following hospital: In this hospital, we have many patients (characterized by social security number, name, insurance, the admission date, and the date of check out) received by medical doctor. Each medical doctor in the hospital is characterized by: ID number, name, and specialization. For every patient, the medical doctor will perform one or more tests and examinations to diagnose his illness. Each test or examination is characterized by an ID, name, date, time, and result. In your ER-Diagram, you must specify the key for each entity and all relationship cardinalities.
Q1 Draw the F-R diagram , a collaboration class diagram and petri-net for the following requirements in a college library: there are two types of books: regular and reserved, and two types of users: students and faculty members. A student can check out a regular book for 1 month, while a faculty member can borrow one for 2 months. A late return for all users will incur a fine measured by the number of days, same for students and faculty. A reserved book can be checked out by any user for 4 hours. The fine for the later return is charged by number of hours. Any user who returned any books later than the deadline for more than twice will be levied an extra amount of money. A regular book checked out for more than 100 times will be put on sale. A reserved book checked out for more than 20 times will be put back as a regular book.
Please draw the E-R Diagram for the following system, being sure to include the attributes and note which attributes are the identifiers. Imagine a sales system that tracks customers, orders, and sales representatives. Customers can place multiple orders, but each order is associated with a single customer. Additionally, every customer is classified as being either a “Major Customer” or a “Minor Customer.” Major Customers are assigned to a single Sales Representative who acts as their primary point of contact, while Minor Customers have no connection to the Sales Representatives. Sales Representatives can be assigned to multiple customers, and whenever one of their customers places an order, the Sales Representative is also associated with the order. Overall, the system tracks the customer IDs, customer contact number(s), order numbers, goods ordered, payment status, sales representative ID, and sales representative name, as well as the customer point-of-contact for major customers.
Draw an ER diagram for the EMU Slimming Center based on the specification given below. Case Study 01 There are many dietitians in the center. There are also many clients in the center. A dietitian gives a menu to a client every week. Many diet menus are available. A diet menu consists of many food items and each food items belongs to one food category. Instructions • Identify the relationship between Entities (clearly showing the cardinality and participation)
Draw an Entity Relationship Diagram for the following scenario A, B, and C are entities. There is a relationship between all three, called D. For each A and B there is one C. For each B and C there can be many A’s. For each A and C, there is one B. Every time the relationship, D, is satisfied, a single value, “Note”, will be stored
This is a continuation to the question above. The directions continue as follows: Also, create a Use Case diagram. Make sure to identify the entities as actors and show the interaction between each of the actors. Be sure to identify at least two processes and show all the actions between them. Don't forget to include a system boundary so we can determine which actions occur within the system and which are external to SIM. With the creation of the use case diagram, you should be able to create a model (or table) showing each object. For each object, be sure to outline associated attributes and methods. Hopefully, the use case diagram and the DFD will make this process fairly straightforward. The developers need 3 instance examples for each of the entities. I suggest that you use the data library and previously developed organizational chart to find examples.
create an Enhanced Entity-Relationship (EER) diagram based on the provided information. Based on the following description, try creating the diagram using a tool such as draw.io, Lucidchart, or any other ER diagram tool: Entities: Person: person_ID (PK), name, address, birth date, phone number Subtypes: Employee, Physician, Patient, Volunteer Visit: date (PK, partial identifier), comments Care Centre: care_centre_ID (PK), name, location Laboratory: lab_ID (PK), name, location Bed: bed_number (PK), room_number, care_centre_ID (FK) Item: item_number (PK), description, unit_cost Treatment: treatment_ID (PK), treatment_number, treatment_name, treatment_date, treatment_time, results Relationships: Works_In (Person - Care Centre): Person (1, M) ----< Works_In >---- (1, M) Care Centre Assigned_To (Employee - Care Centre): Employee (1, M) ----< Assigned_To >---- (1, M) Care Centre Assigned_To (Physician - Care Centre): Physician (1, M)…
Consider a model of an airport with planes, models of planes, a test of planes, and technicians. Draw an ER diagram to represent these entities and the following attributes.Planes have a unique registration number. Airplane Models are each identified by a model number (e.g. DC-80), and each has a capacity and a weight. A number of technicians work at the airport. You need to store for each the name, phone number, address, and salary. The airport has a number of tests that are used regularly to ensure that airplanes aresafe. Each test has a unique FAA number, a name, and a maximum possible score.Extend your ER diagram with relationships to represent the following information.(a) Each airplane is of one specific model.(b) Each technician is an expert on one or more plane models. His or her expertise may overlap with that of other technicians. (c) Transport Canada requires the airport to keep track of each time a given airplane is tested using a given test. For each testing event, the…
Draw an ER diagram for the following domain of criminal court cases. Each judge has a list ofoutstanding cases over which he will preside. Only one judge presides per case. For each case one prosecuting counsel is appointed to represent the Department of Public Prosecutions. Cases are scheduled at one Crown Court for an estimated duration from a given start date. A case can try more than one crime. Make any assumption that you need for the relationship cardinality if you feel it is missing. Note that for this ER the attributes for the entities are missing. You do not have to defineattributes that has not explicitly mentioned in this question
Use ER Assistant to draw your diagram. Draw a self-referencing entity type for the Employee entity type for which an employee is supervised by a maximum of one other employee and doesn’t have to be supervised by any employee at all. Conversely, an employee can supervise zero or many other employees. The attributes of the Employee entity are as follows: EmpNo (primary key), EmpName, EmpAddress.
Create Entity-Relationship (E-R) model for the internal view of gym membership system including all workers and organization units affected by processing gym memberships. When members join the gym, they pay a fee for a certain length of time. Most memberships are for one year, but memberships as short as two months are available. Throughout the year, the gym offers a variety of discounts on their regular membership prices (e.g., two memberships for the price of one for Valentine's day). It is common for members to pay different amounts for the same length of membership. The gym wants to mail out reminder letters to members asking them to renew their memberships one month before their memberships expire. Some members have become angry when asked to renew at a much higher rate than their original membership contract, so the club wants to track the prices paid so that the manager can override the regular prices with special prices when members are asked to renew. The system must track…
Draw an ER diagram for the following scenario- • An instructor has an ID, a name, and a phone number. An instructor teaches a course • A course has a code, course name, credits, and an instructor. Each course uses a textbook. • A textbook has ISBN, name, publisher, editor, and authors. Your ER diagram should have entities, attributes, composite attribute, multivalued attribute, key attributes, binary relationships, and a total participation. Explain your rationale behind each design choice. Please draw the ER diagram on paper showing all seperate parts for each instructor, course and textbook. Showing each connection seperately and explaining which connection is which