*MICROSOFT ACCESS and VISIO*

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

Accounts

Customers

Movies

Rentals

RentalStatus

Transactions

, Accounts Customers Movies Rentals AccountStatus Transactions . 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.