Question : I’ve a scheme of two main tables: problem and tag and a relation (which is a many to […]
Tag: relations
Database: One table or many
Question : I am working on a project of classified ads site. I have 12 main categories, and their items […]
Need a better approach in how to design this relation
Question : I have a table fluxo, and fluxo have many fluxo_acao, but a entry in fluxo_acao can have three […]
MS SQL DB design help
Question : I’m stuck with table design and query FOR XML Sync engine for Ads requires XML schema in this […]
Get data from different tables indexed by same ID
Question : Database: postgresql 12. I have a table people: person_id | name ———-+—– 1 |John 2 |Paul 3 |Jim […]
Table with relation to two others (three-way relation?)
Question : I stumbled across a weird situation that one table has relation to two others but record in it […]
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 […]