Question : I am building a inventory software for mobile phone retailers. There are several things confuse me. Ok, we […]
Category: Database Design
Database for opening times of locations
Question : I’m designing a database for opening times and created this solution. The specifications of the database which will […]
Survey DB Design. No user answers, only questions
Question : The task is to SQL a bunch of surveys in order for the researchers to have examples for […]
Design Tagging module in the database
Question : I’ve a database system which we want to define tags for many tables into it. For example I’ve […]
Express union which is dependent on other results
Question : I would like to make a union of two tables that are actually in a hierarchical constellation. How […]
Different type of column
Question : Maybe the title is misleading but I’ll try to explain what I’m trying to do. I’m building an […]
Closed loops in database model, does it affect the performance?
Question : I have heard that having loops in the database relational model should be avoided. From what I can […]
Flag vs table split
Question : I am designing a table of items which will (potentially) contain tens of millions of records. Some items […]
Postgres jsonb column or standard normalized table?
Question : I’m implementing an app with a payment system, and I need to record transactions that are made through […]
Does this medical database look correct?
Question : I’m pretty new to databases and I’m trying to create some schemas. I’ve been working away at this […]