Where and how can I create a database with a formula other than Excel?

Question

Automation

Good afternoon.
Today there was a task: to create a database with formulas and data output. Yes, I know, there is Excel, but I need separate data types to be in different tables and, based on new data, it would be possible to edit existing data. Main types of tables:
1. Employees. It's all about people.
2. Calculation of expenses per day/week/month. There will be such columns: Name, salary, working hours, number and type of work. Accordingly, every day a new table will appear (for example, 11/3/16), which will affect two tables: "1st week of November" and "November".
3. Rates by type of work.
I do not consider 1C, since it is paid. OpenOffice Base, as far as I understand, does not contain formulas, although in terms of functionality it is quite sufficient for the basics. The option of creating your own structure is not yet possible, but I will also consider it if there are no ready-made solutions.
PS People change, so each new day should be separate, so that the account is not kept for the whole time and sometimes new tables are not created manually.

Answer 1

Microsoft SQL, Oracle - they definitely know how to
PostgreSQL - perhaps
OpenOffice Base - can work with queries in the SQL language and, if desired, it can be turned into something similar to 1C.
You need to revise the data structure - most likely there will be a table of employee performance - each entry for a separate period of time that the employee worked. And with the help of queries it will be calculated for the required period. It is better to read some database literature on how to link tables.

Answer 2

in any subd it is possible to do triggers on an insertion, updating, deletion. create tables, delete
from the office package MS Access is gorgeous for small home databases

Answer 3

Do it on 1C.

Answer 4

If you change values ​​through buttons, you need to separately report this through trigger('change'):
select
.children(`option[value='${value}']`)
.prop('selected', true)
.trigger(' change');