- 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.
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)
- distributed-systems (8)
- caching (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)
- recovery (3)
- replication (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)
- performance (1)
- load-balancing (1)
- course (1)
- arrays (1)
- slices (1)
- typescript (1)
- sorting-algorithms (1)
- strings (1)
- leetcode (1)
- binary-search (1)
- problem-solving (1)
- setup (1)
- go-command (1)
- hello-world (1)
- history (1)
- trade-offs (1)
- er-diagram (1)
- integrity-constraints (1)
- armstrong-axioms (1)
- oop-relationship (1)
- tips (1)
- synchronous (1)
- asynchronous (1)
- leader-follower (1)
- architectural-pattern (1)
- batch-processing (1)
- streams (1)
- heart-beat (1)
- quorum (1)
- error-handling (1)
- high-availability (1)
- observability (1)
- monitoring (1)
- concurrency (1)
- availability (1)
- key-concepts (1)
- load-balacing-algorithms (1)
- load-balacing-uses (1)
- 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
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
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.