Question: 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?
 \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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!