ScholarMatic: Explanation & Answer
Your ready answer from a verified tutor is just a click away for as little as $14.99
Click Order Now to get 100% Original Answer Customized to your instructions!
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
ScholarMatic: Explanation & Answer
Your ready answer from a verified tutor is just a click away for as little as $14.99
Click Order Now to get 100% Original Answer Customized to your instructions!
