Multivalued Dependencies - DBMS

1.

In which of the following , a separate schema is created consisting of that attribute and the primary key of the entity set.

   A.) A many-to-many relationship set
   B.) A multivalued attribute of an entity set
   C.) A one-to-many relationship set
   D.) Both a and b

Answer: Option 'B'

A multivalued attribute of an entity set

2.

The main task carried out in the __________ is to remove repeating attributes to separate tables.

   A.) First Normal Form
   B.) Second Normal Form
   C.) Third Normal Form
   D.) Fourth Normal Form

Answer: Option 'A'

First Normal Form

3.

Which forms has a relation that possesses data about an individual entity?

   A.) 2NF
   B.) 3NF
   C.) 4NF
   D.) 5NF

Answer: Option 'C'

4NF

4.

Which of the normal form is based on multivalued dependencies ?

   A.) Fourth
   B.) Third
   C.) Second
   D.) First

Answer: Option 'A'

Fourth

5.

If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources.

   A.) A many-to-many relationship set
   B.) A multivalued attribute of an entity set
   C.) A one-to-many relationship set
   D.) Both a and b

Answer: Option 'D'

Both a and b

Multivalued Dependencies Download Pdf