Question
Construct an Airbnb ER diagram considering the following requirements: Host: Every property host needs to be tracked. The host details such as the address (house
Construct an Airbnb ER diagram considering the following requirements:
Host: Every property host needs to be tracked. The host details such as the address (house number, street, city, and province), hosts name (first, middle, and last name), and email addresses and phone numbers are also required. Note that on some platforms, a registered host can also be a guest (i.e., they can post accommodation as well as book accommodation), e.g., Airbnb.
Guests: A guest should be able to book more than one property. They want you to capture details such as their ids, address, name, email address and phone numbers. Rental Agreement: A rental agreement is needed for a property. Each such rental agreement should be identified in the database as well as the signing, start and end dates of the rental agreement.
Property: Hosts should be able to list their properties stating the address and property type (e.g., apartment, bed & breakfast, unique homes, and vacation homes, etc.), room type (unique space, private or shared room), accommodates, amenities, bathrooms, bedrooms, beds & type), available date, location, price, etc. Other attributes discovered from your selected enterprise can also be added.
Branches: The enterprise is organized into branches, represented by the country in which the properties are located (e.g., Airbnb is present in 190 countries, therefore, it has 190 branches). Every branch has employees allocated with a branch manager. Each branch details need to be captured by the database.
Employees: Every employee needs to be identified by the basic information, position and salary. Note that the properties in each country the enterprise resides are run by the employees who are managed by a branch manager, who is also an employee.
Pricing (or Renter Rate): Pricing is determined by the hosts. They provide the prices and other details for their rental or event listings, such as the allowed number of guests, home type, rules, and amenities, etc. Each property has its own pricing, but all properties in the same class are priced the same.
Payment: Hosts are able to collect payments for the accommodations online. You are required to keep track of the host that accepted the payment, the type of payment (i.e. cash, check, credit card, direct debit), the amount of the payment, payment status (i.e., completed (cash), approved (debit or credit card), or pending).
Reviews: The enterprise also needs to keep track of the reviews from the guests. Information that needs to be stored include ratings, communications, cleanliness and value.
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