SongKong

[paultaylor]

(30-04-2018 06:57)lyapounov Wrote:  

(27-04-2018 16:24)paultaylor Wrote:  

(27-04-2018 15:20)lyapounov Wrote:  Just a question for you : what is the album title of an opera ? the opera title, or the opera title by the conductor ? When discussing with friends, we always say "opera by xxx"

I would say the album title is the title as it is presented on the front cover/spine. For an Opera this would probably be the name of the Opera preceded by the composer e.g Bizet: Carmen, then the AlbumArtist would be the principal performers of the album, generally they would be credited on the front cover and would generally include conductor, soloists, orchestra e.g Georges Prêtre; Orchestre du théâtre national de l'opéra de Paris; Maria Callas.

Then the composer name is in the title. This is mandatory in the case of a symphony for example, where you need the composer's name, which is then redundant with the composer tag, and your database may not be normalized. And also, if you don't include the performer's name in the title, you will have many albums with the same title. And what about, as an example, Beethoven symphonies by Karajan ? You have 1951-1955, 1963 and 1977 recordings...

In a nutshell, nothing is obvious.

I'm sorry I don't really understand the logic, the composer name should usually be part of the album title because it is part of the album title, and there is some sense in always including it when missing it form actual album cover to normalize the data. It doesn't matter that there is already a separate composer field for the composer, the composer is in the album title simply because that is the album title. And remember there is a separate Work/Group field that can contain the work without additional information such as composer.

Yes you could have duplicate album titles, but the album artist will be different, so the combination will be different, have different years then the year field will be different.

Why do you require that the Album title has to be unique for each album ?