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
How do database connections work?
Is data lake a database?
Explain entity type?
how can you perform lookup range in lookup stage expalin in detail?
What is database collection?
What is Object Oriented model?
What happens when shared and exclusive locks are applied on data item?
i have windows-xp processor with P4 system. whenever I tried to download foxpro for windows 2.6 on windows XP, my operating system failed to install foxpro for windows 2.6.please. how could i download , install & run foxpro for windows 2.6 easily on windows XP ?
What is database schema name?
give a simple example of physical and logical data independence
Which is the best graph database?
Explain artificial key?
List the properties of a transaction.
Explain data independence & its types.
Explain the table term used in database.