I am having trouble figuring out how to create the ERD digram for this. I understand I need a sub category to break up the Many to Many relationship. I don't know where to start.

Each student will demonstrate the ability to help an organization to create an Entity Relationship Diagram (ERD) using a diagramming software. As a database architect to help design a database for an organization, you are presented with the business narrative below as described by the organization.

Business Requirement Narrative:

Note: You will need to add Foreign Keys to the entities as you determine the relationships. Depending on the narrative presented, you may also need to add an additional entity (composite entity) to resolve any many-to-many relationship issue in the design.

Entities and Attributes:

• Manufacture Entity
  • ManufacturerID
  • ManufactureName
  • ManufactureAddress
  • ManufactureCity
  • ManufactureState
  • ManufactureZipCode
  • ManufacturePhoneNum
• Airplanes Entity
  • AirplaneNumber
  • AirplaneModel
  • AirplaneServiceStartDate
  • AirplaneEndOfLifeDate
  • AirplaneNumSeats
• Airports Entity
  • AirportID
  • AirportName
  • AirportCode
  • AirportAddress
  • AirportCity
  • AirportState
  • AirportZipCode
  • AirportPhoneNum
• FlightSchedule Entity
  • ScheduleID
  • AirplaneNumber
  • AirportID
  • DepartureDate
  • DepartureTime
  • ArrivaleDate
  • ArrivalTime