Articles and Guidelines for database modelling

The following articles contain best practices when designing and modelling ER diagrams.

• Be consistent
• Modelling dynamic attributes - Blueprints for the Entity-attribute-value model (EAV)
• Modelling bank accounts in database diagrams
• How to name table columns
• Naming foreign keys
• Naming primary keys
• How to name database tables
• No binary data in your databases
• For larger web applications, use UUIDs as public primary keys
• Check, if your natural key can not change.
• Use a surrogate key for identifying rows