issues
search
stevreut
/
employee-tracker-db
Employee database and interface implemented via node.js and MySql
MIT License
0
stars
0
forks
source link
issues
Newest
Newest
Most commented
Recently updated
Oldest
Least commented
Least recently updated
Pad columns beyond minimum necessary size
#38
stevreut
opened
1 year ago
0
Change underscores to spaces in headers
#37
stevreut
opened
1 year ago
0
Right-alignment of numerics - including dollars (which might be javascript string)
#36
stevreut
opened
1 year ago
0
Explicitly close DB connection when done
#35
stevreut
opened
1 year ago
0
Create loop that shows all query options until "done"
#34
stevreut
opened
1 year ago
0
Create schema based on requirements and table diagram
#33
stevreut
opened
1 year ago
0
Sketch/script video before producing
#32
stevreut
opened
1 year ago
0
Remove any temporary resources
#31
stevreut
opened
1 year ago
0
Code documentation
#30
stevreut
opened
1 year ago
0
Remove any TODOs and unneeded console logging
#29
stevreut
opened
1 year ago
0
Draft proof-of-concept version that uses ANY query, ANY prompt
#28
stevreut
opened
1 year ago
0
Review use of inquirer (see svg-maker)
#27
stevreut
opened
1 year ago
1
Review use of await
#26
stevreut
opened
1 year ago
0
Review and take notes on SQL use in NodeJS
#25
stevreut
opened
1 year ago
0
Bonus: View the total utilized budget of a department—in other words, the combined salaries of all employees in that department.
#24
stevreut
opened
1 year ago
0
Bonus: Delete departments, roles, and employees.
#23
stevreut
opened
1 year ago
0
Bonus: View employees by department
#22
stevreut
opened
1 year ago
0
Bonus: View employees by manager
#21
stevreut
opened
1 year ago
0
Bonus: Update employee managers
#20
stevreut
opened
1 year ago
0
Submit via campus with: video link, github repo link
#19
stevreut
opened
1 year ago
0
Record walk-thru video link in README.md
#18
stevreut
opened
1 year ago
0
Store walk-thru video on YouTube
#17
stevreut
opened
1 year ago
0
Create walk-thru video
#16
stevreut
opened
1 year ago
0
Complete README.md file
#15
stevreut
opened
1 year ago
0
Database should have "seeds.sql" schema query based on requirements README diagram
#14
stevreut
opened
1 year ago
0
SHOULD be .mjs and use appropriate "import" and "await" statements
#13
stevreut
opened
1 year ago
0
Must use inquirer package for prompting
#12
stevreut
opened
1 year ago
0
Must incorporate supporting MySQL database
#11
stevreut
opened
1 year ago
0
Must incorporate MySQL2 package (node/npm)
#10
stevreut
opened
1 year ago
0
User experience should match requirements README video
#9
stevreut
opened
1 year ago
0
WHEN I choose to update an employee role THEN I am prompted to select an employee to update and their new role and this information is updated in the database
#8
stevreut
opened
1 year ago
0
WHEN I choose to add an employee THEN I am prompted to enter the employee’s first name, last name, role, and manager, and that employee is added to the database
#7
stevreut
opened
1 year ago
0
WHEN I choose to add a role THEN I am prompted to enter the name, salary, and department for the role and that role is added to the database
#6
stevreut
opened
1 year ago
0
WHEN I choose to add a department THEN I am prompted to enter the name of the department and that department is added to the database
#5
stevreut
opened
1 year ago
0
WHEN I choose to view all employees THEN I am presented with a formatted table showing employee data, including employee ids, first names, last names, job titles, departments, salaries, and managers that the employees report to
#4
stevreut
opened
1 year ago
0
WHEN I choose to view all roles THEN I am presented with the job title, role id, the department that role belongs to, and the salary for that role
#3
stevreut
opened
1 year ago
0
WHEN I choose to view all departments THEN I am presented with a formatted table showing department names and department ids
#2
stevreut
opened
1 year ago
0
WHEN I start the application THEN I am presented with the following options: view all departments, view all roles, view all employees, add a department, add a role, add an employee, and update an employee role
#1
stevreut
opened
1 year ago
0