0
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.
Wiki User
∙ 9y ago
Wiki User
∙ 12y agoData redundancy is capturing the same data in multiple tables. Ideally, you should only store a particular data point in one table within a database.
Add your answer:
Earn +20 pts
What does it mean by populating a database?
Putting the data into it.
What does it mean to dedupe something?
Dedupe, or deduplication, means to remove duplicate copies of a certain type of data from a database. It helps clear up the database from usless data.
What does database validation mean?
It means where the computer checks whether the data is correct.
What does the term table mean?
In database, Table refers to a structure which contains rows and columns. Data can be stored in these rows and columns in arranged manner.
What does a sort mean in a database?
Sort refers to the action wherein the data fetched from a database table is ordered as per a specific criteria. The default order of sort is Ascending and the user can do a descending sort by using the keyword DESC after the order by keyword. Ex: select * from employee_details order by employee_num desc If the above statement is executed data will be displayed in descending order of employee numbers.
What is data redundancy and data integrity?
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
What does data redundancy mean?
Data redundancy: Sometime Data redundancy refers to in computer data storage, is a property of some disk arrays which provides fault tolerance, so that all or part of the data stored in the array can be recovered in the case of disk failure. The cost typically associated with providing this feature is a reduction of disk capacity available to the user, since the implementations require either a duplication of the entire data set, or an error-correcting code to be stored on the array.Redundancy is attained when the same data values are stored more than once in a table, or when the same values are stored in more than one table.One of the biggest disadvantages of data redundancy is that it increases the size of the database unnecessarily.
What is ad hoc database?
Ad hoc means basic and database is collection of records. Ad hoc database mean data in the database at a basic level. In adhoc database there must not be complex relations in the tables.Database means collection of data or records and adhoc mean basic. So adhoc data means data in the database at a basic level.
What does database software mean?
database software is a network of data
Data conversion and loading in database?
By data conversion we mean the data is first processed. The data after processing is ready to store in database. And from the database we can retrieve it for our use.
What does it mean by populating a database?
Putting the data into it.
What do you mean by Schema in DBMS?
overall design of the database
How much is the capacity of a printed database?
A database's capacity is determined by its Operating System and how much space it has. I'm not sure what you mean by "printed" database. You could not print a database. Now, you might print the database design via Erwin or some other tool--but that's just printing the architecture--not the data.
What does the term record mean in database?
A record is equivalent to a row in a database, a collection of fields that are associated.
What does logical data type in a database mean?
happy birthday to poo
What does database mean ict?
its organised data and is designed for easy access
What does data entry mean?
It is the process of entering information into a computer database.
