Hi. I appreciete a lot your videos, however: having a looking at this diagram, what is the impact of some design choices on the overall performances? I mean, I see the you put the booking_type in a separate table, thus, It will require an additional join for queries involving reading the type of booking. Is this a good choices still?
4 months ago | 0
Database Star
Want some database design examples?
I've created a range of "Database Design Guides", based on some of my YouTube videos on database design. They have the ERD from the video (such as a movie database, AirBNB, eCommerce, hotel booking, and many more), the explanations of the tables and columns, and the SQL to create the database.
You can get all of these Database Design guides here: databasestar.mykajabi.com/lpkj-dbdesign?community=…
5 months ago | [YT] | 99