Sample Header Ad - 728x90

Are there mnemonics in the database design space that you find helpful when communicating database design concerns?

-3 votes
1 answer
69 views
A popular and useful mnemonic in the software development space is SOLID. - **S**ingle responsibility - **O**pen–closed - **L**iskov substitution - **I**nterface segregation - **D**ependency inversion Are there **mnemonics** in the database design space that you find helpful when communicating database design concerns with software developers? Normalization forms is the first to come to mind: - UNF: Unnormalized form - 1NF: First normal form - 2NF: Second normal form - 3NF: Third normal form - BCNF: Boyce–Codd normal form - Don't think I have ever made it past BCNF :-) However, the forms are often perceived as 'academic' by a development team in the public sector/banking/insurance space. Often teams will 'discover' an EAV solution - **E**ntity **A**ttribute **V**alue schema and think they have solved all peristence problems - and they code a *small* perisstence framework around their EAV "innovation". I find EAV schemas very probablematic and I am looking for something like SOLID - or anything more approachable than "Boyce Codd Third Normal Form" to help communicate concerns and ideas about what 'good' database design.
Asked by Brian (135 rep)
Sep 2, 2024, 04:03 PM
Last activity: Sep 3, 2024, 09:57 AM