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