COMPUTER SCIENCE AND ENGINEERING
DATABASE MANAGEMENT SYSTEM
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following is false?
|
Normalization follows relational database creation rules to design a relational database that is free from delete, insert, and update anomalies.
|
|
Update anomaly occurs when improper database organization where a non-primary key item is stored multiple times; updating the item in one location and not the others causes data inconsistencies.
|
|
Insert anomaly occurs when improper database organization that results in the inability to add records to a database.
|
|
Delete anomaly occurs when improper organization of a database that results in the loss of all information about an entity when a row is deleted.
|
|
2NF or second normal form is a state where relational database is free from update, insert and delete anomalies.
|
Explanation:
Detailed explanation-1: -Deletion Anomaly. A deletion anomaly occurs when you delete a record that may contain attributes that shouldn’t be deleted.
Detailed explanation-2: -A delete anomaly is the opposite of an insert anomaly. When a delete anomaly occurs it means that you cannot delete data from the table without having to delete the entire record.
Detailed explanation-3: -Insertion anomaly: The database has been created in such a way that required data cannot be added unless another piece of unavailable data is also added.
There is 1 question to complete.