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)