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