Understanding Relational Databases and SQL Operations

Relational Database

Stores data in tables with relationships.

Entity-Relationship Diagram

Visual representation of data relationships.

Normalization

Process of organizing data to reduce redundancy.

Data Duplication

Storing the same data in multiple places.

Data Security

Protection of data from unauthorized access.

Data Integrity

Accuracy and consistency of data over its lifecycle.

SQL

Structured Query Language for database management.

DBMS

Software for managing databases and data access.

SELECT Statement

Used to retrieve data from a database.

WHERE Clause

Filters records based on specified conditions.

INSERT INTO

Adds new records to a table.

UPDATE Statement

Modifies existing records in a table.

DELETE FROM

Removes records from a table.

INNER JOIN

Combines rows from two tables based on a match.

ORDER BY

Sorts query results by specified fields.

Data Dictionary

Metadata about database structure and data.

Data Definition Language (DDL)

Defines database structure and schema.

Data Manipulation Language (DML)

Manipulates data within the database.

User Access Control

Manages permissions for database users.

Backup

Creates copies of data for recovery purposes.

Multi-user Access

Allows multiple users to access data simultaneously.

Session

A period during which a member participates in activities.

Activity

A specific task offered during a session.

Member

Individual participating in club sessions.

Teacher-Student Relationship

Many-to-many relationship between teachers and students.

Session Activities

Activities offered during specific sessions.

SQL Query

Command to retrieve or manipulate data.

Database Record

A single entry in a database table.

Field

A column in a database table.

Table

A structured set of data in a database.