Your question is Attendance Management Schema and SQL. Start with the requirements and the two tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
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 |