database-design 475

  1. What's the difference between identifying and non-identifying relationships?
  2. MongoDB vs. Cassandra
  3. Database, Table and Column Naming Conventions?
  4. Database development mistakes made by application developers
  5. Difference between scaling horizontally and vertically for databases
  6. What is the ideal data type to use when storing latitude / longitudes in a MySQL database?
  7. Can I have multiple primary keys in a single table?
  8. Auto Generate Database Diagram MySQL
  9. Is storing a delimited list in a database column really that bad?
  10. Should each and every table have a primary key?
  11. What does character set and collation mean exactly?
  12. What are database normal forms and can you give examples?
  13. Recommended SQL database design for tags or tagging
  14. What are the best practices for using a GUID as a primary key, specifically regarding performance?

  15. Relational Database Design Patterns?
  16. Calendar Recurring/Repeating Events - Best Storage Method
  17. First-time database design: am I overengineering?
  18. What does principal end of an association means in 1:1 relationship in Entity framework
  19. What's wrong with foreign keys?
  20. Use email address as primary key?
  21. Max length for client ip address
  22. What should every developer know about databases?
  23. “Prevent saving changes that require the table to be re-created” negative effects
  24. Schema for a multilanguage database
  25. What does ON [PRIMARY] mean?
  26. What is the maximum length of latitude and longitude?
  27. What are OLTP and OLAP. What is the difference between them?
  28. How big can a user agent string get?
  29. How can you represent inheritance in a database?
  30. What are best practices for multi-language database design?
  31. Subqueries vs joins
  32. What is purpose of database schema?
  33. Surrogate vs. natural/business keys
  34. Database Design for Tagging
  35. What's the longest possible worldwide phone number I should consider in SQL varchar(length) for phone
  36. Create unique constraint with null columns
  37. Storing money in a decimal column - what precision and scale?
  38. Remove Primary Key in MySQL
  39. Storing SHA1 hash values in MySQL
  40. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  41. Are soft deletes a good idea?
  42. Good tool to visualise database schema?
  43. NoSql vs Relational database
  44. Strings as Primary Keys in SQL Database
  45. Is there ever a time where using a database 1:1 relationship makes sense?
  46. When/Why to use Cascading in SQL Server?
  47. How to version control a record in a database
  48. Database Structure for Tree Data Structure
  49. SQL ON DELETE CASCADE, Which Way Does the Deletion Occur?
  50. Using a Single Row configuration table in SQL Server database. Bad idea?