Dineo has always been fascinated by the idea of space travel. Since she was a little girl, she has daydreamed about what it would be like to live on another planet. She watched all the movies where people lived in domes, and they had to wear special suits just to walk around outside the house. But oh, the view made all that totally worthwhile! Imagine seeing Saturn floating in the sky at night instead of the moon!Now that she was a college student, she was following with anticipation the development of the space flight industry. The year 2020 was a busy one for space flight. SpaceX launched humans to the International Space Station for the first time. The United Arab Emirates, China and the United States all launched unmanned missions to Mars too.But at the southern tip of Africa, Dineo felt very left out. All of those countries are far away andmight as well have been on another planet with the pandemic going on. And then she found something amazing –South Africa has a space agency! And the South African National Space Agency (SANSA) helped to track the NASA Mars 2020 mission! (Campbell, 2020).She was so excited to hear this, that she decided to create a website dedicated to all the space missions launched from planet Earth. Now ... where to start?You should answer question 1within the context of this scenario. Apply your knowledge –don’t just present the textbook facts.
Question 1–Entity Relationship Diagrams(Marks: 43)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 Displayed1.A launchpad hosts multiple launches over time, and each launch is hosted by exactly onelaunchpad. Launchpads will be created in the database even before the first launch is hostedthere.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 thrustand 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.Drawan Entity Relationship Diagram (ERD), 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 relationship
