OVERVIEW MYSQL FOR BEGINNERS

Hi.. welcome to my blog at “We Are Knowledge”.. In here to be found many IT knowledge.. likely this article discuss about “database” using “mysql”.. You know that ?? or you will reading it.. ?? let’s do read my article… have fun and enjoy friends…

In here is the subject this time :

·           Introduction of database, DBMS, and RDBMS

·           Terms contained in the database

·           Hierarchical database

previously I was discuss about “introduction of MYSQL”.. but now I want giving you more complete…

1. Introduction of database, DBMS, and RDBMS

Database called a data base and its definition is a collection of a lot of data that is crucial in a computer store in a structured manner, so that the data can be called back when we wanted to use it.

DBMS stands for database management system is an application that allows users to create, access, modify, maintain the database. So the purpose DBMS is that users can control and manipulate the data contained in the database (MYSQL)

RDBMS stands relationship Database management system, that an application to connect tables with one another on a single table database.

2. Terms Contained In The Database

Table

>> Is a collection of a lot of data that consists of rows and columns, and each column has particularly different names with each other

Field

>> Field used to replace the columns mentioned. So the same field with a column

Record

>> record is the smallest part of a table. And the record set called field

Key

>> Key is a key term in the operation table .. So that's why he key to the naming should not have the same

SQL

>> SQL stands for structure query language, is a language that we use to access the database. SQL is better known by the name "Query".

3. Hierarchical database

Sense of the word is a hierarchy in the order, so the hierarchy DATABASE is the sequence contained in the database, and this is the order ::

DBMS >> DATABASE >> TABLE >> FIELD & RECORD

the point is ::

DBMS consists of many DATABASE,

DATABASE consists of many TABLE, and

TABLE consists of many FIELD & RECORD

Ok.. just it…
I hope you understandsee you later friends..