Purpose

In this project, you are going to create tables and constraints based on an entity relationship diagram. This midterm project will reinforce the learning objectives from Modules $1-3.$ You will use the tables created in the midterm project as part of the final project where you will create a functional database that is appropriate for a small business.

Note: If you do not complete this assignment you will not be able to successfully complete the final project for the course.

Note: APEX won't allow you to create a customers table in the workspace so just create a customer table in the same workspace for this project.

Create all independent tables and then create dependent tables.

For example:

Create tables in a sequence:

Customer

Actors

Movies

Star$\_$Billings

Media

Rental$\_$History

Background

You have been contracted by a small company named OracleFlix to create a database for storing information about their inventory and rentals.

Instructions

Download the files listed below to your computer.

OracleFlix ERD $($jpeg$)$

OracleFlix PhysicalModel Download OracleFlix PhysicalModel$($pdf$)$

OracleFlix SQL Project Tables Download OracleFlix SQL Project Tables$($pdf$)$

M$04$ Project Midterm Download M$04$ Project Midterm$(.$docx$)$

Follow the instructions contained in the document.

Insert your answers into the document where appropriate.

Upload the completed document using the instructions provided in the section below.