database-modelling.com
  • Home (current)
  • Articles and Guidelines
  • IHK final exams
  • Blog
  • Be consistent (BE_CONSISTENT)
  • Modelling dynamic attributes - Blueprints for the Entity-attribute-value model (EAV) (EAV)
  • Modelling bank accounts in database diagrams (MODELLING_BANK_ACCOUNTS)
  • How to name table columns (NAMING_COLUMNS)
  • Naming foreign keys (NAMING_FOREIGN_KEYS)
  • Naming primary keys (NAMING_PRIMARY_KEYS)
  • How to name database tables (NAMING_TABLES)
  • No binary data in your databases (NO_BINARY_DATA)
  • For larger web applications, use UUIDs as public primary keys (PUBLIC_UUID)
  • Check, if your natural key can not change. (STATIC_NATURALKEYS)
  • Use a surrogate key for identifying rows (SURROGATE_KEYS)
  • Blog
  • Imprint
  • Privacy Policy