0
It Occures When The Same data Dosent Matches Each Other In Various Relations(Tables)
take an exp of this,suppose a publisher request for change his address is stored in a book as well as , if address of publisher is not modified in any of two field than the same publisher will have diff. address into diff. field .This is known as data inconsistency
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
What is meant by data consistency in DBMS?
sdfsfas
What is the meant by anomaly in database?
Data anamaly means same type of data present in database as a duplication.So while updating or modifying the information in the database we gets the problem of data inconsistency to solve this problem we need to remove the duplicated data
What is mvd in dbms?
multivalued data
When data change in multiple list and all list are not updated then it called?
Data inconsistency
How can you justify that a DBMS is better to use than Flat-file database?
A DBMS offers quicker access to the data within the database, particularly with larger datasets. It also makes updates to the data easier.
What is meant by data consistency in DBMS?
sdfsfas
What is the difference between database and file system?
A database is a structured collection of data organized for efficient retrieval, storage, and manipulation, while a file system is a method used by operating systems to store, organize, and access files on a computer. Databases provide features like data integrity, relationships, and query capabilities, whereas file systems primarily focus on storing and managing individual files.
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.
What are three types of dbms?
Three types of DBMS (Database Management Systems) include relational DBMS, object-oriented DBMS, and NoSQL DBMS. Relational DBMS organizes data into tables with rows and columns, object-oriented DBMS stores data as objects and classes, and NoSQL DBMS handles unstructured and semi-structured data with flexible schemas.
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 are the DBMS benefits?
DBMS Benefits 1.Improved strategic use of corporate data 2.Reduced complexity of the organization's information systems environment 3.Reduced data redundancy and inconsistency 4.Enhanced data integrity application-data independence 5.Improved security 6.Reduced application development and maintenance cost 7.Improved Flexibility of information systems 8.Increased access and availability of data and information 9.Logical and physical data independence
What are rows in dbms?
In DBMS the data is stored in the form of table . Each row in DBMS is known as tuple.
What is the meant by anomaly in database?
Data anamaly means same type of data present in database as a duplication.So while updating or modifying the information in the database we gets the problem of data inconsistency to solve this problem we need to remove the duplicated data
What is DBMS and what r the features of Dbms?
DBMS stands for data base management system. DBMS is a collection of programs that enables users to create and maintain a database. The DBMS is a general purpose software system used to facilitate the process of defining, constructing and manipulating data bases for various applications. features of DBMS: 1.Data independence 2.Efficient data access 3.Data integrity & security 4.Data administration 5.Reduced application development time
Is Microsoft OneNote a DBMS?
Yes ,DBMS -data base management system
What are the limitations of flat file databases?
• Data duplication• Data inconsistency or update/deletion/insertion anomalies• Data integrity errors (due to data inconsistency)• Inconsistent search results in multi-value fields
What is data inconsistency?
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.
