Students

StudentIDFirstNameLastNameDateOfBirth
1JohnDoe2003-06-15
2JaneSmith2004-07-22
3AliceJohnson2005-09-10

Teachers

TeacherIDFirstNameLastNameSubject
1Mr.WhiteMathematics
2Mrs.GreenEnglish
3Ms.BlackHistory

Classes

ClassIDTeacherIDRoomNumberDayOfWeekTimeStart
(→ Teachers.TeacherID)
11101Monday09:00:00
22201Wednesday11:00:00
33301Friday14:00:00

Enrollments

EnrollmentIDStudentIDClassIDGrade
(→ Students.StudentID)(→ Classes.ClassID)
111None
221None
332None
413None
523None

Materials

MaterialIDMonthYearResourceTypeQuantityPrice
112021Textbooks5025.5
222021Stationery1001.5
332021Computers10500

Expenses

ExpenseIDMaterialIDSupplierAmount
(→ Materials.MaterialID)
11Office Supply Store150
22Electronics Store500
33Bookstore2550