ntity Relationship Diagram (ERD) using Unified Modelling Language (UML) notation according to the below business rules. Your design should be at the logical level – include primary and foreign key fields and remember to remove any many‐to‐many relationships. Business rules for a horse‐riding competition: 1. All entities should have surrogate primary keys. 2. Each rider may only represent a single club, but each club may enter many riders into the competition. 3. The name of each club must be recorded in the database. 4. The name and surname of each rider must be recorded in the
Draw an Entity Relationship Diagram (ERD) using Unified Modelling Language (UML) notation
according to the below business rules. Your design should be at the logical level – include primary
and foreign key fields and remember to remove any many‐to‐many relationships.
Business rules for a horse‐riding competition:
1. All entities should have surrogate primary keys.
2. Each rider may only represent a single club, but each club may enter many riders into the
competition.
3. The name of each club must be recorded in the
4. The name and surname of each rider must be recorded in the database.
5. Each rider may only ride one horse, and every horse may only have one rider.
6. The name of each horse must be recorded in the database.
7. A horse may compete in multiple different events, and each event will have many horses
that compete in it.
8. The name of each event must be stored in the database
Step by step
Solved in 2 steps with 1 images
