First, we need to know what database is? Database is a data structure that stores organized information. The Database consist of a files, which file is a related collection of a record, for example the records of each costumers on the public service office. The Files contain a records. In database, records is a a group of a fields within the table that are relevant on the specific entity. In turn, each record would consist of fields for individual data items, such as customer name, customer number, customer address, and so forth.
Field is combination of one or more characters and it is the smallest unit of data user accesses.By providing the same information in the same fields in each record (so that all records are consistent), the file will be easily accessible for analysis and manipulation by a computer program. To manage the Database easily the field should have a primary key, because with primary key, the data will have it’s own unique identifier and no other have the same primary key.
Every Companies must have a data of what they did, and they need to manage that data to become an information and a key for the companies development. Such as the Bank which the bank must be have so many costumer who have an account for their savings. No way, that the bank this day, will only write the data of the “many” costumer on the book. If there are only 10-100 costumer, it’s fine to use a book. But what if the costumer comes from a thousand until a million.. Will the bank could efficiently manage the costumer? NO. Because there will be a problems such as data redundancy, security problems, inconsistency data and data integrity.
That’s why, the data that managed by the computer will be easily accessed, managed, and controlled. On the Computer, the database managed by the system called DBMS, or Database Management System. DBMS is a set of software programs that provides access to a database. For the longer mean, it is a software system that uses a standard method of cataloging, retrieving, and running queries on data. The DBMS manages incoming data, organizes it, and provides ways for the data to be modified or extracted by users or other programs. Some DBMS examples include MySQL, PostgreSQL, Microsoft Access, SQL Server, FileMaker, Oracle, RDBMS, dBASE, Clipper, and FoxPro. Since there are so many database management systems available, it is important for there to be a way for them to communicate with each other.