The scenario
A company needs to track employee attendance records.
What is in this drawing
Read the decisions behind it.
01
Decoupling employee and attendance into separate entities
02
Using foreign key to link attendance to employee
03
Allowing one employee to have many attendance records
When designing a database for HR systems to log employee check-in/check-out times.
More like this