Create an Entity Relationship Diagram for the following narrative. Bestari Auto dealership based in Kuala Lumpur sells imported cars. The dealership keeps information about each car manufacturer with whom it deals so that employees can get in touch with the manufacturers easily. The dealership also keeps information about the models of cars that it carries from each manufacturer. It keeps such information as list price, the price the dealership paid to obtain the model, and the model name and series (e.g. Audi Coupe R8). The dealership also keeps information about all sales that it has made (for instance, employees will record the buyer's name, the car the buyer bought, and the amount the buyer paid for the car). To allow employees to contact the buyers in the future, contact information is also kept (e.g. address, phone number).

Create an Entity Relationship Diagram for the following narrative. Bestari Auto dealership based in Kuala Lumpur sells imported cars. The dealership keeps information about each car manufacturer with whom it deals so that employees can get in touch with the manufacturers easily. The dealership also keeps information about the models of cars that it carries from each manufacturer. It keeps such information as list price, the price the dealership paid to obtain the model, and the model name and series (e.g. Audi Coupe R8). The dealership also keeps information about all sales that it has made (for instance, employees will record the buyer's name, the car the buyer bought, and the amount the buyer paid for the car). To allow employees to contact the buyers in the future, contact information is also kept (e.g. address, phone number).

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter4: Entity Relationship (er) Modeling

Section: Chapter Questions

Problem 1RQ

See similar textbooks

Similar questions

answer should be handwritten and the ER MODEL should be be completeDraw the Entity Relationship Diagram (ERD) with appropriate mapping cardinalities for the following scenario, Patients are treated in a single ward by the doctors assigned to them. Healthcare assistants also attend to the patients; a number of these are associated with each ward. Each patient is required to take a variety of drugs a certain number of times per day and for varying lengths of time. The system must record details concerning patient treatment and staff payment. Some staffs are paid part time and doctors and healthcare assistants work varying amounts of overtime at varying rates, the system will also need to track what treatments are required to what patients
Below is an ER diagram for an online shopping portal using the following scenario: A customer enters the shopping portal and places his/her chosen items in some carts. Then he/she proceeds to checkout and pays once using the same payment method for each cart. a. Add an entity named "invoice" and connect it to the ER diagram. The entity should contain the following attributes: total cost of items mentioned in the cart, and the date. b. Then, identify the primary keys, foreign keys, and the relationship between the entities (1:1, 1:M, M:M).
Draw an ER-Diagram for this situation and place minimum and maximum cardinalities on the diagram? Entity type: • EMPLOYEE with attribute: EmpID , Name (Firstname :besan, Lname) , Address :Amman, Birth_of_Date25/5/02 . • DEPARTMENT with attribute : DeptID , DeptName , Loc Relationship: Works_in Relationship between EMPLOYEE and DEPARTMENT and each employee is works in zero or many department and each department worked by one or many employee.
Consider the below ERD in Figure 03 of Student Enrolment system and answer the below questions. List the strong (non-weak) entity types in the ER diagram. Is there a weak entity type? If so, give its name, partial key, and identifying relationship. What constraints do the partial key and the identifying relationship of the weak entity type specify in this diagram? List the names of all relationship types, and specify the (min, max) constraint on the participation of an entity type in a relationship type. Justify your choices. List concisely the user requirements that led to this ER schema design
18. Refer to this entity-relationship diagram. How does this diagram depict a unattractive relationship rather than a binary relationship. A: The entity types back each other up B: the salesperson have the same commission percentage C: the entity types are the same for each D: the salesperson have the same year of hire
Draw an Entity relationship diagram (ER) for a university according to the following rules: ‐ For each student the university needs to keep track of: first name, last name, student id, address, phone no and their major. ‐ The student id is identical for each ‐ Each course has a number, name and credit. The course number is unique for each course. ‐ Each department has a name, code and The code is unique for each department. ‐ Each course may has one or more sections where each section is belong to only one ‐ A department offers one or many 7-‐ Some courses have perquisite courses. 8-‐ Each student could register in one or more courses. In your diagram you need to show the following: 1-‐ The primary key for each entity. 2-‐ The cardinality and participation between entities.
Create an ER diagram for a reservation system of hotel rooms considering the following facts. You should indicate some attributes and the primary key for each entity. ■ Hotel contains several rooms Customer can reserve one or more rooms One room contains one, two, or three beds ⚫ Bed can be normal (for one person), double, or spare (less expensive)
Q.No.1.a. Draw ER- notation for the given elements of ER-Model. Entities Strong Entity Weak Entity Associative Entity Relationship Degree Unary Binary Ternary Relationship Cardinality Mandatory One Mandatory Many Optional One Optional Many Answer: b.Separate Entities and Attributes from the list given below: Skill Student Course Regno DepartmentName ProductID Salary Project DateCompleted Hobby Answer:
Create an Entity Relationship diagram (ERD) for the following scenario indicating the identifiers and cardinality constraints. A division operates many departments, but each department is operated by only one division. Each division must have at least one department and each department must belong to a division. A department employs many employees, but there may be a department with no employees. Division is characterised by Divisionid and Divisionname and the attributes of department include Deptid and Deptname. Majority of employees called “dept_emps” are employed by a department. However, there are also employees known as “free_lance_emps” who are not assigned to any department. A department may own many projects, but there may be a department with no projects. Employee is characterised by empid, empname, emptype and address. Both dept_emps and free_lance_emps can work on many projects, but there are employees who do not work on any project. A project has at least one employee…
b. Draw an Entity Relationship diagram from each of the following descriptions. Include the attributes, primary keys (underlines) and the relationships in the diagram (like relationship in Access). i. Each of the department has many employees assigned to it, but each employee works for only one department. if. A customer can rent many videotapes from the video store. Each of the videotapes can be rented to many customers.
A customer can make many payments, but each payment is made by only one customer.” Use this scenario as the basis for an entity relationship diagram (ERD) representation using either Chen, Crow’s Foot or UML Class Diagram.
Consider the scenario described by the statement "A customer can make many payments, but each payment is made by only one customer." Use this scenario as the basis for an entity relationship diagram (ERD) representation.