Database Flashcards
1
Q
Updation anomaly
A
Data inconsistency that occurs when information is changed in one place and not in other. For example, If we have table containing employee name, dept, dept address.
Suppose we wish to change dept add of a dept, in this case we would have to update the address in every record containing the dept. This is a bad databse design
Instead we can decompose the table into 2 smaller table that would contain employee and dept and the other table containing dept and it’s address
2
Q
Deletion anomaly
A
A deletion anomaly occurs when deleting a record from a database unintentionally removes other data.
