Skip to content

Latest commit

 

History

History
50 lines (40 loc) · 2.42 KB

File metadata and controls

50 lines (40 loc) · 2.42 KB

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

Fields

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

Projects

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

Engineers

Displays all engineers currently in the Database

Engineers

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