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.

Answer rating: 100% (QA)

Heres a normalized EntityRelationship ER model based on the provided information for VacationforYou ... View the full answer