hw3extendedWAggr-11

hw3extendedWAggr-11 - Consider the following University...

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

View Full Document Right Arrow Icon
Consider the following University Database schemas: Department (D-code , D-Name, Chair-SSn) Course (D-code, C-no , Title, Units) Prereq (D-code, C-no, P-code, P-no ) Class (Class-no , D-code, C-no, Instructor-SSn) Faculty (Ssn , F-Name, D-Code, Rank) Student (Ssn , S-Name, Major, Status) Enrollment (Class-no, Student-Ssn) Transcript (Student-Ssn, D-Code, C-no, Grade) In the above tables, primary keys are underlined. Some explanations of attributes are as follows. Chair-Ssn in Department refers to Ssn in Faculty table. Instructor-SSn refers to Ssn in Faculty table, and Student-Ssn refers to Sssn in Student table. Class-no is a unique ID for each offering of a course. (For example, a class with class-no='12020' may be an offering of INFS 614, in which case, we may have a row like <12020, INFS, 614, 100009399> in the Class table.) <P-code, P-no> in Prereq table refers to <D-code, C-no> in the Course table, i.e., they refer to courses. A example row in Prereq table is <INFS, 614, INFS, 501> , which means that INFS614 needs INFS501 as a prerequisite course. Other foreign keys and meanings of the tables should be obvious.
Background image of page 1

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

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

This document was uploaded on 04/28/2011.

Page1 / 2

hw3extendedWAggr-11 - Consider the following University...

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