Supplemental Case Study Now, it’s time to apply (Make my own web site)
Supplemental Case Study Now, it’s time to apply our newly learned principles to a completely different theme. We upgrade from cars to planes, covering a simple airline system. This chapter’s case study does not pretend to encompass the full collection of data from real airline it’s only a sample. Nonetheless, we’ll see that the principles we learned previously can be applied to build and refine a correct and coherent data structure. Normally, each airline has its own information system. We assume here that we have got the mandate to build an information system that encompasses many airlines. Results from the Document Gathering Phase After reviewing the airline system’s current website, a booking agent’s website, some electronic tickets, and boarding passes, we gather a large amount of information. We’ll first express this information with sentences which present the system and data exchange on a rather high level. Each sentence is followed by a list of the data elements which we can deduce from it. An element can be present in more than one sentence. Refer to the Tables and Sample Values section for more details about each data element. There are also some notes that will help us in the naming and grouping phase. Flight 456 of Air Quebec leaves Montreal-Trudeau airport at 22:45 on October 2nd, 2007 heading for Paris’s Charles de Gaulle. The following are the data elements that can be obtained from the above sentence: flight_number airline_name