Create a query to add a column P to an existing view named view1 having columns (M,N,O) from the table T1. MySQL

Compare between the following: Temporary table vs. View Assertion vs. Triggers

Q1Create a view named v_Title_Unavailable.The view should show the movie titles and media_id of the media not returned yet. The view should not allow any DML operationsQ2Create a SYNONYM for v_Title_Unavailable named vTU.Q3Write SQL to query the view using the synonym.

Task 19: List every table that you have created thus far. Display the TABLE_SCHEMA and TABLE_NAME columns. Task 20: List every column in the ITEM table and its associated data type.

Create a view, using JOBS, DEPARTMENTS, and JOB_HISTORY tables that will include department name (not ID),  job title (not jobID), start date, and end date for all rows in the JOB_HISTORY table Using your view, write a query that shows the number of rows (count) for each department. Write a query that uses your view from above to select the columns department name, job title, and end date for all rows where the department name includes the string “Sale” that is NOT case-sensitive.  Use a function.  i.e.  SALE, SaLe, Sale, sAle, etc.  should all match a row

QUESTION 8 Columns added to a table in transform data can be seen in the Data View? O True False

Add a foreign key constraint to the movie table: the column prod_id is the foreign key, referencing the column id from the production table (use sql) following is movie and production table