Question Details

Which of the following is may not dependency preserving decomposition?

Options

A

1NF

B

2NF

C

3NF

D

BCNF

Show Answer
Correct Answer
D BCNF

Solution :

The correct option is BCNF.

In database management systems, normalization is the process of organizing data in a database to avoid data redundancy and dependency issues. When we decompose a relation schema R into multiple relations R1,R2,...,Rn, we want to ensure two key properties:
1. Lossless Join Decomposition: To guarantee that joining the decomposed relations retrieves the original relation exactly without introducing any spurious tuples.
2. Dependency Preservation: To ensure that all functional dependencies that hold on the original relation R can be checked and enforced by looking at individual decomposed relations, without having to join them back together.

Let's analyze the dependency preservation capability for the standard normal forms:
- First Normal Form (1NF), Second Normal Form (2NF), and Third Normal Form (3NF): It is always possible to find a decomposition into 3NF (and subsequently 1NF and 2NF) that is both lossless and dependency-preserving.
- Boyce-Codd Normal Form (BCNF): BCNF is a stronger form of 3NF. While we can always decompose any relation into BCNF such that the decomposition is lossless, it is not always possible to guarantee that the decomposition will be dependency-preserving. There are cases where we must choose between achieving BCNF and preserving all functional dependencies.

For example, consider a relation schema R(A,B,C) with the functional dependencies:
AB→C
C→A
Here, the candidate keys are AB and BC. The dependency C→A violates BCNF because C is not a superkey. If we decompose R to satisfy BCNF, we get R1(C,A) and R2(C,B). Under this decomposition, the functional dependency AB→C is lost because its attributes are split across different relations and cannot be checked within a single relation. Thus, BCNF decomposition may not be dependency-preserving.

Transparent Access on Mindyard

Built for Learners & Educators Alike

Completely free for students. Educators & coaching institutes get 2 months free Pro trial to create tests.

FREE FOR STUDENTS

Practice & Learn Free for Students

Access unlimited practice questions, detailed step-by-step solutions, and exam study materials — completely free for students.

  • Unlimited mock tests & question bank practice
  • Full access to curated study library & formula notes
  • 100% free for students • No credit card required
2 MONTHS FREE TRIAL

Educators & Coaching Institutes

Create and conduct professional online assessments with AI question generation, tab proctoring, and comprehensive batch management.

  • AI question uploader & rapid test generator
  • Anti-cheating tab proctoring & performance reports
  • Full Pro access free for 60 days • No upfront commitment
Discover more resources

You may also like

Mock Tests

View All
  • SSC
  • intermediate
  • 1 hour
  • english, general awareness, general intelligence and reasoning, logical reasoning, quant

SSC CHSL Tier-1 Shift 1 2 July 2024 question paper with answers and detailed solutions. This practice paper covers questions from General Intelligence & Reasoning, General Awareness, Quantitative Aptitude, and English Language as asked in the SSC CHSL Tier-1 examination. Practice the SSC CHSL 2 July 2024 Shift 1 paper to understand the exam pattern, question types, difficulty level, and important topics for upcoming SSC CHSL exams.

  • SSC
  • intermediate
  • 1 hour
  • english, general awareness, general intelligence and reasoning, logical reasoning, quant

SSC CHSL Tier-1 Shift 2 held on 2 July 2024 question paper with answers and detailed solutions. This previous year paper covers General Intelligence & Reasoning, Quantitative Aptitude, General Awareness, and English Language. The SSC CHSL Tier-1 exam was conducted in CBT mode with 100 questions for 200 marks and a 60-minute duration.

Ask AI Tutor
5 left
Q1 View Question & Options
AI Tutor is solving this question...
Reading question context & options...
Ask your own doubt or choose a quick prompt: