Published on Mar 05, 2020
Project Controller is a simple, fast, accurate and easy to use with flexible options for viewing the essential details. The solution is best suited for individuals working on various projects, which helps to keep track of all the Projects and their Schedules. Project Controller also helps you to back & restore your work in a file so that you can always have a backup file to be restored to the application just in case you lose your data accidentally.
You can add any number of schedules to be done for each existing projects using the Project Controller. In This system each schedule can be tracked from the start till the end of the Project cycle. You can track the below details for each schedule:
• Project for whom the schedule is to be done,
• You're Rate/Hour for this particular work to be done.
• Start and End date of the project.
• Total working hours of a day (adjusted with the break time option).
• Current status and Percentage of work completed (Progress Bar).
• Payment amount pending from the project
The project has been planned to be having the view of distributed architecture, with centralized storage of the database. The application for the storage of the data has been planned. Using the constructs of MS-SQL Server and all the user interfaces have been designed using the ASP.Net technologies. The database connectivity is planned using the "SQL Connection" methodology.
The standards of security and data protective mechanism have been given a big choice for proper usage. The application takes care of different modules and their associated reports, which are produced as per the applicable strategies and standards that are put forwarded by the administrative staff.
The entire project has been developed keeping in view of the distributed client server computing technology, in mind. The specification has been normalized up to 3NF to eliminate all the anomalies that may arise due to the database transaction that are executed by the general users and the organizational administration. The user interfaces are browser specific to give distributed accessibility for the overall system.
The internal database has been selected as MS-SQL server 200.The basic constructs of table spaces, clusters and indexes have been exploited to provide higher consistency and reliability for the data storage. The MS-SQL server 200 was a choice as it provides the constructs of high-level reliability and security. The total front end was dominated using the ASP.Net technologies.
At all proper levels high care was taken to check that the system manages the data consistency with proper business rules or validations. The database connectivity was planned using the latest "SQL Connection" technology provided by Microsoft Corporation. The authentication and authorization was crosschecked at all the relevant stages. The user level accessibility has been restricted into two zones namely
PIV 2.8 GHz Processor and Above
RAM 512MB and Above
HDD 20 GB Hard Disk Space and Above
WINDOWS OS (XP / 2000 / 200 Server / 2003 Server)
Visual Studio .Net 2005 Enterprise Edition
Internet Information Server 5.0 (IIS)
Visual Studio .Net Framework (Minimal for Deployment)
SQL Server 2000 Enterprise Edition