Page 505 - Computer_Science_F5
P. 505
Computer Science Step 5: Completing the installation Deliverables
(b) MySQL Installer will download
Write a brief report that includes the
and install selected products.
following items:
(a) Installed MySQL Community
Server with configured settings.
(a) Review the installation
FOR ONLINE READING ONLY
summary screen.
(b) Check “Launch MySQL (b) Ability to create, manage databases,
tables, and perform data operations
Instance Configuration locally using MySQL, include
Wizard” and click “Finish.” screenshots to justify this.
Step 6: MySQL instance Practicing using basics of SQL
configuration Follow these steps to learn SQL concepts
(a) Follow Configuration Wizard and operations using a farming example.
steps to configure MySQL Create a database named ‘farming_
server. database’ with tables ‘farmers’ and ‘crops’.
(b) Choose “Detailed Use a MySQL client or an online platform
Configuration” and select such as W3Schools to execute these
“Server Machine” as server commands and establish the necessary
type. schema and table relationships.
Step 7: Authentication method
Opt for “Use Strong Password Data Definition Language (DDL)
Encryption” and set or confirm
root password. Activity 8.23:
Step 8: Windows service Creating and managing a SQL
(a) Select “Install as Windows database for Farming Data
Service” and specify service
name (or use default). Aim:
(b) Check “Launch the MySQL Understanding how to create and
Server automatically” for manage a SQL database, including the
automatic startup. creation of tables and the establishment
of relationships between them.
Step 9: Apply configuration
(a) Review configuration summary Materials
and click “Execute” to apply 1. Computers with Internet access
changes. 2. MySQL client or command-line
(b) Click “Finish” upon interface installed (such as MySQL
completion. Workbench, phpMyAdmin) or
496
for Advanced Secondary Schools
Computer Science Form 5.indd 496 23/07/2024 12:35
