Students and Exams


FACTS for the Data Model for Students and Exams

Addition on 3rd. March 2002 for school/college timetabling database system  :-

Main Components :-
teacher/lecturer
course
subject
room
time. 
The problem is time as lessons can have different start times, lengths and finish times.

Things of Interest in the Scope of the Data Mode :-
1. Exams.
2. Courses.
3. Semesters.
4. Students.

What are the relationships between these Things of Interest :-
1. A COURSE has one EXAM at the end of each SEMESTER.
2. An EXAM is always associated with a COURSE and a SEMESTER.
3. An EXAM is taken at the end of a SEMESTER.
4. An EXAM can be taken by zero or many STUDENTs.
5. A STUDENT can take zero or many EXAMS.

What are the characteristics of these Things of Interest :-
1. An EXAM has a DATE.
2. A SEMESTER has a Start and End Date.
3. A STUDENT has a Name, and Class.

Barry Williams
Principal Consultant
Database Answers