report#1

Tables (5)

J (Untitled)

  • J# (Key) — VARCHAR2(4) — Primary key — NOT NULL
  • JNAME (Field) — VARCHAR2(10)
  • CITY (Field2) — VARCHAR2(6)

P

  • P# (S#) — VARCHAR2(4) — Primary key — NOT NULL
  • PNAME (Field) — VARCHAR2(10)
  • COLOR (Field2) — VARCHAR2(6)
  • WEIGHT (Field3) — NUMBER
  • CITY (Field4) — VARCHAR2(6)

S

  • S# — VARCHAR2(4) — Primary key — NOT NULL
  • SNAME (Field) — VARCHAR2(10)
  • STATUS (Field2) — NUMBER
  • CITY (Field3) — VARCHAR2(6)

SP (Untitled2)

  • S# (Key) — VARCHAR2(4) — Primary key — NOT NULL
  • P# (Key2) — VARCHAR2(4) — Primary key — NOT NULL
  • QTY (Field) — NUMBER

SPJ (Untitled3)

  • S# (Key) — VARCHAR2(4) — Primary key — NOT NULL
  • P# (Key2) — VARCHAR2(4) — Primary key — NOT NULL
  • J# (Key3) — VARCHAR2(4) — Primary key — NOT NULL
  • QTY (Field) — NUMBER