Page 532 - Computer_Science_F5

pages, to identify any recurring management system (RDBMS) for
themes or concerns expressed by data storage?
users of specific services provided 14. Why are indexes used in a database
by the website. management system (DBMS)?
(a) What features would you find 15. In the context of a database Chapter Eight: Databases and Database Management Systems
FOR ONLINE READING ONLY
in an object-oriented database management system (DBMS), what
model that are not typically is the goal of query optimization?
present in a relational database 16. Consider a national healthcare
model? system in Tanzania that stores
(b) How do data structures patient records, medical histories,
like trees relate to database and treatment information. Which
models? Provide an example system between parallel and
of a database model that uses distributed database systems, would
this structure. be most appropriate if the goal is to

10. Construct an SQL query to update ensure reliable access to complete
patient records at any hospital across
the salary of all employees in the the country, and why?
“Sales” department by 10%.

11. How can you respond to someone 17. Describe demands created by the
rise of IoT (Internet of Things)
who need to understand about devices
parallel and distributed database
systems? 18. What is the purpose of the echo
12. In parallel database systems, why statement in PHP?
is data partitioning considered an 19. What makes GET and POST HTTP
important technique? methods not to look the same?
13. What is the primary reason for 20. Demonstrate with code how to
using tables (comprising rows and implement a CRUD operation for
columns) in a relational database a ‘users’ table in PHP using PDO.

Project: Multi-functional Library Management System

Project Overview:

Develop a comprehensive Library Management System (LMS) that integrates
various functionalities relevant to the topics covered throughout the course. The
LMS will allow users to manage library resources, borrow and return books,
search for books, and provide administrative functionalities.

523
Student’s Book Form Five

Computer Science Form 5.indd 523 23/07/2024 12:35