database-design

  1. Database Design when Admin and Employee have similar roles except Admin can see all the other Employees Data
  2. Is it a bad practice to have several mutually exclusive one-to-one relationships?

  3. What is the definition of bad circular dependency?
  4. True beginner needs advice for online database

  5. Database Design Help: MySql/PostgreSQL Single Database/Multiple Databases
  6. Is there a standard implementation of a Users Database?

  7. Reduce a huge number of possibilites to something manageable?

  8. Creating my own database

  9. Database anonymization and security

  10. Find most frequent values for a given column

  11. trend analysis database schema

  12. One status table for all models?
  13. a user, that is a organizer can create conferences, but can also participante in conferences
  14. possible/available appointments table

  15. Is our use case suitable for a NoSQL Database solution?
  16. Table data capitalization

  17. Spliting Datetime into 2 Columns for Restaurant Reservation Schema?

  18. Decrease size of database (with an expression index)?
  19. Linking MS Access 2010 to Outlook Inbox: Including Attachments

  20. SQL Replication Automatically Add table to Publisher

  21. Should I use a pivot table or not?
  22. Create an encrypted, searchable database

  23. Designing a database structure for Partners and Websites

  24. SQL Relationship between Subtree Cost and Performance Time

  25. Foreign Key as Primary Key when "converting" conceptual entity-relationship elements to logical relations
  26. BCNF decomposition excercise

  27. Does my entity-relationship diagram reflect the relevant business rules?
  28. Troubles with an attribute that depends on the value of another attribute

  29. What is the best way to model an invoicing system with different forms of invoice items?

  30. Tracking changes on a table

  31. Contact system database design

  32. Database design - need someone to guide me

  33. Is this acceptable practice for a many to many?
  34. Advice on a basic design, first time database design

  35. Database design - People and Organisations

  36. How to model a three-way association that involves Product, Category and Label?

  37. Modeling a scenario in which each Music Artist is either a Group or a Solo Performer

  38. Database design: How do i connect these two tables of my database in a normalisation way

  39. Drawing an entity-relationship diagram for a store business context

  40. One-to-"Zero or One" Relation

  41. Double Entry Bookkeeping Database Design - Views vs Derived Tables vs Python Processing

  42. Design using multiple tables for 1 booking table

  43. Recommended way to handle a "type" column in Postgres

  44. Comparison Tool for MySQL data base schemas
  45. Make MongoDB close open files
  46. Database about a forum design issue

  47. Multiple product attribute inventory database design

  48. How to create a flexible table schema for storing messages from different chats?

  49. Schema design for user activity logging
  50. CouchDB and document versioning

  51. Is a composite index also good for queries on the first field?

  52. storing file paths in table
  53. Store parameters of various types

  54. What does column family-oriented datastore mean in practice

  55. How to efficiently clone database records together with all child elements

  56. Access Web App query 3 Tables with aggregatios - Need a workaround

  57. Is it better to create additional tables in order to avoid too many foreign keys?

  58. In an ER diagram, do all entities need to be connected?

  59. How to design a graph database in this scenario?

  60. What's the best database design for implementing categories and tags?

  61. Use of Multiple Collections vs Embedded documents Mongodb
  62. PostgreSQL partitioning vs. using multiple DBs
  63. What symbols in this ER Diagram represent one-to-one, one-to-many, etc...?

  64. How to make it Secure?
  65. Store table names to reference other tables

  66. Avoiding a possible table reference error
  67. Can I add a unique constraint that ignores existing violations?

  68. Database Design for Sports Stats

  69. Normalization to 3NF Homework Help

  70. How can I draw an entity-relationship diagram for a medical business domain?

  71. Modeling a database for a printing company
  72. 2 doubts in db design
  73. Drawing an entity-relationship diagram for a construction company
  74. Database structure - am I "over-doing" it?

  75. Storing 128D facial descriptors for search-ability

  76. How to write a query, with multiple foreign key in mysql
  77. How can I model a medical scenario in an entity-relationship diagram?

  78. Avoid using complicated strings in Joins in SQL Server?

  79. How to represent the optionality of a many-to-one mandatory relationship from the Parent to its two Child entity types in an ERD?
  80. Storing and querying rolling data in PostgreSQL

  81. Best way to store currency values on MySql database
  82. how to merge two or more tables sorted according to date
  83. postgresql: there is no unique constraint matching given keys for referenced table

  84. mysql database, 2400 records for 1500 rows
  85. SQL - Grant Access Rules to Table with Specific ID

  86. Should name suffix (Jr. Sr. III) be a separate field?
  87. Optimize large table design

  88. MySQL - Design + Optimization Question

  89. Simple forum class structure

  90. How to design parent, child, photos relationships in mysql when photos can belong to either parent or child?

  91. How to do this in a relational way: a database with tables that have UUIDs appended to their name
  92. Database Structure with Recurring Payment

  93. Reorganizing a subject area in ERwin

  94. Table just for grouping

  95. Allow access to enter data through forms, but not full database access

  96. Difference between two XMLTYPE datatypes

  97. Best design approach to Overriding Table Fields
  98. One Big Database vs. Several Smaller Ones

  99. What are the best practices regarding lookup tables in relational databases?
  100. Should I use a separate table to store image file names?