I’m new to DB programming and musicbrainz.
I’m currently working on a DB workshop project, the project theme is music, and we are making a reverse akinator program in which the computer gives you hint regarding a certain entity (musician/band/composer) and the user supposed to guess who is it in as less hint as possible.
I’ve got few problems: one is transferring musicbrainz into mysql format, but I think I have this under control, my two main problems are I would love to have a rating field for each entity/song/album (I want to filter unpopular ones) but from what I read, the rating tables are not available in the dump files for some reason, and I don’t see in the schema where are the meta tables?
another problem that I have is that I would also really love to have some personal information about my entities such as parent/child/student of, and so on, such information is available on the search that the website has, but I don’t see such relationships in the musicbrainz schema.
Would really love some help.