ERD Excercise2
Tables (3)
CLASS (Untitled2)
- classNum (Key) — char(10) — Primary key — NOT NULL
- memberName (Key2) — char(10) — Foreign key → MEMBER.memberName — NOT NULL
- code (Field) — char(20)
- hour (Field2) — integer
- limit (Field3) — integer
- now (Field4) — integer
MEMBER (Untitled3)
- memberName (Key) — char(10) — Primary key — NOT NULL
- address (Field) — char(30)
- age (Field2) — integer
- level (Field3) — char(10)
SPORTS (Untitled)
- sportsType (Key) — char(20) — Primary key — NOT NULL
- classNum (Key2) — char(10) — Foreign key → CLASS.classNum — NOT NULL
- memberName (Key22) — char(10) — Foreign key → CLASS.memberName — NOT NULL
- sportsCode (Field) — char(10)
- sportsInform (Field2) — char(40)