Cs186_sp08_mt1-10 - $210 Hammer Naomi Smith $15 $12 c π MANAGER π STORE_ID(Stores π STORE_ID(Sales Stores(4 pts MANAGER d(5 pts S1 =

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

View Full Document Right Arrow Icon
Name: __________________________________ Aug. 11 64221 13 1000 $0.15 Nov. 2 63433 15 50 $0.13 June 29 43121 15 2 $12 July 4 43121 15 1 $12 For the following queries, we have supplied some of the values for the results of the query. Fill in the missing values. Assume set semantics. a π NAME,QUANTITY CATEGORY=’Nails’ ( Products Sales ) ) (4 pts) NAME QUANTITY Roofing nail 100 1000 Drywall nail b. π NAME,MANAGER,MSRP,PRICE MSRP>PRICE ( Products Sales Stores ) ) ( 5pts) NAME MANAGER MSRP PRICE $0.11 Table saw
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $210 Hammer Naomi Smith $15 $12 c. π MANAGER ( ( π STORE_ID (Stores) - π STORE_ID (Sales) ) Stores ) (4 pts) MANAGER d. (5 pts) S1 = ρ (Sales1(DATE1, PRODUCT_ID1, STORE_ID1, QUANTITY1, PRICE1),Sales) S2 = ρ (Sales2(DATE2, PRODUCT_ID2, STORE_ID2, QUANTITY2, PRICE2),Sales) π PRODUCTID1,PRICE1,PRICE2 ( σ DATE1 <> DATE2 ( σ PRODUCT_ID1=PRODUCT_ID2 S1 × S2 ) ) PRODUCT_ID1 PRICE1 PRICE2 43121 $15 $12 64221 $0.11 $0.15 10...
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