과제

테이블 (6)

entity (Customer)

  • Primary Key (CustomerID) — 기본 키 — NOT NULL
  • column (CustomerName)
  • column (City)
  • column (Email)

entity (Order)

  • Primary Key (OrderID) — 기본 키 — NOT NULL
  • Foreign Key (CustomerID) — 외래 키 → entity.Primary Key — NOT NULL
  • column (OrderDate)

entity (OrderDetail)

  • Primary Key (OrderID) — 기본 키 — NOT NULL
  • Primary Key (ProductID) — 기본 키 — NOT NULL
  • column (Quantity)

entity (Product)

  • Primary Key (ProductID) — 기본 키 — NOT NULL
  • column (ProductName)
  • column (Size)
  • column (PricePerUnit)
  • column (UnitsInStock)
  • column (UnitsReceived)
  • column (UnitsSold)

entity (Supplier)

  • Primary Key (SupplierID) — 기본 키 — NOT NULL
  • column (SupplierName)
  • column (Country)

entity (Supplier Transaction)

  • Primary Key (ProductID) — 외래 키 → entity.Primary Key — NOT NULL
  • Primary Key (SupplierID) — 외래 키 → entity.Primary Key — NOT NULL
  • column (TransactionWeek)
  • column (TransactionQuantity)