Question: table [ [ CUSTOMERS , cid,cname,city,discount ] , [ , c 0 0 1 , TipTop,Duluth, 1 0 . 0 0 ] , [
tableCUSTOMERScid,cname,city,discountTipTop,Duluth,Basics,Dallas,Allied,Dallas,ACME,Duluth,ACME,Kyoto,
tablePRODCCTSpid,pname,city,quantity,pricepcomb,Dallas,pbrush,Newark,prazor,Duluth,ppen,Duluth,ppencil,Dallas,pfolder,Dallas,pcase,Newark,
tableAGENTSaid,aname,city,percentaSmith,New York,aJones,Newark,aBrown,Tokyo,aGray,New York,aOtasi,Duluth,aSmith,Dallas,
tableORDERSordno,month,cid,aid,pid,qtydollarsjan,jan,pfeb,pfeb,pfeb,pmar,pmar,papr,jan,pmay,pjan,pjan,pfeb,cpjan,pfeb,mar,pUsing 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
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
