How to Design a Database for AirBNB

Просмотров 4,4 тыс.

% 224

📝 Bonus PDF: This ERD, descriptions of each table and column with sample data, and SQL scripts to create all of the tables on your own database: www.databasestar.com/dbdesign/?
🎓 Learn how to design an effective database and create it using SQL: databasestar.mykajabi.com/edd/?
Do you want to learn how to design a database for AirBNB?
In this video, we'll look at the AirBNB website and design a database for it step-by-step. We'll include properties, ratings, bookings, images, and more.
⏱ TIMESTAMPS:
00:00 - What we're doing
00:39 - Property
03:38 - Users
04:40 - Property attributes
06:53 - Reviews
08:50 - Host
10:10 - About the property
12:50 - Bookings
14:53 - Filter
18:10 - What else?

Наука

Опубликовано:

9 янв 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 59

@VincentCheng1658 2 месяца назад

You're talented and dedicated one, Ben, glad to have you here!

@DatabaseStar 2 месяца назад

Thanks for the kind words!

@endurancethemartian 5 месяцев назад

Wow what a video. I haven't seen someone explain DBA so eloquently.

@DatabaseStar 5 месяцев назад

Thanks! Glad you liked it!

@suni14073 5 месяцев назад

Amazing video. A great example of solving a real world database design problem. Excellent

@DatabaseStar 5 месяцев назад

Glad it was helpful!

@muhammadsalmanagustian75 6 месяцев назад

Very informative and helpful. keep going Database Star!

@DatabaseStar 5 месяцев назад

Thanks, will do!

@shahnawazk 6 месяцев назад

Very informative and helpful. Thanks and keep it up!

@DatabaseStar 6 месяцев назад

Thanks!

@yudi6451 5 месяцев назад

Wow Amazing, i learn so much in 19minute and its using real world example. Keep this series going. Excellent

@DatabaseStar 5 месяцев назад

Thanks! I'm glad it was helpful. I've started to do real-world examples in my database design videos, so it's good to hear it's been useful.

@fd4242 Месяц назад

Excellent. Thanks for making and sharing this video.

@DatabaseStar Месяц назад

No problem, glad it helped!

@lyricass7810 6 месяцев назад

I was waiting for this video from last 2 months thanks for uploading sir.

@DatabaseStar 5 месяцев назад

Glad you like it!

@lyricass7810 4 месяца назад

@@DatabaseStarhello sir, can you tell me how you made data dictionary for your airbnb database design? can you tell me which data dictionary tool is good for mysql, it would be nice if the data dictionary also has a column called "referenced table", please let me know sir, thank you..

@juliomuhlbauer 3 месяца назад

I was looking for this some months ago. Amazing!

@DatabaseStar 3 месяца назад

Glad it helped!

@sobeck6900 6 месяцев назад

Wow, such a fantastic video and way of presenting! You really stepped up your game with this one.

@DatabaseStar 5 месяцев назад

Thanks a lot! I wanted to try a different approach, with an example, so I’m glad you like it.

@sobeck6900 5 месяцев назад

@@DatabaseStar yea, this kind of approach when you crop the image for each step from real sites is really brilliant

@sobeck6900 5 месяцев назад

@@DatabaseStarIt feels so 'real life' because, typically, when I need to design a database, I first receive the UI from Figma and then create ER diagrams based on that UI

@shibinabraham7819 4 месяца назад

You are truly a master at work and explanation. hats off to you!

@DatabaseStar 4 месяца назад

Wow, thank you!

@shibinabraham7819 4 месяца назад

Thank you for your response. For the benefit of others, would it be possible for you to explain how to use look up tales for joins (Using Key Value Pair)?@@DatabaseStar

@DatabaseStar 4 месяца назад

Good idea, I can make a video for that

@shibinabraham7819 4 месяца назад

@@DatabaseStar Thank you very much, looking forward to it. Especially the Key: Value Join(as a composite key) is a very tricky one. Please include that for sure.

@mohammadjaradat7885 6 месяцев назад

Amazing, One of most entertaining and educated video ,keep going 👍👍

@DatabaseStar 6 месяцев назад

Thanks a lot!

@maneaabdullah6059 6 месяцев назад

Amazing, keep going 👍👍

@DatabaseStar 6 месяцев назад

Thanks!

@Im_Ashwin.M 27 дней назад

Very helpful videos. Can you make video about airline PNR database. A PNR can have 1. passenger name (first name, last name, title) 2. flight details (airlineCode, flight number, startCity, endCity, startTime, endTime) 3. phone (cityCode, number) 4. email 5. remarks 6. Special service requests (requestCode, status, remark)

@DatabaseStar 26 дней назад

Good idea!

@Sdirimohamedsalah 2 месяца назад

Great tutorial! I'm working on the same topic with a little bit more specificity. Honestly, my brain feels fried trying to find a good solution to make it translatable. Do you have any ideas aside from adding postfix fields like description_En, description_FR, etc.? Is there a better approach for solving this problem and translate the entier content of a database ?

@DatabaseStar 2 месяца назад

Glad it was helpful! I think it would be better to have a separate table for the descriptions in each language, as there can be many of them. Perhaps there's a new table called description_intl (or another name that you think is better) and it can have a description ID as the PK, an ID as the FK to the main table, and then a column for the language, and then the text of the description.

@Code-sz9db 12 дней назад

Noice vid! In the video you kind of removed the image table by mistake. It's not included in the pdf too. Thanks for the video!

@DatabaseStar 8 дней назад

Good pickup! It should be there, I don't know why I removed it.

@AndrulisTravel 6 месяцев назад

Nice

@DatabaseStar 6 месяцев назад

Thanks!

@sujaritnrc 6 месяцев назад

I live your tutorial. Real world example. If you have time pls share how to design noSQL like Firebase.

@DatabaseStar 5 месяцев назад

Thanks! Good idea.

@haidertest1809 5 месяцев назад

Hi Ben, Great and straight to the point video as always. Can you please make a video for a MySQLdatabase design for a user and vendor relationship application as following. Vendor can have multiple orders from users. User can book multiple vendors. User can leave reviews for each vendor etc. I would like to see to your approach on that.

@DatabaseStar 5 месяцев назад

Thanks! Sure, I can make a video on that.

@haidertest1809 5 месяцев назад

Thanks a Ton@@DatabaseStar

@lyricass7810 4 месяца назад

hello sir, can you tell me how you made data dictionary for your airbnb database design? can you tell me which data dictionary tool is good for mysql, it would be nice if the data dictionary also has a column called "referenced table", please let me know sir, thank you.. another doubt of mine is, what should i do if i need to create a seperate table for host, what will change if i create a seperate table for host. if seperate table is created for host, what tables should it be linked to ? what are the new tables that might arise due to seperate table for host.

@DatabaseStar 4 месяца назад

I don't think I understand your first question. How did I make a data dictionary for an AirBNB design? This video shows exactly how I did it. I used a tool called LucidChart for this video, which I think is pretty good. But you can use Visio or Google Drawings or the built-in modelling tool in MySQL Workbench.

@DatabaseStar 4 месяца назад

If you want to create a separate table for host, you would have to work out what a host is related to, and how. A host would be related to a property. They may also have reviews (if users can review the host).

@lyricass7810 4 месяца назад

@@DatabaseStar sorry i forgot that you used lucid chart lol sorry sir.

@hhgforfhuv 5 месяцев назад

Nice and helpful video. Thanks a lot. Can you make video about designing the database of sports aggregator application like flashscore? I think it will be interesting

@DatabaseStar 5 месяцев назад

Thanks! Sure I can do that. I’ve never heard of flashscore but I can look into it.

@hhgforfhuv 5 месяцев назад

@@DatabaseStar will be great! Thanks

@abhinaysadineni1151 3 месяца назад

Can also let us know to store the nightly price per each date in the database? I have seen this feature in airbnb

@DatabaseStar 3 месяца назад

Yeah you could expand this to have different prices for different dates or date ranges.

@recapMate 3 месяца назад

Why having the total_price field in bookings table when u can compute it?

@DatabaseStar 3 месяца назад

Good point! Generally I don't add computed fields to this table, but I did for this instance because it's a value at a point in time and includes a range of other values that could change over time. But you could also not store it and compute it instead.