Applying 3NF
With our manufacturers table successfully reflecting 2NF standards, we now set our sights on the third normal form. We've recognized that a manufacturer's location is an independent piece of data.
Your task is to eliminate this transitive dependency, refining our data model to support our business's dynamic data needs. This adjustment will significantly improve our data model's flexibility and minimize the impact of data modifications.
Bu egzersiz
Introduction to Data Modeling in Snowflake
kursunun bir parçasıdırUygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Create entity
___ (
-- Add unique identifier
___ NUMBER(10,0) ___,
-- Add main attribute
___ VARCHAR(255)
);