📝 Get my Database Design Guides to many different sample databases: [ Ссылка ]
🎓 Turn your idea into a real database: [ Ссылка ]
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
