Fundamentals

Question 1

Data normaliation is

Answer 1

Q
Data normaliation is the pricess of transforming data into an efficient and robust from for storage ad analysis.

Question 2

The benefits of data normalization can be summarixed as

Answer 2

Protects data integrity
Reduces storage space
easier to maintain
improves query speed

Question 3

Examples of Data in table can included

Answer 3

Repetation in line items
no unique identificators
displaying dates over the column promts the addition of unecessary zeros
tabls should be specific

Question 4

Facts table records

Answer 4

a particular event or measurement

Question 5

How to normalize a table

Answer 5

Contains things measure and atrributes describing objectives
no infromation is repeated
everything has a unique identifier
metrics appear in single column
all attributes are seperated into diffrent tables

Question 6

Data sets for Sale

Answer 6

Date dimension table
Store dimentsion tbale
Category dimension table
sales fact table
Other Financial Fact table