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 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. 6. Each launch is performed by a launch vehicle. The serial number for the launch vehicle should be recorded. A launch vehicle can perform multiple launches over time. 7. Each launch vehicle is of a specific launch vehicle type. The name, maximum thrust and whether it is reusable needs to be recorded for the launch vehicle type. 8. Each launch vehicle type is made by a specific manufacturer and a manufacturer can make many different launch vehicle types. 9. Each launch carries one payload, and a payload is only carried by one launch. 10. Each payload is also made by a manufacturer, and a manufacturer can make many different payloads over time. 11. Multiple crew members can be carried on a crewed launch, and each crew member can be carried on multiple launches over time. 12. Each crew member has a nationality (the country that they come from), and their name and surname also needs to be recorded. 13. Crew members can appear in the database before they launch for the first time. 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
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
1. A launchpad hosts multiple launches over time, and each launch is hosted by exactly one
launchpad. Launchpads will be created in the
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.
6. Each launch is performed by a launch vehicle. The serial number for the launch vehicle
should be recorded. A launch vehicle can perform multiple launches over time.
7. Each launch vehicle is of a specific launch vehicle type. The name, maximum thrust and
whether it is reusable needs to be recorded for the launch vehicle type.
8. Each launch vehicle type is made by a specific manufacturer and a manufacturer can
make many different launch vehicle types.
9. Each launch carries one payload, and a payload is only carried by one launch.
10. Each payload is also made by a manufacturer, and a manufacturer can make many
different payloads over time.
11. Multiple crew members can be carried on a crewed launch, and each crew member can
be carried on multiple launches over time.
12. Each crew member has a nationality (the country that they come from), and their name
and surname also needs to be recorded.
13. Crew members can appear in the database before they launch for the first time.
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.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
