Sign In
Not register? Register Now!
Essay Available:
Pages:
5 pages/≈1375 words
Sources:
Check Instructions
Style:
APA
Subject:
IT & Computer Science
Type:
Coursework
Language:
English (U.S.)
Document:
MS Word
Date:
Total cost:
$ 32.4
Topic:

Database Coursework. Payroll System for ABC Inc. IT & Computer Science Coursework

Coursework Instructions:

I've attached a link below which contains the details for the assignment.
https://drive(dot)google(dot)com/open?id=1SERQ9dFwLgVu4FIDEJofhj3oZkTqTJKPy_k1VIp38hg

Detailed Assignment Description
Outcomes to be assessed
• Describe in brief how a business operates
• Utilise standard graphical notations for communicating the form of the database to the customer and the programmer in a standard manner
• Analyse the requirements for business database, create and query it utilising the SQL language in a database management system (using XAMMP and MySQL)
• Elicit the database specifications from brief documents 
• Perform the database conceptual requirements analysis
• Describe the logical diagrammatic model of the data and how to normalise it
You are designing and implementing a payroll system for a company of your choice. The employees in the company are paid on hourly base, overtime is paid 1.5 of the basic rates. The database must have the followings elements:
• A manner for the payroll assistant to login to the online system.
• The list of employees and their attributes (e.g. designation, name, surname, job title, years in the company, hourly pay, national insurance number, contact details, etc.).
• Payment history (e.g. payment received in the first week of June)
REQUIREMENTS: The database should contain at least 15 employees. There should be 3 different job types with a different hourly pay. The database should have at least 6 weeks history, the hours worked in a day for each day worked). Some of the employees must do overtime. For each job title, there might be several grades, which lead to a different hourly rate. For example, an assistant Grade 6.1 has an hourly wage of £14.50, while an assistant Grade 6.2 has an hourly rate of £16.10.You must produce a Written Report (1500 words max) the minimum font size to be used in the report is ARIAL point 11. All screenshots must be clearly legible.
• The report’s 1st page should contain the report title, the authors (name, surname & student ID, of both students contributing). This is not counted in the word count.
• The 2nd page should have a content list (including list of figures). This is not counted in the word count.A, B, C, D, E elements of the Group Report are as follows (the word count starts now):
• A. (10% of mark) Customer brief – this is an essential part of both the project development and the contract with the client as it helps guarantee that the work for a project will be done according to specific guidelines and expectations of the client. If you cite any source to write this section, please provide it in the reference list utilizing APA style. Your brief should include:o An Overview of what the payroll system is expected to do in order to produce the data required by the mySQL queries below (a short paragraph of max 500 words)
o A Concept Table (who, when, where, why, how)
o A Conceptual Model of the whole payroll system and its attributes (e.g. main tables and columns needed in the database) displayed visually utilizing two different techniques:
Axis Technique
Conceptual ER modelo A Dictionary of all the key-works utilised by the system and their meanings (e.g. hourly pay is the amount an employee gets paid per hour).• B. (25% of mark) Normalization - show with tables, and explain in writing (step by step), how the Conceptual ER (CER) model you have produced is being normalised. In particular in the report you need to present:
o The unnormalized model (this is the CER model, or one long list of attributes, where you have ensured it has all the columns shown in the conceptual model, but it has no keys)o Logical ER model (1NF) and explain how from CER you moved to 1NFo Logical ER model (2NF) and explain how from 1NF you moved to 2NFo Logical ER model (3NF) and explain how from 2NF you moved to 3NF• C. (2% of mark) The database - Build the database in XAMMP (in the report you should provide both the screenshots of the database creation and the code - see note 2 below)
o (1%) Create the databaseo (1%) Create all the tables, with columns and keys• D. (60% of mark) The queries - Code the following queries in XAMMPS. In the report provide i) the code as text in the report, ii) the screen-shots of both the query’ code and its iii) results/print out - see note 2 below:o Produce a list of employees that have worked more than 35 hours in the current week (note the DB should still have some that have worked less than 25 hours)o Produce a list of employees that live in specific UK city that has a particular job designation (note there should be still employees in the DB that live at a different city and have a different job title)o List the employees of the company that on average have been paid the most in the last 4 weeks. (note the DB should contain more than 4 weeks data).o Produce a payslip for the past 4 weeks for one of the employees that has done overtime in at least one week (see template provided, see figure 1. The payslip number to be constructed as a unique key using date and job and grade. Figure 1. Sample payslip, note payslip number is not shown as we want you to work it out.
• E. (3% of mark) Composition of reporto Include a table of content and figureso All screen-shot and graphics must be readable, of good image quality and appropriate for the size of the printed pageo Ensure spelling and grammar is correct throughout the reportNOTE: We MUST provide the following information from XAMMP as a proof that the database has been built. This information I. and II. should be included as an Appendix to the report. Information III. and IV. should be included in the solution of D. The information that MUST be included is the following:• I. Data dictionary – saved as .pdf file and included in the report appendix. This information can be accessed from the main page of XAMMPS. After the database is built, a link will appear called Data dictionary, which needs to be clicked.• II. The Designer – save the screen-shot as a .pdf file or add it as a picture within the report. The Designer can be found under the top navigation bar (or under the More tab in some versions).• III. The SQL code – save the screen-shot as a .pdf file or add it as a picture within the report. This is the code produced in XAMMP, which can be found under the SQL tab in the top navigation bar. Simple code is automatically generated when using the interfaces. However, we required that you show the code that has been created by yourself, such as for example the code to generate the invoice. Please remember to open up the SQL windows to type the code and enlarge the window in a manner that includes the whole code clearly before screen-shoot it. For example, any table containing a composite key should be created with code, and the code screen-shot.• IV. A screen shot of the output created by the code - save the screen-shot as a .pdf file or add it as a picture within the report. This will be generated when running the code pressing the button ‘Go’ at the bottom right of the SQL tab screen. The code run is shown at the top of the screen and should also be included. NOTE 2: All the images used on the report should be of sufficient quality for the text depicted to be read clearly in the printed report. Utilise the same style throughout, label the figures and provide a brief explanation of what the picture shows.

Coursework Sample Content Preview:

Payroll System for ABC Inc.
The author’s name and surname
Student ID (of both students contributing)
1.0 Part A: Customer brief
1.1 An Overview of what the payroll system
Payroll management is a common function in businesses and organizations with several employees. However, the approach used for payroll management differs from one organization to another. In this case, the payroll system used by ABC Inc. uses a manual system composed of ledger books in keeping track of the salary history of its employees, calculating when to rise the salary, and computing other factors like overhead, overtime, conveyance allowance, bonuses, and the net salary to be paid to the employees (Carnevale, Smith, & Strohl, 2013). It also computes overtime based on job groups and descriptions, and the hourly rates assigned to each job description. The amount that an employee earns from overtime is also computed depending on the number of hours they worked.
The current system used by ABC Inc. is pen-and-paper based and thus prone to errors and time consuming as it is used to compute payments for 15 employees. The paperwork can also be easily accessed by unauthorized parties, unlike in the use of an online payroll system that allows access to authorized individuals only since it is encrypted using a password (JA, 2020). In order for the user to log into the payroll system, they need to input their username and password as shown in the screenshot below.
Figure 1: Logging into the system
The current system used at the company is associated with delays and sometimes it is difficult for the users to access historical records. Similarly, entry and analysis of results are prone to errors as the process is done manually, and there is limited confidentiality as the records can be accessed easily. This creates the need for a system that reduces delay, fatigue, and enhances confidentiality. Enhancing the efficiency of the system will also enhance the efficiency of the decision-making process at the company since this function also depends on the effectiveness of the payroll system.
The purpose of this study was to create a payroll system that is effective and thus improve the efficiency of creating and managing salary sheets easily and accurately, capturing the data of the employees depending on the department in which they work, job descriptions, hourly rate as per their job description, number of overtime hours worked, and the net salary. The payroll system that has been developed for ABC Inc. will give users the following benefits;
* Interaction with the software through menu-driven programs which have an interface that is user-friendly.
* Effectively manage employee information and trends.
* Maintaining employee details on allowances (festival, conveyance), overloads, and deductions.
* Automatically managing employees’ salary increment.
* Managing any advance payments made to employees.
* Generating pay slips for all employees with great ease and convenience.
* Generating reports depending on management requirements.
* Computing the net salary of employees.
How the Database Functions
The employees in the company are paid on hourly base, and overtime is paid 1.5 of the basic rates. The dat...
Updated on
Get the Whole Paper!
Not exactly what you need?
Do you need a custom essay? Order right now:
Order

You Might Also Like Other Topics Related to scientific essays:

HIRE A WRITER FROM $11.95 / PAGE
ORDER WITH 15% DISCOUNT!
Order Now