Data Conversion - Information Systems Reengineering, Integration and Normalization - page 163

Student
Student#:integer
Student-name:string
Sex:string

reqister provide

Graduate Student
Degree-to-be:string

Section
Section#:integer
Lecture-hours:integer

Enrol
Year:integer
Grade:string

taught-by

divided-by

Course
Course#:integer
Course-title:string
Location:string

Instructor
Inst-name:string
Inst-addr:string
SS#:integer

Prerequisite
Prerequisite:string
Prereq-title:string

Prere Pre-by

Fig. 4.12 Translated object-oriented schema in UML

Its translated object-oriented schema is as follows:

Class Student Class Graduatestudent

attr student#: integer inherit Student

attr student_name:string attr degree_to_be: string

attr sex: string end

end

ClassSection ClassInstructor

attr section#: integer attr inst_name: string

attr lecture_hour: integer attrss#: integer

association attr divided_by ref course attr inst_addr: string

association attr taught_by ref instructor end

end

ClassCourse Class Prerequisite
attr course:string attr course: string
attr course_title: string attr prerequisite:string
attr location:string attr prereq_title:string
associationattrprer_by ref set(prerequisite) association attr prere ref course
end end