- 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.
All Posts
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)
- 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)
- leetcode (1)
- binary-search (1)
- problem-solving (1)
- strings (1)
- history (1)
- hello-world (1)
- go-command (1)
- setup (1)
- trade-offs (1)
- er-diagram (1)
- integrity-constraints (1)
- armstrong-axioms (1)
- oop-relationship (1)
- tips (1)
- batch-processing (1)
- streams (1)
- leader-follower (1)
- architectural-pattern (1)
- synchronous (1)
- asynchronous (1)
- heart-beat (1)
- quorum (1)
- high-availability (1)
- error-handling (1)
- concurrency (1)
- observability (1)
- monitoring (1)
- availability (1)
- key-concepts (1)
- load-balacing-uses (1)
- load-balacing-algorithms (1)
- 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
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 what First Normal Form (1NF) is, why it's important in DBMS, and how to convert tables to 1NF using real-life examples.- 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.