Questions:

Assume you are creating a database for Video rental library with the following ER diagram

Please answer the following questions, include oracle snapshots and sql code for each:

Create the tables Customer and Inventory. Notice that there are no multivalued variables in this assignment. Insert some sample records in Customer and Inventory table.

Customer Transaction Cust ID Cust Name Address(street, city, zip, state) Cust Phone Balance Submits T ID Rent date Total payment Contains Inventory L ID Movie or TV DVD orTAPE Director Lead Actor Genre Release date Num In Stock Price Transaction Detail T ID I ID Due Date Return Date