V
V
Vladislav Kondrashov2018-12-21 17:37:41
Programming
Vladislav Kondrashov, 2018-12-21 17:37:41

What is the best way to store data in this case?

Colleagues are arguing how to do it right:
Example:
An expense accounting application stores transactions with the attributes "Amount", "Description", "Expense/Income".
Essence of the question:
Colleague No. 1 claims that there should be two cells of expenses and receipts, in which transactions with an amount and description will lie.
Colleague No. 2 claims that there should be one cell in which transactions with the values ​​\u200b\u200bof "Amount", "Description", "Expense / Income" lie.
Who is right and why? If possible, I would like to read some content on this topic.
PS I'm generally a designer, I just got into this dispute and it became interesting myself

Answer the question

In order to leave comments, you need to log in

2 answer(s)
D
Dave, 2018-12-21
@djay

Spanish shame. There are simply no words.
Colleague #1 is right. Colleague #2 should read the database normalization rules.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question