Instructions

Download the PVF$\_$database in Mini$-$Lecture $4$ of the Module Notes. Create an ERD in

Draw.io that describes this database.

Follow the instructions in Mini$-$Lecture $4$ and create and save the trigger indicated.

Right$-$click on Product$\_$T table $>>$click on Generate query for table $>>$ INSERT, then enter the following information: VALUES $(\text{'}9\text{'},$ 'Steel', 'Cherry', $\text{'}1500\text{'},\text{'}3\text{'})$;

Alter the Product$\_$T table to create a new column named ProductSaleCode with a character length of $1.$

Use the UPDATE and CASE WHEN... END clauses to increase the standard price of the furniture by $4\%$ for products that cost less than $500$ and by $2\%$ for products costing $500$ or more. Make sure your trigger in question $2$ captured all the changes you made here.

Submit a text file that includes the SQL code for questions $2-5.$ Also, please submit your updated PVF$\_$database and an ERD from question $1.$