Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
Chapter 13 Running Case Assignment: Achieving Operational Excellence:
Designing an Employee Training and Skills Tracking System and Database
Software skills: Database design, querying, and reporting
Business skills: Employee training and skills tracking
This project requires you to perform a systems analysis and then design a system solution
using database software.
Dirt Bikes promotes itself as a “learning company.” It pays for employees to take training
courses or college courses to help them advance in their careers. As employees move on,
their job positions become vacant and Dirt Bikes must quickly fill them to maintain its
pace of production. Dirt Bikes’s human resources staff would like to find a way to
quickly identify qualified employees who have the training to fill vacant positions. Once
the company knows who these employees are, it has a better chance of filling open
positions internally rather than paying to recruit outsiders. Dirt Bikes would like to track
each employee’s years of education and the title and date completed of training classes
that each employee has attended.
• Dirt Bikes currently cannot identify such employees. Its existing employee
• Prepare a systems analysis report describing Dirt Bikes’s problem and a system
solution that can be implemented using PC database software. Then use the
database software to develop a simple system solution. Your report should include
the following:
1) Description of the problem and its organizational and business impact.
2) Proposed solution and solution objectives.
4) Management, organization, and technology issues to be addressed by the
solution, including changes in business processes.
• On the basis of the requirements you have identified, design the solution using
database software and populate it with at least 10 records per table. Consider
