Understanding Data Normalisation Concepts

What is the primary goal of data normalisation in databases?

• To increase data redundancy

• To reduce data redundancy

• To enhance data encryption

• To improve data visualisation

Which of the following is a type of normalisation?

• Data Encryption

• First Normal Form (1NF)

• Data Mining

• Data Warehousing

What is a benefit of normalisation in databases?

• Increased data redundancy

• Improved data integrity

• Slower query performance

• Larger database size

Which of the following is NOT a benefit of data normalisation?

• Improved data integrity

• Reduced data redundancy

• Increased data retrieval speed

• Easier maintenance

What is meant by data integrity in the context of databases?

• The ability to store large amounts of data

• The accuracy and consistency of data

• The speed of data retrieval

• The encryption of data

What is a partial dependency in the context of database normalisation?

• A dependency where a non-key attribute depends on part of a composite key

• A dependency where a non-key attribute depends on another non-key attribute

• A dependency where a key attribute depends on a non-key attribute

• A dependency where all attributes depend on the entire primary key

Which of the following is a characteristic of First Normal Form (1NF)?

• No transitive dependencies

• No partial dependencies

• No repeating groups

• No foreign keys

Which of the following is a common issue that normalisation helps to prevent?

• Data encryption

• Data anomalies

• Data visualisation

• Data mining

What is a transitive dependency in the context of database normalisation?

• A dependency where a non-key attribute depends on another non-key attribute

• A dependency where a key attribute depends on a non-key attribute

• A dependency where all attributes depend on the entire primary key

• A dependency where a non-key attribute depends on part of a composite key

Which of the following is a direct result of achieving higher normal forms in a database?

• Increased data redundancy

• Improved data integrity

• Decreased data accuracy

• Increased data anomalies