Question

How to create database design using SQL for an Airbnb planning business? Also draw conceptual model, logical model and physical model.

Answer 1

Airbnb's business model is an aggregator business model just like Uber and OYO. They don’t have a business model like hotels such as Hilton and Marriott. Just like Grubhub’s business model, Airbnb also runs with the help of an online platform that connects each component in the model. Airbnb’s biggest assets are the individuals and the hosts who are the key components in the Airbnb process. Unlike big hotels, Airbnb has a minimum cost and doesn’t need a huge capital.

Airbnb acts as a platform for hosts and travelers. Hosts can put up their property for stay and if someone wishes to stay there, the hosts get rent in exchange. The individuals who stay at Airbnb get a completely different experience by staying close to the locals.

SQL for an Airbnb planning business:

reviews Quid int reservation id int rating int comment varchar media reservations Quid int Qid int int model_id model_type user_id int rooms varchar room_id int → Quid int file name varchar start date datetime home type varchar mime_type varchar? end_date datetime varchar price int int room_type total_occupancy total_bedrooms total bathrooms total int int created at datetime int updated_at datetime summary varchar address varchar has_tv boolean users boolean Qid int has_kitchen has_air_con boolean name varchar has_heating boolean has_internet boolean email varchar email_verified_at datetime? password varchar price int published_at datetime remember_token varchar? owner id int created at datetime created at datetime datetime updated_at phone number updated_at datetime varchar latitude float varchar description Is drawSOL profile_image longitude float varchar