exam
Tables (4)
BOOK INFORMATION
- Key (ISBN) — char(30) — Primary key — NOT NULL
- Field (bname) — char(30)
- Field (publication date) — date
- Field (author) — char(40)
- Field (category number) — char(30)
Untitled (PUBLISHING COMPANY)
- Key (pID) — char(30) — Primary key — NOT NULL
- Key (ISBN) — char(30) — Foreign key → BOOK INFORMATION.Key — NOT NULL
- Field (pname) — char(30)
- Field (paddress) — char(30)
Untitled (AUTHOR)
- Key (IDnumber) — char(40) — Primary key — NOT NULL
- Field (aname) — char(40)
- Field (aaddress) — char(40)
- Key (ISBN) — char(30) — Foreign key → BOOK INFORMATION.Key — NOT NULL
Untitled (TOPIC)
- Key (KDCnumber) — char(30) — Primary key — NOT NULL
- Key (ISBN) — char(30) — Foreign key → BOOK INFORMATION.Key — NOT NULL
- Field (keyword) — char(30)
- Field (relevant people) — char(30)
- Field (relevant event) — char(30)