1. Create database D-Mart, create table product inside that with columns product id, product name and category id, where product id is the primary key. 
2. Add 5 to 6 records to it. 
3. Add new column MRP to the table.
4. Add below values to MRP column; Shampoo: 130.5, Soap: 75, Notebook :95, Pens of category A2:90, Pens of category A3: 62
5.   dmart is offering 10% discount on all category A1 products. Update mrp accordingly
6. Add 3 new products: MANGO DUSSHERI, ALPHONSO, LANGDA. 
7. add price of all mango products by 10 rs. Using like . 
8.  add one row with unknown product and mrp 500.
9. change primary key value of category m1 alphonso mango and also set its price to 100.
10. add new column expiry date.
11. set perishable expiry date as 28 july.
12. set sanitary products expiry date of after 6 months.
13. set all remaining expiry date of after 3 years.