- Published on
Learn about keys in relational databases, including primary, foreign, candidate, alternate, composite, and super keys with simple examples. Understand their role in ensuring data integrity.
Database
All Posts
- system-design (116)
- database (30)
- low-level-design (22)
- oop (15)
- databases (15)
- normalization (10)
- misc (10)
- load-balacing (9)
- indexes (8)
- erd (7)
- caching (7)
- networking (7)
- uml (6)
- solid (6)
- messaging (6)
- security (6)
- theorem (6)
- oop-pillars (5)
- data-partitioning (5)
- golang (5)
- interview-prep (4)
- scalability (4)
- data-modeling (4)
- functional-dependency (4)
- bloom-filters (4)
- cdn (4)
- dbms (3)
- relational-data-model (3)
- api-gateway (3)
- recovery (3)
- distributed-file-system (3)
- dns (3)
- proxy (3)
- replication (3)
- data-structures (2)
- trade-offs (2)
- relational-model (2)
- oop-principle (2)
- check-sum (2)
- redundancy (2)
- key-concepts (1)
- tips (1)
- armstrong-axioms (1)
- integrity-constraints (1)
- er-diagram (1)
- oop-relationship (1)
- concurrency (1)
- high-availability (1)
- availability (1)
- observability (1)
- monitoring (1)
- error-handling (1)
- leader-follower (1)
- architectural-pattern (1)
- load-balacing-algorithms (1)
- load-balacing-uses (1)
- batch-processing (1)
- streams (1)
- heart-beat (1)
- synchronous (1)
- asynchronous (1)
- quorum (1)
- go-command (1)
- hello-world (1)
- history (1)
- programming (1)
- setup (1)
- Published on
Understand relational integrity constraints in DBMS with simple examples. Learn about domain, entity integrity, referential integrity, key, and check constraints that ensure data accuracy and consistency.- Published on
Discover the best practices for converting complex ER diagrams to relational models. Learn how to handle composite, multivalued, and derived attributes, relationships, weak entities, and ensure normalization.- Published on
Learn the best practices for converting ER diagrams to relational models. Understand how to handle composite, multivalued, and derived attributes, define relationships, manage weak entities, and apply normalization for clean, consistent database design.- Published on
Learn what ER models are in DBMS, why they matter, and how they help design databases. Understand entities, attributes, relationships, and ER diagrams with examples.