Posted: February 16th, 2017

Design a multidimensional database using a star schema for a data warehouse for the Best Airlines, Inc., airplane maintenance environment described by the database schema.

Design a multidimensional database using a star schema for a data warehouse for the Best Airlines, Inc., airplane maintenance environment described by the database schema. The main subject will be maintenance event, starting with the fact table EVENT. Complete the rest of the design, including snowflake tables as appropriate. Use the Dropbox for Quiz 2: Q32 to submit a diagram or a text-based schema representation is also acceptable. Using the ERD design tool in MySQL Workbench, if you have it, is an appropriate tool for this assignment. (Hint: see Fig 13.9, p 350 for an example of a star schema design)

they are attached as files