2023.3.29.ERD Exercise6
Tables (5)
AUTHOR_AUTHORS (Untitled3)
- Ssn (Key) — char(13) — Primary key — NOT NULL
- Name (Field) — char(30)
- Address (Field2) — char(50)
- Description (Field3) — text
BOOK (Untitled)
- bookISBN (Key) — char(13) — Primary key — NOT NULL
- priID (Key4) — char(13) — Foreign key → PRINTER.priID — NOT NULL
- Ssn (Key3) — char(13) — Foreign key → AUTHOR_AUTHORS.Ssn — NOT NULL
- publisherId (Key2) — char(13) — Foreign key → BOOK'S PUBLISHER.publisherId — NOT NULL
- Title (Field) — text
- publication Date (Field2) — date
- Description (Field3) — text
BOOK'S PUBLISHER (Untitled2)
- publisherId (Key) — char(13) — Primary key — NOT NULL
- Name (Field) — char(20)
- Address (Field2) — char(50)
- Description (Field3) — text
- priID (Key2) — char(13) — Foreign key → PRINTER.priID — NOT NULL
CONTRACTINFOM (Untitled7)
PRINTER (Untitled6)
- priID (Key) — char(13) — Primary key — NOT NULL
- Name (Field) — char(20)
- Address (Field3) — char(50)
- Description (Field2) — text
- publisherId (Key2) — char(13) — Foreign key → BOOK'S PUBLISHER.publisherId — NOT NULL