6 Data and Databases

Question 1

Explain the purpose and importance of effective data modelling and data
normalisation.

Question 2

Demonstrate the principles of data normalisation and redundancy.

Question 3

Describe the concepts and key features of databases and data stores.

Answer 3

1. Relational databases.
   o SQL.
   o data structures (tables, records, fields, definitions).
2. Big data environments.
   o NoSQL.
   o data files.
   o document.
   o key-value.
   o column family.
   o graph.