Hello this needs to be done using Oracle SQL.

Q1 Create 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 operations Q2 Create a SYNONYM for v_Title_Unavailable named vTU. Q3 Write SQL to query the view using the synonym.

\begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ FLIX_CUSTOMERS } \\ \hline PK & Customer_ID \\ \hline & Last_Name \\ First_Name \\ Home_Phone \\ Cell_Phone \\ Email \\ Street1 \\ Street2 \\ City \\ State_Province \\ Postal_Code \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ FLIX_RENTAL_HISTORY } \\ \hline PK & Rental_History_ID \\ \hline FK & Customer_ID \\ FK & Media_ID \\ & Rental_Date \\ & Retum_Date \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ FLIX_ACTORS } \\ \hline PK & Actor_ID \\ \hline & Stage_Name \\ Last_Name \\ First_Name \\ Birth_Date \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ FLIX_STAR_BILLING } \\ \hline PK & Star_Billing_ID \\ \hline FK & Actor_ID \\ FK & Title_ID \\ & Comments \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ FLIX_MOVIES } \\ \hline PK & Title_ID \\ \hline & Title \\ Description \\ Rating \\ Category \\ Release_Date \\ \hline \end{tabular} DBMS 130: Course Project DB