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.
Diese Übung ist Teil des Kurses
Introduction to Data Modeling in Snowflake
Interaktive Übung
Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.
-- Create a new entity
___ (
-- Add unique identifier
___ NUMBER(10,0) ___,
-- Add other attributes
___ VARCHAR(255)
);