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?

• Flat file storage

• Normalization

• Data encryption

• File indexing

In a relational database, what is a "tuple"?

• A column in a table

• A row in a table

• A relationship between tables

• A database schema

What does an Entity-Relationship (E-R) diagram primarily represent?

• The physical layout of a database

• The relationships between data entities

• The user interface of a database application

• The security protocols of a database

Which of the following is a characteristic of a table in Third Normal Form (3NF)?

• It contains transitive dependencies.

• It has no repeating groups.

• It has no partial dependencies.

• It has no transitive dependencies.

What is the primary purpose of normalization in database design?

• To increase data redundancy

• To improve data retrieval speed

• To reduce data anomalies

• To enhance data encryption

Which of the following is NOT a component of a relational database model?

• Tables

• Fields

• Nodes

• Relationships

What is the main advantage of using a relational database over a file-based system?

• Easier data encryption

• Better data visualization

• Improved data integrity

• Faster data entry

Which of the following is a valid reason to normalize a database to 3NF?

• To increase the number of tables

• To ensure all non-key attributes are fully functionally dependent on the primary key

• To decrease the number of relationships

• To simplify the database schema

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

• A unique identifier for each record in a table

• A field that can contain duplicate values

• A key that links two tables together

• A key that encrypts data