Draw an ER-Model for the following info that can appropriately record the info described :
Question : An Airport has a city name and International identification code (Eg: EDDH for Hamburg Airport). A fight is identified by its flight no (Eg: LH4324). A flight has a starting airport, a destination airport and a departure date. Further more, a fight has three prices (first, business, economy) and a status (not yet started, started, landed).
Can anyone on this forum solve this question for me. It will be grateful for me.