Perancangan Database Point of Sales Apotek Dengan Menerapkan Model Data Relasional

Authors

  • Rusydi Umar Universitas Ahmad Dahlan
  • Abdul Hadi Universitas Ahmad Dahlan
  • Panggah Widiandana Universitas Ahmad Dahlan
  • Fahmi Anwar Universitas Ahmad Dahlan
  • Muhammad Jundullah Universitas Ahmad Dahlan
  • Ahmad Ikrom Universitas Ahmad Dahlan

DOI:

https://doi.org/10.58836/query.v3i2.6394

Abstract

Database design is a process of designing data needed to support various system designs. The benefit of a database in Point of Sales drug sales in the Jogja Pharmacy enables storing, changing and returning all data quickly and easily. Problems in database design are different viewpoints from the designer, programmer and end-user. Because of that, the design is needed a methodology the process of designing a good database starting from procedures, techniques, tools and documentation. The database planning method used in Research and Development (R & D) and the database design method uses the Database Life Cycle (DBLC) variable research is POS pharmacy. Research aspects include requirement analysis, conceptual design, logical design and physical design. The final result of this research is to create 8 types of conceptual consists of drugs, drugs, customers, stores, users, detailed details, and temporary details.Keywords: database, apotek, POS, DBLC, relational data

Author Biographies

Rusydi Umar, Universitas Ahmad Dahlan

Program Studi Teknik Informatika

Abdul Hadi, Universitas Ahmad Dahlan

Program Studi Magister Teknik Informatika

Panggah Widiandana, Universitas Ahmad Dahlan

Program Studi Magister Teknik Informatika

Fahmi Anwar, Universitas Ahmad Dahlan

Program Studi Magister Teknik Informatika

Muhammad Jundullah, Universitas Ahmad Dahlan

Program Studi Magister Teknik Informatika

Ahmad Ikrom, Universitas Ahmad Dahlan

Program Studi Magister Teknik Informatika

Downloads

Published

2019-10-13

Issue

VOLUME: 03, NUMBER: 02, OCTOBER 2019

Section

VOLUME: 03, NUMBER: 02, OCTOBER 2019

License

Creative Commons License

Authors who publish with this journal agree to the following terms:

  • that this article contains no violation of any existing copyright or other third party right or any material of a libelous, confidential, or otherwise unlawful nature, and that I will indemnify and keep indemnified the Editor and THE PUBLISHER against all claims and expenses (including legal costs and expenses) arising from any breach of this warranty and the other warranties on my behalf in this agreement;
  • that I have obtained permission for and acknowledged the source of any illustrations, diagrams or other material included in the article of which I am not the copyright owner.
  • on behalf of any co-authors, I agree to this work being published in Query: Jurnal Sistem Informasi as Open Access, and licenced under a Creative Commons Licence, 4.0 https://creativecommons.org/licenses/by/4.0/legalcode. This licence allows for the fullest distribution and re-use of the work for the benefit of scholarly information.