Question : I stumbled across a weird situation that one table has relation to two others but record in it […]
Tag: relations
Mysqldump subset of database with relational data using a master table
Question : I have found a lot of articles describing the concept of exporting and importing relational data, but I […]
Constraining data based on related data in a different table. Should this be done on the database level or the application level?
Question : I am working on a database that contains our customer information as well as information about our vendors. […]
Whats the right table relationship for these entities?
Question : I want to store all the data for the following entities: Users Projects Roles A user can work […]
How to create a reference in a many-to-many relationship with transact SQL?
Question : I am creating my first database using only code (I don’t like to use graphical interfaces, I feel […]
Database: One table or many
Question : I am working on a project of classified ads site. I have 12 main categories, and their items […]
How can I avoid this circular relation?
Question : I based my account/user table design following this article. So I have set my table relationships to look […]
Proof that Inner Join is Commutative
Question : I’m trying to prove to myself that the order of inner joins doesn’t matter, but, in an abstract […]
Return “parent” rows where only one “child” record exists in one-to-many relationship
Question : Having a one-to-many relation, I am trying to get records in the accounts table where only one record […]
Recursive Relationship [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]