- 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)
- data-modeling (4)
- functional-dependency (4)
- bloom-filters (4)
- cdn (4)
- (4)
- programming (3)
- scalability (3)
- relational-data-model (3)
- dbms (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)
- performance (1)
- load-balancing (1)
- course (1)
- arrays (1)
- slices (1)
- typescript (1)
- sorting-algorithms (1)
- leetcode (1)
- binary-search (1)
- problem-solving (1)
- strings (1)
- history (1)
- go-command (1)
- hello-world (1)
- setup (1)
- trade-offs (1)
- armstrong-axioms (1)
- integrity-constraints (1)
- er-diagram (1)
- oop-relationship (1)
- tips (1)
- batch-processing (1)
- streams (1)
- synchronous (1)
- asynchronous (1)
- leader-follower (1)
- architectural-pattern (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 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 the basics of normalization in DBMS, why it's important, and how normal forms help eliminate redundancy and ensure data consistency in relational databases.- 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.