Database Reference
In-Depth Information
Q&A
330
Question: Determine the tables and keys required for User View 4. Merge the result into the cumulative
design and draw the E-R diagram for the new cumulative design.
Answer: Figure A-14 shows the new cumulative design.
Course
Major
Department
CourseNum
DepartmentCode (FK)
MajorNum
DepartmentCode
Description
DepartmentCode (FK)
DepartmentName
CourseTitle
NumCredits
has prereq
is prereq
Advises
Ofice
Prereq
CourseNum (FK)
DepartmentCode (FK)
Course Num/1 (FK)
DepartmentCode/1 (FK)
OficeNum
MajorNum (FK)
StudentNum (FK)
Phone
FacultyNum (FK)
Faculty
FacultyNum
LastName
FirstName
Street
City
State
Zip
CurrentRank
StartDate
OficeNum (FK)
DepartmentCode (FK)
Section
ScheduleCode
SemesterCode (FK)
SectionLetter
Ti m e
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
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
User View 5
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.
'
Search WWH ::




Custom Search