DBMS Topics
HubUnit 1 — Introduction to DBMS & Entity-Relationship ModelAdvantages and Disadvantages of DBMSAggregationCharacteristics of DBMSData IndependenceData ModelsDatabase Users and AdministratorsDBMS LanguagesER DiagramsEntity-Relationship ER ModelIntroduction to DBMSKeys in DBMSRelationships and CardinalitySchema and InstanceSpecialization and GeneralizationUnit 1 Summary — Introduction to DBMS & ER ModelThree-Level Architecture ANSI/SPARC ArchitectureWeak Entity SetUnit 2 — Relational Model & SQLConstraints in SQLCursorsDCL and TCL CommandsDDL CommandsDML CommandsDomain Relational Calculus DRCFunctions and Stored ProceduresJoins in SQLNested Queries SubqueriesRelational AlgebraRelational CalculusRelational ModelSQL IntroductionUnit 2 Summary — Relational Model & SQLTriggers in SQLTuple Relational Calculus TRCViews in SQLArmstrong's Axioms & Closure of AttributesBoyce-Codd Normal Form BCNFClosure of AttributesDependency PreservationFifth Normal Form 5NFFirst Normal Form 1NFFourth Normal Form 4NFFunctional DependencyLossless DecompositionMultivalued DependencyNormal Forms — OverviewNormalization — IntroductionSecond Normal Form 2NFUnit 3 Summary — NormalizationThird Normal Form 3NFUnit 4 — Transaction Management & Concurrency ControlACID PropertiesCheckpointsConcurrency Control & SerializabilityDeadlock in DBMSLock-Based Protocols & Two-Phase LockingLog-Based RecoveryRecovery SystemSerializabilityShadow PagingUnit 4 Summary — Transaction Management & Concurrency ControlTimestamp-Based ProtocolTransaction ManagementTransaction StatesTwo-Phase Locking 2PLUnit 5 — Storage & IndexingB+ TreeB-TreeCost EstimationDynamic HashingFile OrganizationHashing TechniquesIndexing — IntroductionMulti-Level IndexingQuery OptimizationQuery ProcessingSingle-Level IndexingStatic HashingUnit 5 Summary — Storage & IndexingUnit 6 — Advanced Topics in DBMSBig Data and DBMSCloud DatabaseData MiningData WarehouseDatabase SecurityDistributed DatabaseDistributed Query ProcessingDistributed DBMS Architecture, Fragmentation & ReplicationMongoDB — IntroductionNoSQL DatabaseReplication in Distributed DatabasesUnit 6 Summary — Advanced Topics in DBMSViva Voce — DBMSImportant Viva Questions — DBMSInterview Questions — DBMSViva Answers — DBMSDBMS Multiple Choice Questions MCQsDBMS Lab Programs
Unit 1 Summary — Introduction to DBMS & ER Model
Last Updated : 21 May, 2026
Unit 1239 words10 headingsTables includedExamples included
Key Concepts at a Glance
DBMS Fundamentals
| Concept | Key Point |
|---|---|
| DBMS | Software to define, create, maintain, and control database access |
| Database | Organized collection of structured, persistent data |
| File System vs DBMS | DBMS solves redundancy, inconsistency, security, concurrency issues |
| DBA | Central administrator responsible for schema, security, performance |
Three-Level Architecture
External Level
Multiple user views
Customized views for users/apps
Conceptual Level
Single logical schema
What data exists
Internal Level
Physical storage
How data is stored
Physical Independence: change internal without affecting conceptual.
Logical Independence: change conceptual without affecting external.
Data Models
| Model | Structure | Relationships | Still Used? |
|---|---|---|---|
| Hierarchical | Tree | 1:N only | Legacy |
| Network | Graph | M:N | Legacy |
| Relational | Tables | M:N via FK | Yes (dominant) |
| Object-Oriented | Objects | References | Limited |
| ER Model | Entities+Relationships | Design tool | Yes (design phase) |
ER Model Components
| Entity | Rectangle |
| Attribute | Oval |
| Key Attribute | Underlined Oval |
| Multi-valued | Double Oval |
| Derived | Dashed Oval |
| Relationship | Diamond |
| Weak Entity | Double Rectangle |
| Weak Relation | Double Diamond |
Types of Keys
Super Key
Any uniquely identifying attribute set
Candidate Key
Minimal super key
Primary Key
Chosen candidate key, no NULL
Alternate Key
Unchosen candidate keys
Foreign Key
References another table's PK
Composite Key
PK with 2+ attributes
Cardinality Types
| 1:1 | Each A maps to at most one B, and vice versa |
| 1:N | One A maps to many B's; each B maps to one A |
| M:N | Many A's relate to many B's; implemented with a junction table |
EER Extensions
| Concept | Direction | Description |
|---|---|---|
| Generalization | Bottom-up | Combine entities into superclass |
| Specialization | Top-down | Divide entity into subclasses |
| Aggregation | — | Treat relationship as entity |
| Weak Entity | — | Depends on strong entity for identity |
Important Formulas / Rules
- Partial Key (Weak Entity): Full PK = Identifying entity's PK + Discriminator
- M:N Relationship: Always requires a junction table with composite PK
- Total Participation: Enforced by NOT NULL on foreign key
- Foreign Key Rule: FK value must exist in referenced PK column (or be NULL)
Common Exam Questions
- Draw an ER diagram for a given scenario
- Identify the type of key from a given relation
- Convert ER diagram to relational schema
- Explain physical vs. logical data independence
- Identify weak entities and their discriminators
- Explain specialization vs. generalization with examples
Exam Focus
Revise definitions, diagrams, examples, and short-answer points for Unit 1 Summary — Introduction to DBMS & ER Model.
Interview Use
Prepare one clear explanation, one practical example, and one common mistake for this DBMS topic.
Search Terms
dbms, database management system, database notes, sql, unit, summary, unit 1 summary — introduction to dbms & er model
Related DBMS Topics
Continue learning this concept
Unit 1Unit 1 — Introduction to DBMS & Entity-Relationship ModelThis unit introduces the fundamental concepts of database management systems, the architecture that underlies them, and the Entity-Relationship ER model used for conceptuUnit 1Introduction to DBMSA database is an organized collection of structured data stored electronically so that it can be easily accessed, managed, and updated. Databases store data in a way thatUnit 1Advantages and Disadvantages of DBMSData is stored in a centralized location. Normalization ensures that each fact is stored only once, eliminating duplicate data across multiple files.Unit 1Characteristics of DBMSA DBMS has distinct characteristics that differentiate it from simple file-storage systems. These characteristics are what make a DBMS powerful, flexible, and reliable foUnit 1Data ModelsA data model is a collection of conceptual tools for describing data, data relationships, data semantics, and consistency constraints. It provides a way to think about anUnit 1DBMS LanguagesA DBMS provides several specialized languages for different types of database operations. These languages are collectively referred to as database languages or sublanguag