Classes

idclassName
1Mathematics
2Physics
3Chemistry
4Biology
5English Literature

Fields

fieldIdfieldName
1Sports Ground
2Art Studio
3Music Room
4Library
5Auditorium

Halls

hallIdhallName
1Lecture Hall A
2Lecture Hall B
3Seminar Room C
4Conference Room D
5Meeting Room E

Students

studentIdfirstNamelastNameageclassID
(→ Classes.id)
1JohnDoe161
2JaneSmith172
3MichaelBrown183
4EmilyWhite194
5DavidGreen175

Numbers

numberIdnumValueclassIDfieldIdhallId
(→ Classes.id)(→ Fields.fieldId)(→ Halls.hallId)
145111
230222
350333
460444
570555

Trips

tripIdtripDatedestinationfieldId
(→ Fields.fieldId)
12022-10-15New York1
22022-10-20London2
32022-10-25Paris3
42022-10-30Tokyo4
52022-11-05Sydney5