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

Drawing relational schematic between two tables. I added necessary coding commands for basic table manipulation for SQL lite.

What did you learn from the changes you have made?

I learned the basic SQL lite operations like select, merge, filter, aggregate. Furthermore, I learned to create table.

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

For creating table, I hard coded the customer_id. There should be a better way of doing it, allowing database to assign an id to user.

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

Syntax is kinda hard. The commands are predictable but where to put paranthesis and commas is confusing.

How were these changes tested?

I tested code by copying and pasting into the DB browser for SQLite.

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

Checklist

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