This case study concerns a Car Rental Company. The purpose of the database is to record...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
This case study concerns a Car Rental Company. The purpose of the database is to record which customers rent which cars. The company has a fleet of cars. Car details include the car registration, make (e.g. Ford, Nissan) and model (e.g. Mondeo, Micra). The company has many customers that can rent many cars. Customer details include their Address, telephone and driver's license number. Each customer rents a car for an agreed period of time that starts at the loan date and ends at the return date. A rental number uniquely identifies each car rental. Every time a car is returned from a rental, it is checked for damage by a service manager. Each service manager checks many cars. Before a car is rented by a customer, it is cleaned by a team of cleaner. Each cleaner cleans many cars. G11.1 Conceptual Model: Identify Entities and Relationships. Read the Case Study and identify the key entities and relationships. Draw a conceptual model of the database. You MUST include the cardinality and participation of each relationship. G11.2: Logical Model: Convert the conceptual model to a logical model by adding attributes and keys (primary keys and foreign keys) G11.3: Many to Many Decomposition: Decompose one Many to Many relationship. This case study concerns a Car Rental Company. The purpose of the database is to record which customers rent which cars. The company has a fleet of cars. Car details include the car registration, make (e.g. Ford, Nissan) and model (e.g. Mondeo, Micra). The company has many customers that can rent many cars. Customer details include their Address, telephone and driver's license number. Each customer rents a car for an agreed period of time that starts at the loan date and ends at the return date. A rental number uniquely identifies each car rental. Every time a car is returned from a rental, it is checked for damage by a service manager. Each service manager checks many cars. Before a car is rented by a customer, it is cleaned by a team of cleaner. Each cleaner cleans many cars. G11.1 Conceptual Model: Identify Entities and Relationships. Read the Case Study and identify the key entities and relationships. Draw a conceptual model of the database. You MUST include the cardinality and participation of each relationship. G11.2: Logical Model: Convert the conceptual model to a logical model by adding attributes and keys (primary keys and foreign keys) G11.3: Many to Many Decomposition: Decompose one Many to Many relationship.
Expert Answer:
Related Book For
Matching Supply with Demand An Introduction to Operations Management
ISBN: 978-0073525204
3rd edition
Authors: Gerard Cachon, Christian Terwiesch
Posted Date:
Students also viewed these algorithms questions
-
Company XYZ just paid a dividend of $1 per share. The required return on its stock is 15% (EAR). 1) The annual dividends grow at 10% per year over the next three years. Thereafter, dividends will...
-
Zipcar is a subsidiary of Avis Budget Group which acquired it in 2013. Originally Zipcar was founded by Antje Danielson and Robin Chase in 2000. Zipcar's famous tagline: "Wheels when you want them"...
-
Social welfare is maximized when O Total social benefits have been maximized O total social costs have been minimized O total social costs equal total social benefits O marginal social costs equal...
-
In the context of an IDS, we define a false positive to be an alarm generated by an IDS in which the IDS alerts to a condition that is actually benign. A false negative occurs when an IDS fails to...
-
The figure shows three vectors. Vector A has a length of 38.0 vector 25.0. B has a length of 64.0, and vector has a length of Solve the given equations. B = B. (A+C)= At what angles above and below...
-
In life testing, we are sometimes interested in establishing tolerance limits for the life of a component in particular, we may be interested in a one-sided tolerance limit \(t^{*}\), for which we...
-
Bills Cabinets sells a product for $360 per unit. The companys variable cost per unit is $60 for direct material, $50 per unit for direct labor, and $34 per unit for overhead. Annual fixed production...
-
A n aircraft of weight 3 4 7 0 0 0 N is catapulted off the deck of an aircraft carrier. if the aircraft starts at rest, and reaches a velocity of 7 2 m / s 2 in 2 . 5 seconds, how much force is...
-
I want to create an Android mobile application, an application that provides courses for students ... I want advice for safety and security, what are its requirements ... and what are the yooze case...
-
On June 1 , 2 0 2 1 , Ivanhoe Manufacturing acquired a machine for $ 1 2 7 0 0 0 with an estimated useful life of five years and an estimated residual value of $ 1 2 3 0 0 . The company uses the...
-
Hudson Community College enrolls students in two departments, Liberal Arts and Sciences. The college also has two service departments, the Library and the Computing Services Department. The usage of...
-
Using the information below, calculate the cost of each of the energy producing reactions tested. CHEMICAL PRICE LIST Cost of HCI: $29.50/20 L bottle Cost of HC2H3O2: $61.31/20 L bottle Cost of...
-
The F . Mercury, Capital account has a credit balance of $ 3 7 , 0 0 0 before closing entries are made. Total revenues for the period are $ 5 5 , 2 0 0 , total expenses are $ 3 9 , 8 0 0 , and...
-
notesup sdt erwarts 10 umstele di estalqmas Question 10. Find the velocity of the body at time t = 3 s. 4)40jm/s B)20[-i+2j]m/s C)20[-ilm/s D)40[-i+j)m/s E)20[-2i+j)m/s Question 11. Find the position...
-
Liz was a securities analyst at a major New York City investment bank. She had been a securities analyst at that bank for five years and had received satisfactory job evaluations, so when a position...
-
The comparative statements of financial position of Menachem NV at the beginning and end of the year 2019 appear below. Net income of ¬34,000 was reported, and dividends of ¬23,000 were paid...
-
The steam is generated at 8 bar from water at \(32^{\circ} \mathrm{C}\). Find the heat required to produce \(1 \mathrm{~kg}\) of steam. (a) When the steam at dryness \(=0.9\). (b) When the steam is...
-
Determine the state of steam at : (a) \(p=14\) bar and \(t=210^{\circ} \mathrm{C}\), and (b) \(p=8\) bar and \(2700 \mathrm{~kJ} / \mathrm{kg}\) of heat supplied to water from
-
Determine the condition of steam in the following cases : (a) At a pressure of 10 bar and \(200^{\circ} \mathrm{C}\). (b) At a pressure of 8 bar and specific volume of \(0.22 \mathrm{~m}^{3} /...
Study smarter with the SolutionInn App