edited by
3,123 views
5 votes
5 votes

In relational databases, if relation R is in BCNF, then which of the following is true about relation R?

  1. R is in 4NF
  2. R is not in 1NF
  3. R is in 2NF and not in 3NF
  4. R is in 2NF and 3NF
edited by

5 Answers

Best answer
8 votes
8 votes

 

$\therefore$ Option $4.$ is correct.

edited by
1 votes
1 votes
A relation is  in 'N' Normal Form it means it must be in 1NF,2NF,......N-1 NF.

Standard Normal Form Hiearchy

1NF - > 2NF - > 3NF - > BCNF

So Realtion is in BCNF then it must be in 1NF,2NF & 3NF Hence Opton 4 is correct.
edited by
Answer:

Related questions

3 votes
3 votes
2 answers
2
Arjun asked Jul 2, 2019
4,089 views
Which of the following features is supported in the rational database model?Complex data-typesMultivalued attributesAssociations with multiplicitiesGeneralization relatio...
3 votes
3 votes
3 answers
3
Arjun asked Jul 2, 2019
2,970 views
With respect to relational algebra, which of the following operations are included from mathematical set theory?JoinIntersectionCartisian productProjecti and ivii and iii...
1 votes
1 votes
2 answers
4
Arjun asked Jul 2, 2019
3,506 views
Which of the following key constraints is required for functioning of foreign key in the context relational databases?Unique keyPrimary keyCandidate keyCheck key