| Physical name | Product | P |
| Logical name | Catalogue of Products | |
| Attributes | 8 | |
| Description | This is a description of this entity. This entity contains all the products in our catalogue. | |
| PK | Physical name | Datatype | FK Ref. |
| ProductID | INT | |
| ProductName | NVARCHAR (40) | ||
| SupplierID | INT | Suppliers.SupplierID [FK_Products_Suppliers] | |
| CategoryID | INT | Categories.CategoryID [FK_Products_Categories] | |
| QuantityPerUnit | NVARCHAR (20) | ||
| UnitPrice | MONEY | ||
| UnitsInStock | SMALLINT | ||
| UnitsOnOrder | SMALLINT |
| Indexes | |||
| ixCategoryID | CategoryID | ASC | |
| ixProductName | ProductName | ASC | |
| ixSupplierID | SupplierID | ASC | |
| References | Referenced by |
|
Categories [FK_Products_Categories]
Suppliers [FK_Products_Suppliers] | Order Details [FK_OrdDet_Prod] |