Try to paste the database from above here so it\'s easier to copy if needed. Cus
ID: 3601285 • Letter: T
Question
Try to paste the database from above here so it's easier to copy if needed.
Customer
CustID
CName
City
Discount
c001
TipTop
Puyallup
10
c002
Basics
Seattle
12
c003
Allied
Seattle
8
c004
ACME
Puyallup
8
c005
Mega
Bellevue
8
c006
ACME
Olympia
0
Agent
AgentID
AName
City
Percent
a01
Smith
Lacey
6
a02
Jones
Kenmore
6
a03
Brown
Kirkland
7
a04
Gray
Bellevue
6
a05
Otasi
Puyallup
5
a06
Smith
Seattle
5
Order
OrdNo
Month
CustID
AgentID
ProdID
QuantOrd
1011
jan
c001
a01
p01
1000
1012
jan
c001
a01
p01
1000
1013
jan
c002
a03
p03
1000
1014
jan
c003
a03
p05
1200
1015
jan
c003
a03
p05
1200
1016
jan
c006
a01
p01
1000
1017
feb
c001
a06
p03
600
1018
feb
c001
a03
p04
600
1019
feb
c001
a02
p02
400
1020
feb
c006
a03
p07
600
1021
feb
c004
a06
p01
1000
1022
mar
c001
a05
p06
400
1023
mar
c001
a04
p05
500
1024
mar
c006
a06
p01
800
1025
apr
c001
a05
p07
800
1026
may
c002
a05
p03
800
Product
ProdID
PName
City
Quantity
Price
p01
marker
Seattle
111400
$1.25
p02
eraser
Kenmore
203000
$0.50
p03
glue
Puyallup
150000
$2.00
p04
pen
Puyallup
125300
$1.00
p05
pencil
Seattle
221400
$1.00
p06
folder
Seattle
123100
$2.00
p07
case
Kenmore
100500
$3.00
Customer
CustID
CName
City
Discount
c001
TipTop
Puyallup
10
c002
Basics
Seattle
12
c003
Allied
Seattle
8
c004
ACME
Puyallup
8
c005
Mega
Bellevue
8
c006
ACME
Olympia
0
2. Consider the SALES database on the last page of this handout. Show the relation instances that would be produced by each of the tollowing relational algebra operations a. Il AgentName.Agent.City.Cust1D.CName (Agent Customer) b. 0rdNo.cName.PName.Quantord(oMonth-reb(Customer) ba 0rder ba Product) ordNoCName.PName.QuartoralOMonth= feb SALES Database: Order Customer CustID CNameCity Discount TipTop Puyallup Agent gentID AName City Percent OrdNo Month CustID AgentID ProdIDouantOrd lc001- -10 1011jan 1012 jan 1013 ian 1014 jan 1015 jan 1016 jan 1017 feb 1018 feb 1019 feb c001 a02 1020 feb c006 a03 1021 feb 1022 mar c001 a05 1023 mar 001 a04 1024 mar c006 a06 1025 apr 1026 may C002 a05 p01 p01 p03 p05 po5 p01 p03 p04 po2 p07 p01 p06 p05 p01 p07 p03 a01 Smith Lacey a02 a03Brown Kirkland a04 Gray Bellevue 6 1000 1000 1200 1200 1000 600 600 400 600 1000 400 500 800 800 800 cO02 Basics Seattle C003 Allied Seattle C004 ACME Puyallup c005 Mega Bellevue c006 ACME Olympia c001 a01 c002 a03 c003 a03 cO03 a03 c006 a01 c001 a06 c001 a03 JonesKenmore 6 Otasi Puyallup 0 a06SmithSeattle Product ProdID PName City Quantity Price p01 marker Seattle 111400 $1.25 p02 eraser Kenmore 203000 $0.50 p03 glue Puyallup 150000 $2.00 p04 pen Puyallup 125300 $1.00 p05 pencil Seattle 221400 $1.00 p06 folder Seattle 123100 $2.00 p07 case Kenmore 100500 $3.00 C004 a06 c001 a05Explanation / Answer
Ans)
a Ans)
Agent Customer
a05
B) Ans
AgentName Agent city CustID CName a04 Gray Bellevue c005 Megaa05
Otasi Puyallup c001 TipTop a06 Smith Seattle c002 Basics