Database Design Best Practices [closed]

by

A few points:

  • Learn as much as you can about problem domain. You can’t create good data model without knowing what you’re designing for
  • Have good knowledge about data types provided by your database provider
  • How to properly use normalisation and design tables
  • Performance: when and how to apply indexes, how to write efficient queries etc.
  • When and how to use different DB objects like views, procedures, functions, triggers

More Related Contents:

  1. How to design a product table for many kinds of product where each product has many parameters
  2. What is Normalisation (or Normalization)? [closed]
  3. Database design – articles, blog posts, photos, stories
  4. Schema for a multilanguage database
  5. Calendar Recurring/Repeating Events – Best Storage Method
  6. How to version control a record in a database [closed]
  7. designing database to hold different metadata information
  8. Same data from different entities in Database – Best Practice – Phone numbers example
  9. Sql – Indirect Foreign Key
  10. Defining multiple foreign keys in one table to many tables
  11. What are the lengths of Location Coordinates, latitude and longitude? [closed]
  12. Are nulls in a relational database okay? [closed]
  13. Why use multiple columns as primary keys (composite primary key)
  14. Database schema which can support specialized properties
  15. How do you deal with polymorphism in a database?
  16. Nullable Foreign Key bad practice?
  17. How do I design a database to store properties, selecting attributes by synonyms
  18. Composite primary key or not?
  19. Hash Collision – what are the chances? [closed]
  20. How do you determine how far to normalize a database?
  21. Can we create multicolumn unique indexes on MS access databases?
  22. Should I have a dedicated primary key field?
  23. What is the best database schema to support values that are only appropriate to specific rows?
  24. Database design for audit logging [closed]
  25. Should I use a single or multiple database setup for a multi-client application? [closed]
  26. A column as primary key or two foreign keys as primary key
  27. How to Store Historical Data [closed]
  28. Bill of materials database model
  29. What are design patterns to support custom fields in an application?
  30. mongodb schema design for blogs

Leave a Comment