answersLogoWhite

0

Data inconsistency exists when different and conflicting versions of the

same data appear in different places. Data inconsistency creates

unreliable information, because it will be difficult to determine which

version of the information is correct. (It's difficult to make correct - and

timely - decisions if those decisions are based on conflicting information.)

Data inconsistency is likely to occur when there is data redundancy. Data

redundancy occurs when the data file/database file contains redundant -

unnecessarily duplicated - data. That's why one major goal of good

database design is to eliminate data redundancy.

In the below link you can find more details.

http://opencourseware.kfupm.edu.sa/colleges/cim/acctmis/mis311/files%5CChapter1-Database_Systems_Topic_2_Introducing_Databases.pdf

User Avatar

Wiki User

13y ago

What else can I help you with?

Continue Learning about Engineering

What does access to data with more redundancy mean?

Access to data with more redundancy means that there are multiple copies or backups of the same data stored in different locations or systems. This enhances data reliability and availability, as it reduces the risk of data loss due to hardware failures, corruption, or other issues. Additionally, redundancy allows for quicker recovery times and improved performance in data retrieval, ensuring continuity in operations. In essence, it strengthens data integrity and resilience.


What is the purpose for adding redundancy bit?

The purpose of adding a redundancy bit is to enhance data integrity and error detection in digital communications and storage. By including extra bits, systems can identify and correct errors that may occur during data transmission or processing. This helps ensure that the received or read data matches the original, thereby improving reliability and accuracy in data handling. Redundancy bits are commonly used in various coding schemes, such as parity bits and checksums.


What are the disadvantages of file systems?

1)Limited Security 2)limited Data Sharing 3)Data Redundancy 4)Integrity Problems


What does data integrity mean?

"Data integrity refers to the maintenance of, and the assurance of the accuracy and consistency of, data over its entire life-cycle, and is a critical aspect to the design, implementation and usage of any system which stores, processes, or retrieves data". Source: Wikipedia.


Explain how database designers design and normalize databases?

Database designers create and normalize databases by organizing data into structured formats to minimize redundancy and ensure data integrity. They start by identifying the entities, attributes, and relationships within the data, often using entity-relationship diagrams. Normalization involves applying a series of rules (normal forms) to eliminate duplicate data, reduce dependency, and organize data into tables, ensuring that each piece of information is stored only once. This process enhances the efficiency and consistency of data retrieval and maintenance.

Related Questions

What is the definition of form in database?

it is a process of eliminate data redundancy and improved data integrity, storage efficiency, or scalability.


What are the strength of the database?

Reduced data redundancy, Improved data integrity, Shared data, Easier access, Reduced development time


What is the definition of normal form in database?

it is a process of eliminate data redundancy and improved data integrity, storage efficiency, or scalability.


What is normalization and objective of normalization?

Normalization is the process of organizing data in a database to reduce redundancy and dependency. The objective of normalization is to minimize data redundancy, ensure data integrity, and improve database efficiency by structuring data in a logical and organized manner.


What are five strengths of the database approach?

Reduced data redundancy, Improved data integrity, Shared data, Easier access, Reduced development time


Limitation of data processing system?

Hi, Data redundancy Data Inconsistancy Difficulty in accessing data Data Isolation Integrity problem Atomicity problem security problem


What is Data redundancy in DBMS?

In database we store data however the can be redundant. Redundancy means repetitive data that is taking extra storage space . So to reduce or prevent the storage space we should eliminate redundancy or just reduce it.


What are advantages of dbms approach?

There are number of advantages of DBMS approach , some of them are : Data integrity is maintained, Data accessibility is also easy, The redundancy of data is also reduced.


Why normalizations are important for database development?

Normalisation is process of taking data from a problem and reducing it to a set of relations. Meanwhile ensuring data integrity and eliminating data redundancy.


What is Efficiency of storage redundancy?

Efficiency of storage redundancy refers to the ability of redundant storage systems to efficiently protect data without impacting performance. It involves minimizing the amount of redundant data stored while maintaining data integrity and availability in case of failures. Efficient storage redundancy helps optimize storage resources and reduce the overhead costs associated with redundancy.


What is data redadancy?

Data redundancy refers to the unnecessary duplication of data within a database or data storage system. This can occur when the same piece of information is stored in multiple locations, leading to inefficiencies, increased storage costs, and potential inconsistencies. While some level of redundancy can be useful for backup and recovery purposes, excessive redundancy can complicate data management and hinder performance. Effective database design aims to minimize redundancy while ensuring data integrity and accessibility.


What does access to data with more redundancy mean?

Access to data with more redundancy means that there are multiple copies or backups of the same data stored in different locations or systems. This enhances data reliability and availability, as it reduces the risk of data loss due to hardware failures, corruption, or other issues. Additionally, redundancy allows for quicker recovery times and improved performance in data retrieval, ensuring continuity in operations. In essence, it strengthens data integrity and resilience.