GROUP STUDIES, This blog is a good source of information about the engineering subject knowledge, this will make your lockdown joyful.

Breaking

Thursday, 4 June 2020

What is DBMS(database management system)?

What is the DBMS(database management system)?


DBMS,database management system,cse,it,engineering.
A database management system (DBMS) is system software for creating and managing databases. It is a software system that uses a standard method of cataloging, retrieving, and running queries on data. The DBMS manages incoming data, organizes it, and provides ways for the data to be modified or extracted by users or other programs. Some DBMS examples are:- 

  • MySQL
  • Microsoft Access
  • Oracle
  • PostgreSQL
  • dBASE
  • FoxPro
  • SQLite
  • IBM DB2
  • LibreOffice Base
  • MariaDB
  • Microsoft SQL Server etc.
What is the application of DBMS?
  • Banking -For customer information, account activities, payments, deposits, loans, etc. 
  • Airlines -For reservations and schedule information. 
  • Universities -For student information, course registrations, colleges, and grades. 
  • Sales -Use for storing customer, product & sales information, etc...
What are the types of DBMS?
   Four Types of DBMS systems are:
  • Network Model.
  • Object-Oriented Model.
  • Hierarchical DBMS.
  • Object-Oriented Model.
What are the advantages of DBMS?
  • Uniform administration procedures for data.
  • A DBMS uses various powerful functions to store and retrieve data efficiently. 
  • DBMS serves as an efficient handler to balance the needs of multiple applications using the same data.
  • DBMS offers a variety of techniques to store & retrieve data.
  • Reduced Application Development Time.
  • Offers Data Integrity and Security.

No comments:

Post a Comment