FROM EXPERIENCING MIS:

CE7-2. MyLab MIS Answer question CE6-3 at the end of Chapter Extension 6 (pasted below) . Create an Access database for the CUSTOMER and RENTAL tables only. Create the tables and add sample data. Create a data entry form that shows customers and all of their rentals (assume customers rent bicycles more than once). Verify that the form correctly processes new rentals, changes to rentals, and rental returns. Create a report that shows each customer, the rentals they have made, and the total rental fee for all of their rentals.

[CE6-3. MyLab MIS Suppose you are asked to build a database application for a bicycle rental shop. Assume your database is to track customers, bicycles, and rentals. Explain the steps that need to be taken to develop this application. Specify entities and their relationships. Build an E-R diagram. Ensure your diagram shows both minimum and maximum cardinalities. Transform your E-R diagram into a relational design.]