Question 10Summarize 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 organisation.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 organisation.
Examples : MySQL, PostgreSQL	Examples : Text files, CSV files, Excel spreadsheets

Review of Database Concepts & SQL — Question 16

Question 10