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.