cat /blue/bsc4452/share/Class_Files/data/ | cut -d, -f3,4,5| head -n1 > airports.csv # Get the header row for the airports file # I will assume that the origin column has all # possible airports. # Get the rest of the rows-cols 4 & 7 have comas in them. # Get the header row for the main flights file # (skip city name and state columns-4,5, 7,8) cat /blue/bsc4452/share/Class_Files/data/ | cut -d, -f1,2,3,6,9-25 | head -n1 > flights.csv Here are the bash commands I used to prepare two input tables to make out database. Prepare input files to convert the flights data to a database It is somewhat up to us if we want to leave the state abbreviation in the city name field. To solve this, we can make a new table that has the columns above.This is repeating because, for example, every time GNV is the airport code, the city name is Gainesville, FL and the state is FL. Origin Airport, City Name Note that this column has a comma in it No repeating groups–If we look at the information for the departure and arrival airports, we see that we have 3 columns of data for each: Column header Only one value in a cell–I think we are good here.Here’s the metadata for the file.įor first normal form (1NF), we want to ensure that: Let’s work through normalizing and converting our flights data to a database. Databases-Converting the flights table to DB.Databases Intro-LinkedIn Learning Notes.TLCL Notes Ch 27-33-Flow Control-if, while, for.TLCL Notes Ch 24-26-Git and Writing Scripts.Notes on Regular Expressions & TLCL Ch 19.TLCL Notes Ch 5-8-Running Commands, Redirection, Keyboard tricks.TLCL Notes Intro & Ch 1-4-Shell, Navigation, File Management.What do you think of the new site? Is the airline right to continue focus on freight? We’d love to read your thoughts in the comments. The new partnership with IAI proves that the airline is still committed to its freight operations. The airline opened the brand-new Cargo Terminal II at Addis Ababa Airport back in 2017 to help boost ground operations. It’s been the largest cargo fleet in Africa. The airline wants to increase its cargo capacity and capitalize on the rise in demand for freight.Ĭargo operations have also been a central part of the Ethiopian Airlines business model. The conversion of the three passenger aircraft is a part of the airline’s Diversified Aviation Business Model of Vision 2025. Photo: Ethiopian Airlines Ethiopian airlines 2025 plan The capacity building will also help us expand our MRO services with cutting edge technology and knowledge transfer.” The airline has always had a strong focus on cargo operations. We are very happy that we are able to collaborate with IAI to enable us to expand our cargo and logistics services, which is already the largest and leading cargo network in Africa. “ The cargo conversion center in ADD HUB airport will expand its services to all airlines in Africa and the wider region. It will help with the conversion of aircraft but, it will also provide enhanced MRO services, staff training, and certification and licensing. The new conversion site will be a part of Ethiopian’s largest Maintenance, Repair, and Overhaul (MRO) site. Stay informed: Sign up for our daily and weekly aviation news digests. I am excited by the opening of the current center in Ethiopia, and thank my colleagues in Ethiopian Airlines for the trust they have put in IAI’s Aviation Group, as the world’s leader in conversions.” Initially, the partnership will convert three 767 passenger aircraft into freighters, but the airline hopes the site will be used for more. “ IAI has an excellent reputation as a conversion center of passenger-to-freighters aircraft, and we are constantly receiving requests to open such conversion centers in more and more locations around the world. In a statement, Yossi Melamed, IAI’s Executive VP and Aviation Group General Manager, said,