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)