Lab schema (HR schema) is listed as below (primary keys are underlined):

Regions(region_id, region_name);
Countries(country_id, country_name, region_id);
Locations(location_id, street_address, postal_code, city, state_province, country_id);
Departments(department_id, department_name, manager_id, location_id);
Jobs(job_id, job_title, min_salary, max_salary);
Employees(employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id);
Job_History(employee_id, start_date, end_date, job_id, department_id);

• Get familiar with developing database application programs using C++ and Oracle Call-level Interface OCCI

Your task:

Using C/C++ and OCCI, oracle CLI library functions, develop a database application program that:

use the data stored in the schema HR, retrieve and display the data of all employees working in a department. The department's name is passed into your program either as a command line argument or interactively.
The information to be displayed should include each employee's employee_id, full name, and phone number.
If the department name given is not valid, show an appropriate message.
If no employee works in the given department, also show an appropriate message.

You can use either prepared statement or unprepared statement, or try both in this lab. If you decide to use unprepared statement, don't forget to sanitize the user input.