Relational Data
Model Basics
Presented by-
Daulat Singh
R52255
01 Database consists of tables
(relations).
Key Concepts
02 Each table has rows (tuples) and
columns (attributes).
of Relational
Data Model
03 Each row represents a single record.
04 Columns define the properties of
records.
05 Tables are connected using keys
(Primary & Foreign keys).
Why Use a Relational
Data Model?
The relational model ensures data Structured &
integrity, eliminates redundancy, and Organized
allows easy retrieval using SQL queries.
What is a Relational Data Model?
Definition
The relational data model organizes data into tables (relations)
consisting of rows (tuples) and columns (attributes).
Purpose
It ensures data is structured in a logical way, allowing easy access,
retrieval, and manipulation.
Importance
This model provides a clear, organized structure for databases and
enables relationships between tables using keys.
Keys in Relational Data
Model
Primary Key Foreign Key
Candidate Key
A unique identifier for each record A set of attributes that can uniquely
A key that establishes a
in a table. identify a record.
relationship between two tables.
Tables in a Relational Database
What is a Table?
A table (relation) is a collection of data organized into rows and
columns.
Example
A 'Customers' table may contain customer details like Name, Email,
and Phone Number.
Importance
Tables store structured data efficiently and allow easy retrieval and
management.
How Tables Connect
Between Tables
Tables in a relational model are connected using
keys. A primary key in one table can act as a
Relationships
foreign key in another.
This helps maintain data consistency and
prevents redundancy.
Understanding Tuples in a Table
What is a Tuple?
A tuple is a single row in a relational database table, representing a
unique record.
Example
In a 'Students' table, each row represents a student with specific
details like ID, Name, and Age.
Importance
Tuples ensure that each record is stored independently and can be
retrieved efficiently.
Understanding Attributes in a Table
What is an Attribute?
An attribute is a column in a relational database table that defines a
property of a tuple.
Example
In a 'Students' table, attributes can be Student_ID, Name, and Age.
Role in Databases
Attributes help structure data logically and define the characteristics
of stored records.
Understanding
DBMS
How does the relational data
model improve database
Final management?
Thoughts Relational databases simplify data
organization, retrieval, and security.
They remain the backbone of modern
data-driven applications.
Relational Data
Model
Do you have any questions?
Thank You! Feel free to ask any questions or revisit
the slides for clarity. Understanding the
relational data model is key to working
with databases effectively.
