The Gateway to Computer Science Excellence

0 votes

0

@Saurabh Read the article. If you get something different then let me know. If its correct then mark it as best answer:P :P

0

becoz it does not follow the constraint or properties of multivalued dependency (x-->-->y)...

which is , if 2 tuples t1 and t2 exist in r relation such that t1(x)= t2(x) then 2 tuples t3 and t4 should also exist in r with

1) t3(x)=t4(x) =t2(x)=t1(x)

2)t3(y)= t1(y) and t4(y)=t2(y)

3) t3(z)=t2(z) and t4(z)=t1(z)

now in following question for x= d3 there is only 2 tuple say t1 and t2 , there should be t3 and t4 but not exist here thats why last tuples does not follow the properties .

which is , if 2 tuples t1 and t2 exist in r relation such that t1(x)= t2(x) then 2 tuples t3 and t4 should also exist in r with

1) t3(x)=t4(x) =t2(x)=t1(x)

2)t3(y)= t1(y) and t4(y)=t2(y)

3) t3(z)=t2(z) and t4(z)=t1(z)

now in following question for x= d3 there is only 2 tuple say t1 and t2 , there should be t3 and t4 but not exist here thats why last tuples does not follow the properties .

- All categories
- General Aptitude 1.9k
- Engineering Mathematics 7.5k
- Digital Logic 2.9k
- Programming and DS 4.9k
- Algorithms 4.4k
- Theory of Computation 6.2k
- Compiler Design 2.1k
- Databases 4.1k
- CO and Architecture 3.4k
- Computer Networks 4.2k
- Non GATE 1.4k
- Others 1.4k
- Admissions 595
- Exam Queries 573
- Tier 1 Placement Questions 23
- Job Queries 72
- Projects 18

50,741 questions

57,251 answers

198,057 comments

104,685 users