hard20 pts · first answer countsdata-modellingtemporal-data
What we knew about a salary
HR corrects an employee's January salary in March. Auditors need both "what was the salary in January" and "what did the system say on 1 February". What model supports both?
Discussion 0
Join free to post in the discussion.
Related questions
- Primary key for order linesData Engineer
- Modelling doctors and patientsData Engineer
- Several phones in one columnData Engineer
- Several unique columnsData Engineer
- Picking the natural keyData Engineer
- Reading crow's foot notationData Engineer
- The model with indexes and typesData Engineer
- Why denormalise a reporting tableData Engineer