Try to paste the database from above here so it\'s easier to copy if needed. Cus

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 a05

Explanation / Answer

Ans)

a Ans)

Agent Customer

a05

B) Ans

AgentName Agent city CustID CName a04    Gray Bellevue c005    Mega

a05

Otasi Puyallup    c001 TipTop a06 Smith Seattle c002 Basics

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.