In this project, you are asked to design and implement a database that will store all the necessary information for a specific domain.

Movie Rental System

After designing the database, you will insert, delete, and update data.

Your database design should contain at least 6 tables. You are free to design the database any way you like, but the following requirements should be considered:

Design foreign keys to other tables, to, visualize and relate information from different tables.

Write queries to insert, delete, or update data from tables.

Write complex SQL queries that contain joins, and functions (character, date, numeric, and advanced) to illustrate complex querying of the database.

The project will have 3 phases:

DESIGN: The database should be designed and should be demonstrated with ER Diagrams and DDL statements. Foreign keys, primary keys, constraints, and default values should also be indicated with the relational model.

Use the database MySQL, to implement your design POPULATE DATA: Using DML statements to insert/update/delete data to/from your database. Show the inserted records in your tables.

QUERIES: Write at least 15 SQL queries retrieving, displaying, and showing statistical information to help management (use join operations, subqueries, group by, order by, sum, average, count, and other functions, etc.)

Report Structure 1. Introduction An introduction giving brief information. and assumptions about the system 2. Database ER Diagram, Data Def- inition Language Details (DDL), including all necessary constraints, Data Manipulation Language (DML) 3. Queries Show your queries and screen- shots of the results for each query. Make sure the screenshot is readable.