help needed for database design

[wilkob]

I would like to make a human Resource database that shows in a tabbed form some informations about our employees.

I would like to show per employee:
tab 1: general info (name, address, starting date, type of contract, department)
tab 2: salary history
tab 3: capabilities -whether they are available YES/ NO tick field and for the department the person is assigned to

I am thinking of the following tables:
Employees - EmployeeID, Name, address, starting date, type of contract
Department - DepartmentID, Capabilities
Salary History - EmployeeID, Date, Salary, Notes
EmployeeCapabilities - EmployeeID, DepartmentID, Capabilites [Yes/ No]

The only problem I have is to make the correct relations between the lot of them.

Can anyobe help out here?

 

[gemma-the-husky]

that looks fine - You don't HAVE to define relationships, but they are pretty obvious anyway

eg - the employeeid in the employee table links to the employeeid in the salary history table as a 1 to many. ie 1 employee may have more than 1 salary history.

Defining this on the relationships form can help here and there, and can enforce referential integrity - ie you will not be able to delete an employee (accidentally say) if there is a salary history for the employee.