Hai!! On Tuesday, 19 March 2013 we learnt about Database Management System. This topic is quite confusing me but I don't know which part that make me feel confused. I read about this topic before I update the blog and I though I do not be confuse but when my friend asked me what do u understand about database and database management system?? I tried to answer her but my answer was unsatisfied. She got confused as well as me. Now, I wanna test my IQ whether I'm still confuse or not. Heehehhe...
Database is the organised data and used to storing, organizing and controlling the data. It relate with data and information. Database is the concept of storing, managing and retrieving information. Database is applied in university, supermarket, hospital and so forth. There are two components of database, data item and schema. Data item is to retrieve the specific data while schema is the relationship in database and data. It also known as ERD ( Entity Relationship Diagram).
There are 6 fundamentals of database. To use database, we have to understand the term. The first one is field or as known as column. The second one is record. It is a group of related fields that is represent by row. The third one is key field. It is a subject code such as student's ID. The next fundamental of database is irrational database. For example, managing the timetable. The fifth one is table. It is a collection of record.The last one is objects. It used to view, manage, analyse the data such as table, form and report.
Database Management System (DBMS) is a database program. It used to create, store and manipulate the database. The functions of database management system is to allow user to create a database by using the DDL( Data Definition Languages). Database management system is also used to give user ability modify data by using DML( Data Manipulation Languages). Database management system provides information to the decision maker by using SQL ( Structured Query Languages).
There are 3 types of Database Language. The first Database Language is DDL or Data Definition Language which is used to create database. The second one is DML or Data Manipulation Language. It will manipulate, edit and update data The last one is DCL or Data Control Language.
The users of DBMS are End User, Application Programmer and Database Administrator. End user is a person who use database or application program. Application Programmer is a person who designed the system. Database Administrator is a person who's managing or maintaining the system.
Database Model is structure, organization, characteristic and description of database. The basic building block for all data models are entity, attributes and relationship. Entity is any particular object in the real world and it represents in tables. Attributes is the characteristic of an entity that represent by column in table. Relationship describe the relationship among entities.It can be shown in the form of diagram. There are 3 forms of ERD. They are one to one relationship, one to many relationship and many to many relationship.
Database model has 4 types. There are hierarchical database, network database, relational database and object-relational database.
 |
| Hierarchical database organised data in tree-structure and it establish one to many relationship |
 |
| Network database is to represent complex data relationship and it establish many to many relationship |
No comments:
Post a Comment