Write the appropriate by using Microsoft SQL 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’. Note: Students are expected to insert records (minimum 5) in each table as per the required structure and include data as per the requirements in the tasks (for example: task 3.a.iv. requires the data ‘rice’ and hence this data should be inserted in the student table)
Write the appropriate by using Microsoft SQL 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’.
Note: Students are expected to insert records (minimum 5) in each table as per the required structure and include data as per the requirements in the tasks (for example: task 3.a.iv. requires the data ‘rice’ and hence this data should be inserted in the student table)
Step by step
Solved in 4 steps with 4 images