Draw an Entity Relationship Diagram (ERD) using Unified Modelling Language (UML) notation according to the below...

Transcribed Image Text:

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. Tip: Pay attention to the mark allocation shown below. 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 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. 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. Tip: Pay attention to the mark allocation shown below. 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 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.

Answer rating: 100% (QA)

The erd for the above case study shown below In the above ER Diagram there is total five entities and they are as follows i Team ii Driver iii Positio... View the full answer