Data Requirements → Unit 3#

Unit 3 subject matter covered:

  • Justify selection of relevant data from existing data sources [QCAA, 2017]

Analysis of data file#

Questions you need to ask when analysing the data file:

What is the data file about?#

What fields does the data files contain?#

What are their data types?#

Is the table in 3NF?#

Data Scrubbing#

Is there any problematic data?#

Do the data types make sense?#