Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Tag: database-design
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` […]
Creating Database Tables for Reviews functionality that incorporates Tags/Categories
Question : I’m wanting to create some simple website functionality through a little database idea I have in order to […]
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. […]
How to design SQL schema that treats historical data as first-class citizen?
Question : I’m currently designing a SQL Server database schema for an application that consists of highly structured “tree” data. […]