ERD practice

Tables (4)

Branch Inventory (BI)

  • Key — Primary key — NOT NULL
  • FK (Key2) — Foreign key → Products.Key — NOT NULL
  • amounts (left)

Products

  • Key — Primary key — NOT NULL
  • FK (Key22) — Foreign key → Branch Inventory.FK — NOT NULL
  • Region (Field)
  • Branch_name (Field2)

Products (Untitled)

  • Key — Primary key — NOT NULL
  • Sort (Field)
  • name (Field2)

Test

  • Key — Primary key — NOT NULL