Database Reference
In-Depth Information
319
FULL STUDENT INFORMATION
Student Number: 381124188
Term: FA13
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
SP13
Credits
Trigonometry
Western Civilization
American Literature
MTH
123
4
3
3
A
A-
A
16.0
11.1
12.0
HST
201
ENG
101
Programming I
Calculus I
FA13
CS
162
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.
'
Update (Transaction) Requirements
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.
