Database Systems Tutorials

Database and information with examples, DBMS

In this tutorial, we will learn about the followings;

  1. What is a database?
  2. What is data?
  3. What is information?
  4. What is DBMS?

What is the database?

“Database is an organized collection of related data”. The database can contain one or more tables. Table have proper database schemas. Different SQL queries are performed on data to generate the useful reports. Reports are technically called views.

The database can be managed by Database Management System DBMS. All the tables in the database are fully normalized to reduce the anomalies within data and to convert the database from complex to a simple one. Keys are used to uniquely identifies the rows within the database.

Examples of the database

Examples of the database are phone directory in your mobile phone, Database of the library, Database of a college, Database of citizens of the USA etc.

What is data? 

Data is a collection of raw figures and raw facts. Data can consist of text, character, images, audio or video etc. Data plays a key role in any organization because data is processed by data mining to take the big decision about your organization. Data is very expensive. You can notice that many of the social networks provide you free services. Why when there is nothing free in this world? Yes because many social networks keep a record of your activities and then these social networks know more about you and you know less about you. After that many of the social networks sell your data to advertisement companies. Advertisement companies show you ads related to you when you log on the internet.

What is Information?

The processed form of data is an information. For example, we can give the data to the CPU in the form of input. CPU process the data and then CPU gives us the output in the form of information. The only purpose to store the data is to get the useful information from the data. In database processing on the data and in the CPU is done when someone put the SQL query. 

data information

What is DBMS?

DBMS is the database management system. DBMS is used to created and manipulate the database. Some common examples of DBMS are Mysql, Microsoft Access, Oracle, SQL server etc.

database

Hopefully, now you can answer the following questions;

  • What is the database?
  • What is data?
  • What is information?
  • What is database management system?
  • What are examples of database management systems?