2023사서교육원_준사서C반_김종우_중간고사

테이블 (6)

Untitled (Book)

  • Key (Isbn) — char(30) — 기본 키 — NOT NULL
  • Field (Title) — char(30)
  • Field (PublishedDate) — date
  • Key (PublisherId) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Field (WriterName) — char(30) — 외래 키 → Untitled.Field
  • Key (KDCNumber) — char(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Publisher)

  • Key (PublisherId) — char(30) — 기본 키 — NOT NULL
  • Field (PublisherName) — char(30)
  • Field (PublisherAddress) — char

Untitled (Writer)

  • Field (WriterName) — char(30) — 기본 키
  • Field (FamousWork) — char(30)
  • Field (TheNumberOfWriter) — int
  • Field (CoWriter) — char(30)

Untitled (PrintingOffice)

  • Key (PrintingOfficeId) — char(30) — 기본 키 — NOT NULL
  • Field (PrintingOfficeName) — char(30)
  • Field (PrintngOfficeAddress) — char(30)

Untitled (ContractInformation)

  • Key (PublisherId) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (PrintingOfficeId) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Field (TheNumberOfBooks) — int
  • Field (Deadline) — date
  • Field (LimitOnTheNumberOfPrinting) — int

Untitled (Subject)

  • Key (KDCNumber) — char(30) — 기본 키 — NOT NULL
  • Field (subjectName) — char(30)