Hogwarts Database is an extensive, practice case study database application that will cater the needs of storing, managing, querying and retrieving Harry Potter's fantasy world's data needs including their schools, books, characters, appearances, students, courses, grades, enrollment, professors, ministers, levels, incharge, ministry employees, offices, examiner & Owls records. The application is generated by a script and is further beautified manually through Alex app builder.
The below diagram depicts the entities (tables) and their relations. The diagram is designed using Draw.io , which is an online utility to design diagrams.