1312 Part V Advanced Database Topics Tulsa San Mateo San Mat

13-12 Part V Advanced Database Topics Tulsa San Mateo San Mateo Engineering Standard Tulsa Standard Price List Parts Price List Parts FIGURE 13-9 Hybrid data distribution strategy Source: Based on Database Programming & Design, April 1989, Vol. 2, No. 4. New York New York Customers Standard Price List Parts

Solution

13.26:

a. UPDATE StandardPriceList SET UnitPrice=UnitPrice*0.1+UnitPrice WHERE PartNumber= 98756;

13.27:

a. UPDATE StandardPriceList SET UnitPrice=UnitPrice*0.2+UnitPrice where PartNumber= 98765;
UPDATE StandardPriceList SET UnitPrice=UnitPrice-UnitPrice*0.2 where PartNumber= 12345;