Question: Question 4 (Marks: 25) Draw an Entity Relationship Diagram (ERD) using Unified Modelling Language (UML) notation according to the below business rules. Your design should

Question 4 (Marks: 25) Draw an Entity
Question 4 (Marks: 25) 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. Marks will be awarded as follows: Entities 5 marks Relationships 4 marks Multiplicities 4 marks Primary keys 5 marks Foreign keys 4 marks Other attributes 2 marks Correct UML Notation 1 mark Total 25 marks

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!