Question

Create a database that will record employees and their salary histories. For each employee record their first name, last name, DOB and start date and termination date (if applicable). The salary history should include the $s alary, the range of dates for which the salary is effective (the current salary will not have an end date). The database should also record a history of which departments they have worked for. An employee may only work for one department at a time. For departments, you only need to record the department name.

1. Write the business rule for the database?

Answer 1

As per the question, the database records history of employee along with the history of the employees' salary. The database of the company also records the history of departments, in that table which employee is/was in which department now/then. Now since department history is also maintained. The business rule is that the employee can not work for more than one department in one time. The employee can work for many department but not at the same time. The employee can switch department with time and all those will be recorded in the department database but the employee can not work for two or more department simultaneously. If the employee wants to work for different department then the employee had to change the department and leave the previous department work as per the business rule. Business rule also says that every employee has to maintain history, every employee must provide data which are require for the database, and the employee should also provide data about the history of their salary along with department.