Question : I have several tables that will represent an object that can be commented on. I would like to […]
Category: Database Design
Database Table Design
Question : I would like to ask couple of questions regarding my schema table design. I have the following data […]
ER-Model for Borrowing-Lending-Network?
Question : I plan on creating my first database so this is going to be a newbie question. My database […]
Is it good practice to have relationship between the tenant table and all other tables in a multi tenant application?
Question : I am developing a multi tenant SaaS that uses Azure SQL for data storage. I make use of […]
In a one-to-one relationship, where should the foreign key be placed?
Question : I am currently designing an ERD for a project management system. I am unable to choose between two […]
How to determine if there are [idle connections with] uncommitted transactions in PostgreSQL?
Question : According to a comment on this question I asked about idle connections in PostgreSQL 9.2, some uncommitted transactions […]
Users vs. People – where to keep the email address?
Question : I’m designing an app similar to Facebook, called Headtome. I want to have users that create public profiles, […]
How to design a complex multi approval expense db schema in MySQL
Question : I’m very beginner in database design and had the following problem to solve. DB schema design for an […]
Associative property inside functional dependancy
Question : I have a simple question regarding functional dependancy.. is AB –> C the same as BA –> C? […]
Can and should relational database contain tables that don’t have primary keys? [duplicate]
Question : This question already has answers here: Is a table without a primary key normalized? (2 answers) Closed 2 […]