Question : http://dirtsimple.org/2010/11/simplest-way-to-do-tree-based-queries.html provides an algorithm for inserting and deleting from a Closure Table. I’d like to model a similar […]
Tag: database-design
Rules for Decomposition to 2 NF
Question : I am struggling with the concept of 2NF form. Lets say I have a set of functional dependencies […]
How to reference categories table in products table?
Question : I am using modified preorder traversal algorithm to store product categories in database (like image shown above). But […]
How should one design a logical data model for a social platform, or skip it?
Question : After studying from ‘Usage-Driven Database Design: From Logical Data Modeling Through Physical Schema Definition’a book by George Tillmann. […]
Implementation Idea for login structure (login id with two different tables)
Question : I am creating a sample web application for a business and I am stuck at the login implementation. […]
Low cardinality fields: integer or string
Question : A Ticket has the statuses: new in_progress on_hold closed I could make ticket.status a string (on_hold) or an […]
Why does data get corrupted in “large” text files – Reasons to use database
Question : I am just starting to learn about databases and using mysql. I read that databases are more reliable […]
Create two tables with identical superkeys?
Question : I have an existing table called Realms. This has the superkey rlmID (just a surrogate key). We are […]
Schema for dynamic number of attributes
Question : I am implementing an application where users can save alerts for different services. Each service can have multiple […]
Database design for millions of posts
Question : I have this issue. I have three types of posts a user can generate (some users can generate […]