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

Question

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.

10. A manufacturer also makes each payload, 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 they come from), and their name and

surname also need to be recorded.

13. 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, 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