aa

Tables (5)

AEROBIC (AEROBICS)

  • acode — CHAR(20) — Primary key — NOT NULL
  • aexplanation — CHAR(200)

CLASS (Untitled3)

  • ssn (Key) — CHAR(30) — Primary key — NOT NULL
  • classlevel (Field) — CHAR(10)
  • maximumnumber (Field2) — CHAR(10)
  • currentnumber (Field3) — CHAR(10)
  • activitycode (Field4) — CHAR(20)
  • acode — CHAR(20) — Foreign key → AEROBIC.acode — NOT NULL
  • ycode (Key2) — CHAR(20) — Foreign key → YOGA.ycode — NOT NULL
  • scode (Key3) — CHAR(20) — Foreign key → SWIMMING.scode — NOT NULL

MEMBER (Untitled4)

  • ssn (Key) — CHAR(20) — Primary key — NOT NULL
  • fname (Field) — CHAR(30)
  • minit (Field2) — CHAR(10)
  • lname (Field3) — CHAR(30)
  • address (Field4) — CHAR(100)
  • age (Field5) — CHAR(3)
  • ssn (Key2) — CHAR(30) — Foreign key → CLASS.ssn — NOT NULL

SWIMMING (Untitled2)

  • scode (Key) — CHAR(20) — Primary key — NOT NULL
  • sexplanation (Field) — CHAR(200)

YOGA (Untitled)

  • ycode (Key) — CHAR(20) — Primary key — NOT NULL
  • yexplanation (Field) — CHAR(200)