SRS RFID Employee Attendance Tracking System StupendousJSS

RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS

StupendosJSS JSS Academy of Technical Education, Noida Software Requirement Specification

Version 2.0

FACULTY GUIDE: MRS. Seema Shukla TEAM MEMBERS

Tanuj Agrawal

(2909113006)

Pooja Agrawal

(0809113051)

Prashant Srivastava (0809113054) Deepak Kumar

(2909113001)

COLLEGE NAME

JSS Academy of Technical Education, Noida DEPARTMENT NAME

Information Technology STATE

Uttar Pradesh

StupendousJSS/JSS Academy Of Technical Education, Noida 1


Revision History

Date

Version

Description

Author

27-Nov-2011

1.0

Software Requirement Specification

StupendousJSS

15-Feb-2011

2.0

Software Requirement Specification

StupendousJSS


RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS Table of Contents 1. Introduction

1.1 Purpose

5

1.2 Scope

5

1.3 Definitions, Acronyms and Abbreviations

6

1.4 References 1.5 Tools Used

8 9

1.6 Technologies to be used

11

1.7 Overview

12

2. Overall Description 2.1 Product Perspective

14

2.2 Software Interface

15

2.3 Hardware Interface

15

2.4 Communication Interface

16

2.5 Product Function

17

2.6 User Characteristics

18

2.7 Constraints

20

2.8 Architecture Design

21

2.9 Structural Diagram

24

2.9.1 Class Diagram

24

2.10 Behavioral Diagram

28

2.10.1 Use-Case Model Survey……………………………… Survey…………………………………………………. ………………….

28

2.10.2 Activity Diagrams

31

2.10.3 Sequence Diagrams

49

2.11 Database Design

67

2.11.1 ER Diagram……………………………………………………………….

67

2.11.2 Schema…………………………………………………………………… . 68 2.12 Assumptions and Dependencies………………………………………… StupendousJSS/JSS Academy Of Technical Education, Noida 3

71


3. Specific Requirements 3.1 Use-Case Reports 3.2 Supplementary Requirements………………………………………………..80


72


Introduction 1.1 Purpose

•

To automate the attendance maintenance system of an organization through the use of RFID technology.

•

To provide a cost effective system.

•

To maintain the attendance accurately and effectively

•

To efficiently calculate salary of employees based on attendance

1.2 Scope

The scope of this project is to deal with the S/W and H/W part of the system. In this project we will will deal with with different different software software modules modules • • •

• •

Management of multiple client sites Use of RFID Reader and RFID active tags Imple Impleme menta ntati tion on of the orga organiz nizat atio ional nal policy policy rega regardi rding ng atte attenda ndance nce,, calculation and leave processing. Security measures Data management

sala salary ry

In this project we are not dealing with the H/W design of the RFID devices. we are using the RFID reader and RFID active tags for capturing the data.



1.3 Definitions, Acronyms and Abbreviations

This section describes the definitions, acronyms and abbreviations used in the SRS.

EATS

Employee Attendance Tracking System It’s a web application that provides the facility for tracking the attendance of employees. Admin

Administrator has the authority to add/delete records and has the over all right on the server controls. WAS

Web Sphere Application Server is an application server that runs and supports J2EE and web service applications. DB2

A database management system that provides a flexible and efficient database platform maintain records of employees. JSP

Java Server Pages is used to create dynamic web content. J2EE

Java 2 Enterprise Edition. A programming platform which is a part of java platform for developing and running distributed java.


RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS SOA Service-Oriented Architecture (SOA) is a set of principles and methodologies for designing and developing software in the form of interoperable services

EJB

Enterprise JavaBeans (EJB) technology is the server-side component architecture for Java Platform Enterprise Edition (Java EE). EJB technology enables rapid and simplified development of distributed, transactional, secure and portable applications based on Java technology. AJAX

Asynchronous JavaScript and XML is a group of interrelated web development methods used on the client-side to create asynchronous web applications

UML

Unified Modeling Language is a standard language for writing software blueprints. The UML may be used to visualize, specify, construct and document

XML

Extensible Markup Language is a text based format that let developers describe, deliver and exchange structured data between a range of applications to client for display and manipulation.

HTTP

Hypertext Transfer Protocol is a service protocol. RAD


RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS Rational Application Developer is a development tool that helps to design web pages and also helps to design the diagrams like ER, Database schema diagrams and to generate DDL.

1.4 References •

“Object Oriented Modeling and Design with UML” by Michael Blaha, James Rambaugh.

•

IBM TGMC Sample Synopsis.

•

IBM – www.ibm.in/developerworks – www.ibm.in/developerworks .

•

Java - www.sun.com

•

“Database Management Systems “ by Navathe.

•

“Complete Reference” by J2EE Keogh.



1.5 Tools Used

This section describes the tools that have to be used in development of the system. Web server – WAS

Web Sphere Application Serve (from now on WAS) is a free, certified Java EE 5 server for building and managing managing Java applications. applications. It is IBM's supported supported distribution distribution of Apache Geronimo that uses Tomcat for servlet container and Axis 2 for web services. Over 15 WASCE developers are committers in the Apache Geronimo project. Development tool –RAD

IBM Rational Application Developer for Web Sphere Software (RAD) is an integrated developm development ent environm environment ent (IDE), (IDE), made made by IBM's IBM's Rationa Rationall Softwa Software re divisio division, n, for visuall visually y desi designi gning, ng, const construc ructi ting, ng, test testing ing,, and deplo deployin ying g We Web b serv servic ices es,, porta portals ls,, and and Java Java (J2EE (J2EE)) applications. Database platform – DB2

DB2 Database is the database management system that delivers a flexible and cost effective database platform to build robust on demand business applications and supports the J2EE and web services standards. Design tool – Rational Software Modeler

IBM Rational Software Modeler, (RSM) made by IBM's Rational Software division, is a Unified Modeling Language UML 2.0-based visual modeling and design tool. Rational Software Modeler is built on the Eclipse open-source software framework and includes capabilities focused on visual modeling and model-driven development (MDD) with the UML for creating resilient, thought-out applications and web services.



1.7 Technologies to be used

This section describes the technologies that have to be used in development of the system.

JAVA

Java is an object-oriented programming language developed by Sun Microsystems a company best known for its high end UNIX workstations. Java language was designed to be small, simple, and portable portable across platforms, platforms, operating systems, systems, both at the source and at the binary level, which means that Java programs (applet and application) can run on any machine that has the Java virtual machine (JVM) installed.

J2EE

Java Platform, Enterprise Edition or Java EE is a widely used platform for server programming in the Java programming language. The Java platform (Enterprise Edition) differs from the Java Standard Standard Edition Edition Platform Platform (Java SE) in that it adds libraries which provide functionality functionality to deploy fault-tolerant, fault-tolerant, distributed, distributed, multi-tier multi-tier Java software, software, based largely on modular modular components components running on an application server.

SOA

Service-Oriented Architecture (SOA) is a set of principles and methodologies for designing and developing software in the form of interoperable services

EJB


RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS Enterprise JavaBeans (EJB) technology is the server-side component architecture for Java Platform, Enterprise Edition (Java EE). EJB technology enables rapid and simplified development of distributed, transactional, secure and portable applications based on Java technology.

AJAX

Asynchronous JavaScript and XML is a group of interrelated web development methods used on the client-side to create asynchronous web applications

UML Unified Modeling Language is a standard language for writing software blueprints. The UML

may be used to visualize, specify, construct and document

XML

Extensi Extensible ble Markup Language Language is a text text based based format format that let developer developerss descri describe, be, deliver deliver and exchange structured data between a range of applications to client for display and manipulation. Struts

The Apache Struts web framework is a free open-source solution for creating Java web applications. It is based on the MVC architecture. Web Services

Web services are Web based applications that use open, XML-based standards and transport protocols protocols to exchange exchange data with with clients. clients. Web Web services services are developed developed using using Java Technolog Technology y APIs and tools.



1.8 Overview

This section describes the pre-existing system , the proposed system and the our plan of development. Existing System: • • • •

All types of severs (Web, Application and Database) are on a single site. Architecture is not so much flexible Tight binding b/w modules Use of RFID tags

Drawbacks: • • • •

Future modification is very tough because of tight bounding Low performance Security issues 2 -Tier architecture

Proposed System: • • • • • • • •

Service oriented architecture Flexible architecture Use of RFID tags Employee registration Employee Search Email Notification SMS Notification General information provider


RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS Salary and attendance calculation • Discussion forum • Employee Chat • Report and chart generation •

Implementation Plan: • • • • • • • • • • • • • • • • • • • • •

Service oriented architecture Distributed business logic Flexible architecture Data warehousing Multi site architecture Use of active RFID tags Employee registration Email Notification SMS Notification General information provider Salary and attendance calculation Remote Site Controller System date controller Remote Shutdown Email Query Temporary module creator Date synchronizer Discussion forum Report and chart generation Employee Chat Query builder interface for accessing the Client and History database



2. Overall Description This section will describe major components of the system, interconnections and external interfaces.

2.1 Product Product Perspecti Perspective ve Figure 2.1 describes the product perspective.



Fig 2.1: Product Perspective

2.2 Software Interface:

This section describes all the software required on all the tiers. •

Client Tier : Web Browser, Operating System (any)

•

Middle Tier : RFID interfacing module , Application server

•

Data Tier : Database server , Application server , Defined interfaces for services

•

Application Server: WAS, Operating System (Windows and Linux)

•

Data Base Server: DB2, Operating System (Windows and Linux)

•

Development End: JEE, Java, HTML, Java Script, CSS , XML, Struts, EJB, Web Services, SOA, XML

2.3Hardware Interface :

This section describes all the hardware required on all the tiers.

System requirement for all tiers Intel Pentium-4 StupendousJSS/JSS Academy Of Technical Education, Noida 15  

RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS RAM 256 MB HDD 10 GB  

2.3.1

Data Tier:

Computer System must be able to handle multiple requests simultaneously Connection to the internet.

• •

2.3.2

Middle Tier:

RFID Reader connected to Serial Port Computer System must be able to run H/W interfacing application and connect to the internet.

 

2.3.3

Client Tier: 

Computer System must be able to run a web browser and connect to the internet.

2.4 Communication Interface:

This section describes all the communication required on all the tiers.

•

Client on Internet will be using HTTP/HTTPS protocol.

•

Client on Intranet will be using TCP/IP protocol.



2.5 Product Product Functi Function on

This section describes all the functions supposed to be performed by the system.

•

Setup the basics: The basic details of organization such as working hours, number of working days per month to calculate the salaries will be set up.

•

Secure registration: Registration of employees will be secure and unobstructed. Employee Search: Search of employees will be based on different criteria

•

Automatic mailing: There will be provision of sending automatic mails to employees regarding salaries, attendance, holidays.

•

Automatic messaging: There will be provision of sending messages to mobiles if employee absent or issued salaries or general messages regarding holiday’s wishes etc.

•

Employee will be able to view and update his details, view his attendance reports, salary reports and leave status.

•

•

Visitor will be able to view the organization basic details.


RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS •

Employee Chat

•

Employee discussion forum

•

Reports will be available in different formats(PDF,DOC,OTF,TX ,TXT,CSV,XL ,XLS,XML,HTML) and formats(2DBarChart,3DBarChart,2DPieChart,3DPieChart,XYLineChart).

•

GUI will be available in minimum two languages.

•

Creation of the temporary module

•

Shutdown the server from remote location

•

System date synchronization and controller

•

Email Query responder

•

Remote Site Controller

•

Maintaining the history database

•

Query builder for accessing the data from Client and History database


text graphical


2.6 User Characte Characteristic risticss

This section describes Characteristics of all the users of the system. 

Visitor • • • • • •



• •

Can login and view the basic information related to the organization Employees (HR) Departments Products Services Carrier

Employee

All the functions of the visitor Update his personal record


RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS View the profile of all the employees • Communicate with other employees through Chat and SMS • Access to Discussion forum • Search the employees • View his salary report and attendance report • Customize the GUI • Access to RSS feeds • Send SMS • Query his leave status •



•



Operator

All the functions of the Employee Send the SMS manually and Schedule the SMS • Send the Emails manually and Schedule the Email • Add employee record • Update employee record • Send the wishes through SMS • Add the RSS feeds • Monitor the discussion forum • Monitor the Chat application • Monitor the RFID reader module •

Site Admin • • • • • • • • • •

Add, view, edit, and delete records Calculate salary Generate salary report and attendance report Generate usage statistics report Specify working hours holidays Generate pay slip Translation of the complete GUI Monitor date and time controller and synchronizer Administer the forum Administer the Chat application


RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS • • • • • •

Administer the RFID reader application Remotely shutdown the server after approval Access to the history database Specify SMS and Email Query Commands Create the temporary module Access to Query Builder Module

Server Admin



• • • • • • • • •

Blocking of the user ID Specify database Servers Specify web severs Monitoring of the continuously running processes Specify various server side controls Monitoring of the running web services Access to the rejected requests Access to the pending requests Controlling the various sites connected to the server

2.7 Constra Constraints ints

This section describes the constraints implied on the system. 



GUI is in English and in at least one local language. To connect the RFID reader to the system only Serial Port and USB port can be used.



RFID tag value is used for identification of users’.



Limited to HTTP/HTTPS.



2.8 Architecture Diagrams

This section contains all the diagrams that describe the architecture of the system.


RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS Figure 2.8.1 describes the overall system architecture.

Fig 2.8.1: Overall System Architecture


RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS 2.8.2 Centralized Server Architecture

Figure 2.8.2 describes the centralized server architecture.

Fig 2.8.2: Centralized Server Architecture



2.8.3 Site Architecture Architecture

Figure 2.8.3 describes the site system architecture.

Fig 2.8.3: Site Architecture



2.9 Structural Diagrams This section contains all the diagrams that describe the structure of the system. 2.9.1 Web Services Diagram It represents the class diagram of EJB classes that have to be used as a web services.









2.9.2 Monitor Class Diagram

Representation of Monitor Class Diagrams



2.9.3 API Class Diagram

Representation of class diagram of Solution API StupendousJSS/JSS Academy Of Technical Education, Noida 31





RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS 2.10 Behavioral Diagrams

This section contains the diagrams that describe the functional behavior of the system. 2.10.1 Use Case Model Survey

Figure 2.10.1 represents the overview of all the users and use cases in the system.



Fig 2.10.1: Use Case Model Survey StupendousJSS/JSS Academy Of Technical Education, Noida 35


2.10.1 .1 Admin

Admin is responsible for all the operations have to be in the project. 2.10.1 .1.1 Site Admin

Site Admin will monitor the Site controls and services. Site admin will responsible for only one site. 2.10.1 .1.2 Server Admin

Server Admin will be responsible for the server side components and services. It will have the right to perform all the database operations and will have the access to history database. 2.10.2 Operator

Operator will have the right to add records in the database and will be responsible for the site it is operating. 2.10.3 Employee

Employee can update only his profile and can communicate to other employees via SMS and Messages. 2.10.4 Visitor

Visitor can only view the information related to the organization.



2.10.2 Activity Diagrams Diagrams

This section describes all the activities in the project. 1. Login

Figure 2.10.2.1 describes the login activity.



Fig2.10.2.1: Login

2. Add Em Employe loyeee

Figure 2.10.2.2 describes the Add Employee activity.



Fig 2.10.2.2: Add Employee

3. Empl Employ oyee ee Sea Search rch

Figure 2.10.2.3 describes the Employee Search activity.



Fig 2.10.2.3: Employee Search


RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS 4. Calc Calcul ulat atee Sala Salary ry

Figure 2.10.2.4 describes the calculate salary activity.

Fig 2.10.2.4: Calculate Salary

5. Cha Chart Ge Gene nera rato torr StupendousJSS/JSS Academy Of Technical Education, Noida 41

RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS Figure Fig 2.10.2.5 describes the Chart Generator activity.

Fig 2.10.2.5: Chart Generator

6. Com Commun unic icat atio ion n StupendousJSS/JSS Academy Of Technical Education, Noida 42

RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS Fig 2.10.2.6 describes the Communication activity.

Fig 2.10.2.6: Communication

7. Disc Discus ussi sio on Foru Forum m StupendousJSS/JSS Academy Of Technical Education, Noida 43

RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS Figure 2.10.2.7 describes the Discussion Forum activity.

Fig 2.10.2.7: Discussion Forum


RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS 8. E-Mail

Figure 2.10.2.8 describes the Add E-Mail Query activity.

Fig 2.10.2.8: E-mail



9. Update GUI Preferences

Figure 2.10.2.9 describes the Update GUI Preferences activity.

Fig 2.10.2.9: Update GUI Preferences



10. Report Report Generatio Generation n

Figure 2.10.2.10 describes the Report Generation activity.

Fig 2.10.2.10: Report Generation StupendousJSS/JSS Academy Of Technical Education, Noida 47


11. Sen Send d SMS SMS

Figure 2.10.2.11 describes the SendSMS activity.



Fig 2.10.2.11: Send SMS

12. Server Server Managemen Managementt

Figure 2.10.2.12 describes the Server Management activity.



Fig 2.10.2.12: Server Management 13. Create Temporary Module

Figure 2.10.2.13 describes the Create Temporary Module activity.



Fig 2.10.2.13: Create Temporary Module

14. GUI Transla Translate te

Figure 2.10.2.14 describes the GUI Translate activity. StupendousJSS/JSS Academy Of Technical Education, Noida 51


Fig 2.10.2.14: GUI Translate

15. View Infor Informat mation ion

Figure 2.10.2.15 describes the View Information activity.



Fig 2.10.2.15: View Information

16. Visitor Visitor Registrat Registration ion

Figure 2.10.2.16 describes the Visitor Registration activity.



Figure2.10.2.16: Visitor Registration

17. Delete Delete Reco Record rd StupendousJSS/JSS Academy Of Technical Education, Noida 54

RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS Figure 2.10.2.17 describes the Delete Record activity.

Fig 2.10.2.17: Delete Record

18. Update Update Reco Record rd StupendousJSS/JSS Academy Of Technical Education, Noida 55

RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS Figure 2.10.2.18 describes the Update Record activity.

Fig 2.10.2.18: Update Record History


RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS Sequence Diagrams

This section describes sequence diagrams of all the processes in the system. 1. Login

Figure 2.10.3.1 describes all the sequences in the Login process.



Fig 2.10.3.1: Login 2. Add Record

Figure 2.10.3.2 describes all the sequences in the Add Record process.



Fig 2.10.3.2: Add Record

3. Updat date Rec Reco ord

Figure 2.10.3.3 describes all the sequences in the Update Record process.



Fig 2.10.3.3: Update Record

4. View Re Record

Figure 2.10.3.4 describes all the sequences in the View Record process.

Fig 2.10.3.4: View Record



5. Del Delete ete Rec Reco ord

Figure 2.10.3.6 describes all the sequences in the Update Record process.



Fig 2.10.3.6: Delete Record

6. Send E E-M -Ma ail

Figure 2.10.3.6 describes all the sequences in the Send E-Mail process.



Fig 2.10.3.6: Send Email

7. Send SMS

Figure 2.10.3.7 describes all the sequences in the Send SMS process. StupendousJSS/JSS Academy Of Technical Education, Noida 63


Fig 2.10.3.7: Send SMS

8. Ge Gene nera rate te Repo Report rt StupendousJSS/JSS Academy Of Technical Education, Noida 64

RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS Figure 2.10.3.8 describes all the sequences in the Generate Report process.

Fig 2.10.3.8: Generate Report


RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS 9. Ge Gene nera rate te Char Chartt

Figure 2.10.3.9 describes all the sequences in the Generate Chart process.

Fig 2.10.3.9: Generate Chart


RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS 10. GUI Tran Translato slatorr

Figure 2.10.3.12 describes all the sequences in the GUI Translator process.



Fig 2.10.3.12: GUI Translator

11. Calculate Calculate Sala Salary ry

Figure 2.10.3.13 describes all the sequences in the calculate Salary process.

Fig 2.10.3.13: Calculate Salary StupendousJSS/JSS Academy Of Technical Education, Noida 68


12. Commun Communica ication tion

Figure 2.10.3.14 describes all the sequences in the Communication process.

Fig 2.10.3.14: Communication



13. Database Database Search Search

Figure 2.10.3.15 describes all the sequences in the Database Search process.



Fig 2.10.3.15: Database Search Sequence 14. Discussio Discussion n Forum Forum

Figure 2.10.3.16 describes all the sequences in the Discussion Forum. StupendousJSS/JSS Academy Of Technical Education, Noida 71


Fig 2.10.3.16: Discussion Forum Sequence

15. Update GUI Preferences StupendousJSS/JSS Academy Of Technical Education, Noida 72

RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS Figure 2.10.3.17 describes all the sequences in the Update GUI Preferences process Preferences process..

Fig 2.10.3.17: Update GUI Preference Sequence

16. Server Server Managemen Managementt StupendousJSS/JSS Academy Of Technical Education, Noida 73

RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS Figure 2.10.3.18 describes all the sequences in the Server Management process.

Fig 2.10.3.18: Server Management Sequence

2.11 Database Design StupendousJSS/JSS Academy Of Technical Education, Noida 74

RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS This section contains all the database diagrams.

2.11 2.11.1 .1 ERER- Diagr Diagram am

Figure 2.11.1 describes all the relationship between entities in the database.

Fig 2.11.1: ER-Diagram StupendousJSS/JSS Academy Of Technical Education, Noida 75

RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS 2.11.2 Schema

This section contains all the database schemas. 2.11.2.1 2.11.2. 1 Client DB Database Design

Figure 2.11.2.1 describes the schema of the ClientDB datbase.

RFIDREADER

ENQUIRY

VISITOR

RFIDREADERID RFIDREA DERID LOCATION LONGITUDE LATITUDE

ENQUIRY ENQUIRYID ID EMAILID COMMENT

PK VISITORID VISITORID

CAREERS DISCUSSION PK DISCUSSIONID

TOPICID MSG MSG EMPID DATE_OF_MSG

ATTENDANCE

ATTEND ATTENDANCE ANCEID ENTERTIME EXITTIME DATE MONTH YEAR

FNAME LNAME EMAIL PHONENO COUNTRY

CONTACTNOID CONTA CTNOID EMPID NAME CONTACTNO

RFID PK RFIDID

EMPID UPDATERID

DATE_OF_HOLIDAY REASON FESTIVAL MSG

DEPARTMENT PK DEPARTM DEPARTM ENTID

HODID DEPTNAME

TRACKER

TRACKERID TRA CKERID RFIDREADERID RFIDREA DERID RFID TIME

EMP

EMAILID RESUMEPATH RESUMEPATH FRESHER EXPERIENCE PREVORGANIZA PREVORGANIZA TION CONTACTUS

MODULE

SALARYCRITERIA

MODULEID NAME ADMIN ADMINID ID PASSWORD DATE_OF_CREATION EXPIRY_DATE

GROSS_SALARY ANNUAL_CTC ANNUAL_CTC TOTAL_CTC EMPLOYERS_PF EMPLOYEES_PF BASIC HRA HRA MISC_ALLOW MEDICAL_ALLOW CONVEYANCE_ALLOW EDUCATION_AL EDUCATION_ALLOW LOW MCE EMPLOYERS_ESIC EMPLOYEES_ESIC TAXES GRATUITY SUPERA SUPERA NNUATION PFBONUS LTA

PK C ONTACTUSID ONTACTUSID

FNAME DESIGNATION EMAILID CONTACTNO LNAME

YEARLYSALARYID GRATUITY SUPERA SUPERA NNUATION PERFORMANCEBONUS LTA GROSSSALARY TOTALSALARY EMPID TOPIC

MSG PK M SGID SGID

SENDERID RECEIVERID MSG MSG

FAQ PK FAQID FAQID

QUESTION ANSWER ANSWER

WORKINGHOUR

PK TOPICID TOPICID

DELLOG

PK HOLIDAYID HOLIDAYID

PK CAREERSID

YEARL YE ARLYSAL YSALAR ARY Y CONTACTNO

HOLIDAY

PK WORKINGHOURID

NAME DESCRIPTION EMPID CATEGORY CA TEGORY DATE_OF_START DATE_OF_START

HOURS DATE MONTH YEAR

GUIPREFERENCES

GUIPREFERENCESID HEADERIMAGE BGCOLOR TEXTCOLOR FONT FONTSIZE

Fig 2.11.2.1: ClientDB Database Design StupendousJSS/JSS Academy Of Technical Education, Noida 76

USERLOG PK EMPID

FNAME LNAME FATHERNAME ADDRE ADDRESS DOB DOB DOJ DOJ QUALIFICATION DESIGNATION MOBILENO EMA EMA ILID IMA IMA GEPA TH GROSS_SALARY PREVORGANIZATION UPDA UPDA TERID DATE_OF_INSERT DA TE_OF_INSERT DEPARTMENTID RFIDID SITEID GRATUITY SUPERA SUPERANNUATION NNUATION ALTEMAIL ALTEMAIL TYPE

LOGIN PK L OGINID OGINID

PASSWORD ACCESSLEVEL SSLEVEL STATUS

USERLOGID IP LOGINTIME LOGOUTTIME DATE MONTH YEAR

LEAVE

REASON FROMDATE DAYS MONTH YEAR TYPE TY PE EMPID APPRO APPROVED VED TODATE

RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS 2.11.2.2 ServerDB Database Design

Figure 2.11.2.2 describes the schema of the ServerDB datbase.

BLOCKEDID

REJECTEDREQUEST

PIECHART

USERID DATE SITEID

XML XML TIME

KEY KEY VALUE

SITE MONITORS

USERLOG

MONITORSID NAME STATUS

TIME USERID SITEID

SITEID NAME STATUS SITEADMINID EMA EMA ILID PHONE IP DBSERVERI DBSERV ERID D AUTO_SALARY_CALC AUTO_SALARY_CALCUL ULATI ATION ON SECRETCODE

SERVERCONTROLS WEBSERVER WEBSERVERI WEBSERV ERID D SERVERADDRE SERVERA DDRESS SS STATUS

ADMIN ADMIN_E _EM MAIL ADMIN ADMIN_M _MOBI OBILE LE EMAIL_PSD CONTROL_EMAIL CONTROL_EMAIL SHUTDOWN_MAIL_SUBJECT SMS_USERID SMS_PSD

PENDINGREQUEST PK PENDINGRE PENDINGREQUE QUESTI STI D

XML XML SITEID SERVICENAME TIME

Fig 2.11.2.2: ServerDB Database Design


DBSERVER DBSERVERID DBURL USERNAME PASSWORD

DEVELOPER PK DEVELOPERID

NAME DESIGNATION EMA EMA ILID PHONENO

SERVICES SERVICESID NAME STATUS SERVERADDRE SERVERA DDRESS SS ADMI ADMINACCE ACCESS SERVICEADDRESS


2.11.2.3 History DB Database Design

Figure 2.11.2.3 describes the schema of the HistoryDB datbase.

HISTORY_LOGIN LOGINID PASSWORD STATUS ACCE ACCESSLEVEL

HISTORY_USERLOG USERLOGID IP LOGINTIME LOGOUTTIIME DATE MONTH YEAR

HISTORY_EMP

HISTORY_SALARY

EMPID FNAME LNAME FATHE FA THERNAME RNAME ADDRE ADDRESS DOB DOB DOJ DOJ QUALIFICATION DESIGNATION MOBILENO EMA EMA ILID IMA IMA GEPA TH INITIALSALARY PREVORGA PREVORGANIZA NIZATION TION UPDATERID UPDAT ERID RFIDID SITEID DATE_OF_INSERT DATE_OF_INSERT

SALARYID CALCULATED_SALARY MONTH YEAR TOTAL_SALARY TOTAL_WRK_HOURS HOURS_A TTENDED BASIC HRA HRA MISC MEDICAL MEDICAL EDUCA EDUCATION TION CONVEYANCE TAXES MCE EMPLOY EMPLOYEE EES_PF S_PF EMPLOY EMPLOYERS_PF ERS_PF EMPID

HISTORY_ATTENDANCE

HISTORY_DISCUSSION DISCUSSIONID TOPICID MSG EMPID DATE_OF_MSG

HISTORY_CAREERS CAREE CA REERSID EMA EMA ILID RESUMEPA TH

ATTENDANC NDANCE EID ENTERTIME EXITTIME DATE MONTH YEAR

Fig 2.11.2.3: History DB Database Design


HISTORY_TOPIC TOPICID NAME DESCRIPTION EMPID CATEGORY DATE_OF_START


2.12 2.12

Assu Assump mpti tion onss and and Depe Depend nden enci cies es

This section contains all the dependencies and assumptions made about the system.

2.12.1 Dependencies Dependencies This section describes all the dependencies in the system. •

Location of the RFID reader

•

Type of the RFID tags (Active or Passive)

•

Specification of the RFID Reader and RFID Tags

•

Users must carry his RFID tag with them

•

Organization policy regarding the attendance calculation and salary calculation

•

Organization policy regarding the holidays and working hours

•

Employee hierarchy in the organization

•

Type of the deployment site e.g. Centralized or client site

2.12.2Assumptions This section describes all the assumptions made about the system. •

Every employee must carry his RFID tag with him.

•

Site admin must be a person from the administration.

•

Admin and operator must have knowledge of the salary issue process.

•

Site admin and operator must be related to the client organization.


RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS Users must have knowledge of anyone language in which GUI is available. • •

Users must be familiar with the internet and computers.

3 Specific Requirements This section contains all the diagrams that specify the requirements of the system. 3.1 Use Case Reports This section conatins the use case reports for all users. 3.1.1 Visitor use-case report Figure 3.1.1 describes use cases of the Visitor.



Fig 3.1.1: Visitor Use Case report

3.1.2 Visitor use case report

Table 3.1 describe describes s use cases cases of of the Visitor Visitor..

USE CASE Visitor login Organization Information

DESCRIPTION Visitor can login to the site of organization Visitor can view the basic information related to the organization


RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS Employe Employeee Informat Information ion Department Information Produ Product ct Info Inform rmat atio ion n Serv Servic ices es Prov Provid ided ed

Visito Visitorr can view the the basic basic informat information ion relate related d to employees employees Visitor can view the basic information related to department Visi Visito torr can can view view the the basi basicc infor informa mati tion on rel relat ated ed to to produ product ct Visi Visito torr can can view view the the bas basic ic info inform rmat atio ion n rel relat ated ed to serv servic ices es Table 3.1: Visitor Use Case report

3.1.3 Employee use-case report

Figure 3.1.2 describes use cases of the Employee.



Fig 3.1.2: Employee Use Case report

3.1.4 Employee use case report StupendousJSS/JSS Academy Of Technical Education, Noida 83

RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS Table 3.2 describes use cases of the Employee

USE CASE Acce ccess level vel Upda pdate re recor cord View pr profi ofile Chat Chat and and SMS SMS Discuss Discussion ion forum forum Emplo Employe yeee Sear Search ch Gener Generat atee Repor Reportt Pers Persona onali lize zed d GUI GUI RSS feeds

DESCRIPTION Employ ployeee can per perform orm all the funct nctions of visitor Employ ployeee ca can upd updat atee hi his pe persona onal re record Employ ployeee ca can vie view w the the pro profil file of of al all the the emplo ployee yees Empl Employ oyee ee can can com commu muni nica cate te wit with h othe otherr emp emplo loye yees es thr throu ough gh cha chatt and and SMS SMS Employ Employee ee can can have have access access to to the the disc discuss ussion ion forum forum Empl Employe oyeee can can sear search ch oth other er emp emplo loyee yeess Empl Employe oyeee can can view view his his sal salar ary y repor reportt and and att attend endanc ancee repo report rt Empl Employe oyeee can can cust custom omiz izee his his GUI GUI Employee will have access to RSS feeds Table 3.2: Employee Use Case Table

Operator use-case report Figure 3.1.3 describes use cases of the Operator. StupendousJSS/JSS Academy Of Technical Education, Noida 84


Fig 3.1.3: Operator Use Case report

3.1.6 Operator use case report StupendousJSS/JSS Academy Of Technical Education, Noida 85

RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS Table 3.3 describes use cases of the Operator .

USE CASE Acce ccess le level vel SMS E-MAILS Add record Update re record SMS-wishes RSS feeds Discussion forum Chat Chat appli applica cati tion on RFID reader

DESCRIPTION Oper perator ca can pe perform al all the the funct nctions ions of emplo ployee yee Operator can send SMS manually and can also schedule the SMS Oper perator can send e-ma -mails manual nuallly and can als also sched hedule ule e-ma -mails Operator can add employee record Oper perator ca can up update th the re records Operator ca can se send wi wishes th through SM SMS Operator can add RSS feeds Operator will monitor the discussion forum Opera Operato torr wil willl monit monitor or the the chat chat appli applica cati tion on Oper perator will monitor the rfid module Table 3.3: Operator Use Case Table


RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS Administrator use-case report Figure 3.1.4 describes use cases of the Administrator.

Fig 3.1.4: Administrator Use Case report



3.1.7 Administrator use case report

Table 3.4 describes use cases of the Administrator.

USE CASE Acce ccess le level vel Sala Salary ry cal calcul culati ation on Gener Generate ate repor reports ts Usage sage stat statis isttic Specif Specify y work working ing hour Gene Genera rate te pay pay sli slip p Trans ransla late te GUI Monit onitor orin ing g Discus Discussio sion n Forum Forum Chat Chat app appli lica cati tion on RFID reader Site Site Con Contr trol ol Remote Remote shut shutdown down History database Query Query comm commands ands Temporary module

DESCRIPTION Admi dmin can can add add, vi view, upd updaate and and dele delette the the records Admi Admin n can can calc calcul ulate ate the the sal salar ary y Admi Admin n can can gene genera rate te sal salar ary y and and att attend endanc ancee repor reports ts Admin dmin can can gen gener erat atee us usageage-st stat atis isttic re report port Admin will specify working hours, holidays Admi Admin n will will gen gener erat atee pay pay slip slip Admin dmin can can do do the the tran transl slat atio ion n of of com complet pletee GUI GUI Admi dmin wi will mon monit itor or dat date, tim timee co contr ntroll oller and and synch nchronize nizer r Admin Admin will will admini administe sterr discu discussi ssion on foru forum m Admi Admin n will will adm admin inis iste terr chat chat appl applic icat atio ion n Admi dmin will adminis nister RFID reader der appl pplica ication Admin dmin will will cont contro roll dif diffe ferrent ent sit sitees conn connec ecte ted d to to the the ce centra ntrali lize zed d ser server ver Admin Admin can can remote remotely ly shutdo shutdown wn the the serve serverr after after appro approval val Admin will have access to History database Admin Admin will will speci specify fy SMS and e-mail e-mail query query comm commands ands Admin will create temporary modules

Table 3.4: Administrator Use Case Table



3.2 Supplementary Requirements This section specifies the supplementary for the system. 3.2. 3.2.1 1

Repo Report rtin ing g Requ Requir irem emen ents ts

This section describes the reporting requirements of the system. •

Admin can export any report in different formats.

•

Admin can export any report in different forms of charts.

•

Any employee can export his personal report .

•

Any employee can export his personal report in forms of charts.

The formats in which reports should be available •

DOC

•

XLS

•

PDF

•

RTF

•

TXT

•

ODT

•

HTML

•

XML

Different forms of charts •

2D Bar Chart

3D Bar Chart StupendousJSS/JSS Academy Of Technical Education, Noida 89 •

RFID Based Employee Attendance Tracking System Version 2.0 Software Requirement Specification Date: 15-Feb-2012 StupendousJSS 2D Pie Chart • •

3D pie Chart

•

X-Y Chart

3.2. 3.2.2 2

Secu Securi rity ty Requ Requir irem emen ents ts

This section describes the Security requirements of the system.

•

SSL can be used for the secure communication b/w different different tiers of the application

•

Server date must not be changed during operation

•

Proper user authentication

•

Proper user authorization

•

Access Control

•

Use of Encryption

•

Use Of captcha in the registration forms

•

Tempering with H/W devices must not be possible

3.2. 3.2.3 3

Perf Perfor orma manc ncee Requi Require rem ments ents

This section describes the Performance requirements of the system.

•

Services will be available 24 X 7.

•

Better Component design for better performance at the peak time

•

Multiple RFID tag processing

•

Easily accessible

•

Multitier Application StupendousJSS/JSS Academy Of Technical Education, Noida 90


3.2. 3.2.4 4

Main Mainte tena nanc ncee Requi Require rem ments ents

This section describes the Maintenance requirements of the system.

•

Flexible service oriented architecture for future extension.

•

Clear separation b/w different tiers

•

Easily Customizable architecture 3.2. 3.2.5 5

User User Inte Interf rfac acee Requi Require reme ment ntss

This section describes the User Interface requirements of the system.  



GUI should be available in minimum two languages. Web Client should be able to open in different browsers (Mozila, IE, Chrome, Opera) Application must be able to get deployed on windows and Linux.



Special Thanks

We convey a special thanks to our department and to our college. We also conve convey y a specia speciall thank thankss to all all these these softw software are’s ’s and websites websites,, they they have have been been helping a lot in doing the project.


SRS RFID Employee Attendance Tracking System StupendousJSS

Recommend Documents