Sale!
Placeholder

Management Job Costing System

10,000 3,000

Product Description

SUMMARY
Pump Supply & Repair Group Ltd is a medium sized company that manufactures and repairs
industrial pumps. One of the systems that they require is a job costing and quotation system. The aim
of the system is to computerise the quotation documents as well as provide useful management
information from the system, which was not available under the old manual system.
The aim of this project was to continue further development of a system implemented over the
summer as part of an industrial placement, and to design and implement a web-driven database that
would allow customers to access their personal quotation documents and submit decisions for quotes
online.
The requirements were delivered successfully and the website was implemented and tested on the
School of Computing IIS Windows 2000 Server. It can be found at: http://csiis.leeds.ac.uk/iaxtc
A sample account has been created with the following login details
Username: apache
Password: apache

Table of Contents
Chapter 1: Analysis 1
• 1.1 Background to problem 1
• 1.2 The System 1
• 1.3 Problems with the current system 2
• 1.4 Benefits of a successful solution 2
• 1.5 Functional requirements for the new system. 3
• 1.6 Non Functional Requirements 4
• 1.7 System Scope 4
1.7/01 Features within the scope of the system 5
1.7/02 Features outside the scope of the system 5
• 1.8 Work carried out over summer 5
1.8/01 Implementation of database 5
1.8/02 End user involvement 7
Chapter 2: Design 8
• 2.1 Background reading: Development tools 8
2.1/01 Solutions for website development 8
2.1/02 Database Solutions 10
• 2.2 Choice of Software and Hardware 11
• 2.3 Database Design 12
2.3/01 Relational Schema 12
2.3/02 ER Diagram based on schema 13
2.3/03 Description of ER diagram 13
2.3/04 Functional Dependencies and Normalisation 13
2.3/05 Anomalies 13
2.3/06 Functional Dependencies 14
2.3/07 Key 14
2.3/08 3rd Normal Form 3NF 14
• 2.4 UML Deployment and Component Design 15
2.4/01 Deployment Diagram 15
2.4/02 Component Diagram 15
2.4/03 Combining the two diagrams 15
• 2.5 HCI Design 15
2.5/01 Site Navigation Structure 15
Chapter 3: Implementation 16
• 3.1: Implementing the web link 16
3.1/01 Login Screen 16
3.1/02 Creating Cookies 16
3.1/03 Customer Home Page 17
3.1/04 Edit Customer Details 18
3.1/05 Display Job List 18
3.1/06 Display job detail 19
3.1/07 Submit Response 19
3.1/08 Sending of email confirmation 21
3.1/09 Logging out 21
• 3.2 Improving the current database 22
3.2/01 Changes to the table structure 22
3.2/02 Creating reports 23
3.2/03 Problems encountered 24
3.2/04 Improving the HCI 24
IV
Chapter 4: Testing 25
• 4.1 Back Box Testing 25
• 4.2 Comments on test results 25
• 4.3 White Box Testing 27
Chapter 5: Evaluation 27
• 5.1 Evaluation Criteria 27
5.1/01 Meeting the functional requirements 28
5.1/02 Meeting the non-functional requirements 28
5.1/03 Feedback from the company 28
5.1/04 Problems encountered with website development 29
5.1/05 Suggestions for further enhancements/improvements 30
5.1/06 Key recommendations for the organisation 31
5.1/07 Comparison with similar system 31
• 5.2 Conclusions 31
Project Management 32
References 34
Appendix A: Reflection of the project experience 36
Appendix B: Diagrams for analysis 38
Appendix C: Diagrams for design 46
Appendix D: Screenshots and source code for implementation 50
Appendix E: Testing 62
Appendix F: Evaluation material

GET THE COMPLETE MATERIAL

INQUIRES:

OUR SERVICES: