Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Database Management Systems

Authors: Mark L. Gillenson

3rd Edition

978-1119907466

More Books

Students also viewed these Databases questions