Answer
See the explanation
Work Step by Step
To retrieve the Name, Address, JobTitle, and Dept of every current employee from the relational database described in Figure 9.5, you can use the following SQL query:
```sql
SELECT Name, Address, JobTitle, Dept
FROM Employees
WHERE EmploymentStatus = 'Current';
```
This query selects the specified columns from the "Employees" table for records where the "EmploymentStatus" is set to 'Current'.
