Consider the following database of a music record company: MUSICIAN(ID, Name, Surname, BirthYear, DeathYear, Nationality, Instrument) BAND(BandID, Name, BreakupYear) MEMBER(MusicianID, BandID, JoinYear) SONG(SongID, Title, Duration, BandID, Duration) ALBUM(AlbumID, BandID, Title, Year, Genre) INCLUDED(SongID, AlbumID) NOTE: ● If a musician is still alive, then MUSICIAN.DeathYear = 0 ● If the band is still playing together, then BAND.BreakupYear = 0 ● A musician can be part of more than a band. ● Song duration is expressed in seconds. 1a) Find the data of all bands with at least a Cello player, who published an album of the genre “ProgRock” after 1982, where at least a song of duration 15 minutes is included. 1b) Find the data of all musicians that were founding members of a band, that is, no other musician joined the same band in a previous year.
Consider the following
MUSICIAN(ID, Name, Surname, BirthYear, DeathYear, Nationality, Instrument) BAND(BandID, Name, BreakupYear)
MEMBER(MusicianID, BandID, JoinYear)
SONG(SongID, Title, Duration, BandID, Duration)
ALBUM(AlbumID, BandID, Title, Year, Genre) INCLUDED(SongID, AlbumID)
NOTE:
● If a musician is still alive, then MUSICIAN.DeathYear = 0
● If the band is still playing together, then BAND.BreakupYear = 0
● A musician can be part of more than a band.
● Song duration is expressed in seconds.
1a) Find the data of all bands with at least a Cello player, who published an album of the genre “ProgRock” after 1982, where at least a song of duration 15 minutes is included.
1b) Find the data of all musicians that were founding members of a band, that is, no other musician joined the same band in a previous year.
Step by step
Solved in 4 steps