Inventory System (replacement for existing system)


An inventory system to replace the existing mysql inventory and orders database with web/cgi interface.


A system that has all the positive attributes of the existing system, few if any of its negative attributes and additional features as determined by the requirements capture.

Documentation and training materials for the Computing Support Officer (Administration) for data input and for other computing staff for running queries and reports.


A properly functioning inventory of equipment is a legal requirement for the School/University but the main users of the system will be computing staff.


It would be helpful for management to have a more flexible query and reporting mechanism than exists on the current system


No dependencies on any existing projects.


Propose that it be managed by User Support Unit Manager (Ken Dawson)


Requires understanding of and experience in databases and user interfaces to same.

Estimate a requirement of about 3-4 full weeks of a person with the above skills (but depends on outcome of requirements capture).


  1. Carry out a proper 'requirements capture' exercise before proposal can be firmed up.
  2. Evaluate alternative technologies (database engine mysql, postgres, ingres etc) and the extent to which they can be integrated into existing structures (e.g. TEC database GUI, authentication, LCFG managed services).
  3. Set up server for database (or use existing server if appropriate)
  4. Set up/create user interface for loading data
  5. Bulk load existing data for testing
  6. Write documentation and training materials


Medium to high (presumably could however make do with existing inventory system until this project resourced).

Topic revision: r1 - 12 Jun 2006 - 12:18:56 - PaulAnderson
This site is powered by the TWiki collaboration platformCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback
This Wiki uses Cookies