The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
38 views

How is called the reciprocal operation of the join on two tables

Consider two tables in a relational database 1|A 2|B 1|X 1|Y 2|Z whose join on the first column is (if we drop the column used for the join) A|X A|Y B|Z How is called the converse operation ...
2
votes
0answers
112 views

Is this a good implementation of mongodb for a money management tool?

I have a money management tool which has users. Each user may have several accounts/funds (e.g. bank account). For each account/fund there may be thousands of transactions. Users may only view their ...
2
votes
0answers
160 views

Redmine - Database Structure/Normalization

I am using redmine for project management and issue tracking. I was looking at the database tables and the underlying structure and was wondering if anyone who is experienced with database ...
0
votes
0answers
89 views

Fixing data duplication in two similar tables in different databases

I'm currently doing maintenance on an old order system that has grown into the poster child for bad coding practice. One of the tings I'm dealing with is a lot of data duplication, which I want to ...