The world of Harry Potter and Hogwarts is fascinating and is a great example of a topic we can use to design a database. In this video, we’ll look at the world of Harry Potter and Hogwarts and design a database that captures a range of concepts, such as students, teachers, houses, quidditch, and more. We’ll go through each of the concepts step-by-step, creating an Entity Relationship Diagram to represent them and see how they relate to each other, to help you learn about database design and table relationships. Timestamps: 00:00 The world of Harry Potter 00:38 Student 01:25 Teacher and subject 02:53 House 04:34 Classes 05:11 House Cup 05:59 Quidditch 09:06 Other characters 10:09 Final design and possible enhancements /// RESOURCES 📝 Get my free SQL Cheat Sheets: https://www.databasestar.com/get-sql-cheat-sheets/ 🧭 SQL Roadmap from basics to advanced: https://www.databasestar.com/sql-roadmap/ ✍️ Learn how to design a database: https://databasestar.mykajabi.com/edd 🎓 Improve your SQL and database skills with Database Star Academy: https://www.databasestar.com/dsa/ 📧 Contact me here: https://www.databasestar.com/contact/