1,094 views
1 votes
1 votes

Consider the following relational schemes: R(A, B, C, D, E, F) and S(A, B, C) with in the following functional dependencies:

I. AB --> C

II. C --> ABDE

III. ADE --> F

Assume {A,B} is the key for both schemes. Which of the following statements is true?

 

  1. R is in 2NF and S is in 3NF
  1. Both R and S are in 3NF only
  1. Both R and S are in 2NF only
  1. Both R and S are in BCNF
     

For relation R: Is it not 1NF. Since for it to be in 2NF it should not be having partial PA → NPA, which it is havin in ADE → F. Given that AB form the PA. (So R is in 1NF)

For relation S: only AB→ C is the relation for the S table, which satisfies BCNF properties. (So S is in BCNF)

Please let me know if it is correct or not.

 

2 Answers

2 votes
2 votes

Option 1 Is correct 

R is in 2NF and S is in 3NF

Because:

for the Relation R 

I. AB --> C

II. C --> ABDE

III. ADE --> F

out of these 3 FD's 2nd one is giving (Non-Key->Non-key) so it is not in 3NF , but there are no partial dependencies, you might be confused in 3rd FD(but it not  partial FD).

Regarding Relation S,

It is in BCNF means it is also in 3nf right.

So option 1 is more appropriate than 3rd because it is saying ONLY.

0 votes
0 votes
Its simple:

here AB is candidate key.

for R it is not in BCNF AND 3NF for sure.

to check for 2NF, we are not able to find any partial dependency, hence according to the definition of 2NF, if there is no partial dependency then R is in 2NF.

Also for ADE->F, there is no partial dependency(means not any part of candidate key is pointing to non primary attribute). ADE will be treated as one single variable. EX- A->F is partial as A is part  of candidate key AB but not ADE->F as ADE  whole is not part of candidate key AB

Also S is in BCNF

to check AB->C , here AB is super key hence BCNF

Related questions

1 votes
1 votes
1 answer
1
srestha asked Apr 11, 2018
1,530 views
$AB\rightarrow CD$$CD\rightarrow AB$$A\rightarrow C$Is it in 3NF or BCNF?Is prime attribute - prime attribute dependency is there in BCNF?
0 votes
0 votes
0 answers
2
rahul sharma 5 asked Dec 15, 2017
1,180 views
Minimum relations to decompose into BCNF and 4NF.List only relation names with attributes and total number of relations
2 votes
2 votes
4 answers
4
resilientknight asked Sep 17, 2016
3,698 views
if table r has only one candidate key then which of the following is true:if R is in 3nf,it is also in bcnfR may not be in bcnf