Page 495 - Computer_Science_F5

Computer Science 5. Write down your findings and
document them comprehensively
in a portifolio, summarizing key
insights and implications for each
emerging technology.
FOR ONLINE READING ONLY
Deliverables:
A comprehensive document
summarizing findings from the
exploration of emerging applications.
Include analyses of benefits, features,
ideal use cases, categorization based
on industrial uses, and evaluations of
trends’ importance and relevance across
industries.
Relational databases, ER Model and
SQL
A relational database organises data
into tables with rows and columns,
allowing for efficient storage and
retrieval of information. It uses an
Entity-Relationship (ER) model to
represent entities and their relationships
graphically, such as students, teachers,
and classes in a school database.
Constraints like unique keys ensure data
integrity. Structured Query Language
(SQL) is the standard interface for
managing and querying data, enabling
complex operations like filtering
and sorting. Relational databases,
often called SQL databases, use fixed
schemas and structured data, ensuring
consistency and enforcing relationships
between data points. Use Activity 8.15
to learn more about relational databases,
ER Model and SQL.
486
Computer Science Form 5.indd 486
Relational Databases, ER Model
Activity 8.16:
and SQL
Aim:
To impart relational database concepts,
ER modeling, and SQL querying skills
using an online database simulation
tool, focusing on creating and querying
a school library database.
Materials
1. Computer with Internet access
2. Access to an online database
simulation tool (e.g., DB Fiddle,
SQL Fiddle)
3. Database schema design for a
school library (books, members,
loans)
4. SQL queries for data manipulation
Instructions:
Use a computer with Internet access to
access the SQL Fiddle online database
simulation tool (e.g., DB Fiddle: https://
www.db-fiddle.com/, SQL Fiddle:
https://sqlfiddle.com/) to create and
manipulate a database through the steps
below.
Step 1: Build a Sample Database
Use an online database simulation
tool to construct a database schema
for a school library, including tables
for Books, Members, and Loans,
and define appropriate data types for
each attribute.
for Advanced Secondary Schools
23/07/2024 12:35