What is database

Share:


Introduction to the database:

In the age of the 21st century, networking has been increased, this age have a lot of knowledge, information, and data. To store this data on the computer is called a database. DBMS is a system used to manage data in the computer. Much software, online servers, websites provide Database Management System. This article will explain what is a database, Importance of database, DBMS Database management system, Examples of the database, how to use the database, How to install Xamp server. The database can store all of your information. It is a basic necessity of this IT world.

What is the database?

I have a question for you. How many pictures are saved on your phone? I am Damon sure that your answer will so many. How many contact numbers are saved on your phone? You answer will the same? It’s a miracle that a simple device can store a lot of information. The database helps to store this information. The database is a set of information stored in a computer or another device is called a database.


Importance of database:

Database plays an important role in our informative life. Let’s consider you are the owner of a company. You want to store information about your customers, clients, employers, products, and profit. Then what will you do? If your answer is copy paper or accounting register like an old concept, then you are 100 years before then the 21st century. You should be managing a database in your computer, and store all of this information. So in the era of IT database is the basic necessity of any business.

DBMS Database Management system:

DBMS is a system that collects data, store it, update it and give accessibility. There are much free software and online servers that provide the opportunity to store data.

Some types of database management systems are given below:

1.       Rational database
2.       Object database
3.       Graph database
4.       Network database

Examples of database management systems are given below:

1.       MySQL
2.       SQL server
3.       PostgreSQL
4.       Microsoft Access
5.       dBASE
6.       Clipper
7.       Oracle
8.       Xampp

Database
DBMS
·         It is just information stored on the computer.
·         It gives storage as well as management.

Database Administrator:

A database administrator is a person who performs tasks like installation, configuration, upgrade, administration, monitoring and maintenance of databases in an organization. He is a person who someone who uses software and programming to store and organize data, such as banking information and all other types of office records.


How to create database on xampp server:

I will tell you how to download, install and create a database in xampp server, so let’s start:

       Downloading of xampp:
1.     
            Click on this link https://www.apachefriends.org/index.html
2.       Select your operating system
3.       Click on download
4.       When .exe file download

Installation of xampp:
1.     
            Double click on .exe file
2.       Give access
3.       Then just click on next
4.       Some checkbox will appear
5.       Check all these checkboxes
6.       Then click on next and so on.

Apache server:

1.       Go to the window search panel
2.       Search for “Xampp Controler”
3.       Open this controller
4.       Start MySQL and Apache
Now localhost is created for the storage of your data.

How excel stores data:

1.       When we enter information in cells of the worksheet, then they store all of this information.
2.       After the formulation
3.       Coding
4.       And button creating
5.       Excel used as a database

Uses of the database:
·       
            Today’s Database is used in micro or mega projects.
·         It is used in a lot of companies
·         It is used in many industries
·         It is used at household
·         It is used in Libraries, Schools, and Student management system.

Conclusion:

In the end, we can conclude that: in the era of IT database is a basic necessity, it is used to form small business to megaprojects, and DBMS the database management system provides management of the database. Many software, websites and online servers provide management of the database.




No comments