TEST
Tables (3)
BOOK
- Key (bookid) — Number — Primary key — NOT NULL
- Field (bookname) — VARCHAR(100) — NOT NULL
- Field (publisher) — VARCHAR(100) — NOT NULL
- Field (price) — NUMBER — NOT NULL
Untitled (CUSTOMER)
- Key (custid) — NUMBER — Primary key — NOT NULL
- Field (name) — VARCHAR(100) — NOT NULL
- Field (address) — VARCHAR(100) — NOT NULL
- Field (phone) — VARCHAR(100)
Untitled (ORDERS)
- Key (orderid) — NUMBER — Primary key — NOT NULL
- Key (custid) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (bookid) — Number — Foreign key → BOOK.Key — NOT NULL
- Field (saleprice) — NUMBER — NOT NULL
- Field (orderdate) — DATE — NOT NULL