Informatics Practices
Answer
| 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. |
Related Questions
Why do we need a database?
What is database management system? Why do we need a DBMS?
Explain the difference between data and file.
Suppose all customers of a particular business live in states for which the city name is unique. Given the following description for customer data:
CUST-ID, CUST-NAME, STREET, CITY, STATE, PHONE
(i) List the most likely key for the primary key.
(ii) List all the candidate keys and alternate keys.