2024_04_ERD Exercise 2
Tables (5)
Untitled (ACTIVETY)
- Key (actcode) — char(5) — Primary key — NOT NULL
- Field (aceName) — char(30)
- Field — text
Untitled (CLASS)
- Key (classID) — char(10) — Primary key — NOT NULL
- Field (className) — char(20)
- Field (time) — char(30)
- Field (maxRegi) — int(3)
- Field (lever) — int(4)
- Key (actcode) — char(5) — Foreign key → Untitled.Key — NOT NULL
- Key (lecID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Field (memID) — char(10) — Foreign key → Untitled.Field
- Key (memName) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (MEMBER)
- Field (memID) — char(10) — Primary key
- Key (memName) — char(10) — Primary key — NOT NULL
- Field (birthDate) — date
- Field (address) — char(30)
- Field (phone) — char(12)
- Field (email) — email
Untitled (ENROLE)
- Key (classID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Field (memID) — char(10) — Foreign key → Untitled.Field
- Key (memName) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (LECTURER)
- Key (lecID) — char(10) — Primary key — NOT NULL
- Field (lecname) — char(20)
- Field (address) — char(50)
- Field (phone)