This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full 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
- Spring '07