exercise6
Tables (5)
aurthor (Untitled3)
- au id (Key) — Primary key — NOT NULL
- name (Field)
- address (Field2)
book (Untitled)
- isbn (Key) — Primary key — NOT NULL
- id (Key2) — Foreign key → publisher.id — NOT NULL
- au id (Key3) — Foreign key → aurthor.au id — NOT NULL
- title (Field)
- publicationdate (Field2)
contract (Untitled5)
- prinid (Key) — Foreign key → printer.prinid — NOT NULL
- isbn (Key2) — Foreign key → book.isbn — NOT NULL
- id (Key22) — Foreign key → book.id — NOT NULL
- au id (Key3) — Foreign key → book.au id — NOT NULL
- booknumber (Field)
- deadline (Field2)
printer (Untitled4)
- prinid (Key) — Primary key — NOT NULL
- name (Field)
- address (Field2)
- booknumber (Field3)
- deadline (Field4)
publisher (Untitled2)
- id (Key) — Primary key — NOT NULL
- name (Field)
- address (Field2)