A 3.1.1 Relational databases

Database

Organized collection of data.

Relational Database

Structure data into tables with defined relationships.

Table

Data organized in rows and columns.

Primary Key

Unique identifier for each record within a table.

Foreign Key

Links between tables to establish relationships.

Composite Key

Multiple fields combined to create a unique identifier.

One-to-one Relationship

Each record in one table is related to one record in another.

One-to-many Relationship

One record in a table can be related to multiple records in another.

Many-to-many Relationship

Multiple records in one table can be related to multiple records in another (often requires a junction table).

SQL

Structured Query Language; used for efficient data querying.

Normalization

Organizing data to minimize redundancy.

Data Integrity

Ensures that data is accurate, complete, and consistent.

Concurrency Control

Managing simultaneous access by multiple users.

ACID Properties

Atomicity, Consistency, Isolation, Durability; ensures reliable transactions.

Scalability

Ability to handle large amounts of data and users.

Unstructured Data

Data that doesn't fit neatly into rows and columns, like text, images, and videos.

Big Data

Extremely large datasets that can be challenging to process.

Computational Thinking

The organizing concept of the DP computer science course, focused on solving real-world problems.

Algorithm

A sequence of steps to solve a problem.

Programming

Transforming algorithms into computer code.

Abstraction

Creating generalized representations of pet actions and states, focusing on the logic behind pet care rather than detailed, realistic simulations.

Decomposition

Breaking down the virtual pet's needs and behaviors into manageable programming tasks (e.g., hunger level, happiness level, health status).

Pattern Recognition

Identifying similarities in how different actions affect the pet's state (e.g., both feeding and playing increase happiness but may have different effects on health).