Question 7(i)Explain the difference between database and file.

Question

Accepted Answer

DatabaseFileDatabase 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.

Database	File
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.

Review of Database Concepts & SQL — Question 7

Question 7(i)