ERD Excercise6

Tables (4)

Authors (Untitled3)

  • SecurityNumber (Key) — char(13) — Primary key — NOT NULL
  • Name (Field) — char(30)
  • Adress (Field2) — char(100)
  • ISBN (Key2) — char(13) — Foreign key → Books.ISBN — NOT NULL
  • Title (Field3) — char(30) — Foreign key → Books.Title

Books (Untitled)

  • ISBN (Key) — char(13) — Primary key — NOT NULL
  • Title (Field) — char(30) — Primary key
  • SubTitle (Key2) — char(50) — Primary key — NOT NULL
  • PublicationDate (Field2) — char(8)

Printer (Untitled4)

  • ID (Key) — char(5) — Primary key — NOT NULL
  • Name (Field) — char(10)
  • Adress (Field2) — char(100)
  • NumberOfBooks (Field3) — char(6)
  • PrintingDeadline (Field4) — char(8)
  • ISBN (Key2) — char(13) — Foreign key → Books.ISBN — NOT NULL
  • Title (Field5) — char(30) — Foreign key → Books.Title

Publisher (Untitled2)

  • Id (Key) — char(5) — Primary key — NOT NULL
  • Name (Field) — char(20)
  • Adress (Field2) — char(100)
  • ISBN (Key2) — char(13) — Foreign key → Books.ISBN — NOT NULL
  • Title (Field3) — char(30) — Foreign key → Books.Title