(Solved): Background Information: You have been contracted by a small company named OracleFlix to create a database for storing information about their inventory and rentals. Use the entity relationship diagr. ...

Background Information:

You have been contracted by a small company named OracleFlix to create a database for storing information about their inventory and rentals. Use the entity relationship diagram in the file OracleFlix_Project_ERD.pdfas your guide to building the required tables. 

Assignment Deliverable:

Using the tables created for the midterm project

In order to be eligible for full credit, you must complete the following tasks.

1. Create a view called TITLE_UNAVAIL to show the movie titles and media_id of the media not returned yet.
   1. The view should not allow any DML operations.
2. Create the following sequences to be used for primary key values:
   1. Use a sequence to generate PKs for CUSTOMER_ID in CUSTOMERS table
      1. Begin at 101 and increment by 1
   2. Use a sequence to generate PKs for TITLE_ID in MOVIES table
      1. Begin at 1 and increment by 1
   3. Use a sequence to generate PKs for MEDIA_ID in MEDIA table
      1. Use a sequence to generate PKs for MEDIA_ID in MEDIA table
   4. Use a sequence to generate PKs for ACTOR_ID in ACTOR table
      1. Begin at 1001 and increment by 1
3. Create records in your tables. You can use the file, OracleFlix_SQL_Project_Tables.pdf

Actions

 as a guide to loading data in your tables.

3. 1. Use www.imdb.com (Links to an external site.) to find at least 6 titles for your movies table. 
   2. Create at least 6 fake records for your customers table.
   3. You will add data to the rest of the tables based on what is loaded into customers and movies.
4. Create an index on the last_name column of the Customers table.
5. Create a synonym called TU for the TITLE_UNAVAIL view.