MusicBrainz is an online database of information about recordings. The following is returned when I make...

  

  
 

Transcribed Image Text:

MusicBrainz is an online database of information about recordings. The following is returned when I make a request for https://musicbrainz.org/artist/0d79fe8e-ba27-4859-bb8c- 2f255f346853 with a special accept-type in the request header. @prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-nst>. @prefix schema: <http://schema.org/>. <http://musicbrainz.org/artist/0d79fe8e-ba27-4859-bb8c-21255£346853> schema: foundingDate "2013-06-13"schema: Date; schema: member [ schema:member <http://musicbrainz.org/artist/09720eec-\ 3871-49d5-932d-eb7542768cd3> ; [ schema:startDate "2013-06-13"schema: Date; rdf: type schema: OrganizationRole schema:member <http://musicbrainz.org/artist/23c8056b-\ ee13-4cfc-a772-2f5292e35bb5> ; .... schema: startDate "2013-06-13"^^schema: Date rdf:type schema: OrganizationRole 1. schema:name "BTS"; schema: sameAs <http://bts-official.jp/>. <http://musicbrainz.org/artist/23c8056b-ee13-4cfc-a772-215292e35bb5> schema:name "0; rdf: type schema:MusicGroup, schema: Person. <http://musicbrainz.org/artist/09720eec-3871-49d5-932d-eb7542768cd3> schema:name "JIN"; rdf:type schema:MusicGroup, schema: Person. <http://musicbrainz.org/artist/ee27b2d8-648c-4a9d-a68c-e55066959975> schema:name "Megan Thee Stallion" ; rdf:type schema:MusicGroup, schema: Person. <http://musicbrainz.org/release-group/0a2eb4c9-2bf1-4961-b74d-ff5684373978> schema:albumProductionType "http://schema.org/RemixAlbum"; schema:albumReleaseType "http://schema.org/SingleRelease"; schema:byArtist <http://musicbrainz.org/artist/0d79fe8e-ba27-4859-bb8c-2f255f346853> <http://musicbrainz.org/artist/ee27b2d8-648c-4a9d-a68c-e55066959975> schema:creditedTo "BTS feat. Megan Thee Stallion"; schema:name "Butter" 7 rdf: type schema:MusicAlbum. (a) What (approximately) was the type that we put into the accept header? (b) To indicate that someone is a member of a band in this model, the person is associated with a role using schema: member and then that role is associated with the group, also using schema: member. What is the full URL of the predicate schema: member? (c) How many band members of BTS are listed in this snippet? [1] [1] [1] EEE (d) Comment on the way the schema: member predicate is used in this context. [3] (e) What type(s) are associated with the entity with a schema: name of "JIN"? [1] (f) Consider the following SPARQL query SELECT ?a ?b WHERE ( mba:9fe8e-ba27-4859-bb8c-212551346853 schena:member ?c. ?c schema: startDate ?b; schema:member ?d. ?d schema:name ?a. E What prefixes need to be defined for this to work (give the full declarations)? [1] (g) What would the query return? (h) This data represents an export from a relational database. Construct an ER diagram providing a model that could [2] accommodate the instance data above. [6] (i) Give the CREATE TABLE commands for two tables based on your ER model. [4] (i) Suggest a MySQL query to check whether any band member in the database is recorded as joining before the founding date of their band. [5] UL23/0217 Page 6 of 9 (k) MusicBrainz make their data available as both a downloadable database dump and as Linked Data of the sort quoted above. What are the benefits and disadvantages of each approach? [5] MusicBrainz is an online database of information about recordings. The following is returned when I make a request for https://musicbrainz.org/artist/0d79fe8e-ba27-4859-bb8c- 2f255f346853 with a special accept-type in the request header. @prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-nst>. @prefix schema: <http://schema.org/>. <http://musicbrainz.org/artist/0d79fe8e-ba27-4859-bb8c-21255£346853> schema: foundingDate "2013-06-13"schema: Date; schema: member [ schema:member <http://musicbrainz.org/artist/09720eec-\ 3871-49d5-932d-eb7542768cd3> ; [ schema:startDate "2013-06-13"schema: Date; rdf: type schema: OrganizationRole schema:member <http://musicbrainz.org/artist/23c8056b-\ ee13-4cfc-a772-2f5292e35bb5> ; .... schema: startDate "2013-06-13"^^schema: Date rdf:type schema: OrganizationRole 1. schema:name "BTS"; schema: sameAs <http://bts-official.jp/>. <http://musicbrainz.org/artist/23c8056b-ee13-4cfc-a772-215292e35bb5> schema:name "0; rdf: type schema:MusicGroup, schema: Person. <http://musicbrainz.org/artist/09720eec-3871-49d5-932d-eb7542768cd3> schema:name "JIN"; rdf:type schema:MusicGroup, schema: Person. <http://musicbrainz.org/artist/ee27b2d8-648c-4a9d-a68c-e55066959975> schema:name "Megan Thee Stallion" ; rdf:type schema:MusicGroup, schema: Person. <http://musicbrainz.org/release-group/0a2eb4c9-2bf1-4961-b74d-ff5684373978> schema:albumProductionType "http://schema.org/RemixAlbum"; schema:albumReleaseType "http://schema.org/SingleRelease"; schema:byArtist <http://musicbrainz.org/artist/0d79fe8e-ba27-4859-bb8c-2f255f346853> <http://musicbrainz.org/artist/ee27b2d8-648c-4a9d-a68c-e55066959975> schema:creditedTo "BTS feat. Megan Thee Stallion"; schema:name "Butter" 7 rdf: type schema:MusicAlbum. (a) What (approximately) was the type that we put into the accept header? (b) To indicate that someone is a member of a band in this model, the person is associated with a role using schema: member and then that role is associated with the group, also using schema: member. What is the full URL of the predicate schema: member? (c) How many band members of BTS are listed in this snippet? [1] [1] [1] EEE (d) Comment on the way the schema: member predicate is used in this context. [3] (e) What type(s) are associated with the entity with a schema: name of "JIN"? [1] (f) Consider the following SPARQL query SELECT ?a ?b WHERE ( mba:9fe8e-ba27-4859-bb8c-212551346853 schena:member ?c. ?c schema: startDate ?b; schema:member ?d. ?d schema:name ?a. E What prefixes need to be defined for this to work (give the full declarations)? [1] (g) What would the query return? (h) This data represents an export from a relational database. Construct an ER diagram providing a model that could [2] accommodate the instance data above. [6] (i) Give the CREATE TABLE commands for two tables based on your ER model. [4] (i) Suggest a MySQL query to check whether any band member in the database is recorded as joining before the founding date of their band. [5] UL23/0217 Page 6 of 9 (k) MusicBrainz make their data available as both a downloadable database dump and as Linked Data of the sort quoted above. What are the benefits and disadvantages of each approach? [5]