354.3-08.Assignment7

354.3-08.Assignment7 - CMPT-354 D1 Fall 2008 Instructor:...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
CMPT-354 D1 Fall 2008 Instructor: Martin Ester TA: Gustavo Frigo Assignment 7 Total marks: 100 (10 % of the assignments) Posted: October 31, 2008 Due date: November 7, 2008 This is a paper and pencil assignment. Please, submit hard copies of your solutions to the assignment drop box. Problem 1 (Translation of ER diagram into relational schema) (55 marks) Translate the following ER diagram of a university database into an equivalent relational schema. This ER diagram makes the simplifying assumption that each class of a given course section is taught in the same room. ISA LName Courses Instructors Sections Students Enrolment Teaching IsSection Of CourseNo Title InstructorNo FName StudentNo FName LName Year GPA SectionNo Room Grade Capacity Year Term TAAssign nment TAs Contract No ISA
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Your relational schema should satisfy the following two design criteria: The number of tables should be minimal. As many integrity constraints from the ER diagram as possible should be
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

354.3-08.Assignment7 - CMPT-354 D1 Fall 2008 Instructor:...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online