Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 10 of 78

Relational Databases — Question 1

Back to all questions
1
Question

Question 1

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

Answer
Relation fileTraditional 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, PostgreSQLExamples : Text files, CSV files, Excel spreadsheets