Could you please help me on this MySQL questions (Please don\'t use answers alre

Question

Could you please help me on this MySQL questions (Please don't use answers already in the Chegg system as they are not correct). Please send me results if possible. Appreciate your help

Make the following changes to the Premiere Products database (PL SEE BELOW). After each change, execute an appropriate query to show the change was made correctly. Do not commit your changes unless instructed to do so.

3. Add rows to the NONAPPLIANCE table by taking the part number, part description, number of units on hand, item class, and unit price from the PART table for each part that is not in the class AP. -Please help me (Please find a new solusion as the one in the system is not working)

11. In the NONAPPLIANCE table, change the class for the part FD21 to NULL, and commit the change. (Please find a new solusion as the one in the system is not working)

12. Add a column named QTY_VALUE to the NONAPPLIANCE table. The quantity value is a sevendigit number with two decimal places that represents the product of the quantity on hand and the unit price. Then set all values of QTY_VALUE to ON_HAND * PRICE.  (Please find a new solusion as the one in the system is not working)

14. In the NONAPPLIANCE table, increase the length of the DESCRIPTION column to 30 characters.  (Please find a new solusion as the one in the system is not working)

MySQL Database file:

Explanation / Answer

Answer :

11.

update NONAPPLIANCE

set Class='NULL'
where part='FD21'

commit;

12.

alter table NONAPPLIANCE
QTY_VALUE decimal(7,2)

update NONAPPLIANCE
set QTY_VALUE=select ON_HAND*Price from NONAPPLIANCE;

14.

alter table NONAPPLIANCE
alter column DESCRIPTION varchar(30);

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.