Cart design

Set up the shopping cart tables and write skeleton queries.

Cart table

In this project you will build a shopping cart table. The cart table holds customer and product info.

CREATE TABLE cart (
  id INT PRIMARY KEY,
  customer_id INT,
  product_id INT,
  qty INT
);

Id is the primary key; customer, product and quantity columns.

The table cart is created.

The cart table stores how many of each product a customer wants. Each row is one cart line.

Create cart with id INT PRIMARY KEY, customer_id INT, product_id INT, qty INT.

Show example solution

CREATE TABLE cart (
  id INT PRIMARY KEY,
  customer_id INT,
  product_id INT,
  qty INT
)

Create table

CREATE ____ cart (id INT PRIMARY KEY, qty INT);

Show answer

CREATE TABLE cart (id INT PRIMARY KEY, qty INT);