4
AssignmentMultiple Select

Database Software Basics

Question 4 • VA-Information Technology Fundamentals B

What are advantages of using a relational database instead of a flat file? Check all that apply.

Answer
A
data stored in a tabular format
B
reports generated from specific fields
C
data easier to sort, filter, and summarize
D
data stored in columns and rows
E
easier to draw comparisons from data
F
easier to set up
G
reduced likelihood of storing duplicate data

Explanation

A relational database links related tables, so you can select specific fields to generate reports and more easily sort, filter, summarize, and compare information. Its structure can also reduce duplicate data by storing a piece of information once and connecting it to related records. A flat file can also store data in rows and columns, so tabular format alone is not an advantage of relational databases; relational databases are not generally easier to set up, either.

AI-written and checked against the verified answer.