Write a SQL script that performs the following. Creates an updatable view based on the employee table. The view must contain the following features Rename all of the columns Display all "manager"...

Write a SQL script that performs the following.

• Creates an updatable view based on the employee table. The view must contain the following features


• Rename all of the columns


• Display all "manager" records


• Insert 5 new records into the base table (using the view)


• Display all the view records using the base table (to verify that the view performed the inserts)