Musician

idNameGenreInstrumentYearOfBirth
1John DoeCountry SingerGuitar1980
2Jane SmithCountry SingerPiano1975
3Tom BrownBluegrass SingerGuitar1965
4Ann WhiteBluegrass SingerViolin1982
5Rock StarRockerGuitar1990
6Pop QueenPop StarVocals1993

Album

idTitleReleaseYearArtistId
(→ Musician.id)
1Debut20101
2Second Act20152

Song

idTitleDurationAlbumId
(→ Album.id)
1First Single03:301
2Second Track04:002

Concert

idDateVenueHeadlinerId
(→ Musician.id)
12022-06-10Stadium A1
22022-07-15Arena B3

Fan

idFirstNameLastNameEmail
1Fan1Lastname1fan1@email.com
2Fan2Lastname2fan2@email.com

Purchase

idAmountMoneyConcertIdFanId
(→ Concert.id)(→ Fan.id)
1100.011
2150.022