How to Design a Database for Harry Potter

📝 Get my Database Design Guides to many different sample databases: https://databasestar.mykajabi.com/lpkj-dbdesign/?video=FWobkkYD2s8 🎓 Turn your idea into a real database: https://databasestar.mykajabi.com/edd/?video=FWobkkYD2s8 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