A Level Computer Science OCR Test 2025 – 400 Free Practice Questions to Pass the Exam

Question: 1 / 400

In Second Normal Form (2NF), what must every attribute depend on?

Any attribute in the table

The primary key

In Second Normal Form (2NF), every attribute in a database table must depend on the entire primary key. This means that for a table to be in 2NF, it must be free from partial dependency, where an attribute is dependent on only a part of a composite primary key. Therefore, all non-key attributes must be fully functionally dependent on the whole primary key to satisfy 2NF requirements.

By ensuring that all attributes depend on the primary key, it helps to eliminate redundancy and the potential for anomalies during data manipulation, such as insertion, deletion, or updating of records. This step is essential in database normalization as it promotes the integrity and efficiency of data storage and management. Hence, the correct answer highlights the importance of the primary key in determining the dependencies of other attributes within a table in the context of normalization.

Get further explanation with Examzify DeepDiveBeta

Only the non-key attributes

The relationship with other tables

Next Question

Report this question

Download A Level Computer Science OCR Practice Exam PDF Study Guide
Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy