Create relational database schema for E__R Model below...mostly just need a detailed list of steps (respective to the content in the diagram) to take in order to transform

CityState Name DEPARTURE AIRPORTN AIRPORT FLIGHT LEG ARRIVAL AIRPORT LEGS INSTANCE OF Airline FLIGHT AIRPLANE Arr time TYPE DEPARTS1 FARES ARRIVES TYPE FARE of avail seat AIRPLANE ASSIGNED LEG iNSTANCE RESERVATION 1 Notes: A LEG (segment) is a nonstop portion of a flight A LEG INSTANCE is a particular occurrence SEAT of a LEG on a particular date