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)