ERD Exercise 6
Tables (5)
Untitled (book)
- Key (isbn) — Char(13) — Primary key — NOT NULL
- Field (title) — Char
- Field (publicationDate) — Date
- Key (author(ssn)) — Char — Foreign key → Untitled.Key — NOT NULL
- Key (publisherID) — Char — Foreign key → Untitled.Key — NOT NULL
Untitled (publisher)
- Key (publisherID) — Char — Primary key — NOT NULL
- Field (name) — Char
- Field (address) — Char
Untitled (author)
- Key (ssn) — Char — Primary key — NOT NULL
- Field (name) — Char
- Field (address) — Char
Untitled (printer)
- Key (printerID) — Char — Primary key — NOT NULL
- Field (name) — Char
- Field (address) — Char
Untitled (printer_contract)
- Key (printerID) — Char — Foreign key → Untitled.Key — NOT NULL
- Key (isbn) — Char(13) — Foreign key → Untitled.Key — NOT NULL
- Field (quantity) — Int
- Field (endDate) — Date