solvefor database course using live oracle sql $3)$ Write an anonymous block to test the above function. Format the output like this assuming that the project number used is $1$ :

$(1$ point$)$

The location of this project is Bellaire

For the following questions, create the following PRODUCT table and make sure to hand in the CREATE TABLE command for this table: $(1$ point$)$

Code: VARCHAR$(20)$

Description: VARCHAR$(20)$

Price: DECIMAL$(6,2)$

Discount: NUMBER

SalePrice: DECIMAL$(6,2)$

Designate Code as the primary key.

$4)$ Write a statement level trigger called trg$\_$ prod that when the Price and Discount of a product are inserted, the trigger calculates the SalePrice as the Price minus the product of Price and Discount. $(2$ points$)$

Test it like this:

INSERT INTO PRODUCT$($Code$,$Description, Price,Discount$)$ VALUES $(\text{'}$AB$559$DQ$\text{'},$'FLAT SCREEN TV$\text{'},3000,0\mathrm{.}05)$

Check that the trigger set the SalePrice as indicated above which is going to be $2850.$