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)