Answer to Question #327408 in Databases | SQL | Oracle | MS Access for Waleed Asif

Question

4. A launch requires 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 need to be recorded for the launch vehicle type.

8. A specific manufacturer makes each launch vehicle type, 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.

  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.

Answer 1

It's been a while since this question is posted here. Still, the answer hasn't been got. Consider converting this question to a fully qualified assignment, and we will try to assist. Please click the link below to proceed: Submit order