Create the required tables and triggers for the following Product re$-$order tracking database.

a$.$ Create a table Product$-$details with Pname, Pid, Available quantity, Rate. $1$ mark

b$.$ Create a table Re$-$order with attributes Pid, Avail$\_$Qty$.1$ mark

c$.$ Create Trigger which inserts the Pid and Available quantity in the Re$-$order table as soon as available quantity of a product reduces to less tha

$50$ in the Product table. $2$ marks

d$.$ Create a table Total Stock with attributes Pid, Avl$\_$qty and rate. $1$ mark

e$.$Create trigger that updates the total amount in stock in the Total$\_$Stock table when new product details are inserted in the product tabi $2$ marks

f$.$ Insert required data in the Product table. $1$ mark

g$.$ Give the sample input and the contents of the tables to show the effect of the triggers. $2$ mark