Contact at or 8097636691
Responsive Ads Here

Tuesday, 6 February 2018

Budget Planner

Budget Planner

This project is aimed at developing a system by which the employees in the organization submit the bills to their managers. The bills could of various types and also of various amounts. The employee after submitting the bill will automatically provide the manager’s name to which the bill will be submitted. The bill will pass through a workflow process and the owner of the bill can view the status of the bill at any time. An email will be sent to the concerned people to let them know about the status of the bill. 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 2005.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 2005 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.
  • It is limited to a single system.
  • It is less user-friendly.
  • It is having lots of manual work (Manual system does not mean that you are working with pen and paper, it also include working on spread sheets and other simple software's)
  • It requires more no of employees need to work.
  • It is time consuming process.
  • The present system is very less secure.
  • It is unable to generate different kinds of report.
The development of the new system contains the following activities, which try to automate the entire process keeping in view of the database integration approach.
  • User friendliness is provided in the application with various controls.
  • The system makes the overall project management much easier and flexible.
  • It can be accessed over the Internet.
  • Various classes have been used to provide file upload and mail features.
  • There is no risk of data mismanagement at any level while the project development is under process.
  • Report generation feature is provided using Crystal Reports to generate different kinds of reports like bar graphs, pie charts and table type charts etc.
It provides high level of security using different protocols like https etc.
  •    Administration
  •    Managers
  •    Request Creator
  •    Report
  •    Search
  •    Authentication

•          SYSTEM                                  : Pentium IV 2.4 GHz
•          HARD DISK                            : 40 GB
•          RAM                                        : 512 MB
•          Operating system                     : Windows XP Professional
•          Technology                              : Microsoft Visual Studio .Net 2008
•          Coding Language                   : C#
•          Front End                                 : ASP.Net
•          Back End                                 : SQL Server 2005

No comments:

Post a Comment