과제
테이블 (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)