Draw an Entity Relationship Diagram (ERD) using Unified Modelling Language (UML) notation according to the below business rules. Astronaut mission business rules: • Every entity must have a surrogate primary key. • An astronaut lives in a specific country, and many astronauts can be from the same country. • The name for each astronaut must be stored in the database. • The name for each country must be stored in the database. • An astronaut is assigned to a mission to perform a specific role on board a specific vehicle. • An astronaut and a vehicle can be assigned to multiple missions over time. • The start date and end date of each mission must be stored in the d
Draw an Entity Relationship Diagram (ERD) using Unified Modelling Language (UML) notation according to the below business rules.
Astronaut mission business rules:
• Every entity must have a surrogate primary key.
• An astronaut lives in a specific country, and many astronauts can be from the same
country.
• The name for each astronaut must be stored in the
• The name for each country must be stored in the database.
• An astronaut is assigned to a mission to perform a specific role on board a specific vehicle.
• An astronaut and a vehicle can be assigned to multiple missions over time.
• The start date and end date of each mission must be stored in the database.
• The model and name of each vehicle must be stored in the database.
• The description of each role must be stored in the database.
Step by step
Solved in 3 steps with 1 images