Computer Science Form 3 (Chapter 4: Database & SQL) Flashcards

These 30 vocabulary-style flashcards cover the fundamental concepts of Chapter 4: Database and SQL for the KSSM Asas Sains Komputer (ASK) Form 3 syllabus, including table structures, primary keys, and basic SQL commands.

Database

A collection of data organized systematically so it is easy to store, search, and update.

Purpose of Databases

To store information neatly, prevent redundant data, and facilitate easier data searching.

Everyday Examples of Databases

School student records, library systems, hospital records, and the Google Classroom application.

Table

A place to store data organized in the form of rows and columns.

Field

A column in a table that stores a single type of information, such as Name or Age.

Record

A row in a table that contains complete information for a single individual or object.

Data

Facts or information collected for the purpose of storage and processing.

Difference between Field and Record

A field refers to a column, whereas a record refers to a row within a table.

Relational Database

A database consisting of several tables that are interconnected through keys.

School Database Function

Used to store information regarding students, teachers, classes, and examination results in an organized banner.

Primary Key

A field that contains a unique value to identify every individual record.

Importance of Primary Keys

Ensures that every record identifies unique entries and prevents duplicate information.

Primary Key Restriction

Two records cannot share the same primary key; the value must be unique.

Student Table Primary Key Examples

Identity Card Number (Nombor Kad Pengenalan) or Student ID (ID Murid).

Table Relationships

Connections that link data between two or more different tables.

Advantage of Multiple Tables

Ensures data is better organized and prevents the repetition of information compared to using one giant table.

Data Type

The classification of information stored in a field, such as numbers or text.

Examples of Data Types

Text and Number.

"Nama" Field

A field used to store the names of students or users.

"Umur" Field

A field used to store age values in numerical form.

SQL

Stands for Structured Query Language, which is the language used to manage databases.

$SELECT$ Command

An instruction used to display data from a table.

$FROM$ Command

An instruction used to determine which table is being targeted for use.

$WHERE$ Command

An instruction used to filter data based on specific conditions.

$INSERT$ Command

An instruction used to add new records into a table.

$UPDATE$ Command

An instruction used to modify or update existing data.

$DELETE$ Command

An instruction used to remove records from a table.

$*$ Symbol in $SELECT$

A symbol used to indicate that all fields in the table should be displayed.

$$SELECT * FROM Murid;$$

An instruction that displays all records and all fields from the table named $Murid$.

Importance of SQL in ASK

SQL allows users to easily store, search, add, modify, and delete data within a database.