Also need a hand-drawn ER diagram

CASE: CREATING A DATABASE MANAGEMENT SYSTEM (due by Mar. 1,5PM) THE ISSUE Florence Bike Rentals needs help managing its rental business. You are asked 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 Florence Bike Rentals owns 13 mountain bikes in their fleet of rentals. The bikes vary in type, size, and parts. When customers rent bikes, they are required to leave their driver's license and give you their home address, phone, and a credit card number. THE TECHNOLOGY The DBMS software of your choice (Microsoft Access) AVAILABLE INFORMATION A list of integrity constraints (Business rules): Rentals can have many customers assigned but must have at least one. A bike must be assigned to one and only one rental type. A customer can rent one or more bikes at one time. A bike can be assigned to only one customer but need not be assigned to any customer. . . Your individual project is to be completed in the following phases: 1. Use ERD for Florence Bike case developed before. 2. Create a physical database system using a personal DBMS package (Microsoft Access). 3. Insert at least five make-up records per table (entity). Deliverables: - E-R diagram (show both Max. and Min. cardinalities) - Assure that you have created tables, performed couple of QBE examples, Relationships (add symbols), an example of Report', and an example of Form - Submit screenshots in Word file (yourname.docx file) through email