The paper presents the custom design and implementation of a database for National Innovation System (NIS) for Botswana. This was a customer driven design and achieved through sustained consultation with the client to define the framework for the national innovation capability system, the data requirements, and the set of indicators it was required to produce upon commissioning. A top-down design methodology was applied involving moving from technologyindependent level to technology-dependent level in the system development process, taking into account the data and processing requirement of the system. My SQL (Structured Query Language) software platform was selected as the most suitable after comparative analysis with competing solutions. The design was limited to a standalone system though it could easily be upgraded for web-based operation. The capability of the database produced was comprehensive and capable of producing all National Innovation Systems Indicators required. The paper demonstrates how to overcome practical challenges of designing a custom non-conventional database, it highlights how to adapt and apply generic database design to custom databases; it offers a practical experience on database design and implementation in new areas of application such the National Innovation System, in contrast to business oriented databases; and offers lessons learned in the design of the database.

Projects

Currently no objects available

Currently no objects available