Applying 2NF
Your productqualityrating entity is a rich dataset that captures the essence of chocolate bars reviewed over various years. You noticed that the company_location attribute depends on the manufacturer attribute. The company_location values repeat every time they are together with the manufacturer attribute, which violates the second normal form's rule against partial dependencies.
By separating this data into a dedicated manufacturers entity, you can remove redundancies and prepare our data model for more efficient operations. This step is crucial in maintaining data integrity and allows scalable business intelligence solutions.
Your task is to normalize this data to align with 2NF principles, ensuring that each non-key attribute entirely depends on the primary key.
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.
-- Add new entity
___ (
-- Assign unique identifier
___ NUMBER(10,0) PRIMARY KEY,
--Add other attributes
___ VARCHAR(255),
___ VARCHAR(255)
);