Create a database which can be used to run a video store.

DB tables, join paths, constraints, and referential integrity must be constructed using SQL

DML queries.

Must contain at least 6 entities.

All entities must be in 2NF or higher.

Referential integrity must be enforced.

Must contain views for data entry

Must generate at least nine relevant reports through (SQL) queries. These should include

nested queries, group by, having, IN, and inner and outer joins. There should also be

update, delete, and modify queries.