What is an advantage of a relational database compared to a flat-file database?

Question

BlackTom AI · Accepted Answer

Relational databases use multiple related tables and normalization to reduce redundancy, which makes updating data easier than in a flat-file database.

1. Relevant knowledge points and concepts
- Flat-file database: a single table/file storing all records; leads to data redundancy and update anomalies (insertion, deletion, modification).
- Relational database: data is split into tables (entities) with primary keys and foreign keys; normalization removes duplicate data.
- ACID properties, transactions, and indexing in relational systems support consistent, efficient updates.

2. Step-by-step reasoning
- In a flat-file, a repeated piece of information (e.g., a customer’s address) appears in many rows (orders). To change the address you must find and update every row where it appears.
- In a relational design, the address is stored once in a Customer table; Order rows reference the customer via a customer_id. Updating the address requires changing one record in the Customer table.
- Relational databases also provide integrity constraints and transactional updates, so changes are applied consistently and safely.

3. (No numeric calculations required) Intermediate steps shown conceptually:
- Flat-file: update count = number of rows containing duplicated data → many updates.
- Relational: update count = 1 (the single canonical record) → single update; relational DB ensures referential integrity.

4. Why the correct answer is correct
- Because normalization and table relationships remove duplication, updates are simpler, fewer, and less error-prone in relational databases. Built-in transaction support further ensures safe updates.

5. Why the other options are incorrect
- b. “It is harder to update…” — incorrect; the opposite is true due to reduced redundancy and transactions.
- c. “Does not require relationships…” — incorrect; defining relationships (foreign keys) is a fundamental feature of relational databases.
- d. “Always a larger file size…” — incorrect; relational databases can be smaller due to eliminated duplication, and file size depends on design and indexing.

6. Conclusion
- The correct choice is a. It is easier to update data in a relational database. This matches the provided answer.

What is an advantage of a relational database compared to a flat-file database?单项选择题

类似问题

The relational data model organizes data into _____.

In MongoDB, a "Collection" is most analogous to which concept in a relational database like MySQL?

Which category of data is typically stored in rows and columns with a fixed schema?

The main concept of relational databases was published in 1970 by:

A row is the same as a record in a relational database

Question at position 49 Relational databases establish the relationships between entities by means of common fields included in a file called a(n):entity.relation.association.relationship.

Question at position 32 Relational databases establish the relationships between entities by means of common fields included in a file called a(n):association.relationship.entity.relation.

Question at position 29 Unlike columns, the rows of a relation may not be interchanged and must be stored in one sequence. TrueFalse

更多留学生实用工具

智能学习助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单