systems analysis & database design

hi i have a qestion regarding the design of a data base, i am designing a database which has table in it called jobs, ths table will shows all the jobs that the company has done and the employee who has worked on them.
I also have an employee table which has a record of all the employees and their wage.
the jobs table will work out the ost of the job by multiplying the time spent on the job by the wage.
I have done this and i think it is quite easy. The thing i dont understannd is what happens when an employee leaves, as the employee will have no entry on the employee table so when looking back to when they did a job their will be no value for the cost of it. Please could some one tell me if there is a standard way to get round problems like this.
thanks Received on Mon Aug 07 2000 - 00:00:00 CEST