1. Learn
  2. /
  3. Courses
  4. /
  5. Introduction to Data Modeling in Snowflake

Connected

Exercise

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.

Instructions 1/3

undefined XP
    1
    2
    3
  • Select the list of all the manufacturer and company_location attribute values from the productqualityrating entity.