Database Reference
In-Depth Information
Department
334
Course
Major
DepartmentCode
CourseNum
DepartmentCode (FK)
MajorNum
DepartmentName
Location
Description
DepartmentCode (FK)
CourseTitle
NumCredits
has prereq
is prereq
Advises
Ofice
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)
Relationship named
primary is identifying
(represented by
solid line)
RegistrationRequest
Section
StudentNum (FK)
ScheduleCode (FK)
SemesterCode (FK)
ScheduleCode
SemesterCode (FK)
SectionLetter
Ti m e
Room
FacultyNum (FK)
CourseNum (FK)
DepartmentCode (FK)
primary
ScheduleCode/1 (FK)
SemesterCode/1 (FK)
alternate
Relationship named
alternate is nonidentifying
(represented by
dashed line)
StudentClass
Semester
StudentNum (FK)
ScheduleCode (FK)
SemesterCode (FK)
SemesterCode
Student
StartDate
EndDate
ExamStartDate
ExamEndDate
WithdrawalDate
StudentNum
Grade
LastName
FirstName
LocalStreet
LocalCity
LocalState
LocalZip
PermStreet
PermCity
PermState
PermZip
StudentGrade
CourseNum (FK)
DepartmentCode (FK)
StudentNum (FK)
SemesterCode (FK)
Grade
CreditsEarned
GradePoints
CreditsTaken
CreditsEarned
GPA
TotalPoints
ClassStanding
FIGURE A-16
Cumulative design after User View 7
NOTE
The foreign keys are the combination of PrimaryCode and SemesterCode as well as the combination of AlternateCode and
SemesterCode. Because PrimaryCode and AlternateCode are portions of the foreign keys that must match the ScheduleCode
in the Section table, they have been renamed ScheduleCode and ScheduleCode/1, respectively. Likewise, the second
SemesterCode has been renamed SemesterCode/1.
