CI7320 - ‘Flight Punctuality’ Exercise: Databases & Data Management – Assignment 2 , Kingston University

Published: 17 Jan, 2025
Category Assignment Subject Management
University Kingstone University London Module Title CI7320 Databases & Data Management

The data set provided for this assignment is punctuality statistics for selected UK airports. There are 12 files for each month of 2023. Airport IATA codes can be found at iata.org.

For this assignment, you will be reporting on how the data could be used for research using data
warehouse and Tableau.

The report should include the following:

  1.  Discuss the benefits of building a data warehouse for the data set provided.
  2. Design a data warehouse using a star schema. You must justify your design decisions. 
  3. Write the CREATE table statements for the tables in your star schema (include all primary
    and foreign keys). 
  4. Discuss the steps you took in creating and populating the database. This should include the steps you took in preparing the data and the transformation tasks performed. Include screenshots of your populated tables.
  5.  Discuss the advantages that OLAP cubes offer to the airline industry as a whole. Provide two examples of OLAP cube applications within your discussion, ensuring that the cubes are illustrated.
  6. Create 4 visualizations using Tableau. For each visualization, you should include the
    following:
    a)Aim of the visualization
    b)The steps you took to create the visualization
    c)Key findings from the visualization

 

Blur Image of Answer Request Answer of this Assignment

Are you considering getting help from someone for your Databases & Data Management – Assignment 2? Great, you are on the right platform. Our assignment help services provide all types of writing services, including essays, dissertations, theses, and more. Our expertise covers all your needs and ensures plagiarism-free, well-researched, and timely submissions that facilitate A+ grades and student satisfaction with their Assignments. For several years, we have served 4,500+ student clients withholding A+ grades in their Assignments.

Workingment Unique Features

Hire Assignment Helper Today!


Latest University Assignment Questions

CMA3005 – Introduction to Construction Management L3 Assessment Guide

CMA3005 Individual Report: The project involves converting the existing library at GBS into large seminar rooms to support growing student numbers.

View or Download
CET255 Developing A Smart Greenhouse Monitoring System Prototype Assessment Brief

CET255 – IoT & Robotics Assessment: The aim of this assessment is to provide you with an opportunity to demonstrate your understanding and practical skills in IoT and Robotics.

View or Download
ICM218 Research Project Assignment Brief 2024-25 | UoR

The Research Project almost always involves the analysis of data. At the start, each student is allocated an academic supervisor who offers advice on their Research Project.

View or Download
Heisenberg Uncertainty Principle and de Broglie Equation 2024-25

Physics helps us understand the laws that govern our universe. Among the most fascinating areas of modern physics are the Heisenberg Uncertainty Principle and the de Broglie Equation.

View or Download
SWSP6153 Indigenous Social Work 2025T2 | ACAP

This unit will introduce students to the diversity of the social, cultural and political situation in which Aboriginal and Torres Strait Islander people live. Indigenous Knowledge and practice as a new framework for working effectively.

View or Download
771762 Assignment: Big Data and Data Mining Project Report 2025

771762 Assignment Task: Your task is to advise the DfT (and any other relevant UK Gov department) on the policy changes/interventions required to improve road safety, as well as to create a model that would predict such accidents and the injuries that people may incur.

View or Download
MKT62304 Marketing Analytics Group Assignment Task | Taylor's

MKT62304 Group Assignment Task: This assignment aims to assess the role and effectiveness of marketing analytics in the water and SME sectors, focusing on how data-driven approaches can achieve strategic objectives and desired outcomes.

View or Download
CST4530 Security Solutions and Applications Module Handbook 2024-25 | MUL

This module covers the concepts and critical issues of security with an emphasis on security architecture and mechanisms, standards, protocols, solutions, and applications. It aims to provide students with an understanding of security technologies, algorithms, and solutions.

View or Download
UMSD87-15-3 Business Innovation and Growth Module Handbook 2024-25 | UWE

We aim to increase your knowledge and understanding of these three themes and of the theories and concepts that surround them, to provide you with some subject-specific and transferable skills.

View or Download
BTC 3150 Taxation Law Assignment Questions S1, 2025 | Monash University

Part One: Short Answer Questions worth a total of 14 marks;  Part Two: Problem Style Question worth a total of 6 marks; and  Part Three: Problem Style Question (that includes some calculations) worth a total of 10 marks.

View or Download
View More
Online Assignment Help in UK