Question 21Summarize the major differences between a relation and a traditional file.

Question

Accepted Answer

Relation fileTraditional fileData organized in tables with rows and columns.Data stored in unstructured formats.Supports structured querying with SQL.Lacks standardized querying abilities.Allows for defining relationships between tables.No inherent support for relationships.Offers flexibility in data storage and retrieval.Limited flexibility in data organization.Examples : MySQL, PostgreSQLExamples : Text files, CSV files, Excel spreadsheets

Relation file	Traditional file
Data organized in tables with rows and columns.	Data stored in unstructured formats.
Supports structured querying with SQL.	Lacks standardized querying abilities.
Allows for defining relationships between tables.	No inherent support for relationships.
Offers flexibility in data storage and retrieval.	Limited flexibility in data organization.
Examples : MySQL, PostgreSQL	Examples : Text files, CSV files, Excel spreadsheets

Database Concepts — Question 32

Question 21