Databases Reference
In-Depth Information
317
FULL STUDENT INFORMATION
Student Number: 381124188
Term: FA10
Name: Brian Connors
City: Hart
City: Trent
State: MI
State: MI
Zip: 48282
Zip: 48222
Major 1: Information Sys.
Department: Computer Science
Advisor: Mark Lawerence
Major 2: Accounting
Department: Business
Advisor: Jill Thomas
Major 3:
Department:
Advisor:
Course
Number
Grade
Earned
Te r m
SP10
Credits
MTH
123
Trigonometry
Western Civilization
American Literature
4
3
3
A
A-
A
16.0
11.1
12.0
HST
201
ENG
101
FA10
CS
162
Programming I
Calculus I
4
4
A
B+
16.0
9.9
MTH
201
Credits Attempted:
Credits Earned:
Grade Points:
Grade Point Avg:
Class Standing:
44
44
149.2
3.39
2
FIGURE A-6
Sample full student information report for Marvel College
Faculty information report:
This report lists all faculty by department and contains each faculty mem-
ber's ID number, name, address, office location, phone number, current rank (Instructor, Assistant Professor,
Associate Professor, or Professor), and starting date of employment. It also lists the number, name, and local
and permanent addresses of each faculty member's advisees; the code number and description of the major in
which the faculty member is advising each advisee; and the code number and description of the depart-
ment to which this major is assigned. (Remember that this department need not be the one to which the fac-
ulty member is assigned.)
Work version of the time schedule:
Although this report is similar to the original time schedule (see
Figure A-3), it is designed for the college's internal use. It shows the current enrollments in each section of each
course, as well as the maximum enrollment permitted per section. It is more current than the time schedule.
(When students register for courses, enrollment figures are updated on the work version of the time
schedule. When room or faculty assignments are changed, this information also is updated. A new version of
this report that reflects the revised figures is printed after being updated.)
Course report:
For each course, this report lists the code and name of the department that is offering the
course, the course number, the description of the course, and the number of credits awarded. This report also
includes the department and course number for each prerequisite course.
In addition to being able to add, change, and delete any information in the report requirements, the system
must be able to accomplish the following update requirements:
Enrollment:
When a student attempts to register for a section of a course, the system must determine
whether the student has received credit for all prerequisites to the course. If the student is eligible to enroll in
the course and the number of students currently enrolled in the section is less than the maximum enroll-
ment, enroll the student.
