Location:
[CPSC 333]
[Ongoing Examples]
[Student Information Systems]
Version Two
This page was most recently modified on February 4, 1997
This version of the student information system has the capabilities of
Version One, and it can also be used to keep
track of information about students who are registered in several
courses.
As before, every student has a unique ID number, as well as a first
name, middle initial, and last name (which aren't necessarily unique).
Each course has a discipline code (a short character string), a
course number (a positive integer), and a course title
(a longer character string). No two courses have the same discipline
code and also the same course title at the same time. However, several
courses can have the same discipline code (and different course
numbers), and several can have the same course number (with different
discipline codes). Course titles aren't unique.
This system supports the same functions as Version One, with
significant differences and extensions:
- It should be possible to add information about students, even if
those students haven't registered in any courses (yet).
- It should also be possible to add or change information about
courses. Courses can be ``created'' before any students register in
them. Of course, students can't register in courses that don't exist.
- Courses can be deleted; when a course is deleted, all
registrations of students in the course are deleted at the same
time. All other information about this course - namely, information
about which students have passed the course - is deleted at this time
as well. When a course is deleted, a report listing all the course
information that is being deleted (including student registrations,
and so on) is prepared and returned to the user of the system.
- Course titles can be changed, in order to correct errors or update
course information.
- Any student can be registered in or have passed zero or more
courses. Any course can have zero or more students registered in it.
- Any student can have passed zero or more courses. Any course can
have been passed by zero or more students.
- Now, it is necessary to supply a discipline code and a course
number, along with a student's ID number, in order to register a
student in a given course, or to enter the information that the
student has passed, or withdrawn from, the course.
- Information about ``old'' students will be deleted in much the
same way as before: An ID number will be supplied by a user as input,
and the system will prepare a report of all information about students
whose ID number is less than or equal to this (and return it to the
user), and then delete all this information. Now, this information
will include course registration information, etc.
This system will be used one or more times as an example during
lectures:
Location:
[CPSC 333]
[Ongoing Examples]
[Student Information Systems]
[Version Two]
Department of Computer Science
University of Calgary
Office: (403) 220-5073
Fax: (403) 284-4707
eberly@cpsc.ucalgary.ca