Food Wholesale Ordering System


Download Food Wholesale Ordering System


Preview text

California State University, San Bernardino
CSUSB ScholarWorks
Theses Digitization Project
2005
Food Wholesale Ordering System
Dennis Meng Yann Hsieh

John M. Pfau Library

Follow this and additional works at: https://scholarworks.lib.csusb.edu/etd-project Part of the Databases and Information Systems Commons
Recommended Citation Hsieh, Dennis Meng Yann, "Food Wholesale Ordering System" (2005). Theses Digitization Project. 2897. https://scholarworks.lib.csusb.edu/etd-project/2897
This Thesis is brought to you for free and open access by the John M. Pfau Library at CSUSB ScholarWorks. It has been accepted for inclusion in Theses Digitization Project by an authorized administrator of CSUSB ScholarWorks. For more information, please contact [email protected]

FOOD WHOLESALE ORDERING SYSTEM
A Project Presented to the
Faculty of California State University,
San Bernardino
In Partial Fulfillment of the Requirements for the Degree
Master of Science in
Computer Science
by Dennis Meng Yann Hsieh
December 2005

FOOD WHOLESALE ORDERING SYSTEM
A Project Presented to the
Faculty of California State University,
San Bernardino
by Dennis Meng Yann Hsieh
December 2005
Approved by:
?0,
Dr. Keith''Schubert, Chair, Computer Science Date Dr. Ernesto Gfomez Dr. fflong Lai Yt

© 2005 Dennis Meng Yann Hsieh

ABSTRACT FWOS (Food Wholesaler Ordering System) demonstrates the application of web services to provide an ecommerce solution for general food wholesalers and their customers. The FWOS system was implemented using the PHP scripting language, HTML, JavaScript and other web service technologies. The main goal of this project is to provide graphical user interfaces for the four user types including visitor, member, sales person and sales manager. The system provides a contact base ordering system, an account management sub-system, and a powerful accounting sub-system. System handles housekeeping jobs involved with member subscription, account management and member permissions. FWOS' comprehensive customer service also maintains inclusive records including membership purchase history, subscription status and detail order history of each customer. Extra features like real payment system and automate online assistances can be added for future enhancements of the project. Those additions will transform the current project to a more practical web application for online business.
iii

ACKNOWLEDGMENTS I would like to express my special thanks to my advisor Dr. Keith Schubert and the two committee members Dr. Tong Lai Yu and Dr. Ernesto Gomez for their precious comments and support. Their valuable guidelines are essential for the final completion of this project. Also I would like to express my appreciation to the entire faculty of CSUSB Computer Science Department for providing this great academic environment.
Lastly, I want to thank my parents with all my heart It is their love and dedication that encourage me to make this project become possible.
iv

TABLE OF CONTENTS

ABSTRACT .................................................................................................................... iii

ACKNOWLEDGMENTS ....................................................

iv

LIST OF TABLES ..................................................................................................... viii

LIST OF FIGURES .................................................................................................. ix

CHAPTER ONE: SOFTWARE REQUIREMENT SPECIFICATION

1.1 Introduction .................................................................................. 1

1.2 Purpose of this Project ..................................................... 2

1.3 Project Products ....................................................................... 3

1.4 Definition of Term and Abbreviation ..................... 3

1.5 Preliminary Design .................................................................. 4

1.5.1 User Case Diagram .................................................. 4

1.5.2 User Interfaces ........................................................ 7

1.6 Organization of the Project ........................................... 9

CHAPTER TWO: SYSTEM DESIGN

2.1 Product Perspective-............................................................... 11

2.2 Architecture .................................................................................. 11

2.2.1 Client Tier .................................................................. 12

2.2.2 Application Server Tier ................................... 12

2.2.3 Database Server Tier .......................................... 12

2.3 System Interfaces and Constraints ........................... 13

2.3.1 Hardware Interfaces ............................................. 13

2.3.2 Communications Interfaces ............................. 14

2.3.3 Memory Constraint .................................................. 14

2.3.4 Design Constraint .................................................. 14

v

2,4 Database Design ....................................................... .................. 14

2.4.1 Database Scheme Conceptual Model ........... 14

2.4.2 Database Scheme Logical Model .................... 17

CHAPTER THREE: IMPLEMENTATION

3.1 Introduction .................................................................................. 36

3.2 Basic Interface ............................................................................ 36

3.2.1 Food Wholesaler Front Web Site ................ 3 6

3.2.2 Food Wholesaler Member Ordering System .................................. ............................................................... 42

3.2.3 Sale Manager and Staff Support System

......................................................................

53

CHAPTER FOUR VERIFICATION AND VALIDATION

4.1 Introduction .......................................

68

4.2 Unit Test Plan ............................................................................. 68

4.3 Integration Test Plan .......................................................... 73

4.4 System Test Plan .......................................................

76

CHAPTER FIVE MAINTENANCE MANUAL

5.1 Section Overview ....................................................................... 77

5.2 Maintenance Plan ....................................................................... 77

5.2.1 Hourly Maintenance ................................................ 78

5.2.2 Daily Maintenance .................................................. 78

5.2.3 Weekly Maintenance ................................................ 78

5.2.4 Monthly Maintenance ............................................. 78

5.3 System Installation .............................................................. 79

5.4 Back Up and Restore ............................. .................................. 79

vi

CHAPTER SIX CONCLUSION AND FUTURE DIRECTION 6.1- Conclusion ....................................................................................... 81 6.2 Future Enhancements ................................................................ 82
REFERENCES ............................................................................................................... 83
vii

LIST OF TABLES Table 1. Customer Table ............................................................................ 17 Table 2. Customer Contract Products Table .............................. 22 Table 3. Customer Temp Products Table ........................................ 23 Table 4. Customer Payments Table ..................................................... 24 Table 5. Main Categories Table .......................................................... 25 Table 6. Sub Categories Table ............................................................. 2 6 Table 7. Products Table ............................................................................. 27 Table 8. Sale Orders Table ..................................................................... 2 9 Table 9. Sale Items Table ....................................................................... 31 Table 10. Users Table .................................................................................. 33 Table 11. Warehouses Table ..................................................................... 35 Table 12. Unit Test Results (Visitor) ......................................... 69 Table 13. Unit Test Results (Member) ............................................ 70 Table 14. Unit Test Results (Sale Manager/ Salesman)
.................................................................................................................. 72 Table 15. Integration Test Results ................................................. 73 Table 16. System Test Results .............................................................. 76
viii

Preparing to load PDF file. please wait...

0 of 0
100%
Food Wholesale Ordering System