Employee database that records working departments and roles along with employee records and chains of command within a company.
As a personal business grows in size and new employees join as stakeholders, the collective company becomes more intricate and complicated. Oftentimes, modern companies, especially start-ups, grow exponentially quickly, and managing each employee can become difficult. In larger, more established companies, employee management can be equally difficult when working with teams abroad or with third-party contractors from all over. This project aims to provide a database-solution to keeping track of all stakeholders of a given business, from managers to non-managers across all departments and roles.
I learned that querying a database via MySQL must have perfect syntax, as MySQL is a very unforgiving language. Database languages in general are extremely powerful and can deftly adjust and display information with just the right type of table joins. This first experiment with MySQL allows for room for growth in honing queries and returned values so that the database can be managed even more effectively.
To run this interface, please clone this repository locally to your machine.
- Be sure to install Node.js version 16 and run
npm iin the root folder to install Inquirer, MySQL2, Console.Table, and Figlet packages. - Initialize the app in the root folder with
node index.js. - Follow the prompts in the Main Menu to begin managing your company's employee data!
- After initializing with
node index.js, a Main Menu will guide you through. - Select an action, then be sure to respond to each prompt until you receive a notification that your action has been completed, whether it is a table that prints for your review or a confirmation message.
See demonstration of how it works here!
Not currently accepting contributions. Thank you for your interest!
Testing not provided at this time.
- creator: miacias
- email: [email protected]
Documentation referenced:
- Mozilla Developer Network (MDN)
- Stack Overflow Forums
- MySQL2 node package
- Inquirer node package
- Figlet node package
Tutorials referenced:
Tools used:
Tutor(s):
- Alexis San Javier - database queries with a focus on different types of
JOINtable merges - David Gaither - deleting from databases and related properties:
not null,on delete set null,cascade
U. Penn Bootcamp instructor(s):
U. Penn Bootcamp study groups:
MIT
