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)