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
ER Diagrams
Last Updated : 21 May, 2026
An ER diagram uses standard symbols to visually represent the database structure.
Unit 1206 words7 headingsTables includedExamples included
ER Diagram Notation
An ER diagram uses standard symbols to visually represent the database structure.
Symbol Legend
| Symbol | Meaning |
|---|---|
| Rectangle | Entity |
| Oval | Attribute |
| Underlined | Key Attribute |
| Double Oval | Multi-valued Attribute |
| Dashed Oval | Derived Attribute |
| Diamond | Relationship |
| Double Diamond | Weak Relationship (Identifying) |
| Double Line | Total Participation |
| Single Line | Partial Participation |
Example 1 — University Database ER Diagram
Example 2 — Hospital Database ER Diagram
Example 3 — Banking Database ER Diagram
Example 4 — Employee-Department ER Diagram
Steps to Draw an ER Diagram
- Identify Entities — Find the nouns in requirements (Person, Product, Order)
- Identify Attributes — For each entity, list its properties
- Identify Primary Keys — Underline the key attribute(s)
- Identify Relationships — Find verbs connecting entities (enrolls, works_in)
- Determine Cardinality — 1:1, 1:N, or M:N for each relationship
- Determine Participation — Total or partial for each entity in each relationship
- Handle Special Cases — Weak entities, multi-valued attributes, derived attributes
- Draw and Verify — Check the diagram represents all requirements correctly
Common Mistakes to Avoid
| Mistake | Correct Approach |
|---|---|
| Relationship as entity | Use diamond for relationships, rectangle for entities |
| Missing key attributes | Every entity must have a key attribute (underlined) |
| Forgetting cardinality | Label every relationship with 1:1, 1:N, or M:N |
| Ignoring participation | Show total participation with double lines |
| Multi-valued as simple | Use double oval for attributes with multiple values |
Exam Focus
Revise definitions, diagrams, examples, and short-answer points for ER Diagrams.
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, diagrams, er diagrams
Related DBMS Topics
Continue learning this concept
Unit 1Entity-Relationship ER ModelThe Entity-Relationship ER model is a high-level conceptual data model developed by Peter Chen in 1976. It provides a graphical representation of the database structure, 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 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 1AggregationAggregation is an abstraction mechanism in the Extended ER EER model that allows a relationship set to be treated as a higher-level entity set. This makes it possible forUnit 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 IndependenceData independence is the ability to modify the definition or structure at one level of the database without affecting the definitions at the next higher level. It is one