Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

table [ [ CUSTOMERS , cid,cname,city,discount ] , [ , c 0 0 1 , TipTop,Duluth, 1 0 . 0 0 ] , [

\table[[CUSTOMERS,cid,cname,city,discount],[,c001,TipTop,Duluth,10.00],[,c002,Basics,Dallas,12.00],[,c003,Allied,Dallas,8.00],[,c004,ACME,Duluth,8.00],[,c006,ACME,Kyoto,0.00]]
\table[[PRODCCTS,pid,pname,city,quantity,price],[,p01,comb,Dallas,111400,0.50],[,p02,brush,Newark,203000,0.50],[,p03,razor,Duluth,150600,1.00],[,p04,pen,Duluth,125300,1.00],[,p05,pencil,Dallas,221400,1.00],[,p06,folder,Dallas,123100,2.00],[,p07,case,Newark,100500,1.00]]
\table[[AGENTS,aid,aname,city,percent],[,a01,Smith,New York,6],[,a02,Jones,Newark,6],[,a03,Brown,Tokyo,7],[a04,Gray,New York,6,],[a05,Otasi,Duluth,5,],[,a06,Smith,Dallas,5]]
\table[[ORDERS,ordno,month,cid,aid,pid,qty,dollars],[1011,jan,c001,a01,p01,1000,450.00],[1012,jan,c001,a01,p01,1000,450.00],[1019,feb,c001,a02,p02,400,180.00],[1017,feb,c001,a06,p03,600,540.00],[1018,feb,c001,a03,p04,600,540.00],[1023,mar,c001,a04,p05,500,450.00],[1022,mar,c001,a05,p06,400,720.00],[1025,apr,c001,a05,p07,800,720.00],[1013,jan,c002,a03,p03,1000,880.00],[1026,may,cOO2,a05,p03,800,704.00],[1015,jan,c003,a03,p05,1200,1104.00],[1014,jan,cO03,a03,p05,1200,1104.00],[1021,feb,c004,a06,p01,1000,460.00],[1016,jan,c006,a01,p01,1000,500.00],[1020,feb,c006,a03,p07,600,600.00],[1024,mar,c006,a06,p01,800,400.00]]Using Relational Algebra, Get pids of products not ordered by any customer living in a city whose (city) namebegins with the letter D. How can we find cities with names beginning with the letter D?
image text in transcribed

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

Database Processing

Authors: David Kroenke

11th Edition

0132302675, 9780132302678

More Books

Students also viewed these Databases questions

Question

How do Data Types perform data validation?

Answered: 1 week ago

Question

How does Referential Integrity work?

Answered: 1 week ago