Database Reference
In-Depth Information
Department
337
Course
Major
DepartmentCode
MajorNum
CourseNum
DepartmentCode (FK)
DepartmentName
Location
Description
DepartmentCode (FK)
CourseTitle
NumCredits
has prereq
is prereq
Ofice
Advises
Prereq
CourseNum (FK)
DepartmentCode (FK)
CourseNum/1 (FK)
DepartmentCode/1 (FK)
MajorNum (FK)
StudentNum (FK)
OficeNum
Phone
FacultyNum (FK)
Faculty
FacultyNum
LastName
FirstName
Street
City
State
Zip
CurrentRank
StartDate
OficeNum (FK)
DepartmentCode (FK)
Section
RegistrationRequest
ScheduleCode
SemesterCode (FK)
StudentNum (FK)
ScheduleCode (FK)
SemesterCode (FK)
SectionLetter
Time
Room
primary
alternate
ScheduleCode/1 (FK)
SemesterCode/1 (FK)
CurrentEnrollment
MaximumEnrollment
FacultyNum (FK)
CourseNum (FK)
DepartmentCode (FK)
Semester
StudentClass
SemesterCode
StudentNum (FK)
ScheduleCode (FK)
SemesterCode (FK)
Student
StartDate
EndDate
ExamStartDate
ExamEndDate
WithdrawalDate
StudentNum
Grade
LastName
FirstName
LocalStreet
LocalCity
LocalState
LocalZip
PermStreet
PermCity
PermState
PermZip
Student Grade
CourseNum (FK)
DepartmentCode (FK)
StudentNum (FK)
SemesterCode (FK)
Grade
CreditsEarned
GradePoints
CreditsTaken
CreditsEarned
GPA
TotalPoints
ClassStanding
FIGURE A-17
Cumulative design after User View 10
Because the process of determining whether a student has had the prerequisites for a given course
involves examining the grades (if any) received in these prior courses, it makes sense to analyze the user
view that involves grades before treating the user view that involves enrollment.
User View 11
—
Post grades: For each section of each course, the system must post the grades that are
indicated on the class list submitted by the instructor and produce a grade verification report. There is a
slight problem with posting grades
grades must be posted by section to produce the grade report (in other
words, you must record the fact that student 381124188 received an A in the section of CS 162 whose
schedule code was 2366 during the fall 2013 semester). On the other hand, for the full student information
report, there is no need to have any of the grades related to an actual section of a course. Further, because
section information, including these grades, is kept for only two semesters, grades would be lost after two
semesters if they were kept only by section because section information would be purged at that time.
—
