Kennesaw, GA now has city wide availability for renting bikes. Kennesaw Bike Rentals customers will have the largest selection of bikes, parts, accessories, books, maps, clothing, shocks, helmets, eyewear, shoes, car racks, and touring gear in the area with everything you need for on and off the road. You have been working for the past 10 months Kennesaw Bike Rentals. Recently, there has been a surge in business and the owners need a more accurate way to manage the rental business. You have decided to create a database to help the owners keep track of the bike rentals, who the customers are, amount paid, and any damage to the bikes when they are rented. Currently Kennesaw Bike Rentals owns 16 rental bikes. The bikes vary' in type, size, and parts. When customers rent bikes, they are required to leave their driver's license number and to give a home address, phone number, and credit card number. 1. Create the database using a Microsoft Access for the following entity classes and primary keys: Name the database Bikes. Create the tables listed below: Primary key PK Bike_ID Entity Bike Bide_ID Number, Long Integer, PK Description, Text, 25, Required=Yes CostPerHour, Currency, Required=Yes Customer_ID Customer Customer_ID (aka driver's license), Text, 10, PK Last_Name, Text, 25 First_name, Text, 25 Address, Text, 25 City,Text, 15 State, Text, 2 Zip, Text, 2 Phone, text, input mask CreditCard, Number Long Integer Customer_ID, Date, Bike_ID Rentals Customer_ID, Text, 10, PK Rental_Date. Date/time, PK Bike_ID, Number, Long Integer, PK Time_Out, Date/time Time_in, Date/time Damage?, Yes/No 2. Create appropriate relationships to assure correctness of the tables. (Hint: There are two.) 3. Enter data into each of the tables using the business rules defined in #4. You should have at least 10 rentals records. You should have some customers that have rented more than once. Make rentals for different days as well. 1. You can enter your 15 types of bikes. This is the description in the bike table. Here are few examples: 1. Specialized Rockhopper H. Trek Fuel 70 IH. Trek Fuel 80 iv. Trek Fuel 90 v. Marin Downhill FRS vi. Specialized Stump bike FSR vii. Specialized Stump bike Hardtail 2. Your own rental rates which should be between 12 and 18 dollars an hour 3. Your own rentals. (approximate 10 records) 4. Implement the following business rules: a. Rentals can have many customers assigned but have at least one. b. A bike must be assigned to one and only one rental type. c. A customer can rent one or more bikes at one time. d. A bike can be assigned to only one customer but need not be assigned to any customer. 5. Create 3 queries 1. Create a query that displays all bikes and their rental rate in ascending order based on the rate. 2. Create a query that displays all rentals include the customer last name, 3. Create a query that displays all rentals include the bike description and bike 6. Create a report that shows all rentals by customer by date. name
