Relational Database Concepts0%

Relational Database Concepts

Beginner12 min read•Updated: 2026-09-12

Relational Database Concepts: Tables, Rows, Columns & Schemas

In relational database terminology, data is not saved as loose blobs of text. Instead, every piece of information is stored in an organized structure governed by strict mathematical and relational definitions. Understanding these core building blocks—Tables, Columns, Rows, and Schemas—is essential before writing any SQL code.

1. The Anatomy of a Relational Table

A relational table is a two-dimensional structure consisting of rows and columns. In theoretical computer science, a table is called a Relation, a row is called a Tuple, and a column is called an Attribute.

                     TABLE: students (Relation)
 +------------+--------------------+---------------------+--------------+
 | student_id | first_name         | email               | enroll_year  | <-- Columns
 +------------+--------------------+---------------------+--------------+     (Attributes)
 | 101        | Aarav              | aarav@example.com   | 2026         | <-- Row 1 (Tuple)
 | 102        | Diya               | diya@example.com    | 2025         | <-- Row 2 (Tuple)
 | 103        | Rohan              | rohan@example.com   | 2026         | <-- Row 3 (Tuple)
 +------------+--------------------+---------------------+--------------+

Terminology Comparison: Theory vs Practice

Theoretical Term (Codd)	Practical SQL Term	Description
Relation	Table	The entire dataset representing an entity (e.g., `students`, `invoices`).
Tuple	Row / Record	A single horizontal instance of data representing one specific entity.
Attribute	Column / Field	A vertical column representing a specific property with a defined data type.
Degree (Arity)	Column Count	The total number of columns in a table. In the table above, degree = 4.
Cardinality	Row Count	The total number of rows currently stored. In the table above, cardinality = 3.
Domain	Data Type & Range	The allowable set of values for a column (e.g., integers between 1900 and 2100).

2. What is a Database Schema?

A Database Schema is the complete architectural blueprint or structural layout of a database. It defines:

1
All table names and their column names.
2
The data type and byte length of each column (e.g., VARCHAR(100), INT).
3
Integrity constraints (e.g., PRIMARY KEY, NOT NULL, CHECK).
4
Relationships between tables established via foreign keys.
5
Auxiliary database objects including views, indexes, stored procedures, and triggers.

1-- Visualizing a Schema Definition in SQL DDL:
2CREATE TABLE departments (
3    dept_id INT PRIMARY KEY AUTO_INCREMENT,
4    dept_name VARCHAR(50) NOT NULL UNIQUE
5);
6 
7CREATE TABLE employees (
8    emp_id INT PRIMARY KEY AUTO_INCREMENT,
9    emp_name VARCHAR(100) NOT NULL,
10    salary DECIMAL(10, 2) NOT NULL,
11    dept_id INT,
12    CONSTRAINT fk_emp_dept FOREIGN KEY (dept_id) REFERENCES departments(dept_id)
13);

3. Physical vs Logical Data Independence

One of the great advantages of an RDBMS is Data Independence:

Physical Data Independence: The physical arrangement of files on your server's NVMe SSD or hard disk can change without requiring modifications to your SQL queries.
Logical Data Independence: The logical schema of the database can evolve (such as adding a new optional column or creating a view) without breaking existing client applications that read untouched columns.

4. Best Practices & Common Pitfalls

Plural vs Singular Table Naming: Adopt a consistent naming convention throughout your organization (e.g., plural customers, orders or singular customer, order).
Atomic Columns (1NF): Never store multiple values in a single cell (e.g., phone_numbers = "9820012345, 9820054321"). Each column must contain atomic, single-valued entries.
Meaningful Identifiers: Avoid cryptic abbreviations. Choose customer_registration_date rather than c_reg_dt.

Interactive Quiz• Knowledge Check

Multiple Choice Questions

Question 1

In formal relational database theory, what is a single horizontal record (row) called?

Question 2

If a database table has 6 columns and 1,200 rows, what is the degree and cardinality of the table?

Question 3

What does a database schema represent?

Question 4

What is meant by "Domain" in relational database terminology?

Question 5

Why should multiple phone numbers NOT be stored as a comma-separated string in a single column?

Next Lesson

SQL vs NoSQL Overview

Continue learning with hands-on practice, examples, and exercises in the upcoming topic.

Related Lessons

Previous Lesson	Next Lesson
What is a Database & RDBMS	SQL vs NoSQL Overview

Practice Quiz

Test your understanding of this lesson with 5 questions. Each question has one correct answer.

Previous Next

PreviousPrevNext

MSK Institute • Shikohabad

Loading Page Content...

Preparing courses, live labs, and learning resources.सामग्री लोड हो रही है, कृपया प्रतीक्षा करें...

Connecting serverPlease wait...

💻 Practical Labs🚀 Free Demo📜 Verified Certificates

SQL vs NoSQL Overview

Relational Database Concepts

Beginner12 min read•Updated: 2026-09-12

Study Materials Cheatsheet

Relational Database Concepts: Tables, Rows, Columns & Schemas

1. The Anatomy of a Relational Table

                     TABLE: students (Relation)
 +------------+--------------------+---------------------+--------------+
 | student_id | first_name         | email               | enroll_year  | <-- Columns
 +------------+--------------------+---------------------+--------------+     (Attributes)
 | 101        | Aarav              | aarav@example.com   | 2026         | <-- Row 1 (Tuple)
 | 102        | Diya               | diya@example.com    | 2025         | <-- Row 2 (Tuple)
 | 103        | Rohan              | rohan@example.com   | 2026         | <-- Row 3 (Tuple)
 +------------+--------------------+---------------------+--------------+

Terminology Comparison: Theory vs Practice

Theoretical Term (Codd)	Practical SQL Term	Description
Relation	Table	The entire dataset representing an entity (e.g., `students`, `invoices`).
Tuple	Row / Record	A single horizontal instance of data representing one specific entity.
Attribute	Column / Field	A vertical column representing a specific property with a defined data type.
Degree (Arity)	Column Count	The total number of columns in a table. In the table above, degree = 4.
Cardinality	Row Count	The total number of rows currently stored. In the table above, cardinality = 3.
Domain	Data Type & Range	The allowable set of values for a column (e.g., integers between 1900 and 2100).

2. What is a Database Schema?

A Database Schema is the complete architectural blueprint or structural layout of a database. It defines:

1
All table names and their column names.
2
The data type and byte length of each column (e.g., VARCHAR(100), INT).
3
Integrity constraints (e.g., PRIMARY KEY, NOT NULL, CHECK).
4
Relationships between tables established via foreign keys.
5
Auxiliary database objects including views, indexes, stored procedures, and triggers.

1-- Visualizing a Schema Definition in SQL DDL:
2CREATE TABLE departments (
3    dept_id INT PRIMARY KEY AUTO_INCREMENT,
4    dept_name VARCHAR(50) NOT NULL UNIQUE
5);
6 
7CREATE TABLE employees (
8    emp_id INT PRIMARY KEY AUTO_INCREMENT,
9    emp_name VARCHAR(100) NOT NULL,
10    salary DECIMAL(10, 2) NOT NULL,
11    dept_id INT,
12    CONSTRAINT fk_emp_dept FOREIGN KEY (dept_id) REFERENCES departments(dept_id)
13);

3. Physical vs Logical Data Independence

One of the great advantages of an RDBMS is Data Independence:

Physical Data Independence: The physical arrangement of files on your server's NVMe SSD or hard disk can change without requiring modifications to your SQL queries.
Logical Data Independence: The logical schema of the database can evolve (such as adding a new optional column or creating a view) without breaking existing client applications that read untouched columns.

4. Best Practices & Common Pitfalls

Plural vs Singular Table Naming: Adopt a consistent naming convention throughout your organization (e.g., plural customers, orders or singular customer, order).
Atomic Columns (1NF): Never store multiple values in a single cell (e.g., phone_numbers = "9820012345, 9820054321"). Each column must contain atomic, single-valued entries.
Meaningful Identifiers: Avoid cryptic abbreviations. Choose customer_registration_date rather than c_reg_dt.

Interactive Quiz• Knowledge Check

Multiple Choice Questions

Question 1

In formal relational database theory, what is a single horizontal record (row) called?

Question 2

If a database table has 6 columns and 1,200 rows, what is the degree and cardinality of the table?

Question 3

What does a database schema represent?

Question 4

What is meant by "Domain" in relational database terminology?

Question 5

Why should multiple phone numbers NOT be stored as a comma-separated string in a single column?

Next Lesson

SQL vs NoSQL Overview

Continue learning with hands-on practice, examples, and exercises in the upcoming topic.

Related Lessons

Previous Lesson	Next Lesson
What is a Database & RDBMS	SQL vs NoSQL Overview

Practice Quiz

Test your understanding of this lesson with 5 questions. Each question has one correct answer.

Previous Next