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

Exercise

Applying 2NF

Your productqualityrating entity is a rich dataset that captures the essence of chocolate bars reviewed over various years. You noticed that the company_location attribute depends on the manufacturer attribute. The company_location values repeat every time they are together with the manufacturer attribute, which violates the second normal form's rule against partial dependencies.

By separating this data into a dedicated manufacturers entity, you can remove redundancies and prepare our data model for more efficient operations. This step is crucial in maintaining data integrity and allows scalable business intelligence solutions.

Your task is to normalize this data to align with 2NF principles, ensuring that each non-key attribute entirely depends on the primary key.

Instructions 1/2

undefined XP
    1
    2
  • Create manufacturers entity while assigning manufacturer_id as PK with numerical values of 10 digits.
  • List all manufacturers attributes; manufacturer and company_location, both with datatype VARCHAR(255).