Skip to content

vlsulliv/Employee_Tracker

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Employee-Tracker

statement of purpose

roadmap


 [] start the application and read options
 [] if view all departments chosen then presented with a formatted table
 [] if view all roles chosen, then present data
 [] if view all employees chosen. then present: formatted table, employee data
 [] if add a department chosen then prompt to enter the
 [] if add a role chosen then prompt to enter the
 [] if add an employee chosen then prompt to enter the
 [] if update an employee role chosen then prompt to update

database setup


Start app:
    prompt options"
    view all departments,
    view all roles,
    view all employees,
    add a department,    name of the department and that department is added to the database
    add a role, name, salary, and department for the role and that role is added to the database
    add an employee,   name, salary, and department for the role and that role is added to the database
    update an employee role,    update and their new role and this information is updated in the database

DB:
Tables:
1. departments:
        department names
        department ids

2. roles:
        job title,
        role id,
        department
        salary for that role

3. employee:
        ids,
        first names,
        last names,
        job titles,
        departments,
        salaries, and
        managers that the
        employees report to

code & command line


tools used


[mysql2] [mode_modules] [dotenv] [sequelize] [express-session] [handle-bars] [express] [bcrypt]

node package dependencies mysql inquirer

references


  1. [github]
  2. [email]
  3. [linked]
  4. [other]

contact me


githubwww.github.com/vlsulliv

email[email protected]

linkedinwww.linkedin.com/vlsulliv

other...

license


License: MIT MIT

About

No description, website, or topics provided.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published