This is a Content Management Systems focused-application for managing a company's employee database. It's built with a node interface and uses the inquirer npm package to communicate to a mysql backend. The results are then displayed using the console.table npm package. It has three major components (tables) in the database - Employees, Roles and Departments. Each management table consists of its own views, adding, removing and updating functions which the user has complete control over. The schema files in the sql folder can be consulted to find a detailed database structure.
Download or clone the repo to a working director and extract its contents. Use a Command Line Interface to install necessary dependencies by running the following command:
npm i
To create the database, copy the contents from and run it any application capable of managing MySQL database. MySQL Workbench was used for the development process.
Sample data has also been provided in the
in the form of .csv files for populating your database and demo the app.
Locate the connection.js file inside the config folder and change the create connection function with your appropriate parameters.
Type the following in any CLI to run the app.
node index.js
Each module's functions have also been demo-ed below.
This project is licensed under the MIT License - see the LICENSE.md file for details
Message the owner on github or by email. See CONTRIBUTING.md
If you have any questions about the repo, open an issue or contact me directly at [email protected]. You can find more of my work at shamik05.