Answer question at the end of Chapter Extension. 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.
Question
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.
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.