Nusagatizen

Simple Employee assessment Application Design

A few days ago, someone asked for a simple employee assessment application. Even though! At that time, I had no idea at all about the application of employee assessment. Never mind imagining the flow, just imagining its use still cannot. He explained a little about what kind of application he wanted to make. It’s just that, I still don’t understand.

Because I don’t understand, I then browse to find some references related to employee assessment. After getting a little description, I finally started making a project with a very simple flow.

Simple Employee assessment Application Design 2

Table of Employee Assessment Application

The employee assesment I made yesterday used 4 (four) tables, namely: users, criteria, employments, and reports.

The users table is used to store application user data, table criteria are used to store assessment criteria, table employements are used to store employee data that is assessed, table reports are used to store assessment data.

Users Table Design

The users table contains 3 (three) columns, namely: id, username, displayname, and password.

Idusernamedisplaynamepassword
1adminAdmin 1admin1
2staffStaff 1staff1

select * from users

Criteria Table Design

The criteria table contains 3 (three) columns, namely: id, name, and weight. The idea column is used to store the criteria id, the name column is used to store the criteria name, and the weight column is used to store the criteria value weight.

Idnameweight
1Target3
2Age1

select * from criteria

Employments Table Design

The employments table only contains 2 (two) columns, namely the id and name fields. The id column is used to mark entries in record reports.

Idname
1Ahmad Budairi
2Widi Utami

select * from employments

Reports Table Design

Table reports contain 4 (four) columns, namely, id, employers, criteria, and values. The id column used for assessment ids is automatically added (auto increment), the employers column is used to store employee IDs that are assessed, the criteria column is used to store the criteria id, and the value table is used to store the values entered by the application user.

Idemployerscriteriavalue
11110
2126
3215
42226

select * from reports

Output of Employee Assessment

As requested, the application can determine 3 (three) employees who have the highest value. To get the total value of each employee, I use the following formula:

Rumus untuk menghitung total nilai karyawan
Rumus untuk menghitung total nilai karyawan

After all employee values are summed up then sorted in descending terms and taking the top 3 employees. That’s the design of a simple employee application and then I useĀ  PDO dan MySql.

Tahukah Kamu Arti rungguh-2?

rung·guh 2 Mk v, me·rung·guh v bertinggung; berjongkok
Kata Kunci

Ahmad Budairi

Seorang blogger yang bekerja menjadi freelancer di bidang bahasa pemrograman. Baca biografi Ahmad Budairi atau kunjungi lapaknya di Fiverr. Kontak via email: [email protected]. Hubungi via 0822 2500 5825

Tinggalkan Balasan

Alamat email Anda tidak akan dipublikasikan. Ruas yang wajib ditandai *

Back to top button
Close