薪资软件 - 需要有关设计问题的帮助 [英] Payroll Software - Need Help on Design Issues

问题描述

我是为我的公司设计薪资应用程序。我设计了大多数表格，并在需要时将它们相关联。但是，我坚持使用Deduction表，我觉得我需要像你这样的专家的帮助。我将简要解释一下表格设计：

I'm designing a Payroll application for my company.   I designed most of the tables and related them wherever required.  However, I stuck with Deduction table where I feel I need help from experts like you guys.  I will explain the table design briefly:

推荐答案

纠正我，如果我错了，你需要在每个月从员工工资中扣除一笔金额时添加一条记录，如果是这种情况，那么你的设计没问题，你有一个员工表和扣减类型表，当从员工工资中扣除时，你会在扣除表中添加一条记录，考虑到employeeID，DeductTypeID和DedEffectiveDate是独一无二的。

Correct me if I am wrong, you need to add a record when ever an amount deducted from the employee salary per each month, if this is the case then your design is fine, you have an employee table and deduction type table, when ever there is a deduction from the employees salary, you will add a record to the deductions table considering that the employeeID, DeductTypeID, and the DedEffectiveDate are unique.

这篇关于薪资软件 - 需要有关设计问题的帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！