Entity Relationship Diagram: School Database (Updated)

preview_player
Показать описание
Need more help with your HSC study? Check out my new digital study guides here:

A schema outlining Class Generation, which could be used by school for creating Classes for teachers and students using the entities of Student, Teacher, Subject, Classroom and Class.
Рекомендации по теме
Комментарии
Автор

This is incredibly well done and explained. Appreciate it

michaelmoran
Автор

intha senario kku ERD varanchu thangaa sir plz















The final system should be able to provide the
required information for management decision making and to handle daily
operations efficiently and effectively.

kaykay
Автор

Its legal to use the legal name as identification it's vitals statistics documents not our family name and we are the holder in due course over the trust name it's a trust setup for us to operate in the public system

rbxbdpn
Автор

Can someone please help me with the business rule for ER diagram???

just.theo_
Автор

Very interesting illustration. Thanks a lot. However, can you add courses such as Business, General Art, Visual Art etc. The fact is I have been trying to build a database for my school in Mircosoft access but I have been problem with the relationship. My school runs courses like Business, General Art, Visual Art and Home Economy. Each course is divided in Form 1, Form 2 and Form 3.Each student studies eight subjects: three core subjects and four elective subjects.

anthonyblee
Автор

Imagine the next exemple: We have 2 teachers for the same student. So there will be (Classid(1), teacherid(1)) And (Classid(2), teacherid(2)) so now we need to take ur student to both teachers so (Student(1) Classid (1)) and (Student(1) Classid (2)). Every student have to register for any teacher for the class.. I dont know if thats optimal... I have that dilema righ now . I mean start multiplying this and the numers go crazy so fast

lucasvega
Автор

Hello and thank you for the tutorial. Can you add some extra models like attendance, term or semester, exam & exam-result for each academic year's term or semester, in a way that it is possible to update the student info's (grade level) at the end of the academic year so that the last academic year's of each student record be separated and safely archived and having new tables created for the current academic year by only creating the new academic year table? I would appreciate your respond.

Snowflake
Автор

take a shot everytime he says "kayy"

aminebrahmi
Автор

I'm just watching this now can I get MySQL code that can retrieve, update and delete the each student or teacher's name?

davomah