This is the data model for the Chinook Database, which supports a fictitious music e$-$commerce site that sells tracks. Each track is stored in a particular digital format and has an associated genre; many tracks may share the same genre, however. The site also supports playlists, where one single track can be part of multiple playlists but may not be included as part of any playlist. An artist may have created $1$ or more albums, but may not have created any. Each customer order is memorialized in an invoice which is composed of one or more InvoiceLines, each representing one track purchased. Note that the Quantity attribute of InvoiceLine indicates the number of copies of the particular track that was purchased as part of the associated invoice. Every customer is assigned an employee representative, and each employee is supervised by another employee. It is possible that an employee has no customers assigned to them. Since the CEO does not report to another employee, this is stored in the database as the CEO reporting to themselves.

Each arrow represents a foreign key$/$primary key relationship. The arrow points from the child relation to the parent relation.

Use the Chinook Data Model on the previous page to construct Relational Algebra queries for each of the following prompts. $[15$ points each$]$

$1\mathrm{.}1$ Management needs a list of the first names, last names, and email addresses of all customers from Massachusetts and Connecticut. You were told that the database stores the regular two character code for each state. $$

$1\mathrm{.}2$ We need to encourage artists to broaden their appeal by producing tracks in the $$Rock$$ genre. Provide a list of artist names whose tracks only fall in the $$Rock$$ genre. $$

$1\mathrm{.}3$ Chinook is pushing the use of playlists by having sales reps reach out to customers. Provide a list of the names and email addresses of all employees that represent customers who have purchased tracks that do not appear on any playlist. $($Note$,$ the customer may have also purchased tracks that appear on a playlist in addition to some that don$$t appear on a playlist$).$

$1\mathrm{.}4$ Provide a list of names, titles, and email addresses of the managers of any employee that represents a customer that has placed at least $1$ individual order with a total in excess of $$250\mathrm{.}00.$