Question:
A relation \(R(A,B,C,D)\) with functional dependencies A→B, B→C is in _______ .
A relation \(R(A,B,C,D)\) with functional dependencies A→B, B→C is in _______ .
Show Hint
To bring a relation into 3NF, remove transitive dependencies and ensure that every non-prime attribute is non-transitively dependent on every key.
Updated On: Jun 16, 2025
- 1NF but not 2NF
- 2NF but not 3NF
- 3NF but not BCNF
- BCNF
Hide Solution
Verified By Collegedunia
The Correct Option is B
Solution and Explanation
In this case, the functional dependency A→B and B→C violates 3NF because B is a non-prime attribute determining another non-prime attribute (C). The relation satisfies 2NF but not 3NF.
Was this answer helpful?
0
0
Top Questions on Database Management Systems
- In SQL, which clause is used to filter the results of an aggregate function?
- CUET (PG) - 2026
- Data Science
- Database Management Systems
- Define the term data independence. What are the different levels of data independence?
- Kerala Plus Two(Class 12) - 2026
- Computer Science
- Database Management Systems
- Describe the use of built-in MySQL functions like COUNT(), SUM(), and MAX().
- PSEB XII - 2026
- Computer Applications
- Database Management Systems
- Explain the concepts of Primary Key, Foreign Key, and Candidate Key.
- PSEB XII - 2026
- Computer Applications
- Database Management Systems
- Write the syntax and use of SQL DDL commands (CREATE, ALTER, DROP) and DML commands (INSERT, UPDATE, DELETE).
- PSEB XII - 2026
- Computer Applications
- Database Management Systems
View More Questions
Questions Asked in AP PGECET exam
- The absolute humidity of air at 101.325 kPa is measured to be 0.02 kg of water per kg of dry air. Then the partial pressure of water vapour in the air is:
- AP PGECET - 2025
- Thermodynamics
- If the vapour pressure at two temperatures of a solid phase in equilibrium with its liquid phase is known, then the latent heat of fusion can be calculated by the:
- AP PGECET - 2025
- Thermodynamics
- 1 mole of Argon gas is heated at constant pressure from 200 K to 600 K.
If \( C_p = 4\ \text{cal} \cdot \text{deg}^{-1} \cdot \text{mol}^{-1} \), then the change in entropy will be:
(Given \( \ln 3 = 1.09 \))
- AP PGECET - 2025
- Thermodynamics
- The minimum amount of work required to operate a refrigerator which removes 1000 Cal heat at $0^\circ$C and rejects at $50^\circ$C will be:
- AP PGECET - 2025
- Thermodynamics
- The entropy of single crystalline Silicon at absolute zero will be:
- AP PGECET - 2025
- Thermodynamics
View More Questions