Can Show Me The Example Of Insertion Anomaly, Deleting And Modifying Data?
Please show me the example inserting anomalies ,deleting anomalies and modification anomalies..........
1 Answer - Sort by: Date | Rating
Hi,
Deletion Anomaly example:
A situation, usually caused by redundancy in the schema, in which the deletion of one row of a table results in the deletion of an unintended information.
Insetion Anomaly example:
A situation, usually caused by redundancy in the schema, in which the insertion of a row in a table creates an inconsistency with other rows.
Update/Modifying Anomaly example:
A situation, usually caused by redundancy in the schema, in which an update to one value affects another value. An update anomaly may be a deletion anomaly, an insertion anomaly, or a modification anomaly.
riccardi.pearsoncmg.com
Deletion Anomaly example:
A situation, usually caused by redundancy in the schema, in which the deletion of one row of a table results in the deletion of an unintended information.
Insetion Anomaly example:
A situation, usually caused by redundancy in the schema, in which the insertion of a row in a table creates an inconsistency with other rows.
Update/Modifying Anomaly example:
A situation, usually caused by redundancy in the schema, in which an update to one value affects another value. An update anomaly may be a deletion anomaly, an insertion anomaly, or a modification anomaly.
riccardi.pearsoncmg.com
1
0
- What Are The Accessing Methods?
- How Does A Model Look The Way She Does?
- Define Demerits Of Conventional File System?
- How Candidate Key Is Differ From Concatenated Key?
- Is Relational Model Logically Independent?
- Discuss The Relative Advantage Of Centralized And Distributed Databases?
- What Does Cdr/cdt Transaction Mean?
- How Do Accountants Use Databases?
- What Is The Database Component In Database Application?
- Define The Difference Between Logical And Physical Data Views?
- How Middleware Works Between Client And Server?
- What Is Table,cell,row And Columns In MS Word?
- What Are Some Errors In Using Database?
- An Sql Server Is Not An Operating System... why Are People Always Asking Exam Questions On This Site?
- What Is 4nf?
- What Is Hierarchical Communication?
- Q. How Many Types Of Anomalies Are There In A RDBMS?
- What Is Entity Integrity?
- What Is Integrity Constraints?
- What Is A Referential Anomaly?
- When Did Uganda Get Its Independence?
- Explain Any Two Advantages Of A Database Systems?
- Explain File Management Systems Using File-based Approach?
- Do You Need Any Qualifications To Be A Model?
- Writing Of Data To A Transaction Log Is Which ACID Property?
Featured Question
New Comment - Comments are editable for 5 min.