Question: 9 Write the relational algebra expression to list the code and name of vendors who supplied no products. Table Line: table [ [ invoicenumber
Write the relational algebra expression to list the code and name of vendors who supplied
no products.
Table Line:
tableinvoicenumberlinenumber,productcode,quantity,unitprice PPVCDRTSM HB WREQ
Table Product:
tableproductcodedescription,indate,quantityonhand,minquantityonhand,price,discountrate,vendorcodeQERPower painter, psi.,,cm pwr saw blad,QLcm pwr saw blad,QQHrd cloth, cmQWHrd cloth, QTY& jigsaw, cm bli,QWE& jigsaw, cm blat,QPD& cordless drill, HBClaw hammer,AASledge hammer, NULLRattail file, fin,WREQHicut chain saw, PVCDRTPVC pipe, cmNULLSMcm metal screw,,SWcm wd screw, WRTTSteel matting,
Table Vendor:
tablevendorcodename,contactperson,areacode,phone,country,previousorderBryson, Inc.,Smithson,UKYSuperLoo, Inc.,Flushing,SA
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
