1.Write the CREATE table query with appropriate data types.2. Write the queries to INSERT all the records.3.Write a query to display all records.4.Write a query to insert a new record V005,Igloo,14/10/2008,Chennai.5.Write a query to modify the location of V003 from Kolkata to Mumbai.6.Write a query to delete the record for V004 vendor id.7.Write a query to display the Vendor name and Date of registration for V002. 8.Write a query to display all Vendor names.