Console app that implements such commands: 1.Who is head of department {department_name} 2.Show {department_name} statistic 3. Show the average salary for department {department_name} 4. Show count of employee for {department_name} 5. Global search by {template}. Data is fetched from relational database. Underlying database is SQL Seqver. Database consists of 3 tables - lectors (id int primary key, name varchar, degree varchar, salary int), departments(dp_id int primary key, dp_name varchar, head_of_department varchar) and lectors_departments(lector_id int references lectors(id), department_id int references departments(dp_id) primary key (lector_id, department_id))