Question

Which of the following is not a requirement of 1st Normal Form?

1) Each column has a distinct attribute name
2) There is a unique attribute for each entity
3) There are no repeating groups
4) There are no partial dependencies
5) These are all requirements of 1st normal form

Answer 1

In 1st Normal Form, distinct attribute names, unique attribute for each entity, no repeating groups, and no partial dependencies are required. Hence, option 5) is correct.

Step-by-step explanation:

In 1st Normal Form, each column must have a distinct attribute name. This means that each attribute in the table should have a unique name, and no two attributes should have the same name. This helps in identifying and accessing specific data in the table.

Additionally, there should be a unique attribute for each entity, meaning that each row in the table should have a unique identifier. This identifier can be a primary key.

Repeating groups are not allowed in 1st Normal Form. A repeating group refers to when multiple values are stored in a single attribute. For example, if a student can have multiple phone numbers stored in a single column, it violates 1st Normal Form.

Partial dependencies are also not allowed in 1st Normal Form. A partial dependency occurs when an attribute is functionally dependent on only a part of the primary key. To be in 1st Normal Form, all attributes should be fully dependent on the primary key.

Therefore, the correct choice is option 5: 'These are all requirements of 1st normal form'.