Order description must be recorded

Assignment Help Business Law and Ethics

Reference no: EM133362165

Question: An online vacation rental company 'VacationforYou' allows customers to book rentals on their website. Customers can book many vacation rentals and a rental can be booked by one customer at a time. The rental company would like to store date on which rental was booked, number of days rental was booked, customer name, contact email, and home address. Further, the customer can leave comments about their stay at the rental, and VacationforYou can also rate the customer.

VacationforYou also allows customers to book car rentals through its website. A customer may book several rental cars but a car rental can only be rented by one customer at a time. The time and date of the booking must be recorded along with the make, model, mileage of the rental car.

Another feature of VacationforYou's website is that it allows customers to book local tours during the time of their stay at the rental. One such Local tours description on VacationforYou's Website reads "spend an adventurous day exploring the most incredible natural wonders...". A customer may book several local tours and a tour could be booked by many customers. The date of the local tour needs to be recorded along with the amount paid by the customer.

'VacationforYou' has another online feature for customers staying at their vacation rentals. Customers can order food online from restaurants nearby through 'VacationforYou's' website. A customer may place several food orders (that are delivered to their rental location), but a food order is associated with only one customer. The time, date, total price of the order, and order description must be recorded.

Note: Include 2-3 attributes (in addition to the PK and FK) for each of the entities in your normalized ER Model. Further, include at least one attribute (in addition to the two FKs/composite PK) for each bridge/junction table that you include in your ER Model.

Reference no: EM133362165

Questions Cloud

Is the sheriffs action as regards the attachment : Is the Sheriffs action as regards the attachment of Gray's property correct? Why or why not - Gray, on the other hand, questioned such attachment citing

Role of healthcare educator in simulation setting : What is the role of a healthcare educator in a simulation setting? How is this role different from other workplace environments?

What are your thoughts regarding charlie participation : What are your thoughts regarding Charlie's participation in the program? Outline what your inclusion plan would look like? Outline the tools and strategies

Explain if the agreement between bishop pty ltd and zoe ltd : Explain if the agreement between Bishop Pty Ltd and Zoe Ltd is a legally enforceable contract. Introduction

Order description must be recorded : A customer may place several food orders (that are delivered to their rental location), but a food order is associated with only one customer. The time, date

Theory of human caring. : Provide a description of the selected theory and theorist.

What do you think of the new japanese mah framework : What do you think of the "new" Japanese MAH framework? Is it just the same as the old ICC framework, or is it actually a step in a different direction?

What information stood out to you : What information stood out to you? Do you have any experience with the topic this week? Locate an article on the topic of this week. Provide the article name

If an offer states that a reply must be received : If an offer states that a reply must be received by a certain date, receipt is presumed in those situations when acceptance is mailed

User Account

All Pages