Hi，may I know how to program a system that can record the number of food item sold and can know the monthly sales?

Question

Im currently learning to create a food ordering system of a restaurant.. And I get stuck in the middle of it😩hope someone helps.. Thx

Answer 1

I'm just giving you a general idea.

Based on my limited knowledge, a database will be necessary whenever we need to record something, which we can process later on to make decision or analysis (profit, loss etc.).

So if you're serious about this, I suggest you to learn about database and its usage practices.

Whatever language can be used as the front-end tool, but behind the scene, there should be a database storing all the data needed to be processed to become a useful information.

Answer 2

Python, just like many other languages allows interaction with databases (supported database types may vary).

The language used for database manipulation is SQL. You might wanna look into that also.

There's also this NoSQL technology, which works in different way, many new apps are using this thing having several considerations been taken.

Basically, whether you choose SQL or NoSQL, for your idea of project, a database will be necessary.

You can of course count total sales and any other things, but when this data needs to be stored, a database is the way to go 👍

Answer 3

For rather simple data it is possible. But databases can store much larger data, and offer more than mere data storage, being well designed of course.

Answer 4

I see..Thx so much for the explanation. Database is under python language also? I'm sorry.. I'm quite new to programming.. I thought I can count the total quantity sold using python

Answer 5

I see, thx so mch.. Allow me to ask one more ques.. Is it possible to store it in a txt file? I currently learnt until this file I/O of python

Answer 6

I see... Thxx very mch 👍

Answer 7

Wow i see.. For ur info, cos I am a foundation student and I'm asked to create a system using python only as assignment😫and I'm just a beginner.. I'm stucked in it.. Thx for ur info