Which of the following statements is true? Note that more than one of the statements may be true.
a. Normalization of the relational schema in a database always has the effect of increasing the number of relational schema.
b. Normalization of the relational schema in a database can have the effect of reducing the number of relational schema.
c. Normalization of the relational schema in a database may have the effect of increasing the number of relational schema.
d. Normalization of the relational schema in a database always has the effect of reducing the number of relational schema.
There are many benefits of normalizing a database. Here are some of the key benefits:
So normalization of relation schema in database may increase/decrease the no. Of relationship schema depend upon the normal form and initial schema of database. So i think option (b) and (c) are true.
Get Answers For Free
Most questions answered within 1 hours.