기말과제

테이블 (3)

author (Untitled)

  • authorName (Field) — char(30) — 기본 키
  • authorName (Field5) — char(30) — 외래 키 → title.authorName
  • authorName (Field6) — char(30) — 외래 키 → title.authorName
  • birthday (Field2) — date
  • address (Field3) — char(40)
  • title (Field4) — char(50)
  • authorName (Field42) — char(30) — 외래 키 → subject.authorName
  • authorName (Field52) — char(30) — 외래 키 → subject.authorName
  • authorName (Field422) — char(30) — 외래 키 → subject.authorName
  • authorName (Field62) — char(30) — 외래 키 → subject.authorName

subject (Untitled3)

  • authorName (Field4) — char(30) — 기본 키
  • authorName (Field5) — char(30) — 외래 키 → title.authorName
  • authorName (Field42) — char(30) — 외래 키 → title.authorName
  • authorName (Field6) — char(30) — 외래 키 → title.authorName
  • classSign (Field) — int(11)
  • KDC (Field2) — char(30)
  • title (Field3) — char(30)
  • authorName (Field7) — char(30) — 외래 키 → author.authorName
  • authorName (Field52) — char(30) — 외래 키 → author.authorName
  • authorName (Field62) — char(30) — 외래 키 → author.authorName

title (Untitled2)

  • authorName (Field) — char(30) — 기본 키
  • authorName (Field42) — char(30) — 외래 키 → subject.authorName
  • authorName (Field6) — char(30) — 외래 키 → author.authorName
  • pubDate (Field2) — date
  • publisher (Field3) — char(30)
  • classSign (Field4) — int(10)
  • subject (Field5) — char(30)