I
I
Ivan Melnikov2019-10-18 09:41:01
Database design
Ivan Melnikov, 2019-10-18 09:41:01

What requirements for the database (and interaction with the database) should be included in the TOR for the site?

Is it worth it to demand as much as possible to shove the logic of data processing (for displaying reports, graphs, tables) into the database, and connect the script on the backend to the database through ORM?
Is it worth requiring that
- all tables in the database schema be at least 3NF and not higher than BCNF,
- the types of all fields are minimally sufficient,
- hash sums are stored in fields of BINARY type,
- etc.?
Can you recommend some reading on this topic?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
I
Ivan Shumov, 2019-10-18
@inoise

If you have a separate database administrator, then yes, in certain cases. If not, just forget.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question