question archive An airline trip star schema consists of the following dimensions (1] Booking Date (Date reservation create) (2) Flight Date (3} Origin {4) Destination {5} Passenger
An airline trip star schema consists of the following dimensions (1] Booking Date (Date reservation create) (2) Flight Date (3} Origin {4) Destination {5} Passenger
Subject:BusinessPrice: Bought3
An airline trip star schema consists of the following dimensions (1] Booking Date (Date reservation create) (2) Flight Date (3} Origin {4) Destination {5} Passenger. The granularity is 1 row per passenger per trip. The following additional attributes are available, that need to be captured in the model. (1) Total amount for trip (2} Discount code {can be one of AAA, Senior, Military, Government] [3} Booking channel (Web, Agent, Phone, Walk in) (4] Reservation Type (Refundable , Non-refundable) [5) Booking Type (Paid, Award Travel). For each of the attributes above discuss whether they are to be included in a fact table or dimension table. Specify the name of the new or existing dimension and/or fact tablets} and the data type and range of the attribute.
