I need a database designed for a project of mine. Here is what I need.
There are 4 divisions. Once a user is signed up, he will be classified under one of the 4 divisions. Each division will have its own admins.
The admins must be able to:
-- Add new users
-- Register and book out a tasking to users
-- Request feedback from users on taskings
-- View progress on taskings
-- Set deadlines for taskings
-- Manage taskings by adding new info for users
Users must be able to:
-- Log into their accounts and receive new taskings assigned to them by admins.
-- Upload files to every task assigned to them.
-- Add comments on taskings
-- Report feedback to admins on taskings
-- At the beginning of every month report on vehicle milage and gas usage
If you are chosen I will inform you more on the nature of the product.
I need to view the project on your server as you progress.