Question: Please help with creating this database via microsoft access KENNESAW BIKE RENTALS Kennesaw, GA now has city wide availability for renting bikes. Kennesaw Bike Rentals
Please help with creating this database via microsoft access

KENNESAW BIKE RENTALS Kennesaw, GA now has city wide availability for renting bikes. Kennesaw Bike Rentals customers will has 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. Entity Bike PK Bike_ID 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 Damago?, Yes No KENNESAW BIKE RENTALS Kennesaw, GA now has city wide availability for renting bikes. Kennesaw Bike Rentals customers will has 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. Entity Bike PK Bike_ID 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 Damago?, Yes No