[] 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
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
- mysqlwww.github.com/vlsulliv
- windows terminal[email protected]
- javascriptwww.linkedin.com/vlsulliv
- nodejs...
node package dependencies mysql inquirer
githubwww.github.com/vlsulliv
email[email protected]
linkedinwww.linkedin.com/vlsulliv
other...