Table Products

Figure A.11. Schema for Table Products.

Index Name	Fields	Clustered	Primary Key
PK_Products	ProductID	Y	Y
CategoryID	CategoryID	N	N
ProductName	ProductName	N	N
SupplierID	SupplierID	N	N
SuppliersProducts	SupplierID	N	N

Foreign Key Name	Key Field	Related Table	Related Field
FK_Products_Categories	CategoryID	Categories	CategoryID
FK_Order_Details_Products	ProductID	Order Details	ProductID
FK_Products_Suppliers	SupplierID	Suppliers	SupplierID