ERD Exercise 6
Tables (6)
Book (BOOK)
- Key (ISBN) — int(13) — Primary key — NOT NULL
- Field (Title) — char(50)
- Field (publication) — date
- Field (price) — int(10)
- Key (publisherID) — int(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (PUBLICHER)
- Key (publisherID) — int(10) — Primary key — NOT NULL
- Field (name) — char(15)
- Field (address) — char(50)
- Field (phone) — int(13)
Untitled (AUTHOR)
- Key (ssn) — int(13) — Primary key — NOT NULL
- Field (name) — char(10)
- Field (address) — char(50)
- Field (phone) — int(13)
Untitled (PRINTER)
- Key (printerID) — int(13) — Primary key — NOT NULL
- Field (printerName) — char(20)
- Field (address) — char(50)
- Field (phone) — int(13)
Untitled (CONTRACT)
- Key (contractID) — int(13) — Primary key — NOT NULL
- Field (amount) — int(6)
- Field (deadline) — date
- Key (printerID) — int(13) — Foreign key → Untitled.Key — NOT NULL
- Field (remitid) — int(10)
- Key (ISBN) — int(13) — Foreign key → Book.Key — NOT NULL
Untitled (BOOK_ITEM)
- Key (ISBN) — int(13) — Foreign key → Book.Key — NOT NULL
- Key (ssn) — int(13) — Foreign key → Untitled.Key — NOT NULL