354.3-08.Solution7 - CMPT-354 D1 Fall 2008 Instructor...

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

View Full Document Right Arrow Icon
CMPT-354 D1 Fall 2008 Instructor: Martin Ester TA: Gustavo Frigo Solution 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 expressed. a) Write down the complete SQL statements to create the relational schema, including PRIMARY KEY, FOREIGN KEY and NOT NULL constraints. For the FOREIGN KEY constraints, you do not need to specify the reactions to violating updates. (50 marks) CREATE
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/07/2009 for the course CS 12601 taught by Professor Kewang during the Spring '09 term at Simon Fraser.

Page1 / 4

354.3-08.Solution7 - CMPT-354 D1 Fall 2008 Instructor...

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

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