- Designing, planning and executing Java application to manage high-tech company employees
- Using relational DB – SQLite with the use of complex queries, triggers, union, join and more
Displays all fields currently in the Database
Description
- Add different type of fields to the DB
- Select & update existing fields in the DB
- Select & delete fields from the DB
Displays all projects currently in the Database
Description
- Add different type of projects to the DB
- Select & update existing projects in the DB
- Select & delete projects from the DB
- Bottom Projects: View low-investment projects Low-Invesment Projects
- Top Projects: View high-investment projects High-Invesment Projects
- Select & view a project development tools Development Tools
- Select & display engineers that are working on the project EngineersByField
- Select & display project milestones Milestones
Displays all engineers currently in the Database
Description
- Add new engineers to the DB
- Select & update existing engineers in the DB
- Select & delete engineers from the DB
- Busy Engineers: Display all engineers that currently working on more then 5 projects
- View Phones: Select & display engineer phone number PhoneNumber
- View Projects: Select & display engineer's projects ViewProjects
