Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider the SALES database on the last page of this handout. For each of the following data requests, provide relational algebra to solve the request
Consider the SALES database on the last page of this handout. For each of the following data requests, provide relational algebra to solve the request and (2) give the result (relation instance 2. a. Find all (order number, customer name, agent name) triples for orders in April (apr) or May (may) b. Find the agent name and city, and customer name and city by matching agent and customer cities. Include ALL agents in the result, even if there are no customers from their city. Order Customer OrdNo Month CustID AgentID ProdID QuantOrd CustID CName City Discount 001 TipTop Puyallup10 002 Basics Seattle 12 C003 Allied Seattle 004 ACME Puyallup c005 Mega Bellevue 006 ACME Olympia 1011jan01 01 p01 1012jan c001 a1 p01 1013 jan C002 a03p03 pS 1000 1000 1000 Product 8ProdID PName City Quantity Price 8p01 marker Seattle 111400 $1.251014 j c003 a03 8p02 eraser Kenmore 203000 s0.50 0 p03 glue 03 1015 jan C003 a 1000 600 600 400 600 p01 lp04 pen Puyallup | 125300|$1.00 | 1017feb 001506 po p03 p04 1018 feb c001 a03 p05 pencil Seattle 221400 $1.00 p06 folder Seattle 123100 $2.00 p07 case Kenmore 100500 $3.00 Agent 1019 feb c001 02p2 - gentID AName City Percent 01 Smith Lacey 1020feb-[c006-03_p07 1021 feb C004 06 p01 6 a02 a03 a04 JonesKenmore Brown Kirkland Gray Bellevue 05 Otasi Puyallup 400 500 800 800 800 1022 mar c001 a05 p06 1023 mar c001 a04 p0 6 1024 mar C006 a06 p01 1025 apr c001 p7 1026 may c002 03 06 Smith Seattle
Step 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