BACKGROUND A former business administration student contacted your instructor for help in setting up a database. This is what he wrote. Dear Professor, rn a temporary employment agency that matches companies with temporary employees for a predetermined length of time. My agency specializes in providing COBOL programmers to companies that need help revising their codes for the year 2000. My business started with just a ew client companies and a handful of temporary employees. Since then, the business has grown rapidly, mostly due to the explosive demand for competent IS workers. I need a data- base system to match employees with jobs, to send out job offers displaying potential earnings, and to bill the companies for my headhunting fee. I would like you to set up an Access database with three reports that I can run weekly. Report1 needs to show me the jobs that have had employees assigned to them Once that report is generated, I should be able to run Report 2, which should display employees matched with job openings, the start date, and total potential salary. This report will be used by the secretaries to type up the position offers for my employees. (Keep in mind that employees can only work on one job at a time.) The final report, Report 3, will calculate the amount of money I will bill the companies that use my agency for hiring temporary employees. The client companies pay employees directly, and I bill the client companies for my fee, which is 15% of the total salary paid to the employee. Here is an example of my Report 3 headings: Agency Fe In order to produce these reports, you will need to set up the database to log all my client companies, their contact people, jobs available, established fees for jobs, employees' names, and each employee's field of expertise. In the table that lists positions available, I need to be able to mark whether a position is filled" or not. "Filled" can mean either that the job is currently filled, or that a specific person will fill it in the future. So, if an employee has been assigned to a future job, you can consider that job "filled. I certainly hope you can help me with my problem, and I wish you the best of luck for a good database design. Yours truly, Tom Watson