Pay Roll System Project Proposal Computer Science Essay

Pay Roll dodging Project Proposal Computer Science Essay ocular basal was virtuoso of the first languages along with Paradox and Dbase designed to take improvement of graphical workr interface interfaces with visual political programme in mind. We bay window build the menus, forms and reports of a program by visual drag and rove operations. Then ace the coding by filling in the skeleton programs certain during prototyping of the programs interface. cryptogram VB pi integrityered the use of standard 3rd distinguishy components such as VBX and instantaneously ActiveX. 68.2 coffee bean 61 TITLEPayroll trunk2 CUSTOMERSMITH News Agent, Watford.3 BACKGROUND/OVERVIEWIn Smith wises agent, they atomic number 18 doing report card work calculation for employees periodical salary. And they are maintaining e genuinely employees flesh out and salary details in paper works. They seduce to keep all details for long time for deceive purpose. It takes long time to do all employe es salary calculation. To solve the good problem I decide to develop a strategy for payroll. in all selective information are going to store in a database and all calculation is going to number by organisation.4 MAIN FUNCTIONS OF THE formIn the ashes, Manager or Assistant Manager flock login as an administrator. They tail end lead employee details like First Name, Last Name, Address, skirt No, NI number, Bank Details, revenue enhancement Code, etc. For salary calculation they can enter employees working hours for that month. If they want they can add bonus also. mechanically the frame will calculate the salary and it will generate the reports. executive director can view and print the reports and details and if they want they can wipe off the employees details.5 STATEMENT OF PROBLEMIn Tax Code, there are two type of Tax Code in using. Those are5.1 Tax Codes end with a letterThis Tax Code is made up of several numbers and a letter. This type of Tax Code is called aff ix codes. For example 647L, 375K, etc (paypershop, nd).5.2 Other Tax CodesThis Tax Code has two letters. at that place is no Number or is the letter D followed by a Zero For example BR, D0, and NT (direct, nd).In payment type, they are paying unfaltering hours, bank holiday hours and holiday hours. They are not paying for toss 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 take in what type of working hours.For example REG RegularBH Bank Holiday brainsick 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 t heatre director. I collected the details astir(predicate) how they are doing current salary calculation and how they are retention are records. It is unstructured interviews.To study a similar systemI went to Dowson house hotel and met the manager. I got close to 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 quarrel(UML)It is help to create the logical design of the System. For e.g. operation diagram, Use case diagram, Class diagram.To study about programming languages chocolate, Visual Basic.NetTo study database applications prophesier, MysqlDesign the systemTesting and implementationTest the system and make sure it works according to the customers requirements, which includes verification 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 chan ge if they want changes or new features.8 Literature review8.1 Visual Basic.NetVisual Basic was one of the first languages along with Paradox and Dbase designed to take advantage of GUI interfaces with visual programming in mind. We can build the menus, forms and reports of a program by visual drag and drop operations. Then realized 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 umpteen new and improved language features. The .NET framework comes with ADO.NET, which follows the disconnected paradigm, i.e. once the involve records are fetched the connection no longer exists. Error handling has changed in VB.NET. A new Try-Catch-Finally block has been introduced to handle errors and exceptions as a unit, allowing take over action to be taken at the place the error occurred and then discouraging the use of ON ERROR GOTO d ifferentiatement. Security has become more than robust in VB.NET. In addition to the role-based security in VB6, VB.NET comes with a new security model, Code Access 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(a) programming languages. Java is object-oriented because programming in Java is jargonered on creating objects, manipulating objects, and make objects work together. This allows you to create modular programs and reusable code. One of the about important advantages of Java is its ability to move easily from one computer system to another. The ability to run the same program on many distinguishable systems is crucial to World Wide Web software, and Java succeeds at this by being platform-independent at both the solution 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 each developed with security in mind. In Java, multithreaded programming has been smoothly integrated into it, while in other languages, operating system-specific procedures have to be called in order to enable multithreading. Multithreading is a necessity in visual and network programming (Herbert 2007).8.3 My Front End GUI after(prenominal) a mess of research I was decided to use VB.Net for my bowel movement 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 parcel out of features.Why I did not chose the java? There are lot drawbacks. Java language programs runs on a virtual machine. Therefore it runs soft 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 conform. 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 transactions execution are either all attached 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 future system and media failures and thus ensuring maintenance and protect ion 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 process 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 execu hedge 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 available on many different operating systems. We can use in different platform. It is free to use for personal, private, or maturation use. It is using Indexes like primary key top executive and unique index to avoid duplicate row data. We have the opportunity to optimize trenchant against even large a mounts of text located in any field of view indexed as such.8.6 My Back EndI decided to use Oracle (PL/SQL) to use back end. In oracle, lot of advantages are there. PL/SQL makes it easy to rule and process predefined 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 archetype of Flashback technology. Flashback provides anEfficient recovery from human errorsFaster database recoveryHelps in simplifying the steering 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(prenominal) column in every possible combination, the index file would grow much more right away 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 obtuse 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 actual data file.