Simple Coffee shop billing systen (need help)
Hello ,
i need some help with my project "simple coffee shop billing system = counter billing system". the system should have the menu which is has 3 sub menus (hot drinks, cold drinks and snacks ) and eah item has 3 sizes with thier price (the price won'nt appear it stores inside the button of each size). so when the casher press the button of the product he wants it will already add it to the total (but how to enter the quantity should i put text field to enter quantity .?!).
here is what the system should do specifically:
1- Loge in (user and password)
2- Enter the customer order
3- Update the menu(just for administration) .
4- Modified the menu(just for administration).
5- Delete (just for administration)
6- Display Report the profit of each item at the end of the day
with diagram (chart or pie .. etc.)
7- Bills give to the customers.(receipt).
8- Recheck the receipts.
The Questions I have:
1- How many tables I need for my data base (using MS access) ?
I tried to figured it out so I ended up with one table (product information )
The attributes :
Product ID, Product Category,product Size, Product Price.
NOTE:
I don’t know if the customer want 2 cup of coffee (of the same item) how the system will calculate the price specially the price in the table is for one....!?
2- How can I display the daily statistc of revenue for each product, and should I use?
Finally, I really would appreciate if you answer my questions and help me with my project. I’ll try to draw the system screens to let you see how would the system look like.
NOTE:
my project depends on the analysis part more than the design part so i want to make my project as simple as i can , and please answer me as soon as possible.
programs used:
MS access + VB
Replies
-
buzzparastry searching any open source billing software, use your mind and coding to customize it according to your requirement.
You are reading an archived discussion.
Related Posts
I want to know the all the sharing files when systems are connected in LAN......by using java program. Any one give me suggestion how it is possible.....?
i am an electronics engg. as my percentage is less(54%), i didnt get campus placement. pls suggest some certification courses which will help me to get a job in electronics...
Hi All,I'm doing 3rd computer science in SIET. I would like to do In Plant Training in chennai. Can anyone suggest some good companies that offer IPT?... Thanx in advance
An engineering student from Mumbai who likes anonymity …i njoy chatting i m really intrested to know how things work….how they were made what was the need……making new things is...
Hey Godfather I am currently working on a project controlling industrial hazards using GSM intimation and feedback..... has someone worked on a smilar project...... thanks in advance bro.... i have...