Final Project

Tables (6)

CD (Untitled5)

  • CDNo (Key) — char(12) — Primary key — NOT NULL
  • Title (Field) — char(50)
  • expression (Field2) — char(8)
  • PubYear (Field3) — int(4)
  • workID (Key2) — int(30) — Foreign key → WORK.workID — NOT NULL
  • conductorID (Key3) — int(10) — Foreign key → CONDUCTOR.conductorID — NOT NULL

CONDUCTOR (Untitled3)

  • conductorID (Key) — int(10) — Primary key — NOT NULL
  • name (Field2) — char(30)
  • description (Field3) — text
  • nationality (Field4) — char(10)
  • majorWork (Field5) — text

MUSIC (Untitled)

  • MusicID (Key) — int(10) — Primary key — NOT NULL
  • Title (Field2) — char(50)
  • expression (Field3) — char(4)
  • description (Field4) — text
  • workID (Key2) — int(30) — Foreign key → WORK.workID — NOT NULL

MUSIC_PERSON (Untitled4)

  • role (Key) — char(10) — Primary key — NOT NULL
  • MusicID (Key2) — int(10) — Foreign key → MUSIC.MusicID — NOT NULL
  • conductorID (Key3) — int(10) — Foreign key → CONDUCTOR.conductorID — NOT NULL
  • PlayerID (Field2) — int(!0)

STUDENT (Untitled6)

  • StudentID (Key) — int(!0) — Primary key — NOT NULL
  • workID (Key2) — int(30) — Foreign key → WORK.workID — NOT NULL
  • name (Field) — char(20)
  • alternativeName (Field2) — char(30)
  • description (Field3) — text

WORK (Untitled2)

  • workID (Key) — int(30) — Primary key — NOT NULL
  • workTitle (Field2) — char(50)