Page 476 - Computer_Science_F5

Importance of Structured Query you will learn about Structured Query
Language (SQL) Language using MySQL, a popular open-
(a) Allows users to access data in the source relational database management
relational database management system (RDBMS) that uses Structured
systems. Query Language (SQL) for managing Chapter Eight: Databases and Database Management Systems
FOR ONLINE READING ONLY
and manipulating data. To use this
(b) Enables users to describe the data. DBMS, you need to install the XAMPP
(c) Allows users to define the data in a application, an open-source software
database and manipulate that data. stack that provides an easy-to-install
(d) Allows embedding within other Apache distribution for developers to
languages using SQL modules, create a local web server environment
libraries, and pre-compilers. as a popular choice for developers who
(e) Enables users to create and drop need a local development environment
databases and tables. for PHP and MySQL-based applications.
(f) Enables users to create, view, and
store procedures and functions in a To bring this environment in place
database. download and install XAMPP, then start
(g) Allows users to set permissions on MySQL and Apache on the XAMPP
tables, procedures, and views. control panel to access the database;
open your browser and type localhost/
Since there are so many database phpMyAdmin, and the browser will open
management systems, in this chapter the dashboard as shown in Figure 8.18.

Figure 8.18: PhpMyAdmin dashboard

467
Student’s Book Form Five

Computer Science Form 5.indd 467 23/07/2024 12:34