exe6

Tables (6)

Author (Untitled3)

  • author ID (Key) — int — Primary key — NOT NULL
  • author No (Field) — char(50)
  • author name (Field2) — char(30)
  • author add (Field3) — char(30)

Book (Untitled)

  • ISBN (Key) — int — Primary key — NOT NULL
  • title (Field) — char(30)
  • publish date (Field2) — date
  • publisher (Field3) — char(30)

Book author (Untitled6)

  • book ID (Key) — int — Primary key — NOT NULL
  • Author ID (Field) — char(30)
  • author ID (Key2) — int — Foreign key → Author.author ID — NOT NULL

Contract (Untitled5)

  • print No (Key) — int — Primary key — NOT NULL
  • printing deadline date (Field) — date
  • publisher ID (Key2) — int — Foreign key → Publisher.publisher ID — NOT NULL

Printer (Untitled4)

  • printer ID (Key) — int — Primary key — NOT NULL
  • printer name (Field) — char(20)
  • printer add (Field2) — char(20)
  • ISBN (Key2) — int — Foreign key → Book.ISBN — NOT NULL
  • print No (Key4) — int — Foreign key → Contract.print No — NOT NULL
  • publisher ID (Key3) — int — Foreign key → Publisher.publisher ID — NOT NULL

Publisher (Untitled2)

  • publisher ID (Key) — int — Primary key — NOT NULL
  • publisher name (Field) — char(50)
  • publisher add (Field2) — char(30)
  • ISBN (Key2) — int — Foreign key → Book.ISBN — NOT NULL
  • author ID (Key3) — itn — Foreign key → Author.author ID — NOT NULL