Questions and answers

What are the advantages of database management system?

What are the advantages of database management system?

Advantages of Database Management System

  • Better Data Transferring:
  • Better Data Security:
  • Better data integration:
  • Minimized Data Inconsistency:
  • Faster data Access:
  • Better decision making:
  • Increased end-user productivity:
  • Simple:

What are the advantages and disadvantages of centralization and decentralization?

Advantages and Disadvantages of Decentralization – Explained

  • Reduces Burden of Top Executives: Centralization over burdens top executives.
  • Quick and Better Decisions:
  • Facilitates Diversification:
  • Use of Capabilities of Subordinates:
  • 5. Development of Executives:
  • Motivates Subordinates:
  • Reduces Burden of Communication:

What are the problems of centralized database management systems?


  • Centralized databases are highly dependent on network connectivity.
  • Bottlenecks can occur as a result of high traffic.
  • Limited access by more than one person to the same set of data as there is only one copy of it and it is maintained in a single location.

What are the main functions of database management system?

A database management system is a software tool that makes it possible to organize data in a database. It is often referred to by its acronym, DBMS. The functions of a DBMS include concurrency, security, backup and recovery, integrity and data descriptions.

What are the applications of database management system?

Application and Uses of Database Management System (DBMS)

  • Railway Reservation System. Database is required to keep record of ticket booking, train’s departure and arrival status.
  • Library Management System.
  • Banking.
  • Universities and colleges.
  • Credit card transactions.
  • Social Media Sites.
  • Telecommunications.
  • Finance.

What is the importance of centralization?

Centralization lets top managers develop a broad view of operations and exercise tight financial controls. In a highly decentralized organization, decision-making authority is pushed down the organizational hierarchy, giving lower-level personnel more responsibility and power to make and implement decisions.

What centralized system?

Centralized systems are systems that use client/server architecture where one or more client nodes are directly connected to a central server. This is the most commonly used type of system in many organisations where client sends a request to a company server and receives the response.

What are the features of centralized database system?

Advantages of Centralized Database System

  • The integrity of data is increased as the whole database is stored at a single physical location.
  • The data redundancy is controlled in a centralized database.
  • The centralized database is much secure.
  • Data is easily portable because it is stored in the same place.

What are the basic functions of a database?

The ten functions in the DBMS are: data dictionary management, data storage management, data transformation and presentation, security management, access control, backup and recovery management, data integrity management, database access languages and application programming interfaces, database communication …

What is database and its advantages?

Reduced data redundancy. Reduced updating errors and increased consistency. Greater data integrity and independence from applications programs. Improved data access to users through use of host and query languages.