Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
Category: Database Design
What’s difference between standard view and indexed view in SQL Server [closed]
Question : It’s difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or […]
Is it better to store calculated values or recalculate them on request? [duplicate]
Question : This question already has answers here: Closed 11 years ago. Possible Duplicate: Storing vs calculating aggregate values At […]
Constraining inserts/updates for summary tables with complex validation logic
Question : I am designing some MySQL tables and am running into an issue that I believe can be solved […]
Implementation of a many-to-many relationship with total participation constraints in SQL
Question : How should I implement in SQL the scenario depicted in the following Entity-Relationship diagram? As it is shown, […]
Extra rows or Quantity Column DB Design [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
How to handle “or” possibilities in MongoDB
Question : I’m new to MongoDB and by no means an expert in DB design in general. This feels like […]
How to join different tables with same propriety tables?
Question : Which would be the best solution to join 4 different tables with X tables that has to be […]
Clean Code – On which side to place the key
Question : I am currently modelling a database schema. In it, addresses are used several times, which follow a fixed […]
Table normalisation and empty values [duplicate]
Question : This question already has answers here: Why shouldn’t we allow NULLs? (8 answers) Closed 2 years ago. Here […]