Case Study: Castleville Council Services
Castleville council provides a range of support services and facilities to assist individual people and groups in
their area to help them lead a happy and comfortable life. The council provides different types of services such
as sports services or services related to health, day care facilities or providing services to people who have
physical or learning disability. The council is planning to develop a web based system that will make the service
management process more efficient for them as well as for the people availing those services.
Summary of Requirements
The proposed system should be able to identify eligible people (client) by individually assessing them
according to their need and priority that is decided based on the information entered into the system by social
workers or council staff. Some of these services are free of cost for people living in that vicinity however, some
services may incur a fee to offset costs and that is related to the person’s ability to pay. From time to time, the
council can add new services or update or delete existing services.
Castleville council also operates a complaints and representations procedure. People can provide feedback
about their experience and services offered to them for future improvements. The system should incorporate
this feature as well.
The system should keep a record of individual client details that might include their name, address, contact
details, payments made, current status, allocated social worker etc. There should be a facility for council
supervisors to generate administrative reports regarding services provided to different people. There need to
be restricted access to any confidential information about clients to those authorised to view the data using a
password system
You as a system analyst, are hired by the council authorities, to analyse and design the council services
management system that should be able to perform tasks according to the details provided in the above case
study. This will also require you to make necessary assumptions and clearly document all your assumptions in
your report.