Abstract
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 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.
NUMBER
OF MODULES
The system after careful analysis has been identified to be presented
with the following modules:
The modules involved are:
1.
Administration
2.
Finance Managers
3.
Managers
4.
Request Creator
5.
Reports
6.
Search
7.
Authentication
Administration:-
Admin has all
privileges to add/modify employee and view the reports. In this there are sub
modules like
1. Employee Details
2. Deportment Details
3. Bill Details
4. Reports
Employee:
This module only
for employee maintenance like registering new employee details in the
organization.
·
Employee maintenance is used to register
a new employee, modify the details of existing employee or remove the existing
employee.
·
Only the admin type user will have
access to this part. Normal user won’t have access to this. While storing into
database the password should be encrypted and stored. The user can choose its
own logic to encrypt the password.
·
User password is used to change own
password. Both admin and normal user will have access to this.
Department
Details:
This module is
used to maintain the various departments in the organization. Department
details can be modified by the admin type of users only. This module will be
enabled only to the admin type of users.
Reports:
- This module is used to print
various online reports. This module will be enabled only to the admin type
of users.
- In this admin generate various
types of reports about the employees working in the organization.
- In this admin generate various
types of billing reports which are generated by employees working in the
organization.
- In this admin generates the reports
by date wise as input and gives details of bill made on that date along
with total information. This report should be available for a given date
or for a date range.
Managers:-
In this module
there are two types of managers are exists.
1. Finance
Manager Users
2. Managers
Users.
3. Request
Creators.
Finance
Managers:
- There will be number of finance
managers and each finance manager will responsible for 1 or 2 departments.
- Users in this role can only close
the application, they can only view the requests and after crediting the
amount to the request creator the request will be closed by the finance
manager
Manager
Users:
- The manager of user is able to view
the details of the bills which is created by request creators.
- This type of user can view the
details but cannot modify the details send by request creators.
- This type of user can view the
details and he can either approve the request or reject it.
- Every time he performs and
operation the approver has to write the comments for the same.
Proposed
system
·
To debug the existing system, remove
procedures those cause data redundancy, make navigational sequence proper. To
provide information about audits on different level and also to reflect the
current work status depending on organization/auditor or date. To build strong
password mechanism.
System Requirement
Specification:
Hardware
Requirements:
• I2 Processor and Above
• RAM 1GB and Above
• HDD 20 GB Hard Disk Space and Above
Software
Requirements:
• WINDOWS OS (XP service pack 2
/windows 2007 Server)
• Visual Studio .Net 2008(according requirement)
• Visual Studio .Net Framework (Minimal
for Deployment)
• SQL Server 2008(according
requirement) Enterprise Edition
No comments:
Post a Comment