.

can u please make the 20 customer

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: 1. A customer can rent one or more item but must rent at least one 2. An item can be rented to one and only one customer 3. An employee can process one or more rental but must process at least one 4. A rental must be processed by one and only one employee 5. 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: 1. Create data to populate your tables as per the guidelines in figure 2 2. Create a query to show the total amount of items rented by category 3. Create a query to show the employee that processed the least rentals 4. Create a query to show a listing of the total rentals and cost per customer 5. Create a report to show the total rental revenue generated by each employee 6. Create a report that shows the daily invoice (rental details) for each customer Fig 1: Entity (Tables) Customer Employee Item Rental Rental Detail. Category Fig 2: Entity (Tables) Customer Employee Item Rental RentalDetail Category Number of Records Primary Key Customerld Employeeld. Itemid RentalNumber RentalNumber, LineNumber Categoryld 20 7 10 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 apri 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. At least 60 (all rental should contain at least 3 items) At least 5 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: 1. A customer can rent one or more item but must rent at least one 2. An item can be rented to one and only one customer 3. An employee can process one or more rental but must process at least one 4. A rental must be processed by one and only one employee 5. 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: 1. Create data to populate your tables as per the guidelines in figure 2 2. Create a query to show the total amount of items rented by category 3. Create a query to show the employee that processed the least rentals 4. Create a query to show a listing of the total rentals and cost per customer 5. Create a report to show the total rental revenue generated by each employee 6. Create a report that shows the daily invoice (rental details) for each customer Fig 1: Entity (Tables) Customer Employee Item Rental Rental Detail. Category Fig 2: Entity (Tables) Customer Employee Item Rental RentalDetail Category Number of Records Primary Key Customerld Employeeld. Itemid RentalNumber RentalNumber, LineNumber Categoryld 20 7 10 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 apri 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. At least 60 (all rental should contain at least 3 items) At least 5