Question
Which of the following correctly describes the second
normal form (2NF) in database normalization?Solution
A table is in Second Normal Form (2NF) if it is in First Normal Form (1NF) and all non-key attributes are fully functionally dependent on the entire primary key, not just part of it. This eliminates partial dependencies, which occur when a non-key attribute depends on only a part of a composite primary key. Why Other Options Are Incorrect:
- The table contains no duplicate rows: This is a general requirement for any relational database, not specific to 2NF.
- Every determinant is a candidate key: This describes Boyce-Codd Normal Form (BCNF) , a stricter form of 3NF.
- The table is free from transitive dependency: This is achieved in Third Normal Form (3NF) , not 2NF.
- All attributes depend on the primary key: This defines 1NF but does not address partial dependencies, a key focus of 2NF.
What is the range of Pralay, India’s first quasi-ballistic missile?
India’s first dedicated space for writers and artists, “Writers’ Village,” is located in which state?
What does the term ‘Vithoot’ mean in Kerala’s afforestation programme?
How much revenue did Madhya Pradesh’s excise department earn from liquor sales in 2023?
What percentage of gross borrowings is expected to finance the fiscal deficit of Indian states in FY25, according to the NSE report?
Which rocket was successfully launched by Europe after a four-year delay?
Union Minister Dr Jitendra Singh launched two AI-powered weather forecasting systems developed by IMD in collaboration with which two institutions?
What is the total amount currently held in District Mineral Foundations (DMFs) across Aspirational Districts?
Under the NST Rules, 2026, the Chairperson of the National Sports Tribunal shall hold office for a term of five years or till he attains which age, whic...
Who has become India's No. 1 chess player?
