…1.md

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

Homework 1: I drew a diagram of a partial logical model for the Farmers Market db and embedded the JPG picture in homework_1.md.
Homework 2: I wrote sql command lines as required using the functions.

What did you learn from the changes you have made?

Homework 1: I learned to check data table structures in a database and find the linking column between two connected tables.
Homework 2: I learned how to use basic functions to retrieve data from table(s)

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

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

Homework 1: The challenge was to figure out how to view data tables in the SQLite interface and understand that some tables have primary keys and some do not.
Homework 2: Yes, the challenge was to getting familiar with the rules of sql commands which are different from Python. Way to overcome: practice and test on the database.

How were these changes tested?

Homework 1: Not applicable.
Homework 2: Yes

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

Checklist

• [X ] I can confirm that my changes are working as intended