KnowledgeBoat Logo

Informatics Practices

Explain the difference between database and file.

Relational Database

1 Like

Answer

DatabaseFile
Database is an organized collection of interpreted data that serves many applications.A file is a collection of unorganized data stored in a single location.
Data retrieval is fast and efficient, as databases use indexing and querying mechanisms.Data retrieval is slow and inefficient, as the entire file needs to be searched.
Data sharing is easy, as multiple users and applications can access the database simultaneously.Data sharing is limited, as files are typically accessed by a single user or application.
Data integrity is ensured through constraints, triggers, and transactions.Data integrity is not ensured, as data can be corrupted or lost easily.
Databases support relationships between data entities.Files do not support relationships between data entities.

Answered By

3 Likes

Related Questions