0415

Tables (3)

Untitled (Book)

  • Key (bookid) — NUMBER — Primary key — NOT NULL
  • Field (bookname) — VARCHAR2(100) — NOT NULL
  • Field (publisher) — VARCHAT2(100) — NOT NULL
  • Field (pricen) — NUMBER — NOT NULL

Untitled (Customer)

  • Key (custid) — NUMBER — Primary key — NOT NULL
  • Field (name) — VARCHAR(100) — NOT NULL
  • Field (address) — VARCHAR2(100) — NOT NULL
  • Field (phone) — VARCHAR2(100)

Untitled (Orders)

  • Key (orderidN) — NUMBER — Primary key — NOT NULL
  • Key (custid) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (bookid) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (salepriceN) — NUMBER — NOT NULL
  • Field (orderdate) — DATE — NOT NULL