Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started