WEEK 4 : Functional Dependency and Normalization Flashcards
1
Q
What is Normalization?
A
A database design technique that begins by examining the relationship between attributes.
2
Q
What is an Anomalies?
A
The irregularities or inconsistencies that occur in a database that disrupt the normal functioning and data integrity.
3
Q
What are the types of anomalies?
A
Insertion, Deletion and Update.
4
Q
What is an Insertion Anomaly?
A
The table structure requires the same data to be entered repeatedly, resulting in data redundancy
4
Q
A
4
Q
What is a Deletion Anomaly?
A
The removal of relevant data that may be lost when data is deleted.
4
Q
A
4
Q
A
