Download Case Tools and applications and more Study notes Applications of Computer Sciences in PDF only on Docsity!
III-BCA – V SEMESTER
ELECTIVE / SKILL – MM / BCA: CASE TOOLS CONCEPTS AND
APPLICATIONS
UNIT-
UNIT II: Approach used to solve the problem statement: How to deal with a problem statement-Data flow diagram for Payroll System-Presentation Diagram for Payroll System schematics of the model-Forms- Screens-Menu Screens-Data entry Screens-Report Output Format-Utilities. Installation of Ubridge and Synthesis: How to use the tools in Ubridge Synthesis for case-Installation of Ubridge Synthesis-Computer Aided Software Engineering _Getting Ubridge to work-Setup-Assign-Housekeep-The Ubridge page
PAYROLL SYSTEM Synopsis
- Introduction
- Uses of Payroll System
- Project Objectives
- Technical Issues
- Project Description
- The Most Important Modules of The Design Are
- Choosing A Payroll System Introduction Payroll Management System is basically used to build an application program that a company uses to manage the records of the employees working in the company. Only the administration has the legal rights to work with the system. Employees can only log on to the system to see their current status. Uses of Payroll System Create records Delete records Save records For employees according to their information given to the administration of the company.
Project Objectives To improve efficiency of company’s administration. To store up-to-date information of the employees. To make the employees understand the rules of the company. To reduce extra cost for the security of the database. Technical Issues How the program saves data? How errors are detected and how the error messages are to be displayed? What happens when we try to overwrite the data? Is the software user-friendly? Project Description The term payroll encompasses every employee who receives a regular wage or other compensation. The different payment methods are calculated by a payroll specialist and the appropriate paychecks are issued. After a payroll accountant multiplies an employee’s hours by his/her pay rate , the gross income amount is entered into a computer program Regular deductions such as tax withholdings, medical insurance etc. are then categorized and subtracted. The remaining balance is then converted to a check and becomes the employee’s net pay for that time period. Setting up an effective payroll system is not difficult for trained professionals, but it can be very time consuming A payroll system involves everything that has to do with the payment of employees and the filing of employment taxes, keeping track of hours, calculating salary, printing and delivering checks etc. Few of the possible deductions are:- Health insurance Vacation days Sick days Employee loans Child support payments The Most Important Modules of The Design Are
Introduction Payroll Management System is basically used to build an application program that a company uses to manage the records of the employees working in the company. Only the administration has the legal rights to work with the system. Employees can only log on to the system to see their current status. Here we are going to learn the case studies of a payroll system Example for converting Computerized system Your are supposed to conduct a system study and do a presentation on the current manual system and how a computerized system will benefit the organization. You have one hour in which to do the presentation and Manual system MD himself will attend. You’re a system analyst of a known software house Your are supposed to learn the current manual system and change it to the new computerized system. As a system analyst, you job will be to o Learn how the current manual system works o Meet the key personnel ( employees ) of the organization o Conceptualize in diagrams , how the current system works o Go back and talk to that MD about how you have understood the system o Draw your Data Flow Diagrams o Construct the table structures o Get the programming done o Implement the new system o Check that it functions properly o If any flaws found, then go back to step o Make a smooth transfer from the manual to the computer system Presentation session The presentation will contain a model of the current manual payroll system followed by a presentation of the proposed computerized payroll system in great detail This is properly explained by system analyst and the following things are expected by him or her The Environmental Model This is an overview of the proposed system
It concentrates on what has to be done rather than how it is to be done He various heads are o An event list o Functional decomposition diagram o Context diagram o Presentation diagram o A statement of purpose An event list It is a list that contains a sequential ordering of the events taking place in the current manual system. And it is used to identify all the external entities required as inputs and outputs of the current manual system Eg o The HRD department o Time office (time in and out) o Accounts department Functional decomposition diagram In event list, after identifying all the entities , detect the hierarchical decomposition among them (entities). These are functional decomposition diagram o Payslip Earning process Label Process o Input o Output Deductions Process Label Process o Input o Output Context diagram This diagram helps you to identify the department which is involved in the payroll system
The basic pay of an employee is fixed as per the rules laid down by organization The factors like HRA, DA, PF,ESI and IT are paid to the employee as percentages of basic The take home salary of an employee is depends upon the basic that has been fixed by the organization The Earning Heads Basic ( compensation given by the company to the employee for the work done ) Overtime compensation Dearness allowance Bonus Fringe (Extreme) Benefit House Rent Allowance (HRA) -(family accommodation) Leave Travel Allowance (LTA)-(expenditure incurred on a vacation) Leave Travel concession (LTC)-(journey fare) Conveyance Allowance (expense incur in travel to and from office) City compensatory Allowance(CCA) The deduction heads Income tax and profession tax Provident fund Company Accomodation charges Deduction for absence from duties Attendance information Attendance record Leave details-CL, Earned leave (EL)/Privilege Leave (pl) Medical leave (ML) Example for Payslip Format:
APPROACH USED TO SOLVE THE PROBLEM STATEMENT:
HOW TO DEAL WITH A PROBLEM STATEMENT
Synopsis
- Introduction
- Uses of DFD
- DFD diagram for the Payroll system
- Presentation Diagram
- Presentation diagram for the Payroll system
- Schematic of the Model Introduction To have a better understanding of how the new payroll computerized system will work, we will have to draw a schematic (graphical or chart or diagram) Model for the current system. Also one must understand the movement of data in the organization This method of understanding the data movement can be made more simple to understand by drawing diagrams This diagrams which represent the data flow is called the Data Flow Diagram The Data Flow Diagram for the Payroll System is as drawn in the following diagram
For that the representation must change. This has to be done without changing the actual data flow. The representation of data flow diagram style must be easily understand by the clients. Such types of representation diagrams are called PRESENTATION DIAGRAMS Fig: Presentation diagram for the Payroll system New P.I.S New Employee Data Entry for P.I.S Att ATTD Daily Data Entr for Attendance Lea LEAV Leave Requisition Data Entry for Leave Loa LOAN Loan Requisition slip Data Entry for the Loan Information Gov GOVT EMP Government Data Entry Employee’s Salary P.I.S P.I.S. Process ATTENDANCE Attendance Process LEAVE Leave Process LOAN Loan Process INCOME Income & Deduction Data QTY R Quarterly Report Generation PAYSLIP Payslip Printing Payslip Printing process QTY REP Quarterly Report Generation MGT Management
Schematic of the Model MAIN MENU MASTER_MENU PIS LOAN GOVT EXIT_MENU MAIN MENU TRANSACTION_MENU NO_DAYS EXIT_MENU MAIN MENU REPORT_MENU PAYSLIP EXIT_MENU MAIN MENU UTILITIES_MENU BACKUP PASSWD EXIT_MENU MAIN MENU EXIT_MENU MAIN MENU
o The problem of firing complex validations on the user data can be solved by using forms as the temporary pool to store data. The valid data then can be picked up from the form and can be transferred to the table. Design of FORMS or SCREEN Creating fields on the forms Positioning fields on the form Choosing the acceptable default values for the field Chaining of screens by using fields on the form Providing help on fields Providing help on the form Schematic Model for the Payroll System
- MAIN_MENU SCREEN
- MASTER_MENU SCREEN
- PIS SCREEN
- LOAN SCREEN
- GOVT SCREEN
- TRANSACTION_MENU SCREEN
- NO_DAYS SCREEN CASE Tools in Schematic Model CASE tools also provides an option to design all these data entry screen The total no of screens that are to be designed can be determined from the schematic diagram. This will make the documentation for the system to become simple. The documentation for that system can be maintained in software houses It helps the programmer or system analyst to make changes to the system. Documentation of the system It consist of the functioning of the o current manual system o DFD o hierarchy of the system o Presentation diagrams
o Screens and o The current functioning of the system etc The makes the programmer to make changes to the system in future. Aim of Documentation of the system Not only technical documentation but also to produce users manual for the client So that it helps client to use as reference in later The documentation must provide the information about all the fields on the forms Documentation of the Screens The documentation for the screens in the payroll system is given below SCREENS :
1. MAIN_MENU Fields: 1. Choice Position: Row 18,Column 70, Width 1, Depth 1 Character, Format X (1) Must be Entered, Auto Skip Default Value Value Chain To Clear Library M MASTER_MENU Y PAYROLL UBL T TRANSACTION_MENU Y PAYROLL UBL Payroll Management System Developed By Silicon Chip Technologies Main Menu Date : 12/07/ Master Transaction Utilities Reports Exit CHOICE:
Position: Row 18,Column 66, Width 1, Depth 1
- Character, Format X (1)
- Must be Entered, Auto Skip Default Value Value Chain To Clear Library 1. P PIS Y PAYROLL UBL 2. L LOAN Y PAYROLL UBL 3. I GOVT Y PAYROLL UBL 4. E MAIN_MENU Y PAYROLL UBL Field Macro: Please enter P P.I.S Master L Loan Master I Govt Master E Exit to Main_Menu Screen Logic: This Screen: o It is a pull-down menu for the Masters. There are three masters that can be accessed via this screen The P.I.S. Master: o All the personnel information regarding the employee will be kept in the P.I.S. master The Loan Master: o If any employee has taken a loan , then all the information regarding how much loan has been taken, pay back period etc will be entered her The Govt Master: o The information regarding what must be the employees salary ( by taking in consideration all the rules laid down by the government)will be entered here. The Exit Menu: o This menu option will take you back to the Main Menu of this application
3. PIS
Fields:
1. Emp_code Position : Row 5,Column 22, Width 6, Depth 0 Character, Format X (0) Must be Entered, Auto Skip Default Value Field Macro: This field cannot be left blank. It must start with the letter S or W.
- Emp_name Position : Row 5,Column 44, Width 30, Depth 1 Character, Format X (30) Must be Entered, Auto Skip Default Value Field Macro: This field cannot be left blank. PAYROLL MANAGEMENT SYSTEM DEVELOPED BY SILICON CHIP TECHNOLOGIES MASTER DATA ENTRY P.I.S MASTER Date: 12/07/ EMPLOYEE CODE : EMPLOYEE NAME: DEPARTMENT : DIVISION: EMPLOYEE TYPE: ADDRESS : STATE : CITY : PINCODE: JOIN DATE :
Field Macro:
8. state Position : Row 11,Column 22, Width 15, Depth 1 Character, Format X (15) Must be Entered, Auto Skip Default Value Field Macro: This field cannot be left blank 10. City Position : Row 13,Column 22, Width 15, Depth 1 Character, Format X (15) Must be Entered, Auto Skip Default Value Field Macro: This field cannot be left blank 11. Pin_code Position : Row 13,Column 53, Width 6, Depth 1 Character, Format X (6) Must be Entered, Auto Skip **Default Value
- Join_date** Position : Row 15,Column 22, Width 8, Depth 1 Type: Date, Format mm-dd-yy Must be Entered, Auto Skip Default Value Field Macro: Today’s date must be entered here. This field cannot be left blank Screen Logic: This is the P.I.S. Master.
It is used by the company to maintain the personnel information of each and every employee that works for the organization. It is used to enter all the persoonel information regarding an employee.
4. LOAN **Fields:
- Emp_code Position** : Row 7,Column 26, Width 6, Depth 0 Character, Format X (0) Must be Entered, Auto Skip Default Value Field Macro: This field cannot be left blank. 2. Loan Position : Row 9,Column 26, Width 7, Depth 1 Type: Numeric, decimals 2, Format 9 (4)(2) Must be Entered, Auto Skip Default Value Field Macro: The amount of loan taken by the employee will be entered here This field is a mandatory field and hence cannot be left blank 3. Pay_bk_pd PAYROLL MANAGEMENT SYSTEM DESIGNED AND DEVELOPED BY S.C.T LOAN INFORMATION Date: 12/07/ EMPLOYEE CODE : LOAN AMOUNT : PAY BACK PERIOD : DUE :
