Page 445 - Computer_Science_F5

Computer Science Materials: Physical files (such as
student records, attendance sheets);
access to the school’s database system;
and access to a file-based system
FOR ONLINE READING ONLY
Instructions:
1. Physical files:
(a) Observe how physical files are
organised and stored.
(b) Note the ease of access and
retrieval of information.
(c) Identify any potential issues,
such as misplacement or
damage.
2. Database system:
(a) Explore the school’s database
system, focusing on its
structure and organisation.
(b) Examine how efficiently
data is stored, retrieved, and
managed.
(c) Highlight key features such
as search functionality,
data integrity, and security
measures.
3. File-based system:
(a) Investigate the structure and
organisation of a file-based
system used in the school.
(b) Note the limitations and
challenges, such as data
redundancy, consistency, and
security issues.
436
Computer Science Form 5.indd 436
Deliverables
Write a brief report comprising of the
following:
(a) Summary of your observations
method.
and key findings for each storage
(b) Comparison of the pros and cons
of physical files, database systems,
and file-based systems.
(c) Real-world applications and
examples where each system might
be most effective.
Finally, document your findings and
compiled report in a portifolio.
Exercise 8.1
1. Why is immediate and accurate
data updating crucial for complex
databases like government
payment systems and social media
platforms?
2. How does concurrency differ
between file-based systems and
DBMS, and why is it important?
3. Explain how data redundancy and
inconsistency can be a problem in
a file-based system compared to a
DBMS. Provide examples.
4. How does a DBMS handle
concurrent access to data, and
why is this important? Contrast
this with the concurrency control
mechanisms in a file-based system.
5. Explain how a DBMS reduces
data redundancy and inconsistency
compared to file-based systems,
citing real-world examples.
for Advanced Secondary Schools
23/07/2024 12:34