cs186_sp08_mt1-11 - b. (4 pts) Complete the following...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Name: __________________________________ Relational Calculus In this section, Assume there is an additional table , Manager, with a single attribute, NAME, and that there is foreign key constraint from Store.MANAGER to Manager.NAME. a. (4 pts) Write a (tuple) Relational Calculus expression to return Sales tuples indicating that the Shady Lane, Austin store sold more than 50 Hammers. Your answer can use the values shown above to get PRODUCT_ID and STORE_ID and avoid joins.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: b. (4 pts) Complete the following expression to return managers that only manage stores in the WEST region M | M Manager 2200 _____________________________________ c. (8 pts) Write a Relational Calculus expression to find managers whose stores all either 1) sold more than 1000 of some (single) Nail product on some day or 2) sold a power tool costing over $100. 11...
View Full Document

This note was uploaded on 08/26/2009 for the course CS 186 taught by Professor Staff during the Spring '08 term at University of California, Berkeley.

Ask a homework question - tutors are online