Computer Science 4611
DBMS
Homework Assignment 2 (10 points)
Due February 14, 2003

1. Page 96, Exercise 3.8
2. For the schema on Page 127, Exercise 4.3, write the following queries in relational algebra and domain relational calculus:
   1. Find the names of blue parts
   2. Find the names of all parts that cost more than $100.00
   3. Find the names of suppliers who supply some part that costs more than $100.00
   4. Find the names of suppliers who supply ALL parts that cost more than $100.00
   5. Find the names of parts where two suppliers charge different amounts for that part