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.
Cet exercice fait partie du cours
Introduction to Data Modeling in Snowflake
Exercice interactif pratique
Essayez cet exercice en complétant cet exemple de code.
-- Create a new entity
___ (
-- Add unique identifier
___ NUMBER(10,0) ___,
-- Add other attributes
___ VARCHAR(255)
);