Premiere Products Database: Problems 1-10 INPUT& OUTPUT (Screenshots) REP REP LA
ID: 3716692 • Letter: P
Question
Premiere Products Database: Problems 1-10
INPUT& OUTPUT (Screenshots)
REP REP LAST FIRST STREET CITY STATE 2P COMMISSION RATE NUM NAME NAME 20 Kaiser Valerie 624 Randall GroveFL33321 $20,542.50 0.05 5 ull Richard 532 Jaokson Sheldon FL 33553 $39,216.00 0.07 65 Perea Juan1626 Taylor Fillmore 33336 $23,487.00005 CUSTOMER CUSTOMER CUSTOMER STREET NUM CITY STATEZ?P BALANCE CREDITREP LIMIT NUM - NAME 148 Fillsore FL 33336 $6,550.00 $7,500.00 20 's Appliance 2837 and Sport Greenway 282 Brookings3827 Devon GrovE FL 33321 $431.50 $10,000.00 35 Direot Perguson's 382 Wildwood Northfield FL33146 $5,785.00 $7,500.00 65 The Everything 56 408 1828 Raven Crystal FL 33503 $5,285.25 $5,000.00 35 462 Bangains 3829 Central Grove FL 33321 $3,412.00 $10,000.00 65 Kline's 838 Ridgeland Fillmore L 33336 $12,762.00 $15,000.0020 omson's 372 0aford Sheldon FL 33553 $2,106.00 $10,000.00 65 Department Store 608 687 Lee's Sport 282 Evergreen Altcaville FL 32543 $2,851.00 $5,000.00 35 and Appliance Deerfield's 282 Columbia Sheldon FL 33553 $249.00 $7,500.00 35 725 Four Scasons All Season28 Lakeview Grove FL 33321 $8,221.00 $7,500.00 20 FIGURE 1-2 Sample data for Premiere ProductsExplanation / Answer
1. create table NONAPPLIANCE (part_num varchar(4) primary key,description varchar(15),on_hand decial(4,0),class char(2),price decimal(6,2));
2. insert into NONAPPLIANCE values ('AT94','Hand Sewer',148,'SG',192.68);
3. update NONAPPLIANCE set description='Delux Iron' where part_num='AT94';
The above query updates the description of the part_num having AT94.
4. update NONAPPLIANCE set price=(price*1.02) where class='SG';
The above query updates the price multiplied by 1.02 for the parts belongs to the class 'SG'.
According to the chegg policy I am allowed to answer only 4 parts . kindly understand and post the remaining as new post.