Table: product PROD_ PROD_NAM COM_NAM LIFE CODE E E PR001 TV SONY 7 PR002 DVD Player LG 9 PR003 IPOD PHOLIPS 9 PR004 SOUND SONY 8 SYSTEM PR005 MOBILE NOKIA 6 Table: purchase PUR PROD PU PUR_ _NO _COD R Q AMO E TY UNT 2 PR001 1 120 1 PR003 2 300 3 PR0073 300 4 PR005 1 200 5 PR002 2 250 6 PR006 2 150 Questions: - Given tables "product" and "purchase", write SQL Server queries to answers the following questions. 15. Write two SQL queries to create tables "product" and "purchase". 16. Create two stored procedures in SQL for inserting the tables information given in above tables into "product" and "purchase" tables. You can take help from the PPT uploaded on moodle Questions: Given tables "product" and "purchase, write SQL Server queries to answers the following questions. 15. Write two SQL queries to create tables "product" and "purchase. 16. Create two stored procedures in SQL for inserting the tables information given in above tables into "product" and "purchase" tables. You can take help from the PPT uploaded on moodle 17. Call stored procedures multiple times for inserting the information in the tables. 18. Create two stored procedures in SQL for "select * from product" and "select * from purchase? 19. Write SQL query to join "product" and "purchases tables using Cartesian product? 20. Write SQL query to join "product" and "purchases" tables using Inner join? Write SQL query to join "product" and "purchases" tables using Outer "Full join? 21