by Nick
10. July 2006 23:42
Taking the requirements from my previous post I set about to put together a simple database structure that would serve as the backend for my prototype T&E application. Below I have indicated to what extent the functionality is supported by the proposed structure:
- Timesheet entry
primary functionality
- Client / project / job management (both billable and non-billable)
project/work item management is primary functionality
client management is not part of this app
- Staff management including the ability to analyse planned staff availability and setup schedule of rates
not part of this app
- Expense management
primary functionality
- Decent reporting / charting / analysis / modelling functionality
support provided through reporting services
- Ability to export into csv, xml etc
support provided through reporting services
- Invoicing / billing management
not part of this app
- Email notifications (timesheets due, upcoming staff availability, billing/invoicing due etc)
not part of this app (initially)
- Be able to track Time and Expenses OFFLINE
primary functionality
- Be able to integrate with TFS
primary functionality
See the following image for an overview of the initial database which should cater for most of these requirements. I say initial because like most projects, I'm sure I will want to change the scope as I go along.....

6e688f4c-e181-45a9-9b91-5494b9c7e8d9|0|.0
Tags: Databases