Rapid Application Development of Pharmaceutical Database System

  • Fatin Natasya Shuhaimi
  • Nor Liza Saad
  • Roslinda Ramli


This paper provides insight into the design and implementation of a pharmaceutical management system. The primary aim is to demonstrate the rapid development method in developing the important system with Python development tool mainly for the graphical user interfaces and database management. Today, there exists several kinds of pharmaceutical management system have been reported in the literature, but most contents were highly focused on the system functionality and usability studies. The literature that reports on rapid development tools for the system is found to be very limited. Today, with the critical needs of information technology to support fast and accurate data management, the development of information or management system by inexpert users has been an important issue to many organizations. Therefore, this paper presents the system from the aspects of database and usability design and the easy implementation tool for the case of developing a pharmaceutical management system. Usability testing is also provided to show the users evaluation on the system.


A. Khelifi, D. Ahmed, R. Salem, and N. Ali, “Hospital-pharmacy management system: A UAE case study,” Int. J. Comput. Control. Quantum Inf. Eng., vol. 7, no. 11, pp. 795–803, 2013.
[2] P. Beynon-Davies, C. Carne, H. Mackay, and D. Tudhope, “Rapid application development (RAD): an empirical review,” Eur. J. Inf. Syst., vol. 8, no. 3, pp. 211–223, 1999.
[3] J. J. Helmus and S. M. Collis, “The Python ARM Radar Toolkit (Py-ART), a library for working with weather radar data in the Python programming language,” J. Open Res. Softw., vol. 4, 2016.
[4] N. Braun, T. Hauth, C. Pulvermacher, and M. Ritter, “An interactive and comprehensive working environment for high-energy physics software with python and jupyter notebooks,” in Journal of Physics: Conference Series, 2017, vol. 898, no. 7, p. 72020.
[5] A. Annamaa, “Introducing Thonny, a Python IDE for learning programming,” in Proceedings of the 15th Koli Calling Conference on Computing Education Research, 2015, pp. 117–121.
[6] S. Hassan, U. Qamar, and M. A. Idris, “Purification of requirement engineering model for rapid application development,” in 2015 6th IEEE International Conference on Software Engineering and Service Science (ICSESS), 2015, pp. 357–362.
[7] J. Valley and J. Greeven, “Prescription pharmaceutical labeling system.” Google Patents, 2003.
[8] J. A. Dent, S. S. Jafri, and M. McGill, “Pharmaceutical tray filing system and method.” Google Patents, 2020.
[9] A. Qashlim and B. Basri, “Integration of Information System Based on Supply Chain Management (SCM) for Pharmaceutical Warehouse in Mamasa Regency,” ComTech Comput. Math. Eng. Appl., vol. 9, no. 1, pp. 1–8, 2018.
[10] M. V Purushothaman and A. VelTech, “QR CODE INBUILD PRESCRIPTION MODULES FOR EFFECTIVE PHARMACY BILLING APPLICATION,” Int. J. Pure Appl. Math., vol. 119, no. 15, pp. 45–58, 2018.
[11] O. Thinnukool, P. Khuwuthyakorn, and P. Wientong, “Pharmacy assistant Mobile application (PAMA): development and reviews,” Int. J. Interact. Mob. Technol., vol. 11, no. 3, pp. 178–194, 2017.
[12] O. Eme, U. U. CA, F. O. Uwazuruike, and C. U. Ukpai, “Computer--based Drug Sales and Inventory Control System and its Applications in Pharmaceutical Stores,” Int. J. Educ. Manag. Eng., vol. 8, no. 1, p. 30, 2018.
[13] W. Chanpuypetch and D. Kritchanchai, “A design thinking framework and design patterns for hospital pharmacy management,” Int. J. Healthc. Manag., pp. 1–9, 2017.
[14] A. S. Patil, R. S. Patil, S. P. More, and S. S. Sankpal, “Web Application for Online Pharmacy,” 2019.
[15] S. Kumar, E. Swanson, and T. Tran, “RFID in the healthcare supply chain: usage and application,” Int. J. Health Care Qual. Assur., 2009.
How to Cite
SHUHAIMI, Fatin Natasya; SAAD, Nor Liza; RAMLI, Roslinda. Rapid Application Development of Pharmaceutical Database System. Mathematical Sciences and Informatics Journal, [S.l.], v. 1, n. 1, p. 43-54, aug. 2020. ISSN 2735-0703. Available at: <https://myjms.mohe.gov.my/index.php/mij/article/view/14168>. Date accessed: 13 june 2024. doi: https://doi.org/10.24191/mij.v1i1.14168.

Most read articles by the same author(s)

Obs.: This plugin requires at least one statistics/report plugin to be enabled. If your statistics plugins provide more than one metric then please also select a main metric on the admin's site settings page and/or on the journal manager's settings pages.