Understand the sources of data in society, how to collect such data, the problems that might occur in collecting and storing such data and the basic statistics that are routinely performed on it.
Model databases using techniques such as normalisation, entity relationship diagrams and a document-based approach.
Create, populate and perform basic access approaches on a database using SQL Database Management System (DBMS).
Analyse different types of data using tools such as R or Python.
The SQL code for the following queries together with an explanation of the code:
- Find the flight attendants that have flown to Paris – output their ID and name.
- Find the flight attendants that have flown alongside pilot Ian Stoke – output their ID and name.
- Find the flight attendants that have flown on the 19th of April 2021 – output their ID and name.
- Find the flight attendants that have travelled on more than 4 flights – output their ID and name.
- Find the destination that was flown to the highest number of times – specify the destination and the number of times.
WHAT TO FOLLOW
An answer to the following question, together with a justification for the decision: In its current form, it is a
traditional database. Should you keep it that way? 5%
A main body detailing the process of implementing the database using SQL, including:
– normalisation of the table (should that be required) 10%
– the Entity-Relationship Diagram 10%
– use of SQL commands in order to create and populate the tables with data 5%
– SQL queries (15% in total – 3% each – 1.5% for the correct code and 1.5% for the code explanation)
– data analysis graphs (20% in total – 5% each – 3% for the correct code + output and 2% for the explanation)
Reflection and justification of the process for deriving above:
– justification of the database design steps (normalisation and ER diagram) 10%
– reflection on the coursework as a whole 5%
References and correct in text citation – at least 3 references, including books, journals or conference
Spelling, grammar, scientific writing 6%
Consistent formatting (font size, colour, type, alignment) 3%
Graphics, tables, visual aids, etc. 3%
Adopting an appropriate template (title page, table of contents, acronyms, table of figures, introduction, main
body, reflection, conclusion, references) 3%