Tags Database Programming

Animals & Plants Arts & Entertainment Auto Beauty & Health Books and Literature Business Electronics Engineering & Technology Food & Drink History Hobbies Jobs & Education Law & Government Math People & Society Science Social Studies Sports Travel & Places

0

Subjects>Math>Statistics

Is Redundancy in database is a desirable characteristic?

Anonymous

∙ 12y ago

Updated: 9/22/2023

It could be, and could not be at the same time. I'm going to use SQL for an example. Say you have a website, and a user signs up. You would have a users table, first off to store the users information. Then, you would have another table with the actual content that that user has stored. The repeating field would be the USERID.

But, if you have the same data stored twice in two different tables, that's a bad thing.

Wiki User

∙ 12y ago

Still curious? Ask our experts.

Chat with our AI personalities

Rene

Change my mind. I dare you.

Chat with Rene

Vivi

Your ride-or-die bestie who's seen you through every high and low.

Chat with Vivi

Taiga

Every great hero faces trials, and you—yes, YOU—are no exception!

Chat with Taiga

Add your answer:

Earn +20 pts

Q: Is Redundancy in database is a desirable characteristic?

Write your answer...

Submit

Still have questions?

imp

Continue Learning about Statistics

Is Redundancy in databases a desirable characteristic?

yes

What does Data Redundancy mean in database design?

In database there are number of issues to be handled ,like redundant data, inconsistent data, unorganized data etc. Redundancy of data is the repetitive data that is taking the storage unnecessarily . So the redundant data must be removed or at least reduced.

Is data redundancy leads to data inconsistency?

yes. data redundancy is where there is duplication of data in a database. when this happens, anyone who has to make updates to a table in a database (that is, make changes to the database) will have to change that particular data that has been duplicated so many times in so many places. this creates a problem and it is not always going to be possible for a person to change everything correctly. this therefore leads to inconsistencies in the database. hope this helps.

What are the strength of the database?

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

What is the more common name for attribute?

In a database management system (DBMS), an attribute may describe a component of the database, such as a table or a field, or may be used itself as another term for a field. Commonly we can say that an attribute is a "propety" of a database field or its a characteristic or facet of the data field..

Trending Questions

What is structured-response variety for multiple choice type of test? Is statistic a measure that describes a population characteristic? What do NaN means in the stock market? Is standard deviation always smaller than mean? What is one way Anova used to test? How do you do modal interval in maths? What is the probability of getting a even number and a head when rolling a die and then tossing a coin? Which measure of central location is found by arranging the data from smallest to largest and selecting the middle value? What is theoretical assertion? How many cards are not diamonds in a deck of 52 cards? What is the probability of impossible event is? What is the spread period for STD? What are the odds against drawing a 6 of clubs from a deck of cards? How many pounds are in 2500 mg? What percentage of freemartin cattle will breed? What is the difference between population and sample distribution? If you have a standard deck of 52 playing cards with 4 suits If two cards are drawn without replacement what is the chance of selecting two queens? How many 5 digit combinations are there for the numbers 1 through 59? Can a coin land an its side? What is an outlier in 98 85 34 79 85 92?

Related Questions

Is Redundancy in databases a desirable characteristic?

yes

What is replication in database?

it is the process of finding the redundancy.

Can data redundancy be completely eliminated when database approach is used?

Database is collection of some inter related records . And yes, data redundancy be completely eliminated when database approach is used.

When working with a database it is important to?

Avoid redundancy, for instance.

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.

Describe database normalization?

Database Normalization is the process of organizing the fields and tables of a relational database to minimize redundancy and dependency

Does redundancy make updating a database less difficult?

this is true!

What is the repetition of data in a database called?

its called data redundancy.

What is Controlled redundancy in a database?

In non-database systems each application has its own private files. This can often lead to redundancy in stored data, with resultant waste in storage space. In a database the data is integrated. The database may be thought of as a unification of several otherwise distinct data files, with any redundancy among those files partially or wholly eliminated. Data integration is generally regarded as an important characteristic of a database. The avoidance of redundancy should be an aim, however, the vigour with which this aim should be pursued is open to question. Redundancy is * direct if a value is a copy of another * indirect if the value can be derived from other values: ** simplifies retrieval but complicates update ** conversely integration makes retrieval slow and updates easier * Data redundancy can lead to inconsistency in the database unless controlled. * the system should be aware of any data duplication - the system is responsible for ensuring updates are carried out correctly. * a DB with uncontrolled redundancy can be in an inconsistent state - it can supply incorrect or conflicting information * a given fact represented by a single entry cannot result in inconsistency - few systems are capable of propagating updates i.e. most systems do not support controlled redundancy.

What were the shortcomings of early file-oriented database structures?

data redundancy

What are the characteristics of database?

chandranana explain the characteristic of database?

What are to advantages of a database?

A database is a collection of interrelated data and the advantages of a database are ensured efficiency, standardized data, maintainable data, integrated data, reduced redundancy of data.

Still have questions?

imp

Resources

Top Categories

Product

Company

Copyright ©2025 Infospace Holdings LLC, A System1 Company. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Answers.