Worksheets1NF Database Normalisation
Total questions: 10
Worksheet time: 5mins
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.
