Question: 9 Write the relational algebra expression to list the code and name of vendors who supplied no products. Table Line: table [ [ invoicenumber

9Write the relational algebra expression to list the code and name of vendors who supplied
no products.
Table Line:
\table[[invoicenumber,linenumber,productcode,quantity,unitprice],[1001,1,13-Q2P2,1,14.99],[1001,2,23109-HB,1,9.95],[1002,1,54778-2T,2,4.99],[1003,1,2238QPD,1,38.95],[1003,2,1546-QQ2,1,39.95],[1003,3,13-Q2? P,5,14.99],[1004,1,54778-2T,3,4.99],[1004,2,23109-HB,2,9.95],[1005,1,PVC23DRT,12,5.87],[1006,1,SM-18277,3,6.99],[1006,2,2232QTY,1,109.92],[1006,3,23109- HB,1,9.95],[1006,4,89- WRE-Q,1,256.99]]
Table Product:
\table[[productcode,description,indate,quantityonhand,minquantityonhand,price,discountrate,vendorcode],[11QER/31,Power painter, 15 psi.,,113?2012,8,5,109.99,0,25595],[13-Q2P2,7.25-cm. pwr. saw blad,1213?2012,32,15,14.99,0.05,21344],[14-Q1/L3,9.00-cm. pwr. saw blad,1113?2012,18,12,17.49,0,21344],[1546-QQ2,Hrd. cloth, 1/4-cm.,2x5,115?2013,15,8,39.95,0,23119],[1558-QW1,Hrd. cloth, 12-cm.,3x5,115?2013,23,5,43.99,0,23119],[2232/QTY,B??&D jigsaw, 12-cm. bli,1230?2012,8,5,109.92,0.05,24288],[2232/QWE,B??&D jigsaw, 8-cm. blat,1224?2012,6,5,99.87,0.05,24288],[2238/QPD,B??&D cordless drill, 12,120?2012,12,5,38.95,0.05,25595],[23109-HB,Claw hammer,120?2012,23,10,9.95,0.1,21225],[23114-AA,Sledge hammer, 6kg.,12?2012,8,5,14.4,0.05,NULL],[54778-2T,Rat-tail file, 18-cm. fin,1215?2013,43,20,4.99,0,21344],[89-WRE-Q,Hicut chain saw, 16cm.,27?2013,11,5,256.99,0.05,24288],[PVC23DRT,PVC pipe, 3.5-cm.,2m,220?2013,188,75,5.87,0,NULL],[SM-18277,1.25-cm. metal screw,,31?2013,172,75,6.99,0,21225],[SW-23116,2.5-cm. wd. screw, 50,224?2013,237,100,8.45,0,21231],[WR3/TT3,Steel matting, 4816c,117?2013,18,5,119.95,0.1,25595]]
Table Vendor:
\table[[vendorcode,name,contactperson,areacode,phone,country,previousorder],[21225,Bryson, Inc.,Smithson,181,223-3234,UK,Y],[21226,SuperLoo, Inc.,Flushing,113,215-8995,SA,N
 9Write the relational algebra expression to list the code and name

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!