Business Requirement Narrative: The database design needs to track all the airplanes in the airline's fleet. Since we have different airplanes from multiple manufacturers, we need to know each airplane's manufacture and their contact information in case we need to have them perform services. Each airplane is purchased from one specific manufacture, and they are responsible for the maintenance of it. Our airplanes are constantly in route between airports to maximize revenue, so we need to know all the airports information to help track where our airplanes are. The objective of this database is to help us schedule all the flights for each of our airplane in the fleet. So, the database design needs to be able to store flight schedules for each plane between airports We hope you can help us design a database where we can store the data into a database using best practices of relational database design concepts 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 O ManufacturerID O ManufactureName O ManufactureAddress ManufactureCity ManufactureState ManufactureZipCode ManufacturePhoneNum Airplanes Entity AirplaneNumber AirplaneModel AirplaneServiceStartDate AirplaneEndOfLife Date O AirplaneNumSeats Airports Entity o AirportID AirportName O AirportCode AirportAddress AirportCity AirportState AirportZipCode AirportPhoneNum FlightSchedule Entity ScheduleID O AirplaneNumber AirportID