Pay Roll System Project Proposal Computer Science Essay

Pay Roll System Project Proposal Computer Science testVisual Basic was one of the first languages along with Paradox and Dbase designed to take advantage of graphical user interface interfaces with optic programming in mind. We washstand inst solely the menus, forms and reports of a program by visual drag and drop operations. Then complete the coding by filling in the skeleton programs developed during prototyping of the programs interface. cryptology VB pioneered the use of standard 3rd party components such as VBX and now ActiveX. 68.2 Java 61 TITLEPayroll governance2 CUSTOMERSMITH News Agent, Watford.3 BACKGROUND/OVERVIEWIn metalworker news agent, they atomic number 18 doing paper work count for employees monthly salary. And they ar maintaining all employees details and salary details in paper works. They have to keep all details for long time for shop purpose. It takes long time to do all employees salary calculation. To solve the entire problem I decide to develop a sys tem for payroll. All information ar going to enclose in a database and all calculation is going to calculate by system.4 MAIN FUNCTIONS OF THE SYSTEMIn the system, motorcoach or Assistant Manager can login as an administrator. They can add employee details like First Name, Last Name, Address, Phone No, NI number, Bank Details, tax revenue Code, etc. For salary calculation they can enter employees working hours for that month. If they want they can add bonus also. Automatically the system will calculate the salary and it will generate the reports. executive can view and print the reports and details and if they want they can delete the employees details.5 STATEMENT OF PROBLEMIn Tax Code, there are devil type of Tax Code in using. Those are5.1 Tax Codes end with a letterThis Tax Code is made up of several amount and a letter. This type of Tax Code is called Suffix codes. For example 647L, 375K, etc (paypershop, nd).5.2 Other Tax CodesThis Tax Code has two letters. There is no Number or is the letter D followed by a Zero For example BR, D0, and NT (direct, nd).In compensation type, they are paying regular hours, bank holiday hours and holiday hours. They are not paying for sick hours.6 SOLUTIONS FOR PROBLEM STATEMENTFor Tax Code problem, I am going to use second type of Tax Code method (Other Tax Codes). For payment type problem, I am going to add a column called Pay Type. When they enter working hours they can select what type of working hours.For example REG RegularBH Bank HolidaySICK Sickness Hours7 AIMS AND OBJECTIVES7.1 AIMSThe main aim of the project is to develop a system to store employees all details and working hours. The system has to calculate the payment and tax. The system also generates the reports.7.2 OBJECTIVESTo understand the current systemI went to Smith news agent (my customer) store and met the manager. I collected the details about how they are doing current salary calculation and how they are keeping are records. It is uncryst allized interviews.To accept a similar systemI went to Dowson house hotel and met the manager. I got some(a) details about how their current system working, how they are calculating the payment and tax and how they are storing their employees detail.To study about Unified Modelling Language(UML)It is help to create the logical design of the System. For e.g. Activity diagram, Use case diagram, Class diagram.To study about programming languagesJava, Visual Basic.NetTo study database applicationsOracle, MysqlDesign the systemTesting and implementationTest the system and make sure it works according to the customers requirements, which includes handicap and validation.Install the developed system in store. And train the manager and assistant manager.Get feedback from the manager and assistant manager. Make any change if they want changes or new makes.8 Literature review8.1 Visual Basic.NetVisual Basic was one of the first languages along with Paradox and Dbase designed to take advant age of graphical user interface interfaces with visual programming in mind. We can build the menus, forms and reports of a program by visual drag and drop operations. Then complete the coding by filling in the skeleton programs developed during prototyping of the programs interface. Coding VB pioneered the use of standard 3rd party components such as VBX and now ActiveX.Now, VB.NET has many new and amend language features. The .NET framework comes with ADO.NET, which follows the disconnected paradigm, i.e. once the required records are fetched the connection no longer exists. Error handling has changed in VB.NET. A new Try-Catch-Finally block up has been introduced to handle errors and exceptions as a unit, allowing appropriate action to be taken at the place the error occurred thus discouraging the use of ON geological fault GOTO statement. Security has become more robust in VB.NET. In addition to the role-based auspices in VB6, VB.NET comes with a new security model, Code Acce ss security (David, Chittibabu 2004).8.2 JavaJava was designed to be easy to use. Therefore it is easy to write, compile, debug, and learn than other programming languages. Java is object-oriented because programming in Java is cantered on creating objects, manipulating objects, and making objects work together. This allows you to create modular programs and reusable code. One of the most significant advantages of Java is its ability to move easily from one computer system to another. The ability to run the same program on many different systems is crucial to World Wide Web software, and Java succeeds at this by world platform-independent at both the source and binary levels.Java is one of the first programming languages to consider security as part of its design. The Java language, compiler, interpreter, and runtime environment were individually developed with security in mind. In Java, multithreaded programming has been smoothly integrated into it, while in other languages, oper ating system-specific procedures have to be called in nightspot to enable multithreading. Multithreading is a necessity in visual and network programming (Herbert 2007).8.3 My Front End GUIAfter a lot of research I was decided to use VB.Net for my front end GUI. There are some good features in VB.Net. For example, we can build the menus, forms and reports of a program by visual drag and drop operations. Then we have to complete the coding. Like these there are lot of features.Why I did not chose the java? There are lot drawbacks. Java language programs runs on a virtual machine. Therefore it runs slowly and it takes more memory-consuming. In java, No separation of specification from implementation and No preconditions and post conditions. And Exceptions not caught within a method must be declared as thrown by that method. The default look and feel of GUI applications written in Java using the Swing toolkit is very different from native applications.8.4 ORACLE (PL/SQL)Oracle is the No 1 database and has the most advanced feature set. Oracle is made up of a set of processes running in our operating system. Oracle database system has the following propertiesAtomicity That is Results of a minutes execution are either all committed or all rolled back.Consistency The database is transformed from one valid state to another valid state. Illegal transactions arent allowed and, if an integrity constraint cant be satisfied then the transaction is rolled back.Isolation The results of a transaction are invisible to other transactions until the transaction is complete thus increasing the security on data.Durability Once committed (completed), the results of a transaction are permanent and survive forthcoming system and media failures and thus ensuring maintenance and protection of data (Steven, Bill 2005).We are using PL/SQL (procedural SQL) language to use the Oracle. With PL/SQL, we can use SQL statements to manipulate Oracle data and flow-of-control statements to pro cess the data. Moreover, we can declare constants and variables, define procedures and functions, and trap runtime errors. PL/SQL is a block-structured language. A PL/SQL block has three parts a declarative part, an executable part, and an exception-handling part (In PL/SQL, a warning or error condition is called an exception).8.5 MySQLMySQL is open source Relational DataBase Management System (RDBMS). It is using Structured Query Language (SQL). The Mysql has lot of advantages. It is functional on many different operating systems. We can use in different platform. It is free to use for personal, private, or development use. It is using Indexes like first key index and unique index to avoid duplicate row data. We have the opportunity to optimize searching against even large amounts of text hardened in any field indexed as such.8.6 My Back EndI decided to use Oracle (PL/SQL) to use back end. In prophet, lot of advantages are there. PL/SQL makes it easy to detect and process predef ined and user-defined error conditions called exceptions. Anonymous PL/SQL blocks can be embedded in an Oracle Pre-compiler. And one of the main advantages is recent version (10g) oracle has the concept of Flashback technology. Flashback provides anEfficient recovery from human errorsFaster database recoveryHelps in simplifying the management and administration processesWhy I was rejected the MySQL? There are some drawbacks. The indexes take up disk space. Normally the space usage is not significant, but because of creating index on every column in every realistic combination, the index commit would grow much more quickly than the data file. In the case when a table is of large table size, the index file could reach the operating systems maximum file size. The indexes slow down the speed of writing queries, such as INSERT, UPDATE and DELETE. Because MySQL has to internally maintain the pointers to the inserted rows in the developed data file.