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: . @prefix schema: . schema: foundingDate "2013-06-13"schema: Date; schema: member [ schema:member ; [ schema:startDate "2013-06-13"schema: Date; rdf: type schema: OrganizationRole schema:member ; .... schema: startDate "2013-06-13"^^schema: Date rdf:type schema: OrganizationRole 1. schema:name "BTS"; schema: sameAs . schema:name "0; rdf: type schema:MusicGroup, schema: Person. schema:name "JIN"; rdf:type schema:MusicGroup, schema: Person. schema:name "Megan Thee Stallion" ; rdf:type schema:MusicGroup, schema: Person. schema:albumProductionType "http://schema.org/RemixAlbum"; schema:albumReleaseType "http://schema.org/SingleRelease"; schema:byArtist 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]