Multiple choice

Which of the following terms in DBMS refers to the replacement of relation schema by two or more relational schemas, all of which contain a subset of the attributes of the relation?

  1. Redundancy

  2. Decomposition

  3. Update anomalies

  4. Normalisation

  5. Functional dependency

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

This term in DBMS refers to the replacement of the relation schema by two or more relational schemas, all of which contain a subset of the attributes of the relation.