Creating satellites
With the hubs established, the next step is to create satellites that store descriptive information related to each hub. Satellites provide context and depth to the keys stored in hubs, and they capture the descriptive attributes, changes over time, and the history of business concepts.
Your task will be to create these satellites.
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 satellite
___ (
sat_employee_key NUMBER(10,0) AUTOINCREMENT PRIMARY KEY,
hub_employee_key NUMBER(10,0),
employee_name VARCHAR(255),
gender CHAR(1),
age NUMBER(3,0),
-- Add history tracking attributes
___ TIMESTAMP
___ VARCHAR(255),
-- Add a reference to foreign hub
FOREIGN KEY (___) REFERENCES ___(___)
);