ICTFundamental ConceptHSC আইসিটি অধ্যায় ৬ (ডেটাবেস ম্যানেজমেন্ট সিস্টেম)
Relational Database & Primary Key
Bengali: রিলেশনাল ডেটাবেস ও প্রাইমারি কি•Pronunciation: রিলেশনাল ডেটাবেস অ্যান্ড প্রাইমারি কি•Symbol: \text{RDBMS (SQL)}
Standard Definition:
A database structured to recognize relations between stored items of information using tables with rows (tuples) and columns (attributes).
📐 Mathematical Equation, Units & Dimensions
Defining Mathematical Equation
Standard SI Unit
Relational schema(ডেটাবেস মডেল)
Dimensional Analysis
CGS Unit
None
📖 Physical Concept & Comprehensive Explanation
An RDBMS organizes data into tables of records. A Primary Key uniquely distinguishes each record without duplicate or null entries. A Foreign Key references a Primary Key across tables, enabling complex relational queries via SQL.
🎯 High-Yield Revision Points
- ✓Data is organized into structured tables (relations).
- ✓Primary Keys are strictly unique and cannot contain NULL values.
- ✓Foreign Keys establish cross-table relational integrity.
Use Online Solver for Relational Database & Primary Key
Compute step-by-step solutions, verify formulas, and plot interactive diagrams on biggan.me.
❓ Frequently Asked Exam Questions (FAQ)
Common questions in board and competitive entrance examinations
Q1: What is the relationship between Primary and Foreign Keys?
A Foreign Key in one table references the unique Primary Key of another table to maintain relational integrity.