Data definitions

Question 1

What is a data lake?

Answer 1

Store big data of all structures from various data sources.

Question 2

What is a Data Warehouse?

Answer 2

Historical data that has been structured to fit a relational database schema

Question 3

What is a database schema

Answer 3

logical and visual configuration of the entire relational database

Question 4

What is normalisation?

Answer 4

Database design - divides tables into smaller tables and connects them via relationships to reduce redundancy and increase data integrity