Create a Simple Payroll Management System

In our second project, we’ll put what we have learned so far into practice by creating a simple payroll management system with Rust.

Project overview

There are three parts to this project:

1. First, we’ll create a database with a table representing the employees. We’ll also set a method to initialize the connection and the DB, as well as perform simple operations on the employee model.
2. Next, we’ll add another table to record the hours each employee works during a h month. Ideally, an employee’s hours should be logged automatically when they swipe their badge at the beginning and end of each shift.
3. Finally, we’ll add the option of creating a simple payment slip for each employee.

Our goal is not to build a complete system, but to learn how to build a simple system that can easily be improved upon.

The exercises

After checking the code of the first and second steps, test your understanding with a simple exercise. The code solution is given in the next section. After checking our solution, we’ll cover some examples of how to improve the system.

We hope you will enjoy this project!