1 Answer - Sort by: Date | Rating
Logical inconsistencies can occur in tables that are not sufficiently normalized. These inconsistencies are because of various anomalies which involves data operations. This information can be expressed on multiple records and updates can result in logical inconsistencies.
For example a change in employee address will potentially be applied to multiple records. If all the records can not be updated, the table will be left in an inconsistent state. The table will provide conflicting answers to a particular query involving employee address. This condition is known as Update Anomaly.
0
0
- What Are The Advantagem Of Database Management Approach To Organizing?
- Why Does Integrating Flat File Data In A Database Improve Data Integrity?
- What Is Sequential?
- What Do Index Mean?
- How To Remember Stationary And Stationery?
- What Is Program Data Independence?
- Discuss The Concept Of Data Independence And Its Importance In A Database Environment?
- What Are The Various Keys In Sql?
- What Is Database Development?
- What Is External Level?
- What Are The Component Of Database?
- Define 1NF, 2NF, 3NF. Give An Example Of Each?
- What Is CAPTCHA?
- What Are Integrity Rules?
- Is It Possible With A Sequential File Organization To Permit Sequential Scanning Of The Data Based On Several Sorted Orders?
- Is It Possible With A Sequential File Organization To Permit Sequential?
- Where Is The Amethyst Key On Super Secrets?
- What Is The Difference Between Candidate Key And Super Key?
- What Is Centralized Database And Its Architecture?
- What's The Disadvantage Management?
- What Is The Relational Model Terminology?
- What Seeking Independence?
- What Do You Mean By Data Security?
- Problem In SQL Connection To Remote Server?
- What's The Function Of Database Analysts?
Featured Question
New Comment - Comments are editable for 5 min.