Identification Of Database, DBMS and RDBMS - Simple Projects with Source Code

The database is a collection of information stored on a computer in a systematic way so that it can be checked using a computer program to obtain information from the database (http://id.wikipedia.org/wiki/Database). The database is used to store information or data that is well integrated inside the computer.

To manage the database required a software called DBMS (Database Management System). DBMS is a software system that allows the user to create, maintain, control, and access the database in a practical and efficient. With a DBMS, users will be easier to control and manipulate the data.

While RDBMS or Relationship Database Management System is one type of DBMS that supports the existence of a relationship or relationships between tables. In addition to the RDBMS, there are other types of DBMS, such as Hierarchy DBMS, Object Oriented DBMS, etc.

Some DBMS software or software that is often used in applications programs include:

DB2 - http://www-306.ibm.com/software/data/db2/
Microsoft SQL Server - http://www.microsoft.com/sql/
Oracle - http://www.oracle.com
Sybase - http://www.sybase.com/
Interbase - http://www.borland.com/interbase
Teradata - http://www.teradata.com/
Firebird - http://www.firebirdsql.org/
MySQL - http://www.mysql.com
PostgreSQL - http://www.postgresql.org/

Some Terms Database:

Table

A table is a collection of data (values) that is organized into rows (records) and columns (fields). Each column has a name that is specific and unique.

field

Field represents a column of a table. Field has a certain data type size that determines how the data will be saved.

record

Field is a group of interrelated values.

Key is a field that can be used as keys in the operating table. Database concepts, key features many types of them Primary Key, Foreign Key, Composite Key, and so on.

SQL, or Structured Query Language is a language (language) that used to access the database. SQL is often referred to as query.

Database hierarchy
In the concept of a database, a database sequence or hierarchy is very important. Sequence or hierarchy depicted in the image database as follows: