Page 492 - Computer_Science_F5
P. 492
Instructions Deliverable
Step 1: Parallel Database Systems A brief report explaining approach to
Setup: Imagine you are managing completing the tasks and challenges
water usage and maintenance tasks faced. Including a simple schema
FOR ONLINE READING ONLY
for the entire country. Divide the related to water usage tracking, Chapter Eight: Databases and Database Management Systems
tasks into smaller sub-tasks (such as, explained with descriptions of how the
tasks were distributed and processed; A
calculating water usage, identifying visual representation of the areas with
needed maintenance) and write them marked tasks and notes on coordination
on cards. between different areas must be shown.
Document your work in a portifolio.
Task: Complete all sub-tasks as
quickly as possible, working on them Questions
simultaneously (parallel processing). 1. Explain your strategy for completing
tasks in parallel.
Outcome: Reflect on how tasks were 2. Describe how you coordinated
completed faster through parallel tasks between different areas in
processing and relate this to how the distributed system.
parallel DBMS improve performance 3. Discuss the benefits and challenges
and efficiency. of parallel and distributed systems
in this analogy.
Step 2: Distributed Database Systems 4. Provide real-world examples in
Setup: The map represents different Tanzania where these systems can
areas of Tanzania, each with specific be applied.
water system-related tasks. Assign
tasks to different areas but ensure
coordination between them. Exercise 8.6
1. Write an SQL query to select
Task: Work on area-specific tasks,
occasionally collaborating with other all records from a table named
“Students” where the “Grade” is ‘A’.
areas to solve problems, simulating
data sharing and communication in 2. Construct an SQL query to update
a distributed system. the salary of all employees in the
“Sales” department by 10%.
Outcome: Reflect on the importance 3. What attributes in database identify
of coordination and data consistency if it that it is either parallel or
in distributed systems. Discuss the distributed database systems?
challenges and advantages, such 4. Why developers considered data
as improved data access speed and partitioning in parallel database
increased fault tolerance. systems an important technique?
483
Student’s Book Form Five
Computer Science Form 5.indd 483 23/07/2024 12:35
