W.B.C.S. Examination Notes On - Characteristics Of Database Management System

Posted on August 5th, 2020 in Exam Details (QP Included)>Main Exam>Optional Subject-Medical Group>Computer Science
Tags: Computer Science, Notes, WBCS

W.B.C.S. Examination Notes On – Characteristics Of Database Management System – Computer Science Notes.

Provides security and removes redundancy.Continue Reading W.B.C.S. Examination Notes On – Characteristics Of Database Management System – Computer Science Notes.
Self-describing nature of a database system
Insulation between programs and data abstraction
Support of multiple views of the data
Sharing of data and multiuser transaction processing
DBMS allows entities and relations among them to form tables.
It follows the ACID concept ( Atomicity, Consistency, Isolation, and Durability).
DBMS supports multi-user environment that allows users to access and manipulate data in parallel.

DBMS	Flat File Management System
Multi-user access	It does not support multi-user access
Design to fulfill the need for small and large businesses	It is only limited to smaller DBMS system.
Remove redundancy and Integrity	Redundancy and Integrity issues
Expensive. But in the long term Total Cost of Ownership is cheap	It’s cheaper
Easy to implement complicated transactions	No support for complicated transactions

Following, are the various category of users of a DBMS system

Component Name	Task
Application Programmers	The Application programmers write programs in various programming languages to interact with databases.
Database Administrators	Database Admin is responsible for managing the entire DBMS system. He/She is called Database admin or DBA.
End-Users	The end users are the people who interact with the database management system. They conduct various operations on database like retrieving, updating, deleting, etc.

Here, is the list of some popular DBMS system:

Please subscribe here to get all future updates on this post/page/category/website