준사서A -2학기 중간고사

테이블 (5)

Untitled (BOOK)

  • Key (ISBN) — 기본 키 — NOT NULL
  • Field (Title)
  • Field (ReieaseDate)
  • Field (Publisher)
  • Field (KDC)

Untitled2 (PUBLISHER)

  • Key (ID) — 기본 키 — NOT NULL
  • Field (CompanyName)
  • Field (Address)
  • Field (Tel.)
  • Key (ISBN) — 외래 키 → Untitled.Key — NOT NULL

Untitled3 (WRITER)

  • Key (Name) — 기본 키 — NOT NULL
  • Field (Address)
  • Field (Tel)
  • Field (work)
  • Key (ISBN) — 외래 키 → Untitled.Key — NOT NULL

Untitled4 (PRINTING HOUSE)

  • Key (ID) — 기본 키 — NOT NULL
  • Field (CompanyNameField)
  • Field2 (Address)
  • Field2 (Tel.)

Untitled5 (CONTRACT)

  • Key (Quantity) — 기본 키 — NOT NULL
  • Field (ClosingDate)
  • Key (ID) — 외래 키 → Untitled4.Key — NOT NULL
  • Key (ID2) — 외래 키 → Untitled2.Key — NOT NULL