1. Code a SQL statement to create a view that shows the values of the titles of all the movies.

2.

a.) Code a SQL statement to show the first name, last name, and state for all members

b.) Now, use the same SELECT code to create a view that shows the first name, last name and state for all members.

c.) Use the view you just created to show all members who live in Tennessee (TN).

(use the view in a similar way as you do a table)

3.

a.) Code a SQL statement to create a view that computes the sum of daily late fees with the label LateFees for all movies rented. Show the Movie Title as well as the late fees.

b.) Use the view you just created to display the LateFees.

4. Describe how views are used to provide an alias for tables. Why is this useful?

5. Explain how views can be used to improve data security.

FIGURE P8.47 THE CH08 MOVIECO ERD DETAILRENTAL MEMBERSHIP RENTAL PK,FK1 RENT NUM PK,FK2 VID NUM PK RENT NUM MEM FNAME MEM LNAME MEM STREET MEM CITY MEM STATE MEM ZIP MEM BALANCE DETAIL FEE DETAIL_DUEDATE DETAIL RETURNDATE DETAIL_DAILYLATEFEE RENT DATE FK1 MEM NUM MOVIE VIDEO PK MOVIE NUM PK VID NUM PRICE MOVIE TITLE MOVIE_YEAR MOVIE COST MOVIE GENRE PK | PRICE CODE VID INDATE FK1 MOVIE NUM PRICE DESCRIPTION PRICE RENTFEE PRICE DAILYLATEFEE FK1 PRICE CODE