Attendance Control System using RDS-MySQL directly from the AWS cloud

The algorithm consists of a control system for offices via the PyQt5 graphical interface, connected to an RDS-MySQL database directly from the AWS cloud, without the need for a local server. The system allows the control of the activities / services performed in an office in a simple and easy way, allowing to perform service registration, consultations based and by item the choice of the professional.

Requirements

You will need to install the library below:

• mysql-connector
• PyQt5

Creating RDS-MySQL instance

• Access the "AWS Management Console"
• Open the services menu and select the RDS option
• Select the "Create database" option
• Select MySQL
• Version: MySQL 8.0.11 -> Free tier
• Enter the basic data, username and password:

db instance: "database name"

username: "your username"

password: "your password"

• DB instance size and Storage is default not to mess
• VPC: Default
• Subnet group: default
• Public access: Yes
• VPC security group: Create new

New VPC security group name: <enter_com_the_name>

• Availability Zone: choose where you are connected

Home screen

When opening the interface, the following options are presented:

• Register: Allows you to register a new service in the cloud database.
• Consult: Allows you to consult the service history performed.
• Search: Allows you to search for a specific record through pre-defined fields.

Registration screen

• Initial registration screen

• Registration screen filled. By clicking on "Insert Data" the registered data will automatically go to the RDS database in the cloud.

Base query screen

• When we click "Consult" the interface brings the entire service history to the user.

Search screen by item

• In this screen we can perform a search with filters through the checkboxes and the fields.

• Search result by item.