answersLogoWhite

0


Best Answer

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.

User Avatar

Wiki User

9y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

13y ago

If in the database have more then one records of same type then it is called redundancy.

This answer is:
User Avatar

User Avatar

Wiki User

13y ago

if the file system environment makes it difficult to pool data ,it is likely that the same data are stored in many different locations is known as Data Redundancy.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is Data redundancy in DBMS?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Continue Learning about Educational Theory

What is the difference between controlled redundancy and uncontrolled redundancy?

Redundancy is controlled when the dbms ensures that multiple copies of the same data are consistent. If the dbms has no control over this, uncontrolled redundancy.


How is data redundancy reduced?

Data redundancy is removed by reducing the use of using more than one operations for same result.


What is data redundancy?

Storing the information several time leads to waste of storage space is called data redundacy. Data redundancy is a term used about databases and means simply that some data fields appear more than once in the database. Data redundancy is wasteful and inefficient for several reasons and database designers attempt to eliminate it as far as possible by using a technique called data normalization. Data redundancy occurs in database systems which have a field that is repeated in two or more tables. For instance, in case when customer data is duplicated and attached with each product bought then redundancy of data is a known source of inconsistency.


What is data redundancy and which characteristics of the file system can lead to it?

Data redundancy refers to repetitive data in the database. In a system with redundant data it is difficult to manage the relationships. Data redundancy is the result of poorly designed database. By implying proper constraints on the data it can be prevented.


Redundancy control in databases?

Redundancy is the state where duplicate rows of the same data is available in a database. Lets say we have an employee database which contains 2 rows of the following data Emp num Emp Name Age 12345 John 25 12345 John 25 This is data redundancy. Data redundancy can be avoided by the use of keys in tables. If in the employee table we had defined a primary key condition for employee number, then the system would not allow us to enter 2 rows of the same data.

Related questions

How does DBMS reduce data redundancy?

DBMS stands for database management system. DBMS reduce data redundancy as it checks if the data is duplicate and if duplicate then store it as a single record.


What is the difference between controlled redundancy and uncontrolled redundancy?

Redundancy is controlled when the dbms ensures that multiple copies of the same data are consistent. If the dbms has no control over this, uncontrolled redundancy.


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.


What are the characteristics of DBMS?

Database management system is full form of DBMS . Characteristics of a DBMS are following : 1) It maintains data integrity. 2) It reduces redundancy. 3) make access to data easy.


What is de-normalisation in dbms?

Hi, Denormalisation is the process to read the performance by adding redundancy of data or by grouping of data.


DO you have redundancy of records in distributed DBMS?

Redundancy means duplicacy of data or repetitive data. In distributed database case the data is stored in different systems . So the answers is yes there can be redundancy of records / data.In distributed database , data is stored in different systems. Since the data is distributed there is redundancy of records.


What are the advantages DBMS?

-data redundancy:which reduce the redundancy-repetition of data -security-it provides security for various levels -data sharing-it allows multiple users to access and share the data becomes easier in dbms -data concurrency:it allow multiple users to acess the same data simultaniously


Introduction of dbms?

dbms- database management systems............ it is a collection of interrelated data and the set of programs to access those datas....... it is used to meet the disadvantages of the file systems....... there are many disadvantages of filesystems....... lik,, data redundancy and data in consistency, difficulty to access data,integrity problems, atomicity problems............. dbms is quite complicated but better than file systems


What is the characteristics of dbms?

Basic Characteristics of DBMS• Represents complex relationship between data• Controls data redundancy.• Enforces user defined rules.• Ensures data sharing.• It has automatic and intelligent backup and recovery procedures.• It has central dictionary to store information.• Pertaining to data and its manipulation.• It has different interfaces via which user can manipulate the data.• Enforces data access authorization.


Advantages of dbms with example?

There are several advantages of DBMS: 1. Redundancy problem can be solve 2. Security level is high 3. Referential Integrity 4. Multi user Access 5. Data Independence By Sushil Kumar Sinha


How can a primary key be useful in controlling data redundancy?

controlling data redundancy


What does an DBMS do?

DBMS is database management system and it stores data that are related. DBMS maintains data security and integrity as well.