Database Design for a Hotel Management System

 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: https://www.databasestar.com/dbdesign/?utm_sourceviddesc&utm_mediumyoutube&utm_campaign103
 Learn how to design an effective database and create it using SQL: https://databasestar.mykajabi.com/edd/?utm_sourceviddesc&utm_mediumyoutube&utm_campaign103
A hotel booking or hotel management system will let guests book rooms and staff manage the rooms.
In this video, you'll see how to design a database for a hotel management system. We'll go through a range of requirements one by one, and create a database design (Entity Relationship Diagram) from scratch, getting to a diagram that meets all of the requirements.
TIMESTAMPS:
00:00 - Start our diagram
02:10 - Requirement 2
03:01 - Requirement 3
03:41 - Requirement 4
04:23 - Requirement 5
05:36 - Requirement 6
07:35 - Requirement 7
07:56 - Requirement 8
08:59 - Requirement 9
09:24 - Requirement 10
10:01 - Requirement 11
10:43 - Requirement 12