2023_SLI_EX6
Tables (6)
BOOK
- ISBN — char(30) — Primary key — NOT NULL
- Key (pubID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- title — char(50)
- Field2 (publicationDate) — date
Untitled (PUBLISHING HOUSE)
- Key (pubID) — char(10) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (address) — char(50)
Untitled (ENROLL)
- Key (publisher ID) — char(30) — Foreign key → Untitled2.Key — NOT NULL
- ISBN — char(30) — Foreign key → BOOK.ISBN — NOT NULL
- Key (pubID) — char(10) — Foreign key → BOOK.Key — NOT NULL
Untitled (CONTRACT)
- Key (contratID) — char(10) — Primary key — NOT NULL
- Field (number of books) — int(10000)
- Field (print Deadline) — date
- ISBN — char(30) — Foreign key → BOOK.ISBN — NOT NULL
- Key (pubID) — char(10) — Foreign key → BOOK.Key — NOT NULL
- Key (bookpinterID) — char(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (BOOK PRINTER)
- Key (bookpinterID) — char(20) — Primary key — NOT NULL
- Field (title) — char(20)
- Field (address) — char(50)
Untitled2 (PUBLISHER)
- Key (publisher ID) — char(30) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (address) — char(50)