Dimensional modeling exercise

Assignment Help Operation Management
Reference no: EM131724992

Dimensional Modeling Exercise

An airport would like to set up a data warehouse as an Airport Information System. As a consultant, you are called upon to support the client in the data modeling phase of the project.

The airport has two terminals (1 and 2) with gate areas A and B in terminal 1, and gate areas C, D, and E in terminal 2.

All take-offs and landings should be recorded and made available for evaluation. The following information is needed for the evaluations:

            Airline (AA, DL, UA, LH, etc.)

            Flight number (DL234, UA822, etc.)

            Aircraft type (B737, B747, A310, etc.)

            Originating and Destination Airports

            Gate (A01, C14, etc.)

Date, time, day of the week, flight plan (summer or winter), and the hour (00:00 – 00:59, 01:00 – 01:59, etc.) are required as time characteristics.

When carrying out evaluations on the aircraft, the aircraft weight, maximum number of passengers, and freight capacity should be displayed.

The following queries should be supported by the data model:

How many take-offs and landings have been undertaken on a Monday, for example, in the last year?

What was the capacity load on an individual aircraft or individual airline carrier with respect to passenger and freight volumes?

What was the passenger throughput per gate or terminal?

How many tons of freight have been carried in the last 12 months?

What were the fixed and variable costs, and the total cost for an airline per month for flights to Germany and other countries?

Develop a dimensional schema for the Airport Information System.

Airline Flight Schema – Discussion Questions

Draw the flight dimensional schema that was discussed in class (the Airline Dimensional Modeling exercise was handed out in class; I’ve also posted it on D2L under Week 5). Identify the attributes of the 6 dimensions (Time, Airline, Airport, Gate, etc.). In addition to the attributes that have been explicitly stated in the problem, make sure to include attributes based on your knowledge of the air travel domain. For drawing the diagram, use Excel. If you use any other drawing tool (like Visio), make sure to convert it into a pdf file.

Develop a monthly snapshot schema (diagram) based on the flight schema. The snapshot should cover all flights that took off from a given airport for each airline (e.g., United, American, etc.). Make sure to include summary facts in the snapshot schema and suppress (add) non-relevant (relevant) dimensions. Show all the keys and attributes of the fact table and the dimensional tables.

What is the grain size of the snapshot fact table? (Be specific; you can explain the grain size using an example.)

Reference no: EM131724992

Questions Cloud

Was there legally sufficient consideration : Was there legally sufficient consideration? Did the promisee incur a legal detriment?
Green accounting systems and ethical investment : How can green accounting systems and ethical investment make businesses more sustainable?
Role do you think diversity should play within organization : Based on your thoughts, what role do you think diversity should play within an organization?
Exceed the amount invested in the income fund : How would the original recommendation change if the amount invested in the growth fund is not allowed to exceed the amount invested in the income fund?
Dimensional modeling exercise : An airport would like to set up a data warehouse as an Airport Information System. What was the passenger throughput per gate or terminal?
Key issues in sustainable transportation : What are the key issues in sustainable transportation? What is a carbon footprint?
Relate to the content that we have been discussing : How did it relate to the content that we have been discussing? What did you observe?
Design reflection of its environment-goals and competencies : how is the organization's structure and design a reflection of its environment, goals, and competencies?
What is the breakeven point : Each item is sold to retailers at a price that averages 90 cents. What is the breakeven point?

Reviews

Write a Review

Operation Management Questions & Answers

  Book review - the goal

Operations Management is about a book review. Title of the book is "Goal". This book has been written by Dr. Eliyahu Goldartt. The book has been appreciated by many as one of those books which offers an insight into the operations and strategic capac..

  Operational plan in hospitality enterprise

Operational plan pertaining to a hospitality enterprise is given in detail in the solution. The operational plan is an important plan or preparation which gives guidelines regarding the role and responsibilities of each and every operation at all lev..

  Managing operations and information

Recognise the importance of a strategic approach to the development and deployment of organisational information systems. Demonstrate an understanding of the importance of databases and their integration to the organisation's overall information mana..

  A make-or-buy analysis

An analysis of the holding costs, including the appropriate annual holding cost rate.

  Evolution and contributor of operations management

Briefly explain Evolution and contributor of Operations management.

  Functions and responsibilities of an operations manager

A number of drivers of change have transformed the roles, functions and responsibilities of an operations manager over recent years. These drivers have not only been based on technological innovations but also on the need for organisations to develop..

  Compute the optimal order quantity

Compute the Optimal Order quantity of DVD players. Determine the appropriate reorder point.

  Relationship to operations practice in the organisation

Evaluate problems in operations and identify approaches to overcoming them. Critically evaluate operating plans and identify areas for improvement. Justify, implement and evaluate changes to operations in line with modern approaches.

  A make or buy analysis

Develop a report for Figi Fabricating that will address the question of whether the company should continue to purchase the part from the supplier or begin to produce the part itself.

  Prepare a staffing plan

Prepare a staffing plan showing the change of your unit from medical/surgical staffing to oncology staffing.

  Leadership styles in different organizations

Ccompare the effectiveness of different leadership styles in different organizations

  Risk management tools and models

Be able to understand the concept of risk, roles and responsibilities for risk management and risk management tools and models.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd