While I previously wanted to develop a web-based, database-driven, enterprise-wide information system, that plan probably won't happen. For this year, my target is to develop an inter-related database process that will mimic that enterprise-wide, web-based information system.
I will use, with much hesitation and fear of regret, Microsoft Access 2013 (the software used in the office). But for development, I will use LibreOffice Base. I hope that everything that Base can do can be replicated in Access.
My plan for this project:
Phase I - Requirements and Process Analysis (Target: End-April 2015; Weight: 25%)
- Software purpose
- Baseline
- Intended Outcome
- Stakeholder requirements identified
- Processes (including business rules) identified
- Entity relationship model
- Database logical and physical design
- LibreOffice Base prototype
- Database back-end
- Version per user-type
- Reports
- Microsoft Access 2013 version
- FMPS-level testing
- System marketing, to include feedback management
- End-user offices and staff
- Process-owner offices and staff (i.e., FMPS, HRDMS)
- Management offices and staff (PMT)
Phase IV - Cascading and Maintenance (Target: August 2015; Weight 10%)
- Software installed in all offices that indicated interest
- Feedback continuously gathered for improvement
Resources: All open source software:
- ProjectLibre - For project monitoring (even if this is a self-monitored project, I have to monitor my progress against my targets, for reporting to my supervisors)
- LibreOffice - For the database development (Base) and project documentation (Writer)
- FreeMind - For various concept and role-mapping tasks
- Dia - for database design