GitHub repository: AndriyLadanay/TestApp
Primary language: Java
Created: 2017-10-30T08:15:01Z
Description: 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))