Answer to Question #177877 in Databases | SQL | Oracle | MS Access for aaisha

Question

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.

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.

5. For a launch, the date, time and name should be recorded as well as whether it is a crewed launch or not

Answer 1

The answer to your question is provided in the image: