Page 526 - Computer_Science_F5

Step 4: Testing
(a) Test adding new tasks through add_task.php.

(b) Verify the list of tasks and their completion status in index.php.
(c) Test updating task status using update_task.php.
FOR ONLINE READING ONLY
(d) Ensure deletion of tasks functions correctly with delete_task.php. Chapter Eight: Databases and Database Management Systems

Deliverables:
Write a brief report that includes the following:
1. PHP files: index.php, add_task.php, update_task.php, delete_task.php
2. MySQL database named task_manager with a table named tasks
3. Functional web application that allows users to Add new tasks, View a list of
tasks with completion status, Update task completion status, Delete tasks

Key Features of NoSQL databases
Exercise 8.8
(i) Schema-less data: They allow the
1. Describe about PHP and its role in storage of data without a predefined
web development?? schema, offering flexibility in
2. What advantages does PDO handling various data formats.
offer compared to MySQLi for (ii) Scalability: NoSQL databases
developers? are designed to scale out using a

3. How can you connect to a MySQL distributed architecture, making
database using PDO in PHP? them adept at handling large,
rapidly growing datasets across
4. How would you fetch data from a multiple servers.
database using PDO?
(iii) Types: There are several types
of NoSQL databases, including
NoSQL databases document databases, key-value

NoSQL emerged as a response to stores, wide-column stores, and
the limitations of SQL databases, graph databases, each optimised
particularly in handling large volumes for specific types of data and access
of unstructured or semi-structured patterns.
data, and the need for more flexible
data management solutions. NoSQL Examples of NoSQL databases
databases do not adhere to a fixed MongoDB (document), Redis (key-
schema, making them highly adaptable value), Cassandra (wide-column), Neo4j
to changes and variations in data types. (graph).

517
Student’s Book Form Five

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