Project $2($This is a group assignment$)$

Part A

File needed: Bentalacced

Teninis Rental

Venus Rental is a rental company located in Queens, New York, specializing in rental of tennis items for the elementary school tennis industry. Over the past $6$ months, her business has experienced tremendous growth due to a boom in the elementary school tennis industry. The business has kept the daily service records in a workbook format and now needs to expand its reporting capabilities to develop a relational database to affect a more functional structure.

Venus Rental needs help developing a database, specifically:

Performing data entry

Create various queries

Produce a few reports

The entities and primary keys for the database have been identified in figure $1.$ The list of records has been identified in fig $2.$

The following business rules have been identified:

A customer can rent one or more item but must rent at least one

An item can be rented to one and only one customer

An employee can process one or more rental but must process at least one

A rental must be processed by one and only one employee

An item can be rented by the day and must not be rented for more than $5$ days

Project focus

Your job is to complete the following tasks:

Create data to populate your tables as per the guidelines in figure $2$

Create a query to show the total amount of items rented by category

Create a query to show the employee that processed the least rentals

Create a query to show a listing of the total rentals and cost per customer

Create a report to show the total rental revenue generated by each employee.

Create a report that shows the daily invoice $($rental details$)$ for each customer