Managing High-Tech Company DB

• 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

Project Overview

Fields

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

Projects

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
• Top Projects: View high-investment projects
• Select & view a project development tools
• Select & display engineers that are working on the project
• Select & display project milestones

Engineers

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
• View Projects: Select & display engineer's projects