DATABASE

please just answer all questions thank you

Consider the following Entity Relationship Diagram (ERD) of ice cream products at Basket Robino shop ICE_FLAVOUR ICECREAM ICE_TOP PK,FKceCode has PK IceCode has PK,FK1IceCode PK,FK Flavio ++ -04PK,FK ToplD IceName Ice Type TopQuantity loeingredient IcePrice IceDescription in FLAVOUR PK Flavid TOPPING FlavName FlavTaste PK Toplo TopName TopDescription Write the IBM DB2 SQL commands for each of the following questions: a) Create the ICECREAM table (3 marks) b) Add a new attribute of 'Ice_Calory into ICECREAM table (2 marks) c) Display all ice cream information whose price is below RM12.00 for the type of 'sorbat' (2 marks) Find the ice cream name, price and topping quantity that have either 'caramel and "chocolate flakes' topping Sort the result in ascending order according to the ice cream price (4 marks) Give a discount of 20% for all ice cream products that have 'cheese' in the ingredient list. (3 marks) 1 Show the most expensive ice cream for each of the ice cream type. (2.5 marks) d) e) 9) List the ice cream code that has no topping at all. (2.5 marks) h) Delete the record for ice cream code IC 12', (1 mark)