Question : I’m creating the DB for a system and in it is an alert system, where, when a certain […]
Category: Database Design
Database layout to keep track of the “freshness” of a column value in a specific row
Question : I have a Person with columns like name, address and bio. How do I store data in order […]
Is it bad to have a cyclical relationship?
Question : I have 5 tables that have ended up with a cyclical relationship and I don’t think that is […]
Both Primary and Foreign Key Needed on Table?
Question : Someone recently asked this question: There are two tables: Deal and DealCategories. One deal can have many deal […]
Design DB for users with different information fields?
Question : Let’s say I want to register all faculty of a university and they are in different fields and […]
Proper normalization for an Orders table–whether to split or no
Question : Each order has a unique SalesOrderNumber. An order is made up of various PartID numbers, each with an […]
How do huge databases handle new users? [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
Database design/structure for address details [closed]
Question : Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the […]
Encapsulate table with view
Question : I need to change the order of columns in my table (Oracle and SQL Server). Reason is that […]
Do I need MySQL Group Replication or a Single Server is enough for Click Counting, etc?
Question : I’m planning to create a system which tracks visitors clicks into the database. I’m expecting around 1M inserts/day […]