Map the EER model of the following databases, to a relational model. Show all integrity types(Clarify your answer by underline the Primary key, and dotted line the Foreign Key).

(a)  International School of Technology

 

Transcribed Image Text:

Semester Year Instructor Media Trained Emp_ID (PK) 0... to uses 0.. Name Rank Mediaid (PK) Media Type TypeDescription Phone[0..] 1..1 Taichies Prefers Timeslot TSIS (PK) DayOfWeek StartTime EndTime Section EnrollmentLimit 1.1 1..* Prerequisites Computer 1..1 CourseID (PK) Course Description Credits SectionID 0.. (Mandatory, Or) Classroom Board type Computer id (PK) ComputerType TypeDescription Disk Capacity Processor Speed Semester Year Instructor Media Trained Emp_ID (PK) 0... to uses 0.. Name Rank Mediaid (PK) Media Type TypeDescription Phone[0..] 1..1 Taichies Prefers Timeslot TSIS (PK) DayOfWeek StartTime EndTime Section EnrollmentLimit 1.1 1..* Prerequisites Computer 1..1 CourseID (PK) Course Description Credits SectionID 0.. (Mandatory, Or) Classroom Board type Computer id (PK) ComputerType TypeDescription Disk Capacity Processor Speed