Sale!
Placeholder

Employee Expense and Reimbursement System

10,000 3,000

Product Description

Summary
Cooper Cameron (U.K.) Limited is located in Leeds and is a subsidiary of Cooper Cameron
Corporation, a U.S. Company. The Company utilises high technology business solutions including
SAP R/3 and a full range of Microsoft , manufacturing and engineering dedicated software.
The project addresses employee expense reports which are currently prepared and submitted for
processing on paper which is cumbersome and inefficient. The objective is to provide a web based
system to facilitate the submission of expense reports on a weekly basis which will form the basis of
making data available for departmental costs, financial related transactions and re-imbursement to
employees.
The system will be a satellite system to the existing SAP R/3 with bridging being executed by the
Company’s I.T. department.
This report documents the process encompassing the initial study, design, implementation and final
system evaluation.

Contents
1. Introduction 1
1.1 The Company 1
1.2 The Project 1
1.3 Background Research 2
1.4 Project Schedule 2
2. Objectives 3
2.1 Main Objectives 3
2.2 Minimum Requirements 3
2.3 Additional Requirements 4
3. Analysis 5
3.1 Requirements Gathering 5
3.1.1 The Current System 5
3.1.2 Interviews 6
3.1.3 Existing Solutions 6
3.2 User Requirements 7
3.2.1 Essential User Requirements 7
3.2.2 Enhanced User Requirements 8
3.3 Chosen Methodology 8
3.4 Chosen Technology 8
4. Design 10
4.1 Database Design 10
4.1.1 Entity Relation Diagram 10
4.1.2 Database Entities and Attributes 12
4.1.3 Database Constraints 13
4.1.4 Database Normalisation 13
4.2 System User Types 15
4.3 User Interface Design 16
4.4 Coding Style 18
4.5 Existing System Integration 19
– iv –
4.6 Security 20
5. Implementation
5.1 Database Implementation 23
5.2 Interface Implementation 24
5.3 Backup 31
6. Testing 32
6.1 Methods of Testing 32
6.2 System Testing 32
7. Evaluation
7.1 System Requirements 34
7.2 Methodology 34
7.3 Implementation and Testing 35
8. Conclusion 36
8.1 Future Enhancements 36
8.2 System Testing 36
Biography 37
Appendixes
Appendix A – Personal Reflection 38
Appendix B – Initial Project Schedule 39
Appendix C – Revised Project Schedule 40
Appendix D – Entity Relationship Diagram 41
Appendix E – Database Schema 42
Appendix F – ASP Code Extract 46
Appendix G – Sample Test Plan 47
Appendix H – Current Company Paper Expense Report

GET THE COMPLETE MATERIAL

INQUIRES:

OUR SERVICES: