Lab Exercises:

Create a view name patient containing the customer number, first name, Seller$\_$ID for all customers whose Seller ID is $122.$ Name the columns $($Customer$\_$Number, Name, Seller$\_$Id$).$

Insert a new customer with $id=12$ to the view with Seller$\_$ID $=122.$ Choose values for the other columns.

Insert a new customer with id $=13$ to the view with Seller$\_$ID $=123.$ Choose values for the other columns.

Recreate the view with "WITH CHECK OPTION".

Repeat $(3)$ with customer id $=14.$ Justify your results.

Recreate the view with "WITH READ ONLY"

Repeat $(3)$ with customer id $=15.$ Justify your results.

Create a view that contains the seller's name and the number of customers for each seller.

Create an index for customer name in the customer table.