연습문제 6,7

테이블 (10)

Author Info. (Untitled3)

  • AuthorId (Key) — char(10) — 기본 키 — NOT NULL
  • AuthorName (Field) — char(20)
  • AuthorAddress (Field2) — char(50)
  • ISBN (Key2) — char(20) — 외래 키 → Book info..ISBN — NOT NULL

Book info. (Untitled)

  • ISBN (Key) — char(20) — 기본 키 — NOT NULL
  • BookTitle (Field) — char(50)
  • PublishDate (Field2) — date
  • PublisherId (Field3) — char(20)

Contrat Info. (Untitled5)

  • ContractCode (Key) — char(10) — 기본 키 — NOT NULL
  • BookNumber (Field) — int
  • DeadlineDate (Field2) — date
  • capacityBookNumber (Field3) — int
  • PublisherId (Key2) — char(20) — 외래 키 → Publisher Info..PublisherId — NOT NULL

Loan Info. (Untitled10)

  • LoanCode (Key) — char(10) — 기본 키 — NOT NULL
  • LoanNumber (Field) — int
  • Payment amount (Field2) — int
  • ProjectCode (Key2) — char(10) — 외래 키 → Project Info..ProjectCode — NOT NULL

Printer Info. (Untitled4)

  • PrinterId (Key) — char(10) — 기본 키 — NOT NULL
  • PrinterName (Field) — char(20)
  • PrinterAddress (Field2) — char(50)
  • ContractCode (Key2) — char(10) — 외래 키 → Contrat Info..ContractCode — NOT NULL

Project Info. (Untitled6)

  • ProjectCode (Key) — char(10) — 기본 키 — NOT NULL
  • pmId (Field) — char(10)
  • pmId (Key2) — char(10) — 외래 키 → Project Manager Info..pmId — NOT NULL
  • SubcontractorCode (Key22) — char(10) — 외래 키 → Subcontractor Info..SubcontractorCode — NOT NULL

Project Manager Info. (Untitled7)

  • pmId (Key) — char(10) — 기본 키 — NOT NULL
  • pmName (Field) — char(20)
  • Field2
  • ProjectCode (Key2) — char(10) — 외래 키 → Project Info..ProjectCode — NOT NULL

Publisher Info. (Untitled2)

  • PublisherId (Key) — char(20) — 기본 키 — NOT NULL
  • PublishName (Field) — char(20)
  • PublisherAddress (Field2) — char(50)
  • ISBN (Key2) — char(20) — 외래 키 → Book info..ISBN — NOT NULL

Specialization Info. (Untitled9)

  • SpecializationCod (Key) — 기본 키 — NOT NULL
  • SubcontractorCode (Key2) — char(10) — 외래 키 → Subcontractor Info..SubcontractorCode — NOT NULL

Subcontractor Info. (Untitled8)

  • SubcontractorCode (Key2) — char(10) — 기본 키 — NOT NULL
  • ProjectCode (Key) — char(10) — 외래 키 → Project Info..ProjectCode — NOT NULL