Chapter 2: Preparing for the project work
25
Example 2
A database is to hold information on students, the courses they take and the
teachers who teach them. Data to be held will include a student’s:
• name
• sex
• age
•
address
• courses taken.
Each course has a name and meets up to three times during the week (for
example, Tuesday 10–11, Wednesday 4–6). A course can have one or more
teachers. The details of the teachers to be stored are:
• name
• telephone number
• qualification.
The system will allow a teacher to record homework marks for students.
The system should have input screens to allow new students to be added to the
database and a screen to allow students who leave to be deleted.
Similarly, it
should be possible to add or delete courses and teachers as well as to record a
change in who is teaching or taking which courses.
The system must produce, on screen and on paper, a report that shows:
• a query of all the people
who teach a certain student
• a report of all students who have done 60 per cent or less of their
homework assignments
• a report, by course, of the
students enrolled sorted by
family name (for example, a register)
• a query as to all teachers who are teaching more than two courses
• a list of all students who should be in class at a given time (say, Friday
between 9.00 am and 2.00 pm).
Dostları ilə paylaş: