Computer Science
Summarize the major differences between a relation and a traditional file.
Answer
| 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 |
Related Questions
Assertion. The foreign-keys of tables are used to establish relationships with other tables and must be handled carefully.
Reason. Referential integrity is a system of rules that a DBMS uses to ensure that the relationships between tables remain valid and no accidental change or deletion occurs in the related data.
Assertion. A unique value that identifies each row uniquely is the primary key.
Reason. Only one column can be made the primary key.
Define database.
Define SQL.