Employee Management System
The activity advantaged as “BANK Agent Administration System” which keeps the clue of agent accommodation such as present alive employees, acting alive employees, advisers transferred, agent attendance, agent bacon etc . This It maintains the employee’s accommodation such as new employees, alive employees, leave appearance and bacon aliment of the employers. This activity accent beforehand appearance than the absolute arrangement project. This activity is mainly advised appliance VB as advanced end and SQL as backend
1.1 About the project
Employees are the courage of any company; their administration pays a aloft role in chief the success of the organization. Agent Administration Software makes accessible for the employer to accumulate a clue all the records. This Activity contains Agent amount and Bacon features, which is developed Appliance VB (Visual Basic) 6.0 and Microsoft Admission Driver. In this activity ambassador can add agent records, designation, assignment status, announcements, activity accommodation and applicant details. Advisers can appeal for leave, assignment report, assignment details, etc. The arrangement checks achievement assay of the employees. Ambassador can column announcements, Holidays, birthdays and notes. This software arrangement has 4modules. Ambassador has abounding permission to admission this software and agent has bound features. 1. Admin Module
2. HR Module
3. Amount Management
4. Agent Module
1.2 Arrangement Specification
1.2.1 Hardware Configuration
Processor :Pentium IV
Speed :2.8 GHz
RAM accommodation :1 GB
Floppy deejay drive : 1.44 MB
Hard deejay drive : 160 GB
Key Board : Samsung 108 keys Mouse : Logitech Optical Mouse DVD Writer : 52x LG
Printer :HP Laserjet 1018 Motherboard :Intel
Monitor : 17” Samsung
1.2.2 Software Configuration
Operating System:Windows XP
Front end acclimated :MS Visual Basal 6.0
Back end acclimated :MS Access
ABOUT VISUAL BASIC 6.0
Visual Basal is a able programming arrangement for developing sophisticated, graphical appliance for Microsoft Windows Environment. It makes use of Graphical User Interface for creating able-bodied and able application.
Using VB6 we can actualize accident applications. In VB6 appliance cipher is active in acknowledgment to events. Another important affection of VB6 is the able set of congenital controls that are provided for creating Windows-based application, for archetype command button, checkbox. These controls accommodate user interface after acute circuitous programming.
We can additionally use activating articulation library routines in application. A DLL is a set of action that is alien application, and can be alleged from with in the appliance back required. ActiveX basal advice in reusing the cipher application.
Features of Visual Basic
Visual Basal makes the designing allotment the appliance easy, and creates added interactivity with the user. Hence Visual Basal is abundant easier than alternative languages.
The programmer uses controls to get user input, affectation achievement and to activate accident procedures. Visual Basal is not alone a programming language, but additionally a complete graphical development environment. This ambiance allows users with little programming acquaintance to bound advance advantageous Microsoft Windows applications which accept the adeptness to use OLE (Object Linking and Embedding) objects, such as an Excel spreadsheet. Visual Basal additionally has the adeptness to advance programs that can be acclimated as a advanced end appliance to a database system, confined as the user interface which collects user ascribe and displays formatted achievement in a added ambrosial and advantageous anatomy than abounding SQL versions are able of developments.
About SQL server:
SQL Server is a actual able applicant server accretion archetypal accessible in the accretion environment. It comprises of all the appearance from basal abstracts accumulator to high-level abstracts representation techniques in the anatomy of reports. It additionally comprises of VB bore programming, which allows embedding Visual basal functions into SQL server Stored Procedures. SQL Server is a actual able applicant server-computing archetypal accessible in the accretion environment. It comprises of all the appearance from basal abstracts accumulator to high-level abstracts representation techniques in the anatomy of reports. It additionally comprises of ASP.NET bore programming, which allows embedding ASP.NET into SQL server Stored Procedures.
SQL Manager 2005 for SQL Server key features:
* Abounding abutment of SQL Server 2005
* New advanced graphical user interface
* Rapid database administration and navigation
*Easy administration of all SQL Server objects
* Effective aegis management
2. Arrangement Study
2.1 Absolute System
The absolute arrangement in the coffer is manual. The advice provided by the
existing arrangement crave a lot of chiral interventions at the time of advancing the system. All the activities are actual abundant difficult to adapt letters for account and yearly. Hence there is a charge for afterlight of the system.
The capital check of the absolute arrangement is chiral and involves lots of inputs. Alone chiral blockage is done
All the activities complex are in the paper
The agent accommodation are maintained locally
Unavailability of quick references
Tedious address generation
2.2 Proposed System
The aloft said arrangement is taken in to appliance for the new system. The difficulties of the absolute arrangement are anxiously advised and the arrangement was proposed. The proposed arrangement will be developed appliance Visual Basal as Advanced End and Admission as Back End.
Provides a able-bodied authentic user interface
Provides user authentication
Reduces the cardboard work
Saves the time
User affable environment
Provides appropriate reports
Human action is reduced
Most accessible to abate the crowd
3. Arrangement Design and Development
3.1 Book Design
3.1.1 Bore Design
1. Admin Module
2. HR Module
3. Amount Management
4. Agent Module
Administrator controls the absolute application. Ambassador can add, delete, adapt and appearance all agent accommodation and admin can actualize Agent Payslip. Ambassador additionally manages the abstracts accompanying to organizations and businesses. Ambassador generates letters abandoned on assorted criteria.
HR controls the absolute application. Ambassador can add, delete, adapt and appearance all agent details. Ambassador additionally manages the abstracts accompanying to organizations and businesses.
Admin and HR can add and Annul Payslip details.
Employees charge accept accurate login advice to admission the application. Anniversary agent can appearance the accommodation of Vacancy, Payslip , schedules and Training Materials.
3.2 Ascribe Design
3.2.1 Arrangement Flow Diagram
3.2.2 Abstracts Flow Diagram
AddEmp Operator EmpDetail Operator
Emp advice Emp detail Modification
EmpSlip For login user, countersign Emp Amount Slip Generation
Emp detail address Generation
3.3 Database Design
The best important aspect of architecture applicant arrangement is “database design”. Instead of anniversary affairs managing its own data, the accustomed bodies allotment abstracts beyond applications with database software managing the abstracts as an entity.
It is a analytic development, in the methods acclimated by the computers to admission and manipulates abstracts stored in the assorted genitalia of computer system.
It is advice from several files is accommodating accessed and operated aloft as admitting it is a distinct file. A database is collections of inter accompanying abstracts stored with a minimum back-up to serve abounding users bound and efficiently. The cold is to accomplish advice admission accessible and quick, bargain and adjustable to the User.
3.3.1 Table Design
In this report, an advice system’s development has been presented. It was emphasized on the basal steps, appropriately taken during the project’s development advance as a accurate absorption was angry to the basal accessible functions performed aloft the abstracts into the database.
The report’s agreeable comprises the accomplished assignment solution, starting from the programming environments accept been selected, activity through the database, the application’s assay and construction, and finishing with the code-implementation and test-samples, apparent alone in Appendix chapters.
.As a approaching work, some added being could be implemented and chip into the appliance cipher authoritative it abundant added reliable and flexible; abnormally what apropos a pay-roll module, for instance.
Order a unique copy of this paper