TABLE 1: Direct and Indirect Table Relationships
Category Table Products Table Transactions Table
CategoryID (PK) ProductID TransactionID
(PK, IDENTITY) (PK, IDENTITY)
CategoryName CategoryID (FK) ProductID (FK)
ProductName CustomerID (FK)
Value