Introduction to Databases

    A database helps people to find an interested data. Databases are consist of table(s) which have columns and rows and relationships between these tables. Each row stores data about related thing. Table names are written with all capital letters such as ‘PRODUCT, SALES, CUSTOMER’ and column names are written with initial letter on each  word such as ‘Price, CustomerName, UnitsSold’.

While working with applications, a Database Management System (DBMS) is required to manage data on databases. A DBMS creates, processes and administers databases. Here are some well-known DBMSs;  Microsoft Access, Microsoft SQL Server, IBM DB2, ORACLE and MySQL. We will compare them with details on another post but in summary, if we order them in difficulty of usage; MS Access, MS SQL Server, IBM DB2 and ORACLE is the hardest. But they are in a opposite order if we compare them to the power and features.

    DBMSs  commonly use SQL (Structured Query Language). SQL is an internationally recognized standart database language. If we sum up all the relationship between user and database from here; Users can manage the data on the database via DBMS by using SQL.

                                          User <–> SQL <–> DMBS <–> Database


One thought on “Introduction to Databases

  1. Pingback: Creating a sample database in Microsoft Access 2007 – SoftNotes

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s