A database is required to allow Surrey Cars to advertise and rent out its cars online....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. 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.
Expert Answer:
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date:
Students also viewed these databases questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Climate-change concerns are resulting in investment in fuels that dont produce greenhouse gases. Although solar and wind power garner a lot of attention, nuclear power from uranium is also a...
-
How might you perform "risk adjustment" of Consumer Reports automobile ratings?
-
Each graphing calculator window shows the graph of a function f(x) and its derivative function f(x). Decide which is the graph of the function and which is the graph of the derivative. -6 Y (Y) 8 -10...
-
Lynn Goldsmith is a photographer known for her photographs of famous musicians. In 1981, Goldsmith had a photography session with the singer Prince. Three years later, Vanity Fair obtained a license...
-
Worksheet data for DeSousa Company are presented in E4-2. The owner did not make any additional investments in the business in April. In E4-2, The adjusted trial balance columns of the worksheet for...
-
ESG CSR Study caseSunset Manufacturing Inc. manufactures Umbrellas in the Western Canadian market, and is comparing the budget for the current year with the actual results. The market has been good...
-
A bond pays annual interest. its coupon rate is 8.5%. its value at maturity is $1,000. it matures in 5 years. its yield to maturity is currently 6.5%. the duration of this bond is _ years
-
Rountree et al. (2008) show that investors do not like cash flow volatility. Consider the financial ratios presented in this chapter. Can you adapt an existing financial ratio or construct a new one...
-
Valuation: The One-period Case Your friend tells you that it does not matter when you receive money, since it is always worth the same. He tells you that 100 today is worth the same as 100 tomorrow....
-
Compounding Periods As you increase the length of time involved, what happens to future values? What happens to present values? What happens to the future value of an annuity if you increase the rate...
-
Valuation: The Multi-period Case You have taken out a loan that requires annual payments of 110 for each of the next 2 years. You wish to pay back the loan over 4 years. Should the payment be 55 per...
-
What is a Firm Worth? What is discounted cash flow (DCF) valuation? Can it be used to estimate the value of companies? What businesses could we value using DCF valuation? What are the advantages and...
-
Partnership P was formed on November 1, 2020, by A, B (both individuals) and C Corporation. A and B are calendar year taxpayers and C has a fiscal year end of January 31. A contributed property with...
-
Fill in each blank so that the resulting statement is true. 83 + 103 = ______ .
-
What is a helper table, and why is it often used to help organize derived data?
-
Define each of the following terms: a. Supertype b. Subtype c. Specialization d. Entity cluster e. Completeness constraint f. Enhanced entity-relationship (EER) model g. Subtype discriminator h....
-
Not all versions of this database include referential integrity constraints for all foreign keys. Use whatever commands are available for the RDBMS you are using, investigate if any referential...
-
Using an economic balance sheet, which of the Laws current financial assets is most concerning from an asset allocation perspective? A. Equities B. Real estate C. Fixed income Raye uses a costbenefit...
-
Using the economic balance sheet approach, the Laws economic net worth is closest to: A. $925,000. B. $1,425,000. C. $1,675,000. Raye uses a costbenefit approach to rebalancing and recommends that...
-
Raye believes the previous advisers asset class specifications for equity and derivatives are inappropriate given that, for purposes of asset allocation, asset classes should be: A. diversifying. B....
Study smarter with the SolutionInn App