WPC 300: Problem Solving Actionable Analytics Assignment 9:

WPC 300: Problem Solving & Actionable Analytics

Assignment 9: Data Architecture & Normalization

You have been asked by a startup airline to generate the information architecture for the relational database system that will facilitate the business. You have been given the following paper for a flight and you remember in your dim distant past before graduation that your professor said that an efficient and effective way to organize data involves normalizing it. You set out to normalize the data below.

Flight number: AA 3097

Origin: PHX

Destination: EWR

Flight commencement date: 5/10/2019

Takeoff: 11 am

Landing: 7 pm

Origin Terminal: 4

Origin Gate: 21

Destination Terminal: C

Destination Gate: 09

Destination Luggage Claim: 14

Pilot: Mary Smith

Co-Pilot: John Jones

Air Hostess 1: Cynthia Taylor

Air Hostess 2: Paul Brown

Air Hostess 3: Melinda Park

Plane make & model: Boeing 737

Last maintenance: 5/1/2019

Passenger i Name: Joe Dawes

Passenger i DOB: 03/03/1988

Passenger i gender: Male

Passenger i address: BA 365, ASU

Passenger i phone: 480-000-0000

Passenger i fare class: X

Passenger i total ticket Price: $405

Passenger i reservation number: 5468755668787541561687978

Reservation purchase date: 03/12/19