How will they fly to get to their holiday destinations

Assignment Help Database Management System

Reference no: EM133708084

Data Acquisition and Management

Your Task

You are required to:

1. Complete each of the graph database queries provided in a Neo4J CQL script file.

2. Prepare a team presentation to explain and summarise the business insights found, when executing the CQL scripts, and the corresponding data visualisations (Nodes/Tables) produced.

Business Problem: Suppose that you are an analyst for the department of aviation. You have been provided with data from Australian airports, such as the number of flights in and out of cities, flight times and delays. With this in mind,

Part A: Teamwork Presentation

1. Form groups of 3 or 4 students and chose a team leader.
Notes: Your lecturer would have provided the Neo4j script 7 days prior to the date of presentation.

2. Access the PowerPoint slide instructions provided by your lecturer in class and work through the business problems as described.

4. Create at least 5 slides to present your team's findings.

Part B: Individual Report (600 words)
As an individual, perform some research and provide answers to the following:

How do graph databases and the format of the data used by them differ from traditional SQL databases? Illustrate your answers.

Discuss two industry applications of graph databases with illustrations.

List and briefly explain one challenge in relation to using graph databases to explore patterns and relationships.
The Money Heist Crew Moved to Australia
Synopsis:
The infamous Money Heist Crew has moved to Australia and they are living in different Australian cities e.g., Melbourne, Sydney, Adelaide, Perth, Brisbane, and Darwin
They have maintained their relationships: some are partners whilst others
are good friends
Now and then, the "Heisters" must fly to see each other and/or go on holidays to their favourite places in Australia: this means that they must buy tickets and fly on airlines (e.g., Qantas, Virgin, Jetstar, Rex) between different Australian cities

Business Problems - What you need to present in Class

Select at least 4 Heister characters (you may report insight on all Heisters):
Find where they live
Find who they are friends and/or partners with
Find out where they like to go on holiday
What class (first, business, or economy) they prefer to fly?
Given where the Heisters live, who they are friends with, or where they go on holidays:
How will they fly to see their friends or partners?
How will they fly to get to their holiday destinations?
How much will the plane tickets cost to get to their holiday destinations?
Given the provided queries, can you find other interesting insights? Hint: you can start from a query, change variables, and when the visuals are displayed, browse for more patterns of connections
Can you find out where the next bank heist will be? - Explain your answer

Your Task
You are required to:

1. Complete each of the graph database queries required in Slide 4 - you may use the provided in the CQL script file - Aussie_flights_heisters_CQL_Queries.txt

2. Prepare a team presentation to explain and summarise the business insights found from executing the CQL scripts and the corresponding data visualisations (Graph of Nodes)

Reference no: EM133708084

Questions Cloud

Children in menu planning and meal preparation : Describe how you could include the children in menu planning and meal preparation.

Benefits of incorporating telehealth into oncology care : Although many studies highlight the benefits of incorporating telehealth into oncology care,

Are nurses involved in evaluating the systems : What training is provided when a new information system is implemented in your organization? Are nurses involved in evaluating the systems?

Common cause of death or disability : Background Cerebrovascular accident, or stroke, is a common cause of death or disability.

How will they fly to get to their holiday destinations : T32023 Assessment Graph Database & Queries, How will they fly to get to their holiday destinations? How much will the plane tickets cost to get to their holiday

Describe how the nursing theory key concepts : NSG 416- Describe how the nursing theory key concepts relate to professional nursing practice, critical thinking, and clinical decision-making processes.

State what will be gained from your project : State what will be gained from your project. Describe the expected outcomes of your project to practice within your population and setting.

Conduct an analysis of the elements of the research article : Using the Module section of your Academic Success and Professional Development Plan. Conduct an analysis of the elements of the research article you identified.

Reflect on the strategies presented in the resources : Reflect on the strategies presented in the Resources for this Module in support of academic style, integrity, and scholarly ethics.

User Account

All Pages