1NF Database Normalisation

What does 1NF stand for in the context of database design?

• First Normal Form.

• First Numeric Form.

• First Nominal Form.

• First Notation Form.

Which of the following is a requirement for a table to be in 1NF?

• The table must have a primary key in the first and last column.

• The table must have foreign keys.

• The table must not have any repeating groups or arrays.

• The table must be indexed.

In 1NF, each column in a table must contain atomic values. What does "atomic" mean in this context?

• Each value is a single, indivisible unit.

• Each value is a string.

• Each value is a number.

• Each value is a date.

Which of the following is NOT a characteristic of a table in 1NF?

• Each column must have a unique name.

• Each column must contain only one type of data.

• Each row must be unique.

• Each table must have a composite key.

Why is it important for a database table to be in 1NF?

• To ensure data redundancy.

• To simplify data retrieval and manipulation.

• To allow for multiple data types in a single column.

• To increase the complexity of the database.

Which of the following scenarios violates the 1NF requirements?

• A table with a column containing a list of values.

• A table in a column containing only text.

• A table with a column containing only integers.

• A table in a column containing only dates.

If a table is in 1NF, which of the following statements are true?

• The table can have duplicate rows.

• The table can have repeating groups.

• The table can have multi-valued attributes.

• The table has no repeating groups or arrays.

What is the primary goal of achieving 1NF in a database table?

• To increase the number of columns.

• To allow for complex data types.

• To ensure data integrity and eliminate redundancy.

• To decrease the number of rows.

Which of the following is an example of a table that is NOT in 1NF?

• A table with a column for each attribute.

• A table with a column containing only email addresses.

• A table with a column containing multiple numbers for a single contact.

• A table with a column only postal codes.

How can a table be converted to 1NF if it contains repeating groups?

• By adding more columns.

• By merging columns.

• By splitting the repeating groups into separate rows.

• By deleting the repeating groups.