Answer to Question #178403 in Databases | SQL | Oracle | MS Access for bill

Question

A launchpad hosts multiple launches over time, and each launch is hosted by exactly one launchpad. Each launchpad has a location. A launch requires a launchpad that hosts it, a launch vehicle, and the payload. For a launch 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 maximum thrust and whether it is reusable needs to be recorded for the launch vehicle type. Each launch vehicle type and payload is made by a specific manufacturer and a manufacturer can make many different launch vehicle types. Each launch carries one payload, and a payload is only carried by one launch. 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 needs to be recorded. Draw an ERD

Answer 1

The answer to your question is provided in the image: