Database Management System (DBMS)

 What is Database?

A Databse is a collection of data stored in a standardized format, designed to be process, shared by different users. A database may have a single table or multiple tables. The data in a databse organized in row and columns. 
A databse represents some aspect of real world or the universe of discourse. 

Example : University databse organizes the data about students, faculty, and admin staff. Which hepls in efficient retrieval, insertion, and deletion of data from it.







What is DBMS?

Database Management System (DBMS) is a collection of program that enables users to create and maintain a database. The DBMS is hence a general purpose software system that facilities the process of defining. The DBMS accepts the request for data from an application and instructs the operating system to provide the specific data. In large systems, a DBMS helps users and other software to store and retrieve data.

DBMS allows users to create their own database as per their requirement. It provides an interface between the data and the software application.

As a example of University database : A University can have various details of students, such as student name, student Id, email, course, year, mobile no, parents name etc. All these information can stored in a database with the name "Student" in a structured format such as table.







Characteristics of DBMS

  • DBMS contains automatic backup and recovery produres.
  • It uses a digital repository established on a server to store and manage the information.
  • It used to provide security and support manipulation, processing of data.
  • Allow changing data storage structures and operations without having to change the DBMS access programs.
  • Online Transaction processing is a major part of database applications.
  • A data model is used to hide storage details and present the users with a conceptual view of the database.
  • In DBMS, the authorized users of an organization can share the data among multiple users.


    Let's Get GroupGyaan


Comments

Post a Comment

Most popular post

SDLC in Software Engineering

SDLC Software Development Life Cycle The System/Software Development Life Cycle is a structure sequence of phase for implementing assistance.There are following phases in SLDC-- 1:-&nbsp   Requirement of need:-             The first step in the SDLC is identification of need.Need is the uer request to change , improve or inhance and existing system.The key question of this phase is "What is the problem?". 2:-&nbsp   Feasibility Study:-          Feasibility refers to the determination of wheather it is practical and benificial to build the system or not.In this study the requirement of candidate system are composed with cost,time,mainpower and technical resources.To know that all requirement can be fullfill or not.  Various types of Feasibility Study are---- (i):- Economy Feasibility (ii):- Technical Feasibility (iii):- Behaviour Feasibility (iv):- Operational Feasibility 3:-&nbsp   Analysis:-      Analysis is the details study of v
Read more