Page 489 - Computer_Science_F5
P. 489
Computer Science 2. Explain your process for finding MySQL, PostgreSQL); and SQL
answers to the queries using your
tutorials or reference guide.
chosen approach(es).
Instructions:
3. Discuss how database management
system (DBMS) software optimises
FOR ONLINE READING ONLY
Step 1: Create a database for a topic
queries through analyzing query
execution plans, utilising indexes, of your interest, such as your
favorite sports team.
and employing optimization Step 2: Manipulate data-insert,
techniques. update, and delete records in
4. Analyse how the strategies you your database. For example,
employed align with the principles you can add new players,
of query optimization in DBMS. update player statistics, or
5. Discuss the importance of selecting remove retired players.
the most efficient approach based Step 3: Query Challenge- create
on factors such as data volume, challenges where you must
complexity, and performance retrieve specific information
requirements. using SELECT statements
with various conditions. For
example, finding the top
Optimization in context of school scorer or listing players from
environment is similar to organizing a particular position.
your study notes, in such a way that it Step 4: Optimise querry by creating
will make you review them easily before indexes on your tables and
an examination. In this case, optimizing observe the performance
a database makes data retrieval faster difference in query execution.
and more efficient.
Compare the speed of queries
before and after indexing.
Activity 8.13:
Understanding database Deliverables:
functionality and sql operations Write a summarized report of your
Aim: database design, including table
To understand database functionality, structures and relationships. In a report,
efficient data storage and access, and include examples of SQL statements
the role of SQL in managing database used for data manipulation and queries,
operations. screenshots or descriptions of the
performance differences observed
Materials: during the optimization experiment.
Computer with a database management Also, write the answers to the questions
system (DBMS) software (such as provided above.
480
for Advanced Secondary Schools
Computer Science Form 5.indd 480 23/07/2024 12:35
