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:

8 comments Page 1 of 1.

Rahul said: 1 decade ago

Why I m not understanding.

Mouli said: 1 decade ago

What is the meaning of theme ?

Lily said: 1 decade ago

What is theme in relation ?

Roja iza said: 1 decade ago

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

Ngula said: 10 years ago

Split because its full constraint avoids anomalies.

Aka said: 9 years ago

What is a theme in DBMS?

Jie Li said: 9 years ago

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

Jumanne hamis kapungu said: 2 years ago

Anyone, please explain this in detail.

Post your comments here:

Quick links

Quantitative Aptitude

Verbal (English)

Reasoning

Programming

Interview

Placement Papers