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 tablesii. 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) insert into food values (111, 'rice',9, '2021-09-21', 'SID111');insert into food values (122, 'Bread',10,'2021-09-22','SID122');insert into food values (133,'Wheat',4,'2021-09-22','SID133');insert into food values (144,'Fruites',5,'2021-09-23','SID144');insert into food values (155, 'meat',3,'2021-09-24', 'SID155');SELECT * FROM Food; Table name: foodColumn NameData TypeConstraintfoodIDIntegerPrimary KeyfoodNameVarcharNot nullfoodPriceNumber with three decimalsExpiryDateDateSupplierIDVarcharForeign keyTable name: supplierDetailsColumn NameData TypeConstraintSupplicrIDSupplierNamevarcharPrimary kcyvarcharNot nullLocationvarcharNot nullShould be atleast 8 digitsPhoneNumberNumeric

In case of multipart questions, we are required to answer first 3 subparts.

Answered: Write the appropriate by using…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

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)