Identifying Data Redundancy
Businesses thrive on efficient data management, and identifying data redundancy is crucial for maintaining an organized and cost-effective data model. Redundant data can take up unnecessary space and complicate processes.
Your task is to identify redundancy for product quality rating data, the business has collected over their product and the manufacturers, which differs from delicious chocolate bars and each manufacturer has their own characteristics.
This step is essential to identifying unnormalized data, getting ready for the normalization step, and streamlining the storage of your data model.
This exercise is part of the course
Introduction to Data Modeling in Snowflake
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- List all values from the attribute
___
___
-- Read all these values from the entity
___;