UofT-DSI | SQL - Assignment 1

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

I have added one ERD of the product and customer purchases tables from the farmers market database. I have added SQL queries to the assignment sql file to retrieve database information and display them in various way. Finally, I have added a written response to section 4 of the assignment md file, reflecting on how databases can cause friction for various individuals in real life.

What did you learn from the changes you have made?

I have learned to use SELECT statements to retrieve information from databases, with clauses like WHERE, LIMIT, and GROUP BY to filter and organize the results that are returned. I have also learned to use JOIN queries to combine tables based on matching criteria, and can make temp tables. On the whole, the assignment has familiarized me with basic SQL operations and has furnished me with some foundational understanding of how databases work.

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

I'm not entirely sure how else to engage with databases, so I simply followed the instructions and made the changes according to suggestions/hints in each section

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

On the whole, building SQL queries has been challenging, and once I moved past the 'easiest' questions (the initial ones), I wasn't sure where to start with the more complex questions. Eventually though, I established a pattern of starting with "SELECT" and "FROM" and writing out all the statements/clauses I know I will need, and I started filling out the query part by part. This helped me overcome the sense of paralysis I got when faced with a more "difficult" question.

How were these changes tested?

I ran each query to make sure no errors occurred. Then I manually checked the each output to ensure that requirements were met. For some questions, such as the one about customers spending more than $2000, I changed the conditions a few times (e.g. < 2000, < 500 etc.) to double check that the code was working properly and returning exactly what I wanted it to.

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

Checklist

• I can confirm that my changes are working as intended