cs411-sp07-hw2-part1

cs411-sp07-hw2-part1 - CS411 Database Systems Spring 2007...

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

View Full Document Right Arrow Icon

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

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

Unformatted text preview: CS411 Database Systems Spring 2007 HW #2 - Part 1 Due: 11:30am CST, 2/27/07 Note: Print your name and NetID in the upper right corner of every page of your submission. Handin your stapled homework to Trisha Benson in 4322 SC. In case Trisha is not in office, slide your homework under the door. NOTE : Please use Greek notations for relational algebra operators. (e.g., for a selection operator, for a projection operator, for a cartesian product, for a renaming operator, and 1 for a join operator.) Problem 1 Relational Algebra Consider the following relations: Suppliers(sid , sname, address) Parts(pid , pname, color) Catalog(sid , pid , cost) Give the queries in relational algebra to answer the following questions. (1.1) Find the sid of all suppliers who supply green parts. (1.2) Find the sname of suppliers who supply some green part but are NOT at 201 N. Goodwin Ave.. (1.3) Find the sname of suppliers who dont supply any part that is more expensive than $50....
View Full Document

Page1 / 2

cs411-sp07-hw2-part1 - CS411 Database Systems Spring 2007...

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