Table name: food Column Name Data Type Constraint foodID Integer Primary Key foodName Varchar Not null foodPrice Number with three decimals ExpiryDate Date SupplierID Varchar Foreign key Table name:...

Write the appropriate SQL statement for the following with screen shots of the execution.

i. Create food and supplierDetails tables as per the above given structure and insert the data to both the tables

ii. Create a view that will display the food name and supplier name with supplier location which delivers the food.

iii. Increase the prices of all food in the food table by 10%.

iv. Write a subquery to find names of supplier whose supplies ‘rice’.

Extracted text: Table name: food Column Name Data Type Constraint foodID Integer Primary Key foodName Varchar Not null foodPrice Number with three decimals ExpiryDate Date SupplierID Varchar Foreign key Table name: supplierDetails Column Name Data Type Constraint SupplicrID SupplierName varchar Primary kcy varchar Not null Location varchar Not null Should be atleast 8 digits PhoneNumber Numeric