Answered step by step
Verified Expert Solution
Link Copied!

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 

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Econometric Analysis

Authors: William H. Greene

5th Edition

130661899, 978-0130661890

More Books

Students also viewed these Economics questions

Question

Brief the importance of span of control and its concepts.

Answered: 1 week ago

Question

What is meant by decentralisation?

Answered: 1 week ago