Database Fundamentals: Understanding Relational Databases, Tables, and SQL

1. Introduction

Whether you are checking exam results on a state board portal, looking up a train timetable, or maintaining student attendance registers in an ICT lab, data is at the center of the application.

A Database is an organized collection of structured data stored electronically in a computer system. Unlike a plain text file or an isolated spreadsheet, a database management system allows multiple users to search, retrieve, update, and secure vast amounts of data simultaneously without duplication or errors.

2. What is a DBMS and RDBMS?

• DBMS (Database Management System):
  • System software used to create, maintain, and manage databases.
  • Provides an interface between the end user or software applications and the physical underlying storage.
• RDBMS (Relational Database Management System):
  • The most widely used database model in enterprise software and school record management.
  • Stores data in structured two-dimensional grids known as Tables (or Relations), consisting of Rows (records/tuples) and Columns (fields/attributes).
  • Common RDBMS platforms: MySQL, PostgreSQL, SQLite, and Microsoft Access.

3. Key Database Concepts & Terminology

Component	Definition	Real-World ICT Lab Example
Table	A structured matrix of rows and columns storing related information.	Students table containing academic rosters.
Field (Column)	A specific attribute or data type defined in a table.	Roll_No, First_Name, Class, Date_of_Birth.
Record (Row)	A single complete entry representing an entity.	A single student's complete row of personal data.
Primary Key	A unique identifier for every record; cannot contain null values or duplicates.	A unique Admission_Number or Roll_ID.
Foreign Key	A field in one table that links directly to the primary key in another table.	Class_ID linking students to their designated class timetable.

4. Introduction to SQL (Structured Query Language)

SQL (pronounced "sequel" or "S-Q-L") is the standard language used to interact with and query relational databases. SQL commands fall primarily into two foundational categories:

• DDL (Data Definition Language): Defines database structure (e.g., CREATE TABLE, ALTER TABLE, DROP TABLE).
• DML (Data Manipulation Language): Manages the data records inside tables:
  • SELECT: Retrieves records matching specific conditions.
  • INSERT: Adds new data rows to a table.
  • UPDATE: Modifies existing data entries.
  • DELETE: Removes specified records.

5. Hands-on Lab Exercise: Writing Basic SQL Queries

Students can practice relational concepts using a simple classroom schema. Imagine a table named ICT_Students:

-- Step 1: Create the table structure
CREATE TABLE ICT_Students (
    Roll_No INT PRIMARY KEY,
    Student_Name VARCHAR(50),
    Class_Grade INT,
    Computer_Score INT
);

-- Step 2: Insert student records
INSERT INTO ICT_Students VALUES (101, 'Aman Kumar', 9, 88);
INSERT INTO ICT_Students VALUES (102, 'Priya Kumari', 10, 95);
INSERT INTO ICT_Students VALUES (103, 'Rahul Singh', 9, 72);
INSERT INTO ICT_Students VALUES (104, 'Anjali Roy', 10, 91);

-- Step 3: Query all students in Class 10
SELECT Student_Name, Computer_Score 
FROM ICT_Students 
WHERE Class_Grade = 10;

-- Step 4: Find top-performing students scoring 90 or above
SELECT * 
FROM ICT_Students 
WHERE Computer_Score >= 90;

6. Review Questions & Key Answers

Q1: What is the primary purpose of a Primary Key in a relational table?

• Answer: A Primary Key uniquely identifies each record in a database table, ensuring no duplicate rows exist and allowing reliable data relationships.

Q2: What is the difference between a flat spreadsheet file and a Relational Database?

• Answer: While spreadsheets are suitable for single-user data entry and simple calculations, relational databases support concurrent multi-user access, enforce strict data validation, minimize redundancy across linked tables, and handle millions of records efficiently.

Q3: Which basic SQL command is used to read and fetch information from a database?

• Answer: The SELECT statement.