- Published on
Learn what functional dependency is in DBMS with simple examples. Understand how it works, why it's important, and how it helps reduce redundancy and improve data consistency in relational databases.
Database
All Posts
- system-design (153)
- system-design-interview (42)
- database (34)
- interview-prep (30)
- low-level-design (22)
- oop (15)
- databases (15)
- normalization (10)
- misc (10)
- networking (9)
- golang (9)
- load-balacing (9)
- caching (8)
- distributed-systems (8)
- indexes (8)
- data-structures (7)
- erd (7)
- uml (6)
- solid (6)
- messaging (6)
- theorem (6)
- security (6)
- oop-pillars (5)
- data-partitioning (5)
- functional-dependency (4)
- data-modeling (4)
- bloom-filters (4)
- cdn (4)
- (4)
- programming (3)
- scalability (3)
- dbms (3)
- relational-data-model (3)
- distributed-file-system (3)
- replication (3)
- recovery (3)
- proxy (3)
- dns (3)
- api-gateway (3)
- algorithms (2)
- searching-algorithms (2)
- relational-model (2)
- oop-principle (2)
- check-sum (2)
- redundancy (2)
- system-designs (1)
- tiny-url (1)
- load-balancing (1)
- performance (1)
- course (1)
- sorting-algorithms (1)
- arrays (1)
- slices (1)
- typescript (1)
- strings (1)
- leetcode (1)
- binary-search (1)
- problem-solving (1)
- go-command (1)
- hello-world (1)
- history (1)
- setup (1)
- trade-offs (1)
- armstrong-axioms (1)
- integrity-constraints (1)
- er-diagram (1)
- oop-relationship (1)
- tips (1)
- leader-follower (1)
- architectural-pattern (1)
- batch-processing (1)
- streams (1)
- synchronous (1)
- asynchronous (1)
- heart-beat (1)
- quorum (1)
- high-availability (1)
- error-handling (1)
- observability (1)
- monitoring (1)
- concurrency (1)
- availability (1)
- key-concepts (1)
- load-balacing-uses (1)
- load-balacing-algorithms (1)
- Published on
Learn what relationship attributes are in ER models, why they matter, and how to use them with clear examples like student enrollments and employee positions.- Published on
Learn the key ER model concepts - degree of relationship, cardinality, and participation. Understand how entities connect in a database with simple examples and diagrams.- Published on
Learn the core components of ER models in DBMS—entities, attributes, and relationships. Discover ER diagram symbols and how to represent data structures visually and efficiently.- Published on
Learn how to find the closure of a set of attributes using Armstrong’s Axioms in DBMS. Understand step-by-step examples for computing closures and verifying functional dependencies.