isaacfallon/12-Challenge-SQL-Employee-Tracker

View on GitHub ↗Related repositories →

This is a repository containing the completed week 12 SQL Employee Tracker challenge for The University of Sydney's Coding Bootcamp.

active 2024-05-24 → 2024-05-28 (UTC)

Complete coverage27,345 / 27,345 hourly files (100%) · 2 absent upstream2023-08-15 → 2026-09-27 (UTC)

Events

Pushes

Pull requests

Issues

Stars

Forks

Activity over time

Daily event counts in the loaded window

Pushes
Pull requests
Issues
Comments
Stars

Top contributors

Pushes, PRs, issues, reviews and comments — stars and forks excluded, so this is contribution rather than popularity

Contributor	Contributions	Pushes	PRs	Comments
isaacfallon	29	4	6	0

Recent activity

Latest issues, pull requests and releases

Issue#2isaacfallon2024-05-28 02:32
Check codebase for typos and grammatical errors
Pull request#18isaacfallon2024-05-28 02:31
Pull request#18isaacfallon2024-05-28 02:31
Issue#10isaacfallon2024-05-26 06:49
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
Issue#9isaacfallon2024-05-26 06:49
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
Pull request#14isaacfallon2024-05-26 06:45
Pull request#14isaacfallon2024-05-26 06:44
Issue#8isaacfallon2024-05-26 05:41
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
Issue#7isaacfallon2024-05-26 05:41
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
Pull request#13isaacfallon2024-05-26 05:40
Pull request#13isaacfallon2024-05-26 05:40
Issue#6isaacfallon2024-05-25 07:20
WHEN I choose to view all departments THEN I am presented with a formatted table showing department names and department ids
Issue#5isaacfallon2024-05-25 06:24
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
Issue#12isaacfallon2024-05-24 23:13
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
Issue#11isaacfallon2024-05-24 23:13
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
Issue#10isaacfallon2024-05-24 23:12
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
Issue#9isaacfallon2024-05-24 23:12
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
Issue#8isaacfallon2024-05-24 23:12
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
Issue#7isaacfallon2024-05-24 23:12
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
Issue#6isaacfallon2024-05-24 23:12
WHEN I choose to view all departments THEN I am presented with a formatted table showing department names and department ids
Issue#5isaacfallon2024-05-24 23:12
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
Issue#4isaacfallon2024-05-24 23:11
Once project is complete and meets all acceptance criteria, create video submission showing how it runs
Issue#3isaacfallon2024-05-24 23:11
Create detailed README.md file explaining the application
Issue#2isaacfallon2024-05-24 23:11
Check codebase for typos and grammatical errors
Issue#1isaacfallon2024-05-24 23:11
Final check of application against all acceptance criteria before submitting

Totals cover only the window loaded into ClickHouse and count events, not GitHub's lifetime totals — 0 stars here means stars gained during the window, not the repo's star count.