Implementing conceptual data model
As you progress in this journey to model data, it's essential to get hands-on practice on how to implement the models.
In our ongoing E-Commerce project, the logical and conceptual data model indicated to us that there are three key entities: customers, orders, and products.
The customers entity is ready, and now, for this exercise, you will focus on defining the table structures for orders and products.
This exercise is part of the course
Introduction to Data Modeling in Snowflake
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Create a new products entity
___ products(
-- List the entity's attributes
___,
___
);