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: