Create a classification model, Database Management System

Assignment Help:

Use again the GE Flight Quest Data and build on the work done for homework 1 and 2. The goal is to create a classification model which classifies flights into "on-time" (you can define how many minuteslate you still accept) and "delayed". Use all available data (there is weather information available). Notealso that you have data for several days which you can use for training and testing.

Then, add 4 columns for the delay. These delay are:

  • gate_departure_delays =>(actual_gate_departure-scheduled_gate_departure )
  • gate_arrival_delays =>(actual_gate_arrival-scheduled_gate_arrival)
  • runway_departure_delays =>(actual_runway_departure-scheduled_runway_departure)
  • runway_arrival_delays =>(actual_runway_arrival-scheduled_runway_arrival)

Then work on this file.

Follow the CRISP-DM framework

3. Data Preparation

  • Construct variables as needed.
  • Deal with missing data.

Depend on the model that you use, how it deals with messing data, such as replace them with the mean values or find out what values should be, or anything you comfortable with, and provide a short description for that.

  • Combine the flight history data with additional data (weather, etc.)

Add column for weather to the file history that we have. You can find weather data in the data files.

4. Modeling

  • Create at least 3 different classification models (different techniques) and discuss theadvantages of each model for this classification task.

They could be 3 different trees, and describe each model. For example, put the tree or part of it then explain everything "what does it mean? What it tell the airport? What does it mean for them? And what can they do?

  • Assess how well each model performs (use training/test data, cross validation, etc. asappropriate).

Which of these models work better?

5. Evaluation

  • How useful is your best model for the airline industry? How would you measure the model'svalue?

6. Deployment

  • How would you deploy the model?
  • Write a report covering in detail all steps of the project. The results have to be reproducibleusing this documentation.

Related Discussions:- Create a classification model

Database application development, The database application project (DAP) fo...

The database application project (DAP) for this assignment consists of the creation of a fully functional Microsoft Access database application for a real client. I recommend you s

Which operations need the participating relations to union, Which operation...

Which operations need the participating relations to be union compatible? A UNION, INTERSECTION and DIFFERENCE operations need the participating relations to be union compatibl

Log based recovery, under what condition log based recovery is feasible?

under what condition log based recovery is feasible?

What is an entity relationship model, What is an entity relationship model?...

What is an entity relationship model? The entity relationship model is a set of basic objects known as entities and relationship between those objects. An entity is a thing or

Benefits of using a relational database management system, Question 1: ...

Question 1: a) What is the difference between a non-impact and impact printer? b) Which type of printer is generally used in a supermarket to print your receipt? Describe

What is a dataset, What is a dataset? A dataset is an in-memory databas...

What is a dataset? A dataset is an in-memory database that is disconnected from any regular database, but has all the significant characteristics of a regular database. Dataset

Distributed and client server databases, Distributed And Client Server Data...

Distributed And Client Server Databases Introduction This unit tells the distributed database systems which are primarily relational and one important execution model: the

Shadow copy, why shadow copy technique is used?

why shadow copy technique is used?

Deletion anomalies-data redundancy, Deletion Anomalies: Loss of important ...

Deletion Anomalies: Loss of important Information: In some cases, useful information may be lost when a tuple is deleted. For instance, if we delete the tuple corresponding to stu

Write Your Message!

Captcha
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