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

Exercise

Creating 1NF entities

Previously, you have learned about the disadvantages of unnormalized data and the benefits of relational data with normalized data. It is time to apply it to the productqualityrating entity.

To ensure that the data model complies with the first normal form, breaking the repeating groups and eliminating them is necessary. productqualityrating entity contains attributes with multiple values; ingredients, and reviews.

Your task is to start normalizing this data by creating new entities that conform to 1NF, ensuring each record holds an atomic, individual and unique piece of information.

Instructions 1/2

undefined XP
  • 1
    • Create or overwrite the entity ingredients while adding the attribute ingredient_id as a numerical of 10 digits and ingredient as characters.
    • Set ingredient_id as the unique identifier of the entity.
  • 2
    • Overwrite the entity reviews while adding the attribute review_id as a numerical of 10 digits and review as characters of 255.
    • Set review_id as the unique identifier of the entity.