Master SQL for Data Analysis - Loading the eCommerce Datasets

The video tutorial covers the creation of an e-commerce database schema, including tables for customers, products, suppliers, orders, order reviews, order items, and order payments. It explains how these tables are interconnected through primary and foreign keys, and demonstrates the use of SQL commands to create tables and load data from CSV files. The tutorial concludes with a review of the relational diagram to understand the connections between datasets.

What is the primary key in the customers table?

• Customer Name

• Customer ID

• City

• State

Which attribute in the orders table acts as a foreign key?

• Customer ID

• Order ID

• Order Status

• Order Purchase Timestamp

What is the primary key in the order_reviews table?

• Review Creation Date

• Review ID

• Order ID

• Review Score

In the order_items table, which attribute is a foreign key to the products table?

• Order Item ID

• Product ID

• Shipping Limit Date

• Price

What is the primary key combination in the order_items table?

• Product ID and Shipping Value

• Order Item ID and Product ID

• Order ID and Product ID

• Order ID and Order Item ID

Which dataset holds the payment information for orders?

• Suppliers

• Order Payments

• Order Reviews

• Order Items

How is the supplier identified in the order_items dataset?

• By Shipping Value

• By Supplier ID

• By Order ID

• By Product ID