Database Design
Project Proposal; Client Records Management System
The proposed database will be designed to progressively store records of drug addicts enrolled for rehabilitation at community-based rehabilitation centers. Rehabilitation centers often have a challenge keeping track of client records thus are unable to initiate effective follow-up post-rehab. As such, a client records management system will promote record keeping as well as reduce the total costs associated with monitoring the clients post-rehab.
System Users and Information Stored
Drug rehabilitation operations often involve four key stakeholders; the rehabilitation team, the drug or substance addicts, families of the addicted persons, and external sponsors. All these stakeholders require some type of information to be relayed to them about the rehabilitation operations. As such, the proposed system will effectively facilitate the sharing of information among all key stakeholders. The rehabilitation team will have a designated system administrator to monitor and control the activities in the database. The clients will have access to the system through user accounts. Similarly, the other stakeholders will also have access to the database through user accounts.