rite a query to insert any 4 records into the 'route' table.Note:1. You can provide any values to the columns of route table. Ensure the values matches with the data type of those columns.2. Insert only 4 records into the table.

Write a query to insert any 4 records into the 'route' tabl

Create a procedure named 'insertRoute' which has route_name as an input parameter with varchar as its datatype. This procedure should take the count of the existing table records(route table) and add 1 with that to generate the new route id.The newly generated id along with the route_name should be inserted into the route table.Hints:Procedure name : insertRouteParameters : route_name is type of varchar

Create a procedure named "insert_route"  which has key_id and route_name as the input parameter and status as output parameter. This procedure insert values into the table route. The values are passed as the input parameter to the procedure.Note:If the key_id value does not exists in the table, then set the status parameter as Inserted successfully.If the key_id value already exists in the table then you should handle the exception or warning by displaying the statusas Sorry

Write a query to insert any 3 records into the 'building' table.

Write a query to change the route_name from 'East West line' to 'South West line' in the 'route' table.Note:1. No need to insert any new records into the route table with the route_name specified in the question. This is already taken care in the backend. You just write the update query with right condition and submit it.2. Specify the route_name correctly. It is case sensitive3. Do not make any mistakes while specifying the condition.