Database Reference
In-Depth Information
Report Requirements
Employees at Marvel College require several reports to manage students, classes, schedules, and faculty
members; these reports have the following requirements.
Report card: At the end of each semester, the system must produce a report card for each student.
A sample report card is shown in Figure A-1.
316
MARVEL COLLEGE
Credits
Taken
Credits
Earned
Grade
Points
Course
Number
Course
Description
Department
Computer Science
Mathematics
Grade
CS 162
MTH 201
Programming I
Calculus I
A
B+
4
3
4
3
16.0
9.9
Current Semester Totals
3.70
25.9
7
Credits
Taken
7
Semester: FA13
Credits
Earned
GPA
Total
Points
Cumulative Totals
44
Credits
Taken
44
3.39
149.2
Student Number: 381124188
Credits
Earned
GPA
Total
Points
Student Name & Address
Brian Connors
686 Franklin
Hart, MI 48282
Local Address (IF DIFFERENT)
4672 Westchester
Trent, MI 48222
FIGURE A-1
Sample report card for Marvel College
Class list: The system must produce a class list for each section of each course; a sample class list is
shown in Figure A-2. Note that space is provided for the grades. At the end of the semester, the instructor
enters each student
'
s grade and sends a copy of the class list to the records office.
CLASS LIST
Department: CS
Computer Science
Term: FA13
Course: 162
Programming I
(4 CREDITS)
Section: B
Schedule Code: 2366
Time: 1:00 - 1:50 M, T, W, F
PLACE: 118 SCR
Instructor: 462 Diane Johnson
Student
Number
381124188
Class
Standing
Student Name
Grade
Brian Connors
2
FIGURE A-2
Sample class list for Marvel College
