What are the three types of anomalies in database and
Explain?
Answer Posted / irshad ahmad
Anomalies are problems that arise in the data due to a flaw
in the database design. There are three types of anomalies….
*Insertion Anomalies:Insertion anomalies occur when we
try to insert data into a flawed table.
*Deletion Anomalies:- Deletion anomalies occur when we
delete data from a flawed schema.
*Update Anomalies:- Update anomalies occur when we
change data in a flawed schema.
| Is This Answer Correct ? | 146 Yes | 21 No |
Post New Answer View All Answers
What are the various ways to execute a query in teradata?
What is odm database?
How to shrink a database?
What are the advantages of views in a database?
Can a database table exist without a primary key?
What is a reference table in database?
What is the candidate key used for?
What is the concept of Virtual field?
can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?
What is the role of driver manager?
How concurrency problems effect the database?
What is a Transformation?
Give the syntax of exception handling used in DBMS?
Differentiate between unique key and foreign key?
if i want to display the name of students such that to which city they belong must have count greaer than two