\documentclass[10pt,a4paper]{article}

% Packages
\usepackage{fancyhdr}           % For header and footer
\usepackage{multicol}           % Allows multicols in tables
\usepackage{tabularx}           % Intelligent column widths
\usepackage{tabulary}           % Used in header and footer
\usepackage{hhline}             % Border under tables
\usepackage{graphicx}           % For images
\usepackage{xcolor}             % For hex colours
%\usepackage[utf8x]{inputenc}    % For unicode character support
\usepackage[T1]{fontenc}        % Without this we get weird character replacements
\usepackage{colortbl}           % For coloured tables
\usepackage{setspace}           % For line height
\usepackage{lastpage}           % Needed for total page number
\usepackage{seqsplit}           % Splits long words.
%\usepackage{opensans}          % Can't make this work so far. Shame. Would be lovely.
\usepackage[normalem]{ulem}     % For underlining links
% Most of the following are not required for the majority
% of cheat sheets but are needed for some symbol support.
\usepackage{amsmath}            % Symbols
\usepackage{MnSymbol}           % Symbols
\usepackage{wasysym}            % Symbols
%\usepackage[english,german,french,spanish,italian]{babel}              % Languages

% Document Info
\author{ehe}
\pdfinfo{
  /Title (big-data-aqa-computer-science-cheat-sheet.pdf)
  /Creator (Cheatography)
  /Author (ehe)
  /Subject (Big Data - AQA Computer Science Cheat Sheet)
}

% Lengths and widths
\addtolength{\textwidth}{6cm}
\addtolength{\textheight}{-1cm}
\addtolength{\hoffset}{-3cm}
\addtolength{\voffset}{-2cm}
\setlength{\tabcolsep}{0.2cm} % Space between columns
\setlength{\headsep}{-12pt} % Reduce space between header and content
\setlength{\headheight}{85pt} % If less, LaTeX automatically increases it
\renewcommand{\footrulewidth}{0pt} % Remove footer line
\renewcommand{\headrulewidth}{0pt} % Remove header line
\renewcommand{\seqinsert}{\ifmmode\allowbreak\else\-\fi} % Hyphens in seqsplit
% This two commands together give roughly
% the right line height in the tables
\renewcommand{\arraystretch}{1.3}
\onehalfspacing

% Commands
\newcommand{\SetRowColor}[1]{\noalign{\gdef\RowColorName{#1}}\rowcolor{\RowColorName}} % Shortcut for row colour
\newcommand{\mymulticolumn}[3]{\multicolumn{#1}{>{\columncolor{\RowColorName}}#2}{#3}} % For coloured multi-cols
\newcolumntype{x}[1]{>{\raggedright}p{#1}} % New column types for ragged-right paragraph columns
\newcommand{\tn}{\tabularnewline} % Required as custom column type in use

% Font and Colours
\definecolor{HeadBackground}{HTML}{333333}
\definecolor{FootBackground}{HTML}{666666}
\definecolor{TextColor}{HTML}{333333}
\definecolor{DarkBackground}{HTML}{04DECC}
\definecolor{LightBackground}{HTML}{EFFCFB}
\renewcommand{\familydefault}{\sfdefault}
\color{TextColor}

% Header and Footer
\pagestyle{fancy}
\fancyhead{} % Set header to blank
\fancyfoot{} % Set footer to blank
\fancyhead[L]{
\noindent
\begin{multicols}{3}
\begin{tabulary}{5.8cm}{C}
    \SetRowColor{DarkBackground}
    \vspace{-7pt}
    {\parbox{\dimexpr\textwidth-2\fboxsep\relax}{\noindent
        \hspace*{-6pt}\includegraphics[width=5.8cm]{/web/www.cheatography.com/public/images/cheatography_logo.pdf}}
    }
\end{tabulary}
\columnbreak
\begin{tabulary}{11cm}{L}
    \vspace{-2pt}\large{\bf{\textcolor{DarkBackground}{\textrm{Big Data - AQA Computer Science Cheat Sheet}}}} \\
    \normalsize{by \textcolor{DarkBackground}{ehe} via \textcolor{DarkBackground}{\uline{cheatography.com/212604/cs/46225/}}}
\end{tabulary}
\end{multicols}}

\fancyfoot[L]{ \footnotesize
\noindent
\begin{multicols}{3}
\begin{tabulary}{5.8cm}{LL}
  \SetRowColor{FootBackground}
  \mymulticolumn{2}{p{5.377cm}}{\bf\textcolor{white}{Cheatographer}}  \\
  \vspace{-2pt}ehe \\
  \uline{cheatography.com/ehe} \\
  \end{tabulary}
\vfill
\columnbreak
\begin{tabulary}{5.8cm}{L}
  \SetRowColor{FootBackground}
  \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Cheat Sheet}}  \\
   \vspace{-2pt}Not Yet Published.\\
   Updated 28th April, 2025.\\
   Page {\thepage} of \pageref{LastPage}.
\end{tabulary}
\vfill
\columnbreak
\begin{tabulary}{5.8cm}{L}
  \SetRowColor{FootBackground}
  \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Sponsor}}  \\
  \SetRowColor{white}
  \vspace{-5pt}
  %\includegraphics[width=48px,height=48px]{dave.jpeg}
  Measure your website readability!\\
  www.readability-score.com
\end{tabulary}
\end{multicols}}




\begin{document}
\raggedright
\raggedcolumns

% Set font size to small. Switch to any value
% from this page to resize cheat sheet text:
% www.emerson.emory.edu/services/latex/latex_169.html
\footnotesize % Small font.

\begin{multicols*}{3}

\begin{tabularx}{5.377cm}{x{0.84609 cm} x{4.13091 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{5 Vs of Big Data}}  \tn
% Row 0
\SetRowColor{LightBackground}
\seqsplit{Variety} & The range of data formats and data types collected \tn 
% Row Count 2 (+ 2)
% Row 1
\SetRowColor{white}
Value & How useful data is to an organisation \tn 
% Row Count 4 (+ 2)
% Row 2
\SetRowColor{LightBackground}
\seqsplit{Veracity} & Accuracy and quality of data \tn 
% Row Count 6 (+ 2)
% Row 3
\SetRowColor{white}
\seqsplit{Volume} & The amount of data (if the volume is large enough, it is considered big data) \tn 
% Row Count 9 (+ 3)
% Row 4
\SetRowColor{LightBackground}
\seqsplit{Velocity} & How quickly the data is generated \tn 
% Row Count 11 (+ 2)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{x{1.29402 cm} x{3.68298 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Example Big Data Applications}}  \tn
% Row 0
\SetRowColor{LightBackground}
\seqsplit{Healthcare} & Predict disease outbreaks and personalize treatment plans \tn 
% Row Count 2 (+ 2)
% Row 1
\SetRowColor{white}
\seqsplit{Entertainment} & Recommend content and analyze audience preferences \tn 
% Row Count 4 (+ 2)
% Row 2
\SetRowColor{LightBackground}
\seqsplit{Transportation} & Improve traffic flow and predict maintenance needs \tn 
% Row Count 6 (+ 2)
% Row 3
\SetRowColor{white}
Retail & Optimize inventory and personalize customer recommendations \tn 
% Row Count 9 (+ 3)
% Row 4
\SetRowColor{LightBackground}
Finance & Detect fraudulent transactions in real-time \tn 
% Row Count 11 (+ 2)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{x{1.24425 cm} x{3.73275 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Relationships in Relational Databases}}  \tn
% Row 0
\SetRowColor{LightBackground}
\seqsplit{One-to-one} & One school has one principle \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
\seqsplit{One-to-many} & One school has many students \tn 
% Row Count 3 (+ 2)
% Row 2
\SetRowColor{LightBackground}
\seqsplit{Many-to-many} & Many students and take many subjects \tn 
% Row Count 5 (+ 2)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Entity Relationship Diagram}}  \tn
\SetRowColor{LightBackground}
\mymulticolumn{1}{p{5.377cm}}{\vspace{1px}\centerline{\includegraphics[width=5.1cm]{/web/www.cheatography.com/public/uploads/ehe_1745818294_Screenshot 2025-04-28 123056.png}}} \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{x{1.59264 cm} x{3.38436 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Relational Databases}}  \tn
% Row 0
\SetRowColor{LightBackground}
Table & Set of facts or figures that are set out in a column and row structure \tn 
% Row Count 3 (+ 3)
% Row 1
\SetRowColor{white}
Flat-file database & Database that stores all data items using one table \tn 
% Row Count 5 (+ 2)
% Row 2
\SetRowColor{LightBackground}
Data redundancy & When data is unnecessarily repeated in a database \tn 
% Row Count 7 (+ 2)
% Row 3
\SetRowColor{white}
Data-entry error & Error that occurs when data is being entered into a database \tn 
% Row Count 10 (+ 3)
% Row 4
\SetRowColor{LightBackground}
Relational database & Database that stores data using two or more linked tables \tn 
% Row Count 13 (+ 3)
% Row 5
\SetRowColor{white}
Entity & Person, place or object represented in a table in a relational database \tn 
% Row Count 16 (+ 3)
% Row 6
\SetRowColor{LightBackground}
Attribute & Heading for organising data in a relational database \tn 
% Row Count 18 (+ 2)
% Row 7
\SetRowColor{white}
Primary key & Field in a database table that provides a unique identifier for a record/entity \tn 
% Row Count 21 (+ 3)
% Row 8
\SetRowColor{LightBackground}
Foreign key & When the primary key from one table appears in another table to establish a link between two entities \tn 
% Row Count 25 (+ 4)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{x{1.89126 cm} x{3.08574 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Query}}  \tn
% Row 0
\SetRowColor{LightBackground}
Simple queries & Only a single search criterion is used to select data items from a database \tn 
% Row Count 4 (+ 4)
% Row 1
\SetRowColor{white}
Complex queries & More than one criterion is used to search a database, a query is used to combine data from more than one table, or calculations are performed using the data in a query or a report \tn 
% Row Count 12 (+ 8)
% Row 2
\SetRowColor{LightBackground}
Parameter queries & Queries where the end user provides the search criteria \tn 
% Row Count 15 (+ 3)
% Row 3
\SetRowColor{white}
Wildcard queries & Queries where special characters are used to stand in for unknown characters (this is useful when trying to find lots of data items that are similar but not exactly the same) \tn 
% Row Count 23 (+ 8)
% Row 4
\SetRowColor{LightBackground}
Multi-table queries & Use data from more than one data table \tn 
% Row Count 25 (+ 2)
% Row 5
\SetRowColor{white}
\seqsplit{Multiple-criteria} queries & Use more than one criterion to select data items from a database \tn 
% Row Count 28 (+ 3)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{x{1.29402 cm} x{3.68298 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Spreadsheet Model}}  \tn
% Row 0
\SetRowColor{LightBackground}
Function & Sub-program that can exist as part of a bigger program \tn 
% Row Count 2 (+ 2)
% Row 1
\SetRowColor{white}
MIN function & Returns the lowest value in a specified range of cells in a spreadsheet \tn 
% Row Count 5 (+ 3)
% Row 2
\SetRowColor{LightBackground}
MAX function & Returns the highest value in a specified range of cells in a spreadsheet \tn 
% Row Count 8 (+ 3)
% Row 3
\SetRowColor{white}
IF statement & This evaluates a condition which determines the path of the program depending on whether the condition is true or false \tn 
% Row Count 13 (+ 5)
% Row 4
\SetRowColor{LightBackground}
COUNT function & Checks all the cells in a specified range in a spreadsheet and outputs how many contain a numeric value \tn 
% Row Count 17 (+ 4)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Evaluating models}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{1}{x{5.377cm}}{Evaluation: checking the suitability of a solution to a problem} \tn 
% Row Count 2 (+ 2)
% Row 1
\SetRowColor{white}
\mymulticolumn{1}{x{5.377cm}}{Efficient: the efficiency of a program can be measured by how quickly it runs} \tn 
% Row Count 4 (+ 2)
% Row 2
\SetRowColor{LightBackground}
\mymulticolumn{1}{x{5.377cm}}{User requirements: tasks a user expects of an application} \tn 
% Row Count 6 (+ 2)
% Row 3
\SetRowColor{white}
\mymulticolumn{1}{x{5.377cm}}{Data type: classification applied to a data item specifying which type of data that item represents, e.g. in a spreadsheet some of the data types available include currency, text and number} \tn 
% Row Count 10 (+ 4)
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{x{2.18988 cm} x{2.78712 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Frameworks}}  \tn
% Row 0
\SetRowColor{LightBackground}
Structured Query Language (SQL) & Specialised language for accessing data in relational databases \tn 
% Row Count 3 (+ 3)
% Row 1
\SetRowColor{white}
Query by Example (QBE) & Interface that allows users to select fields and criteria for use in a query in a database application \tn 
% Row Count 8 (+ 5)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}


% That's all folks
\end{multicols*}

\end{document}