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

A database management system (DBMS) is a software package designed to define, manipulate, retrieve and manage data in a database. A DBMS generally manipulates the data itself, the data format, field names, record structure and file structure. It also defines rules to validate and manipulate this data.Continue Reading Computer Science Notes On – Database Management System – For W.B.C.S. Examination.

A DBMS relieves users of framing programs for data maintenance. Fourth-generation query languages, such as SQL, are used along with the DBMS package to interact with a database.

DBMS allows users to create their own databases as per their requirement. The term “DBMS” includes the user of the database and other application programs. It provides an interface between the data and the software application.

Advantages of DBMS

• DBMS offers a variety of techniques to store & retrieve data
• DBMS serves as an efficient handler to balance the needs of multiple applications using the same data
• Uniform administration procedures for data
• Application programmers never exposed to details of data representation and storage.
• A DBMS uses various powerful functions to store and retrieve data efficiently.
• Offers Data Integrity and Security
• The DBMS implies integrity constraints to get a high level of protection against prohibited access to data.
• A DBMS schedules concurrent access to the data in such a manner that only one user can access the same data at a time
• Reduced Application Development Time

Disadvantage of DBMS

DBMS may offer plenty of advantages but, it has certain flaws-

• Cost of Hardware and Software of a DBMS is quite high which increases the budget of your organization.
• Most database management systems are often complex systems, so the training for users to use the DBMS is required.
• In some organizations, all data is integrated into a single database which can be damaged because of electric failure or database is corrupted on the storage media
• Use of the same program at a time by many users sometimes lead to the loss of some data.
• DBMS can’t perform sophisticated calculations

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

Want to keep yourself updated about WBCS and other Govt. exams? Submit the form here-

For all WBCS Exam etc. course details CLICK HERE

If you want to be in contact with us and get future posts and news, subscribe here...

* indicates required

Email Address *

First Name

Your information will *never* be shared or sold to a 3rd party.