Record

Tables (11)

Musician (Musician)

  • MusicianID — VARCHAR(20) — Primary key — NOT NULL
  • Collaboration — VARCHAR(20) — Foreign key → MusicianSingCollaboration.Collaboration
  • Name — VARCHAR(20) — NOT NULL

Address

  • (Address) — VARCHAR(20) — Primary key — NOT NULL
  • MusicianID — VARCHAR(20) — Foreign key → Musician.MusicianID — NOT NULL
  • TelephoneNo — VARCHAR(20) — NOT NULL

Album

  • AlbumID — VARCHAR(20) — Primary key — NOT NULL
  • RegisteredDate — VARCHAR(20)
  • ISBN — VARCHAR(20)
  • Title — VARCHAR(20)

Instrument

  • InstrumentID — VARCHAR(20) — Primary key — NOT NULL
  • Type — VARCHAR(20)

InstrumentPitch

  • InstrumentID — VARCHAR(20) — Foreign key → Instrument.InstrumentID — NOT NULL
  • Pitch — VARCHAR(20) — Foreign key → Pitch.Pitch — NOT NULL

MakeSing

  • MusicianID — VARCHAR(20) — Foreign key → Musician.MusicianID — NOT NULL
  • SingID — VARCHAR(20) — Foreign key → Sing.SingID — NOT NULL
  • Collaboration — VARCHAR(20) — Foreign key → Musician.Collaboration — NOT NULL

MusicianSingCollaboration

  • Collaboration — VARCHAR(20) — Primary key — NOT NULL
  • SingID — VARCHAR(20) — Foreign key → Sing.SingID — NOT NULL

Pitch

  • Pitch — VARCHAR(20) — Primary key — NOT NULL

Play

  • MusicianID — VARCHAR(20) — Foreign key → Musician.MusicianID — NOT NULL
  • InstrumentID — VARCHAR(20) — Foreign key → Instrument.InstrumentID — NOT NULL

Producure

  • ProducureID — VARHCAR(20) — Primary key — NOT NULL
  • MusicianID — VARCHAR(20) — Foreign key → Musician.MusicianID — NOT NULL
  • AlbumID — VARCHAR(20) — Foreign key → Album.AlbumID — NOT NULL

Sing

  • SingID — VARCHAR(20) — Primary key — NOT NULL
  • AlbumID — VARCHAR(20) — Foreign key → Album.AlbumID — NOT NULL
  • Title — VARCHAR(20)
  • Actor — VARCHAR(20)