Executing cql scripts and the corresponding data

Assignment Help Database Management System

Reference no: EM133709734

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: EM133709734

Questions Cloud

Explain immigration policy of president biden administration : Explain Immigration Policy of President Biden Administration. You must discuss in your paper the roles of Congress, the Executive Branch and the Judiciary.

What is being conditioned by the kidneys : The kidneys are one of the body's conditioning organs. What is being conditioned by the kidneys? Can a person live with only one kidney? Explain your answer.

What value does level of evidence provide during synthesis : The nurse is working to synthesize information from literature review to answer PICOT question. What value does the level of evidence provide during synthesis?

Discuss the role of public administrators in balancing : Discuss the role of public administrators in balancing these two seemingly conflicting ideals and provide an example that supports your view.

Executing cql scripts and the corresponding data : 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

Relationship between global issues-states and organizations : Relationship between global issues, states and organizations, and people that we've studied this semester to someone who has never studied global issues?

Which statements regarding client and alcohol use is best : Which statements regarding the client and alcohol use is the BEST example of appropriate clinical documentation?

Assess ballistic missile program capabilities : You will need to assess North Korea's Nuclear and Ballistic Missile program capabilities and assess its intent to employ them.

Ppt showcasing deep understanding of computer networks : Create a 10-minute presentation on the fundamentals of information, communication, and computer networks, focusing on the main technologies, models

User Account

All Pages