A DBMS Makes The : Collection Of Data Set Of Program

A DBMS makes the collection of data or a set of programs to manipulate data stored in a database. that’s called database management system or DBMS. A database management system provides basic functionalities like storage manipulation or user of data.

a DBMS makes the :

There are four major components of the database management system which form of the database system environment as listed below.

HOW A DBMS MAKES THE SET OF PROGRAM

  • Data
  • Hardware
  • Software
  • Users

The following figure depicts these four components. These components are described in the following sub-sections.

Data

The collection of related data is referred to as a database. In other words, the database is a repository of related data. Integrated data means they are correct and consistent.

Correctness suggests that data satisfies the integrity rules, such as balance should not be negative.

Consistency suggests that all the data stored in a database should be consistent. For example, an account should not have a branch name that does not exist.

Depending upon the number of users interacting with the system. a database system can be a single user system or multi-user system. In a single-user system, at most one user can access the database at a time. In a multi-user system, more than one user can access the database at the same time.

Hardware

All the physical devices of a computer system are referred to as hardware. A computer system can have several different hardware such as processor, memory, hard disk, monitor, keyboard, mouse, printer, scanner, etc.

From a database system point of view, important hardware can be divided into two categories:

processor and main memory – Supports the execution of the database software.

secondary storage device – Used to store data of a system or organization permanently.

These include hard disks, magnetic tapes, compact disks, etc.

Hard disks are the most widely used secondary storage devices nowadays.

Software

The software provides the interface between users and databases stored in physical devices. Application programs, DBMS software, and operating systems from the software component here.

The operating system manages all the hardware of the computer. The file system of the operating system provides interaction between other software components and hardware such as a hard disk.

User

These are the four main categories of database users:

•        Database Administrator – He/She is responsible for the proper functioning of the database system.

•        Database designers – Identify the data to be stored in a database and designs the structure of the database for an organization.

•        End users – These users interact with the database in different manners depending upon their requirements.

Advantages of DBMS

database management system contains centralized management and control over the database. Also, DBMS software is used to provide interaction between application programs and databases. Due to this, it provides many advantages. These advantages are given below.

Advantages Of DBMS

Minimal Data Redundancy

possible to avoid unnecessary duplication of information. For example, all the information about bank customers can be kept centralized. This prevents unnecessary duplication of customer information who has both types of accounts.

leads to reduced data redundancy. Reduced data redundancy prevents memory. wastage.

Improved Data Consistency

inconsistency occurs due to data redundancy. For example, consider that customer requirement is maintained separately for savings accounts and current accounts.   

Efficient Data Access

Utilizes a variety of techniques to retrieve data. Required data can be retrieved by providing an appropriate query to the DBMS.   

The data can be accessed in a convenient and efficient manner.

Improved Data Sharing

the database is maintained centrally, all authorized users and application programs can share this database easily.

Improved Data Integrity

the software provides different ways to implement such type of constraints. Also, it ensures that the data stored in the database follows such constraints on its own. Application programs need not worry about this.

Guaranteed Atomicity

operation on a database must be atomic. This means it must happen in its entirety or not at all. For example, a fund transfer from one account to another must happen in its entirety.

That is the responsibility of the DBMS software to ensure such a kind of atomicity. If any operation fails due to some problems, such as system crashes, then the effects of the partially executed operation can be undone.

In database systems, atomicity can be guaranteed.

Improved Security

For example, a customer can check balance only for his/her account.

the software provides a way to control access to data for different users according to their requirements.

It provides several advantages over other database systems, such as file-oriented systems, as described in the previous section. In spite of this, DBMS contains some drawbacks. The following are the disadvantages of using DBMS.

Disadvantages Of DBMS

Disadvantages Of DBMS

High Cost

the initial cost is required to implement database and application programs.

incurs high initial cost behind DBMS software. Also, hardware needs to be upgraded according to the requirements of the DBMS software.

from older file-oriented system to a database system is also costly in terms of money as well as time.

Specialized Manpower

The system requires specialized, skilled manpower to design & develop databases and to provide database administration services.

due to rapid changes in database technology. this manpower needs to be trained and retrained regularly

Security Risks

It is kept centrally and can be used by multiple users remotely at the same time requires to authorize access to data among users to prevent misuse of confidential and important data.

Increased Complexity

It is necessary to understand the requirements of the organization and different kinds of users to design and implement an efficient database.

Need for Explicit Backup and Recovery

the entire database is maintained centrally, it is must to provide efficient backup and recovery facilities.

all these drawbacks, it becomes quite essential to decide whether to use a database system or to use a file-oriented system.

It is desirable not to use database systems if the – database is simple & well-defined, need not change frequently, and concurrent access among multiple users is not required.

Google FAQ

Q. 1) What is meant by DBMS?

Ans. DBMS is the data base management system helps to arrange website data onto the database server by performing various SQL (Structured Query Language) operations.

Q. 2) What are the features of DBMS?

Ans. You can see the DBMS features listed in given below.
(1) Minimal Data Redundancy
(2) Improved Data Consistency
(3) Efficient Data Access
(4) Improved Data Sharing
(5) Improved Data Integrity
(6) Guaranteed Atomicity
(7) Improved Security

Q. 3) What is the purpose of a DBMS Quizlet?

Ans. the purpose of DBMS is to store user performance in database such as user is allowed to search, sign up, edit, comment, etc.

Share This Article

12 thoughts on “A DBMS Makes The : Collection Of Data Set Of Program”

  1. I’m extremely impressed with your writing skills and also with the layout on your blog.
    Is this a paid theme or did you customize it yourself?
    Anyway keep up the excellent quality writing, it is rare to see a nice blog like this one these
    days.

    Reply
  2. I got this site from my friend who shared with me concerning this
    website and now this time I am browsing this web site
    and reading very informative articles here.

    Reply
  3. Hello, I think your blog might be having browser compatibility issues.
    When I look at your blog site in Chrome, it looks fine but when opening in Internet Explorer, it has
    some overlapping. I just wanted to give you a quick heads up!
    Other then that, wonderful blog!

    Reply
  4. Woah! I’m really enjoying the template/theme of this site.
    It’s simple, yet effective. A lot of times it’s touch
    to get that “perfect balance” between user friendliness and appearance.
    I must say that you’ve done a excellent job
    with this. In addition, the blog loads extremely quick for me on Safari.
    Excellent Blog!

    Reply
  5. This is veery interesting, You aare a very skilled blogger.

    I have joined your rss feed and look forward to iin quest of extra of youjr great post.
    Additionally, I have shared your site in my social networks

    Reply
  6. My developer is trying to convince me to move to .net from PHP.
    I have always disliked the idea because of the costs.
    But he’s tryiong none the less. I’ve been using WordPress on various websites for
    about a year and am nervous about switching to another platform.

    I have heard fantastic things about blogengine.net.
    Is there a way I can import all my wordpress content into it?
    Any help would be really appreciated!

    Reply
  7. I used to be recommended this website by way of my cousin. I am now not
    positive whether or not this post is written via him as
    no one else recognize such exact about my trouble.
    You are amazing! Thank you!

    Reply
  8. You ought to take part in a contest for one of the greatest blogs on the web. Im going to highly recommend this site!

    Reply
  9. Itís hard to come by educated people in this particular subject, but you seem like you know what youíre talking about! Thanks

    Reply

Leave a Comment