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
Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool
What are different types of data models available? Explain with example?
Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?
What is ole db in ssis?
How do I manually create a database?
What advantages does DBMS have over traditional file systems?
What are the most common databases?
What is the advantage of varchar2 over char?
Is it good to store images in database?
What is difference between server and database?
List various types of log-based recovery in DBMS.
Explain the table term used in database.
Explain normalization in one line?
Explain database partitioning. What is its importance?
How many types of locks are present in a database?