Understanding Relational Databases and Normalisation

What is a major limitation of a file-based approach to data storage?

• It allows for too much data redundancy.

• It provides excellent data integrity.

• It supports complex queries efficiently.

• It ensures data consistency across all files.

Which feature of a relational database helps to eliminate data redundancy?

• Data encryption

• Normalization

• Data replication

• Data fragmentation

In a relational database, what is a "primary key"?

• A field that uniquely identifies each record in a table

• A field that allows duplicate values

• A field that is used to store large text data

• A field that is used to store binary data

What is the purpose of normalization in a relational database?

• To increase data redundancy

• To improve data retrieval speed

• To organize data to reduce redundancy and improve integrity

• To encrypt data for security

Which of the following is a characteristic of a table in a relational database?

• It can only have one column.

• It can have multiple rows and columns.

• It cannot have a primary key.

• It must have only text data.

What does 3NF (Third Normal Form) primarily address in database design?

• Elimination of duplicate columns

• Ensuring that all non-key attributes are functionally dependent only on the primary key

• Ensuring that all tables have a primary key

• Ensuring that all data is encrypted

Which of the following is NOT a term associated with a relational database model?

• Field

• Attribute

• Node

• Relation

What is a "foreign key" in a relational database?

• A key that is used to encrypt data

• A key that uniquely identifies a record within its own table

• A key that links two tables together

• A key that is used to store foreign language data

Which of the following is a benefit of using a relational database over a file-based system?

• Increased data redundancy

• Improved data integrity and consistency

• Simplified data encryption

• Faster data entry

What is the result of normalizing a database to 3NF?

• Increased data redundancy

• Reduced data integrity

• Elimination of transitive dependencies

• Increased complexity of queries