Relational Algebra Database:

List the name and ID of customers who made a sales transaction on 2/1/2011.

List the customer name and store zipcode of all female customers who made a sales transaction at a store in the region named 'Chicagoland'.

List the customer name and customer zipcode of all female customers who bought a product named "Zzz Bag".

List the customer name and customer zipcode of all customers who did not buy any items from store S2.

List the total number of products that cost less than $100. (12pts)

List the vendor name and the cost of the product with the lowest cost in category CP that is produced by each vendor. Use a natural join when the attributes have the same name.

List the region name, store id and store zip for all regions. Include all regions, even those regions without any stores.

Tables

customer

product

region

salestrans

vendor

store

soldvia

cid 1 1-2-333 Tina 2 2-3-444 Tony 3 4-5-666 Pam cname gender czip 60137 F 60611 M 35401 F