How to Design a Database for Harry Potter

 Get my free SQL Cheat Sheets: https://www.databasestar.com/get-sql-cheat-sheets/?utm_sourceviddesc&utm_mediumyoutube&utm_campaign55
 Learn how to design an effective database and create it using SQL: https://databasestar.mykajabi.com/edd/?utm_sourceviddesc&utm_mediumyoutube&utm_campaign55
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