Database Design for School Students for an Entire School

 Get my Database Design Guides to many different sample databases: https://www.databasestar.com/dbdesign/?utm_sourceviddesc&utm_mediumyoutube&utm_campaign77
 Learn how to design an effective database and create it using SQL: https://databasestar.mykajabi.com/edd/?utm_sourceviddesc&utm_mediumyoutube&utm_campaign77
Databases for schools where students change grades each year is a little more complicated than your average "university database design".
In this video, you'll see me design a database for a school that allows multiple levels, such as a primary school or secondary school. We will look at 16 different requirements and slowly design the database to meet each of them.
Check out the link below for an image of the entire completed design.
TIMESTAMPS:
00:00 - Intro
01:14 - Req 1: students
02:24 - Req 2: parents and carers
04:31 - Req 3: school years
05:27 - Req 4: terms
0614: - Req 5: year levels
08:01 - Req 6: classes
08:38 - Req 7: subjects
09:13 - Req 8: departments
09:55 - Req 9: teachers
10:43 - Req 10: teacher details
11:15 - Req 11: classes and terms
12:04 - Req 12: classrooms
13:09 - Req 13: class times
13:54 - Req 14: multiple periods
14:35 - Req 15: student scores
15:25 - Req 16: score grade mapping
16:59 - Further requirements
VIDEO LINKS:
Final ERD of this database: https://dbshostedfiles.s3.us-west-2.amazonaws.com/dbs/erd_school.png