# a) Show the list of databases. # b) Select sakila database. # c) Show all tables in the sakila database. # d) Show each of the columns along with their data types for the actor table. # e) Show the total number of records in the actor table. # f) What is the first name and last name of all the actors in the actor table ? # g) Insert your first name and middle initial ( in the last name column ) into the actors table. # h) Update your middle initial with your last name in the actors table. # i) Delete the record from the actor table where the first name matches your first name. # j) Create a table payment_type with the following specifications and appropriate data types # Table Name : "Payment_type" # Primary Key: "payment_type_id" # Column: "Type" # Insert following rows in to the table: 1, "Credit Card" ; 2, "Cash"; 3, "Paypal" ; 4, "Cheque" # k) Rename table payment_type to payment_types. # 1) Drop the table payment_types