What changes are you trying to make? (e.g. Adding or removing code, refactoring existing code, adding reports)

I have created two entity-relationship diagrams that are saved both in the assignment-2 markdown file and as a separate pngs. I have also answered the prompt 3 in section 1 regarding changing dimensions in the markdown file. I have completed all of the SQL prompts in the assignment2.sql file which involved various manipulations of "farmersmarket.db". Finally, I have included a response to the article "Neural nets are just people all the way down" in the assignment-2 markdown file.

What did you learn from the changes you have made?

I learned how to perform intricate commands in SQL that allowed me to summarize data from various interconnected datasets in the form of database queries. I also learned how to modify existing datasets in the database.

Was there another approach you were thinking about making? If so, what approach(es) were you thinking of?

As with assignment 1, I found myself wondering how commands might be completed in R, but I continued with SQL as the assignment required

Were there any challenges? If so, what issue(s) did you face? How did you overcome it?

I found the string manipulation question in section 3 extremely challenging as we were asked to not include a general case statement. I overcame this through trial and error where I tried many different query options and through researching solutions online. Ultimately, I found the correct combination of commands that included a NULLIF statement.

How were these changes tested?

I tested all SQL commands on "farmersmarket.db" on my local computer.

A reference to a related issue in your repository (if applicable)

NA

Checklist

• I can confirm that my changes are working as intended