DATABASE


Database is an organized collection of data which is arranged and presented in alphabetical order. It is a mechanism use for storing, managing, and retrieving information. Database can be applied in organization such as bank, hospital, university and many more. There are three function of database which is to store, to organize and to control the information. Database consist of two component which are data item and schema. The database architecture consist of the actual database, hardware to process and store the data, software to manipulate the contents and people to administer the access, control and modification of data, whereas, database management system is a software package for manipulating database. It is also known as database program. Some examples of database management system are MySQL, Microsoft Access, Oracle and FoxPro.



There are three features of Database Management System (DBMS). The first is it allow users to create new databases, it give users the ability to query and modify the data using appropriate language and it provide information to the decision makers in order to make important decision. Data definition language, data manipulation language and structured query language are the language that can be uses in this system. There are seven components in DBMS; field, record, table, key field, relational database, and objects. Database contain three type of relationship which are one to one relationship, one to many relationship and many to one relationship. This system can be used by end users, application programmers, and database administrator.

For database model, it consist of structure, characteristic, description, and organization. It has four types. The first type is hierarchical database wich is used to organize data in tree structure and can establish one to many relationship. The second type f database model is network database which is improvement from hierarchical database. For this database we can present a more complex data relationship. The next is relational database which is used to organized data in the form of rows and columns. Lastlyis object relational database.



0 comments: