Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The car rental company allows customers to reserve rental cars over the internet, the company also allows customers to rent cars by calling up car

The car rental company allows customers to reserve rental cars over the internet, the company also allows customers to rent cars by calling up car rental personnel or by walking up to the rental counter. The rental car company has several branches, and each car is assigned to a home branch. Cars are always rented from the home branch but may be returned to a different branch. Cars are sometimes shifted from location to location – i.e., the home branch location of a given car can be changed. The company offers various types of cars and various price plans. Cars are grouped into the following classes: Subcompact, Compact, Midsized, Full-sized, and Luxury. Pricing varies by class of car, and duration of the rental. The company periodically offers special deals, e.g., one week's rental of a midsized car for $150. The company also offers discounts for organizational memberships, e.g., AAA, and AARP. There is a separate set of fees when a car is not returned to the car’s home branch – this fee will depend on the identity of the home branch and the branch to which the car is returned, e.g., the fee might depend on the distance between the home branch and the return location. We assume that a customer must register before he or she rents a car. Once the customer is registered, the registration data stays in the system.
Provide:
A detailed E-R model including 
• Each entity.
• Attributes for each entity and relationship.
• Explanations of the non-obvious entities (if any) from description and relationships.
What to turn in: 
• A softcopy of your answers.
• No handwritten answers are accepted.

Step by Step Solution

3.44 Rating (167 Votes )

There are 3 Steps involved in it

Step: 1

Entities Customer Represents the customers who rent cars Attributes CustomerID PK Name Address Phone Email RegistrationDate MembershipStatus eg AAA AARP Branch Represents the different locations of th... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Organizational Behaviour Concepts Controversies Applications

Authors: Nancy Langton, Stephen P. Robbins, Timothy A. Judge, Katherine Breward

6th Canadian Edition

132310317, 978-0132310314

More Books

Students also viewed these Accounting questions

Question

write an abstract for kafka

Answered: 1 week ago

Question

What is the difference between gain sharing and profit sharing?

Answered: 1 week ago

Question

17. What is an example of an unconscious visually guided behavior?

Answered: 1 week ago