Database - The Relational Model and Normalization - Discussion

Discussion Forum : The Relational Model and Normalization - General Questions (Q.No. 20)

The Relational Model and Normalization

20.

One solution to the multivalued dependency constraint problem is to:

split the relation into two relations, each with a single theme.

change the theme.

create a new theme.

add a composite key.

Answer: Option

Explanation:

No answer description is available. Let's discuss.

Discussion:

7 comments Page 1 of 1.

Jie Li said: 6 years ago

I guess it should be A, it is part of 2nf in normalization.

Aka said: 7 years ago

What is a theme in DBMS?

Ngula said: 8 years ago

Split because its full constraint avoids anomalies.

Roja iza said: 9 years ago

A multivalued dependency is a full constraint between two sets of attributes in a relation.

Lily said: 9 years ago

What is theme in relation ?

Mouli said: 1 decade ago

What is the meaning of theme ?

Rahul said: 1 decade ago

Why I m not understanding.

Post your comments here:

Quick links

Quantitative Aptitude

Verbal (English)

Reasoning

Programming

Interview

Placement Papers