Answer to Question #171356 in Databases | SQL | Oracle | MS Access for lee nakana

Question

Question 3 – Entity Relationship Diagrams (Marks: 45)

Dineo has given what she wants to display on the website a lot of thought. And she has come up with quite a comprehensive set of business rules.

Launch Data To Be Displayed

1. A launchpad hosts multiple launches over time, and each launch is hosted by exactly one launchpad. Launchpads will be created in the database even before the first launch is hosted there.

2. A launchpad is located in a country, and a country in turn is located on a continent.

3. Each launchpad has a name and a location.

4. A launch requires three things: a launchpad that hosts it, a launch vehicle (the rocket), and the payload.

...

Draw an Entity Relationship Diagram (ERD) using Unified Modelling Language (UML) notation, representing these business rules. Your design should be at the logical level – include surrogate primary key and foreign key fields and remember to remove any many‐to‐many relationships.

Answer 1

The answer to your question is provided in the image: