sql btcamp hw 6

Tables (7)

AUTHOR (Untitled4)

  • SSN (Key) — Primary key — NOT NULL
  • authorName (Field)
  • authorAddress (Field2)

BOOK (Untitled2)

  • ISBN (Key) — Primary key — NOT NULL
  • publisherID (Key2) — Foreign key → PUBLISHER.publisherID — NOT NULL
  • bookName (Field)
  • pusblishDate (Field2)

BOOK_WRITE (Untitled3)

  • ISBN (Key) — Foreign key → BOOK.ISBN — NOT NULL
  • publisherID (Key2) — Foreign key → BOOK.publisherID — NOT NULL
  • SSN (Key3) — Foreign key → AUTHOR.SSN — NOT NULL

CONTRACT (Untitled5)

  • duedate (Field)
  • numberOfBooks (Field2)
  • phID (ID) — Foreign key → PRINTINGHOUSE.phID — NOT NULL
  • ISBN (Key) — Foreign key → BOOK.ISBN — NOT NULL
  • publisherID (Key2) — Foreign key → BOOK.publisherID — NOT NULL

PRINTINGHOUSE (Untitled7)

  • phID (ID) — Primary key — NOT NULL
  • phName (Field)
  • phAdress (Field2)

PUBLISHER (Untitled)

  • publisherID (Key) — Primary key — NOT NULL
  • publisherName (Field)
  • publisherAddress (Field2)

TAG (Untitled6)

  • tagID (Key) — Primary key — NOT NULL
  • description (Field)
  • ISBN (Key2) — Foreign key → BOOK.ISBN — NOT NULL
  • publisherID (Key22) — Foreign key → BOOK.publisherID — NOT NULL