final
Tables (3)
Author (Untitled2)
- name (Key) — char(15) — Primary key — NOT NULL
- ISBN (Key2) — int(13) — Foreign key → Book.ISBN — NOT NULL
- majorWork (Field) — char(30)
Book (Untitled)
- ISBN (Key) — int(13) — Primary key — NOT NULL
- id (Key2) — char(10) — Foreign key → Publisher.id — NOT NULL
- name (Key3) — char(15) — Foreign key → Author.name — NOT NULL
- bookTitle (Field) — char(20)
- bookNo (Field3) — int(9)
- publishDate (Field2) — int(8)
Publisher (Untitled3)
- id (Key) — char(10) — Primary key — NOT NULL
- ISBN (Key2) — int(13) — Foreign key → Book.ISBN — NOT NULL
- address (Field) — char(10)
- Field2