What is true about Join Dependency?

3. What is true about Join Dependency?

  1. An extension of Multivalued Dependencies is Join Decomposition.
  2. It is possible to call the join of R1 and R2 over C a join dependency (JD) if they are equal to relation R.
  3. Alternatively, R1 and R2 can be written as lossless decompositions of R.
  4. All of the above

Answer: D) All of the above

Explanation:

In case of Join Dependency -

  1. An extension of Multivalued Dependencies is Join Decomposition.
  2. It is possible to call the join of R1 and R2 over C a join dependency (JD) if they are equal to relation R.
  3. Alternatively, R1 and R2 can be written as lossless decompositions of R.

Comments and Discussions!





Languages: » C » C++ » C++ STL » Java » Data Structure » C#.Net » Android » Kotlin » SQL
Web Technologies: » PHP » Python » JavaScript » CSS » Ajax » Node.js » Web programming/HTML
Solved programs: » C » C++ » DS » Java » C#
Aptitude que. & ans.: » C » C++ » Java » DBMS
Interview que. & ans.: » C » Embedded C » Java » SEO » HR
CS Subjects: » CS Basics » O.S. » Networks » DBMS » Embedded Systems » Cloud Computing
» Machine learning » CS Organizations » Linux » DOS
More: » Articles » Puzzles » News/Updates

© https://www.includehelp.com some rights reserved.