Fortech : Journal of Information Technology
Vol. 4 No. 1 (2020): Fortech (Journal Of Information Technology)

PEMODELAN DATA PROSES BISNIS PADA PERUSAHAAN ADVERTISING (STUDI KASUS CV ABC): DATABASE, CONTSTRAINT CHECK , PRIMARY KEY, FOREIGN KEY

Mutamassikin (Unknown)



Article Info

Publish Date
05 Apr 2020

Abstract

Database is a collection of information stored in a computer systematically so that it can be checked using a computer program to obtain information from the database, so that the database can help store data and information that can be retrieved at any time. The data and information that is owned by abc company consists of several, starting from ordering data, employee data, financial data, job distribution data, and information related to abc company. Database modeling in this case study uses a constraint check to provide a limit of the data inputted, so that later the data entered in the database table can be filtered that is not the same or in accordance with the constraint check that is inputted in the data table. The database capability to filter every existing data is one of the good and correct structures for implementing the constraint check in each database table, while the structures owned by the constraint check are primary key, foreign key, not null and uniqie. Therefore each structure has its own function, which will determine the level of accuracy of the data entered by the user, the better.

Copyrights © 2020






Journal Info

Abbrev

fortech

Publisher

Subject

Computer Science & IT Decision Sciences, Operations Research & Management

Description

Fortech (Journal of Information Technology) merupakan media publikasi terbitan Lembaga Penelitian dan Pengabdian Masyarakat (LP2M) STMIK Nurdin Hamzah Jambi yang terbit sebanyak 2 kali dalam setahun pada bulan April dan November, berisi hasil penelitian para akademisi dan praktisi berkaitan dengan ...