Exercise6
Tables (5)
Author (Untitled4)
- SSN (Key) — char(30) — Primary key — NOT NULL
- name (Field) — char(30)
- address (Field2) — char(30)
- Field3
Book (Untitled)
- ISBN (Key) — char(20) — Primary key — NOT NULL
- Title (Field) — char(30)
- publication date (Field2) — date
- SSN (Key2) — char(30) — Foreign key → Author.SSN — NOT NULL
- ID (Key3) — char(30) — Foreign key → Printer.ID — NOT NULL
Contract (Untitled2)
- print (Key) — char(30) — Primary key — NOT NULL
- deadline (Field) — date
- ID (Key2) — char(30) — Foreign key → Printer.ID — NOT NULL
Printer (Untitled5)
- ID (Key) — char(30) — Primary key — NOT NULL
- Name (Field) — char(30)
- address (Field2) — char(30)
Publisher (Untitled3)
- ID (Key) — charj(30) — Primary key — NOT NULL
- name (Field) — char(30)
- address (Field2) — char(30)
- ISBN (Key2) — char(20) — Foreign key → Book.ISBN — NOT NULL