Database Reference
In-Depth Information
Table 2.4
Class Registration Receipt
Student ID: 10
The following classes have been registered:
Class ID
Course ID
1004
ISC3321
1002
ISC4301
Table 2.5
Transcript
Student ID: 10
First Name: Liz
Last Name: Smith
Semester: Spring07
Course ID:
Course Name:
Grade:
ISC2301
VB
A
Semester Average: 4.0
Semester: Summer07
Course ID:
Course Name:
Grade:
ISC3311
Database
B
Semester Average: 3.0
Semester: Fall07
Course ID:
Course Name:
Grade:
ISC3321
Info-Systems
ISC4301
E-Commerce
Semester Average
Grade Accumulate Average: 3.5
he registration clerks will verify that the prerequisites are satisied. If a prerequisite is not
satisied or a class is full, the student will be asked to choose a diferent class. If the registration is
conirmed, the student will get a receipt like the one shown in Table 2.4.
he class id is necessary since the same course may be taught in more than one class. If asked
by the student, the registration clerk will print the transcript in the format shown in Table 2.5.
After the information is collected, the next task is to extract the useful components for the
database design.
