Bikes Rental Circle Rental is a rental company located in Manhattan, New York, specializing in rental of bikes for the home industry. Over the past 12 months, his business has experienced tremendous growth due to a boom in the home 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. Circle 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 PPP'P!' Project Focus Yourjob is to complete the following tasks: Create data to populate your tables as per the guidelines in gure 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 P'P'PP'N!' Fig 1: Entity fl'ables) Primary Key Customer Customerld Employee Empioyeeld item Itemid Rental RentalNumber RentalDetail RentalNumber, LineNumber Category Categoryld Fig 2: Entity Number of Records (Tables) Customer 20 Employee 7 item 10 Rental At least 20: 1. 10 rentals per one month and 10 records in another month) e.g. 10 records with startdate and enddate in mar; 10 records with start date and end date in apr 2. The start date must be less than the end date 3. The end date cannot be greater than 5 days from the start date. RentalDetail At least 60 (all rental should contain at least 3 items] Category At least 5