For my project, I developed an innovative employee tracking system aimed at simplifying workforce management for businesses. This tool is specifically designed to streamline the process of monitoring employee details, job roles, and departmental assignments. A key aspect of this project was my immersion into the world of mySQL, a robust database management system. I acquired hands-on experience in creating and managing tables directly through a terminal, enhancing my technical skillset in database operations.
Clone the repository to your local machine
1. git cloneEnter password for mysql db in server.js
Log into mysql on local machine than enter password
2. mysql -u root -pAdd the schema.sql to create the database structure
3. SOURCE schema.sql;Add the seeds.sql to populate the database
4. SOURCE seeds.sql;Install dependencies and start the local server
5. npm iTo get started with this project, you'll need to use the integrated terminal in your server.js environment. Here's how to kick things off:
Open your terminal within the server.js environment:
npm startOnce the program starts, you'll see a variety of options. Choose the one that fits your needs.
After selecting an option, simply follow the on-screen prompts to proceed. Additionally, I've included a helpful video demonstration to guide you through the process.
Tutorial video 🎬
If you have any questions about this project, please feel free to contact me:
- GitHub: @rodrigo0599
- Email: rodrigo0599@hotmail.com