Mock Customer Database

Description

The first part to this project was creating a python and sqlite script to prepare, or initialize, the database for the data I created. Once initialized, another python script was used to load the data into the created database. The second part was to create fake data, because in this class we didn't actually own a store with customers. A python script with randomized first names, last names, different ranges given the item was used to create the fake data loaded into the database. I created an extra script to "reset" the database and test if data insertion had been successful. This is one of my favorite projects I've worked on, even though sql can pose interesting challenges.

Skills Utilized

• SQLite
• mock data creation
• python programming