Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Dineo has given what she wants to display on the website a lot of thought. And she has come up with quite a comprehensive
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. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. Launch Data To Be Displayed A launchpad hosts multiple launches over time, and each launch is hosted by exactly one launchpad. Therefore, Launchpads will be created in the database even before the first launch is hosted there. A launchpad is located in a country, and a country, in turn, is located on a continent. Each launchpad has a name and a location. A launch requires a launchpad that hosts it, a launch vehicle (the rocket), and the payload. For a launch, the date, time and name should be recorded as well as whether it is a crewed launch or not. 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. Each launch vehicle is of a specific launch vehicle type. The name, maximum thrust and whether it is reusable need to be recorded for the launch vehicle type. A specific manufacturer makes each launch vehicle type, and a manufacturer can make many different launch vehicle types. Each launch carries one payload, and a payload is only carried by one launch. A manufacturer also makes each payload, and a manufacturer can make many different payloads over time. Multiple crew members can be carried on a crewed launch, and each crew member can be carried on multiple launches over time. Each crew member has a nationality (the country they come from), and their name and surname also need to be recorded. 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,
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started