IDEAS home Printed from https://ideas.repec.org/a/bjf/ijltem/v15y2026i6a28.html

KAINAN: Design and Implementation of a Gui-Based Python Restaurant Ordering and Billing System with SQLite Integration

Author

Listed:
  • Abella, Gerald Z.

    (Department of Computer Engineering Eulogio “Amang†Rodriguez Institute of Science and Technology (EARIST), Nagtahan, Manila, Philippines)

  • Ampis, Jorsha Myle C.

    (Department of Computer Engineering Eulogio “Amang†Rodriguez Institute of Science and Technology (EARIST), Nagtahan, Manila, Philippines)

  • Aquino, Princess A.

    (Department of Computer Engineering Eulogio “Amang†Rodriguez Institute of Science and Technology (EARIST), Nagtahan, Manila, Philippines)

  • Doctor, Francine Ann T.

    (Department of Computer Engineering Eulogio “Amang†Rodriguez Institute of Science and Technology (EARIST), Nagtahan, Manila, Philippines)

  • Taborada, Sean Allen A.

    (Department of Computer Engineering Eulogio “Amang†Rodriguez Institute of Science and Technology (EARIST), Nagtahan, Manila, Philippines)

  • Ma. Jessa C. Velasco

    (Department of Computer Engineering Eulogio “Amang†Rodriguez Institute of Science and Technology (EARIST), Nagtahan, Manila, Philippines)

  • Engr. Meshelle N. Fabro

    (Department of Computer Engineering Eulogio “Amang†Rodriguez Institute of Science and Technology (EARIST), Nagtahan, Manila, Philippines)

Abstract

Efficient management of restaurant orders and billing is critical for providing quality service, minimizing errors, and improving operational workflow. Traditional manual billing systems are prone to inaccuracies, delays, and difficulty in tracking orders, particularly during peak hours. This study presents KAINAN, a GUI-based restaurant ordering and billing system developed using Python and integrated with an SQLite database. The system allows restaurant staff to create, view, update, and delete orders while automatically calculating bills and managing inventory. Object-Oriented Programming (OOP) principles ensure modularity, code reusability, and maintainability, while the graphical user interface (GUI) provides an intuitive and user-friendly environment. Functional testing confirmed that all modules, including order management, billing computation, and record updates, perform as expected. KAINAN improves accuracy, reduces human error, and streamlines restaurant operations, demonstrating the practical application of Python programming, GUI development, and database management in small to medium-scale food service establishments. Limitations include the absence of online payment integration and multi-user network functionality, which can be incorporated in future versions.

Suggested Citation

  • Abella, Gerald Z. & Ampis, Jorsha Myle C. & Aquino, Princess A. & Doctor, Francine Ann T. & Taborada, Sean Allen A. & Ma. Jessa C. Velasco & Engr. Meshelle N. Fabro, 2026. "KAINAN: Design and Implementation of a Gui-Based Python Restaurant Ordering and Billing System with SQLite Integration," International Journal of Latest Technology in Engineering, Management & Applied Science, RSIS International, vol. 15(6), pages 363-388, July.
  • Handle: RePEc:bjf:ijltem:v:15:y:2026:i:6:a:28
    DOI: 10.51583/IJLTEMAS.2026.150600028
    as

    Download full text from publisher

    File URL: https://www.ijltemas.in/submission/online/article/view/5127/6985
    Download Restriction: no

    File URL: https://www.ijltemas.in/submission/online/article/view/5127
    Download Restriction: no

    File URL: https://libkey.io/10.51583/IJLTEMAS.2026.150600028?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    More about this item

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:bjf:ijltem:v:15:y:2026:i:6:a:28. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    We have no bibliographic references for this item. You can help adding them by using this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Dr. Pawan Verma (email available below). General contact details of provider: https://www.ijltemas.in/ .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.