Question

Chapter 12 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 database is limited to basic human resources data, such as employee name, identification number, birth date, address, telephone number, marital status, job position, and salary. A portion of this database is illustrated here. You can find some sample records from this database on the Laudon Web site for this chapter.   Dirt Bikes’s human resources staff keeps skills and training data in paper folders.

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:

Description of the problem and its organizational and business impact.

Proposed solution and solution objectives.

Information requirements to be addressed by the solution.

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 whether you can use or modify the existing employee database in your design. Print out the design for each table in your new application. Use the system you have created to create queries and reports that would be of most interest to management, such as which employees have college education or which employees have training in project management or advanced computer-aided design [CAD] tools.

Answer 1

Description of the problem andits organizational and business impact: The problem is that the companydoesnot have a succession plan or career planto develop people to fill in potential a empty vacant. Proposed solution and solution objectives The solution for thisproblem is create talentpools to identify people who want to develop a career on the company but in order to develop the talentpool management needs appraisal reviews every 6 monthor l year. Informationrequirements to be addressed by the solution Managementneeds to set goals to each of their employees and review them onamonthly basis and at the end oftheyear develop an appraisal review. With the score of the review the manager can create talentpools and will have a clear vision on who could take anewposition or fill his position. Appraisalreviews often include skills besides goals; theseskills depend on thajob typa ofthe employee and mustbemeasured as well. People, organization, and technology is sues to be addressed bythe solution, including changes in business processes The change mustcome from management, every person that works in the company reports to someone until you reachthe highestpositionlike a VP, CEO or board of directors dependingon howthe organizationwas established.Everyone shouldhave goals and they need to be measured monthly, this can be done byusing MS Excel or advance Cloud Platforms like Saba Cloud https://www.saba.com us/appsperfomance-work aba cloud has amodule about performance thatI believe is what Dirt Bike needs to measure their personal and has it ready for anewjob position