What is database | What is a DBMS | Importance of a database

Share:

What is database | What is a DBMS | Importance of a database
what is database
what is database

In this article, I will discuss with details about What is database? what are a DBMS and the importance of a database in our life? I will also discuss with details about the Database Administrator. How to create a database on the Xampp server. Uses of database and many more.

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? Your 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:

The 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 many 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 followings:

  1. MySQL
  2. SQL server
  3. PostgreSQL
  4. Microsoft Access
  5. dBASE
  6. Clipper
  7. Oracle
  8. Xampp
DatabaseDBMS
·         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 a 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
  1. Select your operating system
  2. Click on download
  3. When .exe file download

Installation of xampp:

  1. Double click on .exe file
  1. Give access
  2. Then just click on next
  3. Some checkbox will appear
  4. Check all these checkboxes
  5. 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, the localhost creates 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 using a lot of companies
  • This is using in many industries
  • It is using at household
  • It is using 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 using form small businesses to megaprojects, and DBMS the database management system provides management of the database. Many software, websites, and online servers provide management of the database.

Feedback is important to me. 

Please don't forget to give me feedback on how you find this article? If this is helpful for you then give a good comment otherwise let me know how I can improve this article? I hope you find something good about this topic of useful content.

No comments