Question

Summarise the major difference between a relation and a traditional file?
​

Answer 1

$\huge\purple{Answer:-}$

1. Files act locally where as DBMS saves directly in a database

2. Saves in temporary locations where as DBMS in well arranged and permanent data base locations

3. In File System., transactions are not possible where as various transactions like insert, delete, view, updating etc are possible in DBMS

4. Data will be accessed through single or various files where as in DBMS, tables (schema) is used to access data.

5. A "File manager" is used to store all relationships in directories in File Systems where as a data base manager (administrator) stores the relationship in form of structural tables

6. Last.... but not the least.... Data in data bases are more secure compared to data in files.