A5 - -1 University of Waterloo School of Computer Science...

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

View Full Document Right Arrow Icon
- 1 – University of Waterloo School of Computer Science CS348 Spring 2009 Assignment 5 Due: July 7, 2009 1. Consider the following relational schema. Student (Snum, Sname) Course( Cnum, Cname ) Prerequisite (Cnum, Prereq ) Professor (Enum, Ename, Dept, Office) Enrollment (Snum, Cnum, Term , Section, Mark) Schedule (Cnum, Term, Section, Days, Time, Room) Class (Cnum, Term, Section , Instructor) The relation Professor stores information on professors. Enum is the employee number. Ename and Office are the name of a professor and his/her office, respectively. Dept indicates the department with which a professor is affiliated. Prerequisite stores the information on prerequisites of a course. All other relations should be self-explanatory. For each relation scheme, the underlined attributes form the primary key. The attribute Snum (and Cnum) in the Enrollment relation is a foreign key referencing the relation Student (and Course, respectively). Each of the attributes Cnum and Prereq in the Prerequisite relation is a foreign key referencing the relation Course. The attribute Cnum (and Instructor) in the Class relation is a foreign key referencing the
Background image of page 1

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

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 2

A5 - -1 University of Waterloo School of Computer Science...

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