Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A database is required to allow Surrey Cars to advertise and rent out its cars online. Customers should be able to rent cars based

image text in transcribed 

A database is required to allow Surrey Cars to advertise and rent out its cars online. Customers should be able to rent cars based on their category(s) and not the specific model. In other words, if a customer is interested in hiring a BMW 5 Series or Mercedes E- Class can simply go for luxury car option which offers something in that category at $20 per day, while if a customer is interested in hiring a Toyota Yaris, Nissan Tiida or Kia Rio type of cars, can simply go for Hatch back category which is $10 per day. SUV is also an option at $25 per day. When customers book online they have to provide from date and to date of the booking. The system should be able to see if a car from within the required category is available or not, if yes, the booking can go ahead and the customer is quoted the total price to pay. Customers sometimes book two cars of the same category or two cars of different categories as part of a single booking. Moreover, once the booking is complete, and on the collection day, the customer should head to the garage to collect the car(s), at that point the agent who completes the paperwork, will assign the car to the customer and the time of the pick up as well as the name of the agent is recorded. Some agents are able to update the category price in which case the date and the name is essential to be captured. Produce only one EARD for the above scenario, making assumptions, and justifying your choice if needed. Moreover, address any many to many relationships if encountered.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

12th edition

133544613, 978-0133544619

More Books

Students also viewed these Databases questions