Analysis And Database Design from Import And Export Reporting in Company in Indonesia
Keywords:database, DB-SDLC, ERD, customs
Director General of Customs and Excise (DJBC) is a government agency that oversees exports and imports in Indonesia. Companies that receive exemption and tax returns are required to wipe Orkan activities export and import by using IT-based reporting. This study aimed to analyze and design databases to support the reporting of customs based report format for Director General of Customs and Excise No. PER-09/BC/2014. Data collection used was the Fact Finding Techniques consisted of studying the documents, interviews, observation, and literature study. The methods used for Design Database System is DB-SDLC (System Development Life Cycle Database), namely: Conceptual Design, Design Logical and Physical Design. The result obtained is ERD (Entity Relationship Diagram) that can be used in the development of Customs Reporting System in companies throughout Indonesia. In conclusions, ERD has been able to meet all the reporting elements of customs.
Connolly, T., & Carolyn B. (2005). Database Systems: a practical approach to design, implementation and management (4th ed.). Database Place: Wesley.
Kementerian Keuangan Republik Indonesia. (2014). Peraturan Direktur Jenderal Bea dan Cukai, Nomor PER-09/BC/2014 tentang Penerapan Sistem Informasi Persediaan Berbasis Komputer pada Perusahaan Pengguna Fasilitas Pembebasan, Pengembalian, dan Tempat Penimbunan Berikat, serta Kerahasiaan Data dan/atau Informasi oleh Direktorat Jenderal Bea dan Cukai. Jakarta.
Kementerian Keuangan Republik Indonesia. (2011). Peraturan Keuangan Republik Indonesia, Nomor 177/PMK.04/2011. Jakarta.
Lee, J., Cho, R. K., & Paik, S. (2016). Supply chain coordination in vendor-managed inventory systems with stockout-cost sharing under limited storage capacity. European Journal of Operational Research, 248(1), 95-106.
Pons, D. (2010). System model of production inventory control. International Journal of Manufacturing Technology and Management (IJMTM), 20(1-4), 120 - 155.
Sheldon, R., & Moes, G. (2005). Beginning MySQL (1st ed.). Canada: Wiley Publishing Inc.
Authors who publish with this journal agree to the following terms:
a. Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License - Share Alike that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
b. Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
c. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.
All articles published Open Access will be immediately and permanently free for everyone to read and download. We are continuously working with our author communities to select the best choice of license options, currently being defined for this journal as follows: