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

Added answers to assignment 2.

What did you learn from the changes you have made?

I learned a lot of new SQL things, such as more complicated joins and updating and creating new tables. I also got to think more deeply about ethics in AI and databases.

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

I thought to do some things in excel again, but ended up just figuring it out in SQL. I also am not the biggest fan of joins and thought to use multiple temp tables instead of them.

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

The biggest challenge was the cross join and the update function in the last question. For the cross join I did the all temp table way, then I found somewhere I could put the cross join in. For the update function, I had to do a lot of google searches. For most other questions the live code was really helpful and the slides were a little helpful.

How were these changes tested?

Tested by running in sql and cross referencing by hand if possible.

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

n/a

Checklist

• I can confirm that my changes are working as intended