BaşlayınÜcretsiz Başlayın

Creating an entity

As you've progressed from the conceptual to the logical stages of data modeling, you've learned to define the structures representing real-world entities and their connections. Now, it's time to put the knowledge into practice.

In the e-commerce system, logical model included three essential tables: customers, products, and orders. These tables are designed to mirror the real interactions within a business context: customers generate orders, and orders contain products. Previously, you learned to create products, now it is time to define the customers table.

Bu egzersiz

Introduction to Data Modeling in Snowflake

kursunun bir parçasıdır
Kursu Görüntüle

Egzersiz talimatları

  • Create or replace, if it already exists, the customers table.
  • Assign customerid, with a numerical data type, no decimals, 38 digits long, as the unique identifier of the customer's records.

Uygulamalı interaktif egzersiz

Bu örnek kodu tamamlayarak bu egzersizi bitirin.

-- Create customers table 
___ (
  -- Define unique identifier
  ___,
  country VARCHAR(255)
);
Kodu Düzenle ve Çalıştır