Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Write the relational algebra statement to answer the following question. Then write the SQL statement to answer the same question. Create an unduplicated list of
Write the relational algebra statement to answer the following question. Then write the SQL statement to answer the same question. Create an unduplicated list of product id's for products that have been ordered.
CUSTOMERS PRODUCTS City scnt Ipi d pname city quantity price c i d name C001 TipTop Duluth 10.00 p01 comb Dallas 111400 0.30 C002 Basics Dallas 12.00 p02 brush Newark 203000 0.50 C003 Allied Dallas 800 p03 razor Duluth 150600 100 c004 ACME Duluth 8.00 p04 pen Duluth 125 300 100 C006 ACME Kyoto 000 p05 pencil Dallas 221400 1.00 case Newark 100500 1.00 07 AGENTS Laid name City percent ORDERS a01 Smith New York 6 ordno month cid aid pid qt y dollars 202 ones Newark 6 1012 ian C001 a01 p01 1000 450.00 1023 mar C001 204 p05 500 450.00 1022 mar c001 205 P06 400 720.00 1013 C002 203 p03 1000 880.00 1026 may c002 aos p03 800 704.00 1015 Ijan C003 203 pos 1200 1101.00 1011 jan LC003 a03 pos 1200 110.00 1021 feb c004 206 p01 1000 46000 1016 jan C006 a01 P01 1000 500.00 1020 feb C006 203 p07 600 600.00 1024 mar c006 a06 po1 800 400.00Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started