Database Systems: Design, Implementation, & Management
12th Edition
ISBN: 9781305627482
Author: Carlos Coronel, Steven Morris
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 9, Problem 5P
Explanation of Solution
Design of video rental
The below is the design of video rental database that includes the support of all rental activities such as customer payment, work schedule of the employee, checkout which employee has processed the videos for the customers.
Explanation:
- Every movie is classified based on the type and the relationship between MOVIE and TYPE is N:1.
- One movie gets rented many times and the relationship between the MOVIE and RENTAL is 1:N.
- Every customer needs to pay for the rental made and the relationship between CUSTOMER and RENTAL is 1:N.
- Employee gathers details and writes about the rental made and the relationship between EMPLOYEE and RENTAL is 1:N.
- Every employee sign a work log and the relationship between the EMPLOYEE and WORK_LOG is 1:N
- Every schedule of the Employee gets enters and the relationship between the EMPLOYEE and Schedule is 1:N...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
ER-diagrams are high-level design of the Database.
The given ER-diagram describes the Dentist office and service details.
 are there strong and weak entities, recursive relationships and different attribute types are involved ? would you identify what eachentity are relationship are and to describe all constraintsrelated to them
What type of relationship in the conceptual model is converted to an entity in the logical database design?
Why do we do the normalization stage in database design, especially in the logical stage?
Chapter 9 Solutions
Database Systems: Design, Implementation, & Management
Knowledge Booster
Similar questions
- The ______________ model is a simple but highly useful way to organize data into collections of two-dimensional tables called relations.arrow_forwardUsing a graphics program, develop an entity-relationship diagram for a database application for an Internet bookstore where students buy textbooks from a salesperson and receive invoices for their purchases. Use Figure 5.5 as a guide.arrow_forwardYour task for this assignment is to complete a database design for the given case studies. Model the system described in the case study and draw a Physical Data Model using MySQL Workbench. Your diagram must conform to the notation used in this subject (object notation = ‘Workbench Simplified’, relationships notation = ‘Crows Foot’, show data types). If you include sub-types, place them inside a Layer with a note explaining their relationship to the super-type.arrow_forward
- Develop an EER model for the following situation using the traditional EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor: An international school of technology has hired you to create a database management system to assist in scheduling classes. After several interviews with the president, you have come up with the following list of entities, attributes, and initial business rules: • Room is identified by Building ID and Room No and also has a Capacity. A room can be either a lab or a classroom. If it is a classroom, it has an additional attribute called Board Type. • Media is identified by MType ID and has attributes of Media Type and Type Description. Note: Here we are tracking type of media (such as a VCR, projector, etc.), not the individual piece of equipment. Tracking of equipment is outside the scope of this project. • Computer is identified by CType ID and has attributes Computer Type, Type Description,…arrow_forwardDraw an E-R diagram for the description below. Suppose that you are asked to model a database including all pharmaceutical companies, their drugs, and all pharmacies. Each pharmaceutical company is identified by its name and has a phone number. For each drug, the trade name (e.g., Acetaminophen) and formula must be recorded. Each drug is sold by only one pharmaceutical company, and the trade name identifies a drug uniquely from among the products of that company. If a pharmaceutical company stops production, we do not need to keep track of its products any longer. Each pharmacy has an identifier name, address, and phone number. Each pharmacy sells several drugs. A drug could be sold at several pharmacies, and the price could vary from one pharmacy to another.arrow_forwardSuppose that the initial conceptual design of the Car Rental database consisted of just a single relation as follows:Rental(VehicleID, CustomerID, DateOut(PK), DateReturned, VehicleClass, RentalRate, CustomerFName, CustomerLName, Balance) Normalize the Rental relation to 2NF and 3NFarrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning