I found the following ERD design:
Which trying to capture as much information about employee leave (i.e sick, travel, etc). What am trying to understand is what does the columns:
Table : Employee_Annual_Leave
- year_number // Why is this set as the PK? What does it mean by
- year_number der_leave_cumulative_days_taken // where could it be possible be derived from?
- der_leave_days_remaining // and how does these two column work in real scenario?
PS: Yes i have read the "Note" box written above it. But i still dont get it.
Could anyone explain what it means?