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.
Questo esercizio fa parte del corso
Introduction to Data Modeling in Snowflake
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
-- Create a new entity
___ (
-- Add unique identifier
___ NUMBER(10,0) ___,
-- Add other attributes
___ VARCHAR(255)
);