Chapter 13 Running Case Solution Description
Students will have to perform a systems analysis and then design a system solution using
database software. They will need to identify information requirements and then map out
entities, attributes, and relationships to guide the design of database tables. They will
need to populate the database and generate queries and reports that satisfy management
information requirements. This project should not be assigned unless students have the
requisite database skills.
The solution calls for enhancing Dirt Bikes’ employee database so that it captures
employee educational level and training data. The new system could help Dirt Bikes
management identify employees of interest much more rapidly. Information from the
system could also help Dirt Bikes identify skills that are in short supply to help it beef up
its training programs in those areas.
Key information requirements include the ability to identify employee educational levels,
and the ability to identify the training classes employees have taken.