Using appropriate modelling techniques, design and specify a prototype database information system solution.

Information Systems Case Study
Identify a small information system problem (or opportunity) in an organisation you
are familiar with OR that is described in a written case study, and carry out the
following tasks:
1. Using appropriate modelling techniques, specify the scope of the problem, and provide an analysis of the current reality and any requirements for a solution.
2. Using appropriate modelling techniques, design and specify a prototype database information system solution.
3. Develop and document the prototype.
4. Outline a set of realistic implementation plans for the new information system. Discuss issues (organizational, human, technical, contextual) that might affect the
successful implementation of the system.