The Gateway to Computer Science Excellence

BCNF doubt [closed]

0 votes
31 views
If a relation R is 3 NF and atmost one compound candidate key [remaining candidate keys are simple ]

then R is :-

A:-also in BCNF

B:-not BCNF

C:-may not BCNF

D:-none
closed with the note: no more inputs needed
in Databases by Active (1.7k points)
closed by | 31 views
0
0

what does Y-X mean there ?

does it mean set difference  of X & Y ?

Also can you please tell what is simple candidate key and compound candidate key?

0

does it mean set difference  of X & Y ?

yes.

 

what is simple candidate key and compound candidate key

simple candidate key means, the key have only one attribute

compound candidate key means, the key have more than one attribute

if AB combinely forms the key then it is compound candidate key

 

read my answer, it will clear your doubts

0
thanks a lot for the explanation..

Related questions

0 votes
2 answers
1
asked Jul 2, 2018 in Databases by mehul vaidya Active (4.9k points) | 59 views
Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
50,647 questions
56,459 answers
195,377 comments
100,270 users