Case Study: You are required to: 1. Draw an Entity Relationship Diagram (ERD) that represents this case study. Central West Airways (CWA) is headquartered in Bathurst NSW and flies to many regional and capital city destinations in Central and Eastern Australia. CWA has a fleet of 5 types of aircraft that range in size from 10 seat planes to 90 seat aircraft. Aircraft of either 50 or 90 seat capacity have both Business and Economy class seats. Flights are scheduled to most destinations on a daily basis, but each flight may consist of zero or many legs to intermediate stops before reaching the destination CWA makes all reservations on the CWA website and does not use booking agents. Each passenger must make a reservation for a flight to a destination. Each passenger must hold a valid ticket for flight to their destination on the specified date. Passengers must select their date of flight, Flight number, class of travel (Business or Economy), and request a seat allocation at the time of reservation, When a passenger has completed their reservation, arn itinerary of their flight(s) must be emailed to them. Notes The third party payment site is out of scope for this question and can be ignored. The ERD must show names for both entities and relationships. The ERD must indicate the cardinality (ie, one-to-one, one-to-many or many-to-many) of all relationships. The ERD does not need to show attributes. . List any assumptions that you make