EER conceptual design for a rental bicycle database

Job ID: 35245289

Budget: $10 – $30 USD

List the business constraints and assumptions of the requirements, and design a standard EER diagram based on them.

The diagram should include:

● All Entities (including strong entities, weak entities,
super/subtype entities...)
● Primary keys and foreign keys
● Cardinality for each end of each relationship
● Description of relationships
● Aggregation/ Composition
● Participation and disjoint constraints
● Resolved M: M relations (composite PK’s)

After the diagram design, I will need to ask questions to understand the design logic and thoughts.