One of the key facets of successful database design is to translate user requirements (i.e. the business objectives) into the underlying data structures such that the user requirements (expressed as queries as well as other activities) can be achieved. Your objective in this assignment is to list 5 questions that reflect the kinds of things the users of your Fuzzy Logic Radio Station database might ask. For each of these, provide the following:

1. The user requirement expressed as a question. For example, the accountant for Fuzzy might ask: "What are the payments (in $) for all Songs played by Radio Station Identifier or the month of January 2017?

2. How your data model supports this question. You need to be specific here. You can show the ERD components required to answer the question (i.e. show the parts of the model: Entity, Attributes, relations needed to answer the question). Alternatively, you can list the tables, fields, and relations needed to answer the question (assuming you have these created). Regardless of whether you describe this using your ERD or actual tables, you also need to describe the steps you would take to answer this questions pretending that you are the underlying database manager. For example, to answer the sample question posed:

[The following assumes I have an SONG table with SONG_ID as the PK and ROYALTY_ID as a FK, a ROYALTY table with ROYALTY_ID as the PK, and a PLAY_LOG table with STATIONID+TIMESTAMP as the PK and the MEDIA_ID (which is the SONG_ID for items in the log which are of MEDIA_TYPE="SONG")

a) I would look in the PLAY_LOG table for rows whose TIMESTAMP is between 1/1/2017 and 01/31/2017 and where MEDIA_TYPE="SONG".

b) For each of the rows identified by a), I would look in the SONG table using the SONG_ID and get the ROYALTY_ID (FK) for that song. I would then use the ROYALTY_ID to look in the ROAYLTY table to get the ROYALTY_AMOUNT associated with the playing of that song.

c) I would categorize (group by) the STATION_ID and add up (sum) the ROAYLTY_AMOUNT.