What is your understanding of normalization, facts, and dimensions in the context of database design?

Question

Accepted Answer

Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity. Facts and dimensions are components of a star schema used in data warehousing.

Normalization involves breaking down data into smaller, more manageable tables to reduce redundancy and improve data integrity.
Facts are numerical data that can be analyzed, such as sales revenue or quantity sold.
Dimensions are descriptive attributes related to the facts, such as product name or customer location.
In a star schema, facts are stored in a central table surrounded by dimension tables linked through foreign keys.
Example: In a sales database, the fact table may contain sales revenue and the dimension tables may include product, customer, and date dimensions.

What is your understanding of normalization, facts, and dimensions in the context of database design?

Top Ernst & Young Manager interview questions & answers

Popular interview questions of Manager

Top HR questions asked in Ernst & Young Manager