Applying 1NF
After creating ingredients and reviews entities, it's time to populate them with data from productqualityrating.
This step is crucial to ensure that each value within the ingredients and review is treated as a distinct entry, aligning with the principles of 1NF.
Start by crafting a query to transform and input the unnormalized data into these entities, adhering to the first normal form principles.
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.
SELECT
-- Clean empty values
___(f.value)
FROM productqualityrating,
-- Add function to split values separated by comma
LATERAL ___(INPUT => SPLIT(productqualityrating.___, ';')) f;