1) Create a DELIVERY table to organize all this below data : Product Name 1 Unit Bil Item ID Date 17/02/98 Discount Area West Price AquaForm Deluxe 2 MicroSet P5-100 3 AlphaTree 4 HighNote Special 5...


Using MySQL yog



1) Create a DELIVERY table to organize all this below data :<br>Product Name<br>1<br>Unit<br>Bil Item<br>ID<br>Date<br>17/02/98<br>Discount<br>Area<br>West<br>Price<br>AquaForm Deluxe<br>2 MicroSet P5-100<br>3 AlphaTree<br>4 HighNote Special<br>5 Matrix LC-700<br>6 Transcel<br>7 MegaHit Labels<br>8 ExtraByte Tapes<br>9 Pointstar Plus<br>10 Palo Alto Bizform<br>0.07<br>0.03<br>4<br>8<br>120<br>1<br>1<br>26/3/98<br>South<br>170<br>North<br>East<br>10<br>12<br>05/02/98<br>15/06/98<br>0.11<br>0.05<br>140<br>450<br>2<br>5<br>20<br>8<br>29/6/98<br>07/07/98<br>0.15<br>0.03<br>West<br>East<br>100<br>40<br>40<br>120<br>25<br>20/07/98<br>25/07/98<br>0.15<br>0.05<br>South<br>West<br>20<br>25<br>2<br>2<br>01/08/98<br>0.07<br>North<br>30<br>1<br>04/08/98<br>0.05<br>West<br>60<br>

Extracted text: 1) Create a DELIVERY table to organize all this below data : Product Name 1 Unit Bil Item ID Date 17/02/98 Discount Area West Price AquaForm Deluxe 2 MicroSet P5-100 3 AlphaTree 4 HighNote Special 5 Matrix LC-700 6 Transcel 7 MegaHit Labels 8 ExtraByte Tapes 9 Pointstar Plus 10 Palo Alto Bizform 0.07 0.03 4 8 120 1 1 26/3/98 South 170 North East 10 12 05/02/98 15/06/98 0.11 0.05 140 450 2 5 20 8 29/6/98 07/07/98 0.15 0.03 West East 100 40 40 120 25 20/07/98 25/07/98 0.15 0.05 South West 20 25 2 2 01/08/98 0.07 North 30 1 04/08/98 0.05 West 60

Jun 10, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here