Physical name  Product  P
Logical nameCatalogue of Products
Attributes8
DescriptionThis is a description of this entity. This entity contains all the products in our catalogue.

PKPhysical nameDatatypeFK Ref.
ProductIDINT 
 ProductNameNVARCHAR (40) 
 SupplierIDINTSuppliers.SupplierID [FK_Products_Suppliers]
 CategoryIDINTCategories.CategoryID [FK_Products_Categories]
 QuantityPerUnitNVARCHAR (20) 
 UnitPriceMONEY 
 UnitsInStockSMALLINT 
 UnitsOnOrderSMALLINT 

Indexes
ixCategoryID CategoryIDASC
ixProductName ProductNameASC
ixSupplierID SupplierIDASC

ReferencesReferenced by
Categories [FK_Products_Categories]
Suppliers [FK_Products_Suppliers]  
Order Details [FK_OrdDet_Prod]