My super mart

After learning about and experimenting with Databases in the previous project. I decided to go next level with a project that requires more tables in my database. After some research online, I decided to make my very own super mart managed on a database.
In this database, I will be managing, customer interactions, item handling and price management.

Let us first talk about item handling. So, I first created a table seller_details to store the details about the vendors from whom I was going to purchase my items from. For example, I may purchase breads from Raj's Bakery. So, I will store their name, phone, email and address...just as I did in my contact book project.
Then, I created a table of stock_type that will store all the types of items I will store in my shop like oranges, apples, bananas, milk, etc. I also created a table that stored details of all the items I had in my store like the name Beautiful Bananas, their quantity, their sale and purchase prices, etc. .

Then, I had to look into customer management so I created the tables customer_details and customer_purchase_details. The first table stored details of my customers like name, phone, email and address... just as I did in my contact book project. The cutomer_purchase_details stored all the transactions they had made. They stored the item bought, the quantity and the price they paid.

Finally, I created a table for my income management that stored the details of all the income I had made.

Overall, in this project I learnt about database handling, SQL syntax and how to connect python to sql.