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.
During his visit to Italy in May 2026, PM Narendra Modi was honoured with the Agricola Medal, which is the highest honour of which organisation?
Which new benchmark has the RBI introduced to replace MIBOR?
Who among the following has been honoured with Indian Film Personality of the Year at 53rd IFFI?
Which financial institution's rating forecast for India's GDP growth for FY25 was raised to 7%?
Rearranging the letters "AKBLU", we get the capital of ______
- How many government schools were assessed under ASER 2024?
Which logistics company  has joined ONDC (Open Network for Digital Commerce), enabling Pan India delivery services to over 20,000 pin codes?Â
...What is the theme of the 81st plenary meeting of the International Cotton Advisory Committee (ICAC)?
BimaKavach has received a direct insurance broking licence from the Insurance Regulatory and Development Authority of India (IRDAI), enabling the firm t...
As per Morgan Stanley’s projections in April 2026, what is India’s Current Account Deficit (CAD) expected to be as a percentage of GDP in FY27?