ERD exercise 2(20200909)
Tables (4)
CLASS (Untitled2)
- clNo (Key) — CHAR(4) — Primary key — NOT NULL
- time (Field) — time
- capacity (Field2) — int(4)
- currentPersonnel (Field3) — int(4)
- leCode (Key2) — CHAR(4) — Foreign key → LEPORTS.code — NOT NULL
LEPORTS (Untitled)
- code (Key) — CHAR(4) — Primary key — NOT NULL
- explanation (Field) — CHAR(50)
MEMBER (Untitled3)
- name (Key) — CHAR(10) — Primary key — NOT NULL
- address (Field) — CHAR(50)
- age (Field2) — int(4)
REGISTERFOR (Untitled4)
- clNo (Key) — CHAR(4) — Foreign key → CLASS.clNo — NOT NULL
- name (Key2) — CHAR(10) — Foreign key → MEMBER.name — NOT NULL
- level (Field) — CHAR(10)