Entry Four : Database Management System ( DBMS )

Hello,

   I would like to post about DBMS ( Database Management System) which I have learnt as four learning outcome in IT class in this entry four. First and foremost, I would like to explain what database is. Database is normally a place to store data and information. It is used to store , organize and control data in different organization.

Sample Database

There are two components of database which are data item and schema. Schema is the relationship among different entities in database system. It works by matching data and can be shown in the form of diagram.The are three type of schema. They are one to one , one to many, and many to many schema.

Diagram of three schema

  

Database architecture includes actual database , hardware to process and store data, software to manipulate the contents and people to administer the access, control the modification of data.

Sample Database Architecture

  Moreover, we have learnt three features or functions of DBMS. The first function is to allow users to create new database with DDL ( Data Definition Language). Another feature is to give users the ability to modify the data using appropriate language. The final one is to provide users with information.

  Besides, we have studied database models. It is also call data dictionary. There are four type of database models which are hierarchical database model, network database model, relational database model, and object relational model. We also have learnt about components of DBMS. There are six components which are field , record, table, key field, relational database and objects.

  We also have learned three basic database language which are DDL ( Data Definition Language ) used to create data, DML ( Data Manipulation Language) used to manipulate data, and SQL ( Structured Query Language ) used for retrieving specific data.