0
What is redundancy and inconsistency in data base management system?
Wiki User
∙ 13y ago
Redundancy - Repetative storage of data leading to possible multiple versions and/or ill utilisation of data storage capacity.
Inconsistency - Failure to adhere to standardised storage of data; usage of varying formats, non-confirmation to standardised/defined methods to store similar/related data.
Wiki User
∙ 13y ago
Redundancy in a database occurs when the same piece of data is unnecessarily stored in multiple places, leading to inefficiency and potential data inconsistencies. Inconsistency arises when different copies of the same data do not match due to errors or failure to update all instances simultaneously, impacting data integrity and reliability. Database management systems aim to reduce redundancy and ensure consistency through normalization and transaction processing techniques.
Wiki User
∙ 9y agoRedundancy refers to the repetitive data in the database consuming storage capacity unnecessarily . Also redundant data can cause ambiguity. Inconsistency refers to the inconsistency in the data in terms of standardized methods to store related data.
Add your answer:
Earn +20 pts
What is the fullform of DBMS?
The full form of DBMS is Database Management System.
When was a data base invented?
The first database management system (DBMS), known as the Integrated Data Store, was developed by Charles Bachman in 1963. This marked the beginning of modern database systems.
What is DBMS and when it should not be used?
DBMS stands for Database Management System. It is software that manages and organizes databases, allowing users to store, retrieve, and modify data efficiently. However, there are situations where using a DBMS may not be appropriate. For example, if the amount of data to be stored is small, or if the data needs to be accessed and manipulated in a simple and straightforward manner, using a DBMS might be unnecessary and can add unnecessary complexity and overhead to the system.
What is the difference between DBMS and conventional file system?
A Database Management System (DBMS) is a software that allows for efficient organization, storage, and retrieval of data in a structured manner. It provides features like data integrity, security, and concurrency control. In contrast, a conventional file system is a basic system for storing and retrieving files in a hierarchical structure, lacking the advanced functionalities of a DBMS.
What is view of data in dbms?
In a database management system (DBMS), a view is a virtual table derived from one or more base tables. It allows users to query or manipulate data without directly accessing the underlying tables, providing a layer of abstraction and security. Views can simplify complex queries, hide sensitive information, and provide a consistent interface to the data.
What is the difference between file base system and data base system?
DBS has more security and data integrity.It reduce data redundancy and updating errors which can occur in FBS.Contains of concurrent data access.But also it's expensive to use and they are also complex.Damage to DB affects virtually all application programs.
What is the fullform of DBMS?
The full form of DBMS is Database Management System.
What is the difference between data base and data base management system?
data base means a collection of data,which may be inter related. data base management system is a collection of programs for managing the data base.
The Data Base Management System makes data management more?
efficient
What dbms stands for?
Data Base Management System
What is DBMS?
DBMS is short for database management system . DBMS is the collection of related records.
What kind of problems are associated with redundancy in databases?
problems associated with redundancy in data base,Redundancy occurs in same data multiple time tends to several problems some times redundancy controlling is necessary to improve the performance of the query.
Is Microsoft OneNote a DBMS?
Yes ,DBMS -data base management system
Who issue funds to the base using automated funds management system?
MAJCOMs
What are the subject topic for rdbms?
RDBMS is all about Relational Data Base Management System...
Difference between expert system and learning content management system?
An expert system is intended to solve specific problem as if it is a human. It uses base of rules (knowledge base) and algorithms to reach a decision or conclusion. It may be built as from-scratch software or using a content management system software/technology. A learning content management system literally means any content management system for learning purposes. If it includes a thinking component (i.e inference engine), then the content represents the knowledge-base, and it may produce step-by-step explanation of how the decision or conclusion is reached. The purpose of such knowledge-base learning content management systems is to support the learning process, rather than to make decisions for real-world problems.
What is DBMS system?
dbms is data base management system .It is combination of the data base & the the softwares to access the data from the database. eg:Poracle 91,dbase; for more reply to rexrer234@gmail.com
