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 than $50$ in the Product table. $2$ marks

d$.$Create a table Total$\_$Stock with attributes Pid, Avl qqty 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 tabl $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