recategorized by
259 views
0 votes
0 votes

The undesirable multivalued dependency in a relation arises if there exist 

  1. Two one-to-many relationships between attributes of a relation 
  2. One one-to-one and one one-to many one relationships between attributes within a relation
  3. Two one-to-one relationships between attributes of a relation 
  4. One one-to-many relationship between attributes across relation
recategorized by

1 Answer

0 votes
0 votes
A

two i:N relationship A,B and A,C relation mix into same relation R(A,B,C) ................Navathe  page 399

Related questions

441
views
1 answers
0 votes
gatecse asked Aug 4, 2019
441 views
The relational DBMS is constructed on relational principles which are based on The matrix theory Axiomatic principles Primary key Primary & foreign key relationship
336
views
0 answers
2 votes
gatecse asked Aug 4, 2019
336 views
The process of normalization is used toEnhance the number of relations Determine the relationship between different relations Minimize the redundancies & eliminate anomalies Ease the computational work.
265
views
1 answers
0 votes
gatecse asked Aug 4, 2019
265 views
The difference between the structured query language and the programming relationship language is thatStructured query language does not contain answer ... query language uses strict semioticsOnly programming language uses strict semiotics.
251
views
0 answers
0 votes
gatecse asked Aug 4, 2019
251 views
One of the differences between Object-Oriented Paradigm (OOP) and Database Management System (DBMS) is that In DBMS, null values &redundancies are completely ... only null values are minimized In DBMS, only null values are eliminated.