erd 중간과제

테이블 (8)

Book

  • Key (ISBN) — char(20) — 기본 키 — NOT NULL
  • Field (Title) — char(20)
  • Field (PubDate) — date

Untitled (Publisher)

  • Key (PublisherID) — char(20) — 기본 키 — NOT NULL
  • Field (Name) — char(20)
  • Field (Address) — char(15)

Untitled (Author)

  • Key (AuthorID) — char(20) — 기본 키 — NOT NULL
  • Field (Name) — char(20)
  • Field (Address) — char(20)

Untitled (Subject)

  • Key (KDC) — char(20) — 기본 키 — NOT NULL
  • Key (ISBN) — char(20) — 외래 키 → Book.Key — NOT NULL
  • Field (Subject) — char(20)

Untitled (User)

  • Key (UserID) — char(20) — 기본 키 — NOT NULL
  • Field (Name) — char(20)
  • Field (Address) — char(20)
  • Field (Phone Number) — char(20)
  • Field (Email) — char(20)

Untitled (Loan)

  • Key (LoanID) — char(20) — 기본 키 — NOT NULL
  • Field (UserID) — char(20)
  • Field (ISBN) — char(20)
  • Field (LoanDate) — date
  • Field (ReturnDate) — date
  • Key (UserID2) — char(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (ISBN2) — char(20) — 외래 키 → Book.Key — NOT NULL

Untitled (Publication)

  • Key (PublisherID) — char(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (ISBN) — char(20) — 외래 키 → Book.Key — NOT NULL

Untitled (Several authors)

  • Key (AuthorID) — char(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (ISBN) — char(20) — 외래 키 → Book.Key — NOT NULL