Question : So there have been many questions on Stack Exchange DBA and Stack Overflow that go close to answering […]
Category: Database Design
Optional oneToOne relations and criteria field
Question : Introduction: Visitors can fill reports on my website. Those report can either be filled by a legalPerson or […]
Copy of a database with an existing database with schema and data in sql server
Question : I have two databases one is having master kind of tables and other will have transaction data. I […]
Database design for holding read/unread content state
Question : In forum application I have member table and post table. What I need is to keep track of […]
How to optimize table for arbitrary user-made queries?
Question : Let’s say you have have a large-ish database table, and you’d like to allow users to query it […]
Multiple one-to-one relations
Question : I’m trying to design database relations for archaeological places in a country. There are around 9000 places registered. […]
How to mark the default row to select in a many to many relationship
Question : To start off, I have the following tables: products – a list of products images – a list […]
Should I use MongoDB or a relational database management system for this scenario? [closed]
Question : Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the […]
Is creating a joining/bridging table the most practical and efficient way of normalizing numerous M:M relationships in a database?
Question : Let me start with an example: Table users: ID | Name ——— 1, Kirk 2, John Table class: […]
How should I model a database structure to retain calculation results?
Question : I am trying to improve the performance of the queries related to one table that I consider “weird”, […]