Data from one or more tables- use zag
-- Marketing needs a list of customers and what product they have purchased
-- which also shows category name and vendor name for that product.  
-- Generate query that returns customername, productname, categoryname, vendorname
-- order the list by customer name
-- Your list should contain 9 items

 

category categoryid CHAR(2) categoryname VARCHAR(25) Indexes product productid CHAR(3) productname VARCHAR(25) productprice DECIMAL (7,2) ++ vendorid CHAR(2) categoryid CHAR(2) Indexes 1 T 1 vendor vendorid CHAR(2) vendorname VARCHAR (25) Indexes includes productid CHAR(3) ?tid VARCHAR(8) quantity INT Indexes HH salestransaction tid VARCHAR(8) customerid CHAR (7) storeid VARCHAR(3) tdate DATE Indexes store storeid VARCHAR(3) storezip CHAR(5) regionid CHAR(1) Indexes H V region regionid CHAR(1) regionnam e VARCHAR(25) Indexes K >+ -H customer customerid CHAR (7) customername VARCHAR(15) customerzip CHAR (5) Indexes + saletransaction ?tid VARCHAR (8) customerid CHAR(7) stored VARCHAR (3) tdate DATE Indexes 0 0 Q 0