Database Systems: Design, Implemen...

11th Edition
Steven + 8 others
ISBN: 9781285196145



Database Systems: Design, Implemen...

11th Edition
Steven + 8 others
ISBN: 9781285196145
Textbook Problem

What is the role of a DBMS, and what are its advantages? What are its disadvantages?

Program Plan Intro

Database Management System (DBMS):

Database management system is a software system with a collection of programs that are used to maintain and control the database.

  • Its main purpose is constructing the database for the multiple users and applications.
Program Explanation

Role of DBMS:

  • The DBMS creates the security system to decrease the involvement of unauthorized users.
  • It has the ability of creating database structures on storage requirements.
  • It has complex structures which can be accessed by multi-users.
  • It stores the data definitions and meta data in a directory or dictionary and the changes made to that definitions and meta data will be automatically updated in directory or dictionary.
  • It has the ability of performing data backup and recovery which assures the data safety.

Advantages of DBMS:

  • Data Consistency:
    • It represents the usability of data and the data is affected only in allowed ways during the database transaction.
  • Data Independence:
    • Data independence is the ability of accessing the programs which are independent of storage characteristics of data.
    • File systems doesn’t includes the data independence because accessing a file always depends on its data characteristics.
  • Backup and Recovery Procedures:
    • It has the ability of data backup and restore or recovery on requirement.
  • Controlled Data Redundancy:
    • Data redundancy is presence of repeated data in the storage device...

Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Additional Engineering Solutions

Find more solutions based on key concepts

Show solutions add

What is the purpose of CTE or vocational education?

Precision Machining Technology (MindTap Course List)

Your future company has purchased a machine and has entered into a contract that requires the company to pay 20...

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)

Convert 5 megawatts of power into BTU/hr, ft-lbs/s, and kJ/hr.

Fundamentals of Chemical Engineering Thermodynamics (MindTap Course List)