Page 502 - Computer_Science_F5
P. 502
(iii) Complex queries: SQL databases
Materials: are powerful in handling complex
Computer with Internet access; queries, making them suitable for
Access to online databases (optional applications where data interrelation
for further exploration), Access to is essential.
FOR ONLINE READING ONLY
library resources. Chapter Eight: Databases and Database Management Systems
Instructions Examples of SQL databases
Explore the Internet and library MySQL: Widely used open-source
resources to understand the critical role RDBMS, suitable for a variety of
of databases in modern web and mobile applications.
applications. Record your discoveries
and document them into a portfolio. PostgreSQL: An open-source, feature-
rich RDBMS known for its extensibility
SQL databases and standards compliance.
SQL databases, also known as relational
databases, organise data into tables Oracle Database: A comprehensive
which can be linked—or related—based commercial RDBMS solution for
on data common to each. This structure enterprise-level applications.
allows for the relational database
management systems (RDBMS) to Microsoft SQL Server: A commercial
access and assemble data points stored RDBMS with extensive tools and
across different tables through SQL features for businesses.
queries. SQL databases are characterized
by their use of schema, a predefined Use Cases of SQL databases
structure for data that dictates the format (i) Banking systems for transactional
of the data stored. data processing.
Key features of SQL databases (ii) Enterprise applications with
(i) Structured data: SQL databases are complex queries and reporting.
highly structured and require data (iii) E-commerce platforms need
to adhere to predefined schemas, consistent data integrity and
which specify the tables, columns, relational operations.
data types, and relationships among
data.
(ii) ACID properties: They strongly MySQL (relational database
management system)
adhere to ACID (Atomicity,
Consistency, Isolation, Durability) MySQL is one of the most popular
properties, ensuring reliable relational database management systems
transaction processing. (RDBMS) in the world, widely used for
493
Student’s Book Form Five
Computer Science Form 5.indd 493 23/07/2024 12:35
