MyDB_04

Tables (11)

Album

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

Collaborate making

  • CollaborationID — INTEGER — Primary key — NOT NULL
  • MusicID — INTEGER — Foreign key → Music.MusicID — NOT NULL
  • MusicianID — INTEGER — Foreign key → Music.MusicianID — NOT NULL

Instrument

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

Instrument_Pitch

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

Make Music

  • MusicianID — INTEGER — Foreign key → Musician.MusicianID — NOT NULL
  • MusicID — INTEGER — Foreign key → Music.MusicID — NOT NULL

Music

  • MusicID — INTEGER — Primary key — NOT NULL
  • AlbumID — INTEGER — Foreign key → Album.AlbumID — NOT NULL
  • MusicianID — INTEGER — Foreign key → Producer.MusicianID — NOT NULL
  • Name — VARCHAR(20)
  • Author — VARCHAR(20)

Musician

  • MusicianID — INTEGER — Primary key — NOT NULL
  • CollaborationID — INTEGER — Foreign key → Collaborate making.CollaborationID
  • Name — VARCHAR(20)

Musician_Address

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

Pitch (Untitled12)

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

Play

  • MusicianID — INTEGER — Foreign key → Musician.MusicianID — NOT NULL
  • InstrumentID — INTEGER — Foreign key → Instrument.InstrumentID — NOT NULL

Producer

  • ProducerID — INTEGER — Primary key — NOT NULL
  • AlbumID — INTEGER — Foreign key → Album.AlbumID — NOT NULL
  • MusicianID — INTEGER — Foreign key → Musician.MusicianID — NOT NULL