Repository navigation
I designed an SQLite database for a customer order tracking management system. I created four related tables that are product, customer, purchase_order and order_item; then import the data from the CSV files and check their data. I run queries to select the particular customer’s purchase and order information, which involved the use of the JOIN. Also, I tested data manipulation through creating records and editing them, and checked to confirm if modifications we made were appropriate. I liked this exercise as it gave me an opportunity to create, query and manage relational databases successfully.