Channel | Publish Date | Thumbnail & View Count | Download Video |
---|---|---|---|
Publish Date not found | 0 Views |
Learn how to design an effective database and build it using SQL: https://databasestar.mykajabi.com/edd/?utm_sourceviddesc&utm_mediumyoutube&utm_campaign77
Databases for schools where students change classes every year are a bit more complicated than your average "college database design/".
In this video you will see me designing a database for a school that allows multiple grades, such as a primary 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 a picture of the entire completed design.
TIMESTAMP:
00:00 – Introduction
01:14 – Req 1: students
02:24 – Req 2: parents and guardians
04:31 – Req 3: school years
05:27 – Query 4: terms
0614: – Req 5: annual levels
08:01 – Requirement 6: course
08:38 – Request 7: topics
09:13 – Req 8: departments
09:55 – Req 9: teachers
10:43 a.m. – Req 10: teacher contact details
11:15 a.m. – Requirement 11: courses and terms
12:04 p.m. – Requirement 12: classrooms
1:09 p.m. – Req 13: class schedules
1:54 p.m. – Req 14: several periods
2:35 p.m. – Requirement 15: student grades
3:25 p.m. – Requirement 16: grade mapping
4:59 p.m. – Other requirements
VIDEO LINKS:
Final ERD of this database: https://dbshostedfiles.s3.us-west-2.amazonaws.com/dbs/erd_school.png
Please take the opportunity to connect and share this video with your friends and family if you find it useful.