Design a database schema/tables for a company's employee attendance management system using two tables, and write simple SQL queries against it.
Asked in the Virtual Onsite stage. Round 1 of VO.
| Column | Type | Description |
|---|---|---|
| employee_idPK | INT | Unique employee identifier |
| employee_name | VARCHAR(100) | Employee full name |
| department | VARCHAR(100) | Employee department |
| Column | Type | Description |
|---|---|---|
| attendance_idPK | INT | Unique attendance record identifier |
| employee_id | INT | References employees.employee_id |
| attendance_date | DATE | Date of attendance |
| status | VARCHAR(20) | Attendance status such as Present or Absent |
| check_in_time | TIME | Check-in time when available |