Question : I have an assignment that requires me to use particular attributes. The query that I have is. If […]
Category: Database Design
Modelling users and groups – but with multiple types of groups
Question : I’m modelling a user management system in PostgreSQL that is fairly typical in that it consists of users, […]
optimize design for a table with 50 columns [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Efficient way to store multi choice in a column with few options
Question : I am looking for advices on how to handle multiple choices in a column? By way of example […]
Handling of Topic Drill Downs in Databases
Question : I have a requirement wherein I have to set up a drill down feature. For example: There is […]
How to link other tables (entities) to parent and child categories?
Question : I am not a developer by any means, but I have a fairly good understanding of how relational […]
MYSQL Indexes when looking up on alternating sets of columns
Question : I have a table that looks like: CREATE TABLE `connections` ( `connection_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `service_id` […]
Are there situations where queries are formed geometrically?
Question : The topic came up in this other question. We were discussing sign value on a primary key having […]
Database structure for product attributes on orders
Question : I’m making a POS and currently kind of stuck on the order proccess due to the product attributes. […]
Every “INSERT” query check a combination of column’s records
Question : Unfortunately, my mind has stacked right now and i would like to design a really simple DB schema. […]