edited by
3,132 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

0 votes
0 votes
option D as the BCNF is stricter than 1NF,2NF,3NF. Hence a relation in BCNF,then it is also in 1NF,2NF,3NF.
Answer:

Related questions

3 votes
3 votes
2 answers
6
Arjun asked Jul 2, 2019
4,099 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
7
Arjun asked Jul 2, 2019
2,979 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
8
Arjun asked Jul 2, 2019
3,516 views
Which of the following key constraints is required for functioning of foreign key in the context relational databases?Unique keyPrimary keyCandidate keyCheck key