home / study / engineering / computer science / computer science questions and answers / consider the following 5 relations of a database: songs (title, year, length, genre, studioname, ...

Question: Consider the following 5 relations of a database: Songs (title, year, length, genre, studioName, ...

Consider the following 5 relations of a database:

Songs (title, year, length, genre, studioName, producerC#)

Singers (songTitle, songYear, singerName )

SongSinger (name, address, gender, birthdate)

SongExec (name, cert#, address, networth)Studio (name, address, presC#)

Find the SQL queries for:

1. Find the names of producers of songs that "Taylor Swift" sang, and for each producer, output the producer name and the number of "Taylor Swift" songs produced by the producer.