BOOK
Tables (5)
Author (Untitled5)
- SSN (Key) — Char(10) — Primary key — NOT NULL
- aName (Field) — Char(10)
- aAdr (Field2) — Char(30)
- ISBN (Key2) — Char(10) — Foreign key → Book.ISBN — NOT NULL
Book (Untitled)
- ISBN (Key) — Char(10) — Primary key — NOT NULL
- bname (Field) — Char(25)
- bpubdate (Field2) — date
- pubID (Key2) — Char(10) — Foreign key → Publisher.ID — NOT NULL
Contract (Untitled4)
- ISBN (Key) — Char(10) — Foreign key → Book.ISBN — NOT NULL
- ID (Key2) — Char(10) — Foreign key → Printer.ID — NOT NULL
- numPrBook (Field) — int(6)
- dueDate (Field2) — date
Printer (Untitled3)
- ID (Key) — Char(10) — Primary key — NOT NULL
- prName (Field) — Char(10)
- prAdr (Field2) — Char(30)
- prLimit (Field3) — int(6)
Publisher (Untitled2)
- ID (Key) — Char(10) — Primary key — NOT NULL
- pubName (Field) — Char(10)
- pubAdr (Field2) — Char(30)