Skip to content
This repository has been archived by the owner on May 22, 2018. It is now read-only.
Alexander Booth edited this page Feb 8, 2017 · 2 revisions

BCSMSSA Database

Summary

Program to analyze data (and potentially visualize it?). Project is medium sized.

Problem to be solved:
They cannot currently analyze the data of their patients.

Requirements

  • Program must allow data to be entered
  • Data must be backed up periodically in order to not get lost
  • No personal details of client
  • Graphs would be nice, but numbers are more important in order to analyze data

Functionalities

  • Ability to input data
  • Ability to query data
  • Ability to log in securely
  • Ability to see relationship between different variables

Roles

Project Lead:

Developers:

Timeline

Project must be completed and handed over before the end of the semester.

Tech Stack

We will be using Django as the framework for this project(https://www.djangoproject.com/). Django is a high-level Python Web framework that encourages rapid development and clean, pragmatic design. Additionally, python is a popular language for data analytics which may be useful for future iterations. On the front end we will use CSS and HTML to create the user interface.

Data Model

The data will focus on specific instances of sexual assault. Fields should include: Type of Abuse (Physical or Verbal); Role of Abuser (Mother, father, doctor, etc); Age when abused (buckets: below 10, 10-12, 13-18, 18+); sexual orientation; Year of birth; If mother, father or client is/was an alcoholic; if mother, father or client is/was a drug abuser (if so, prescription vs street drugs); if mother, father or client is/was violent; client #.

User Interface

User Experience Priorities

  • Database should be easily searchable

User Interface Guidelines

Challenges

Ensuring that data is backed up periodically. If program is via web, could pay for server space for backups.

Additional Information Needed

Resources

Todo list for contributing

Todo list