Inventory design

Set up product and category tables and write skeleton queries.

Inventory table

In this project you will build an inventory system. First step is to create the inventory table.

CREATE TABLE inventory (
  id INT PRIMARY KEY,
  name VARCHAR(100),
  qty INT,
  location VARCHAR(50)
);

Table with id, name, qty and location columns.

The table inventory is created.

The inventory table holds product name, quantity and location. PRIMARY KEY makes id unique.

Create inventory with id INT PRIMARY KEY, name VARCHAR(100), qty INT, location VARCHAR(50).

Show example solution

CREATE TABLE inventory (
  id INT PRIMARY KEY,
  name VARCHAR(100),
  qty INT,
  location VARCHAR(50)
)

Create table

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

Show answer

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