Final_Project

Tables (4)

Untitled (MY_BOOK_COLLECTION)

  • Key (ISBN) — int(15) — Primary key — NOT NULL
  • Field (title) — char(50)
  • Field2 (price) — int(10)
  • Field3 (pubYear) — data
  • Field4 (My_Purchase_Year) — data
  • Key (PubID) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (PUBLISHER)

  • Key (PubID) — char(10) — Primary key — NOT NULL
  • Field (pubName) — char(20)
  • Field2 (adress) — char(50)
  • Field3 (Phone&Fax) — int(13)

Untitled (BOOK_AUTHOR)

  • Key (authorID) — char(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (ISBN) — int(15) — Foreign key → Untitled.Key — NOT NULL

Untitled (AUTHOR)

  • Key (authorID) — char(20) — Primary key — NOT NULL
  • Field (authorName) — char(30)