EER conceptual design for a rental bicycle database
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.
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.
Related categories:
SQL
Database Administration
Database Programming
Database Development
Relational Databases