Databases Reference
In-Depth Information
Course
Major
Department
328
DepartmentCode
CourseNum
DepartmentCode (FK)
MajorNum
Description
DepartmentCode (FK)
DepartmentName
CourseTitle
NumCredits
has prereq
is prereq
Advises
Office
Prereq
CourseNum (FK)
DepartmentCode (FK)
Course Num/1 (FK)
DepartmentCode/1 (FK)
MajorNum (FK)
StudentNum (FK)
OfficeNum
Phone
FacultyNum (FK)
Faculty
FacultyNum
LastName
FirstName
Street
City
State
Zip
CurrentRank
StartDate
OfficeNum (FK)
DepartmentCode (FK)
Section
ScheduleCode
SemesterCode (FK)
SectionLetter
Time
Room
FacultyNum (FK)
CourseNum (FK)
DepartmentCode (FK)
Student
StudentClass
Semester
StudentNum
StudentNum (FK)
ScheduleCode (FK)
SemesterCode (FK)
LastName
FirstName
LocalStreet
LocalCity
LocalState
LocalZip
PermStreet
PermCity
PermState
PermZip
SemesterCode
Grade
StudentGrade
CourseNum (FK)
DepartmentCode (FK)
StudentNum (FK)
SemesterCode (FK)
Grade
CreditsEarned
GradePoints
CreditsTaken
CreditsEarned
GPA
TotalPoints
ClassStanding
FIGURE A-14
Cumulative design after User View 4
User View 5—Grade verification report:
After the records office processes the class list, it returns the class
list to the instructor with the grades entered in the report. The instructor uses the report to verify that the
records office entered the students' grades correctly. Because the only difference between the class list and the
grade verification report is that the grades are printed on the grade verification report, the user views will be
quite similar. In fact, because you made a provision for the grade when treating the class list, the views are
identical and no further treatment of this user view is required.
User View 6—Time schedule:
List all sections of all courses offered during a given semester. Each sec-
tion has a unique four-digit schedule code. The time schedule lists the schedule code; the department offer-
ing the course; the course's number, section letter, and title; the instructor teaching the course; the time the
course meets; the room in which the course meets; the number of credits generated by the course; and the pre-
requisites for the course. In addition to the information shown in the figure, the time schedule includes the
date the semester begins and ends, the date final exams begin and end, and the last withdrawal date. The
attributes on the time schedule are as follows: term (which is a synonym for semester), department code,
