music
Tables (5)
CLASS (Untitled2)
- classID (Key) — char(10) — Primary key — NOT NULL
- classname (Field) — char(20)
- classdescription (Field2) — char(200)
- library (Key2) — char(10) — Foreign key → SINWOLLIBRARY.library — NOT NULL
ENROLL (Untitled5)
- EID (Key) — char(10) — Primary key — NOT NULL
- benefit (Field) — char(2)
- classID (Key2) — char(10) — Foreign key → CLASS.classID — NOT NULL
- memberID (Key3) — char(10) — Foreign key → LIBRARYMEMBER.memberID — NOT NULL
LIBRARYMEMBER (Untitled3)
- memberID (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(20)
- address (Field2) — char(100)
- age (Field3) — char(2)
- gender (Field4) — char(2)
- dateofbirth (Field5) — char(4)
- volunteerhours (Field6) — char(3)
- SID (Key2) — char(10) — Foreign key → SCHOOLMEMBER.SID — NOT NULL
SCHOOLMEMBER (Untitled4)
- SID (Key) — char(10) — Primary key — NOT NULL
- schoolname (Field) — char(20)
- schooladdress (Field2) — char(100)
SINWOLLIBRARY (Untitled)
- library (Key) — char(10) — Primary key — NOT NULL
- laddress (Field) — char(100)
- lphonenumber (Field2) — char(11)