Well done! We'll now discuss the
Products table stores information about products sold at the Northwind store. Each product has a unique
ProductID and a
ProductName. Each product is supplied by a single supplier (
SupplierID) and belongs to a single category (
CategoryID). Each product also has a certain
Discontinued column contains either a
0 (available in store) or a
1 (discontinued) that reflects the current availability of that product.
Products are organized into categories. The information about categories is stored in the
Categories table. Each category has a unique ID and a
CategoryName. There is also a short
Products table contains the
CategoryID column, you can join it with the
Categories table to get more information about the product's category (e.g., the category name).