Myanma Computer Co.Ltd., Yangon Course: COMP1181 B.Sc Top Up Programme Date: 2013 Nov
Title: Cosmetic wholesale and delivery management system A dissertation submitted in partial fulfillment of the requirements for the University of Greenwich’s Bachelor of
Science Degree in Business Information Technology
Student ID: Student Name: Word Count: Supervisor:
789976 ThanDar Zin 15,596 U SANN LWIN
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Statement and Confirmation of Own Work Program/Qualification name:
Each NCC Education assessed assignment submitted by you must have this statement attached to the assignment as the cover page or it will not be accepted for marking. Please ensure that this statement is either firmly attached to the cover of the assignment or electronically inserted into the front of the assignment. Student Declaration
I have read and understood NCC Education’s Policy on Academic Dishonesty and Plagiarism. I can confirm the following details: Student ID/Registration number
:
789976
Name
:
ThanDar Zin
Centre Name
:
Yatanarpon MCC
Module Name
:
Project
Module Leader
:
U SANN LWIN
Number of words
:
15,499
I confirm that this is my own work and that I have not plagiarized any part of it. I have also noted the assessment criteria and pass mark for assignments. Due Date Student Signature Submitted Date
ThanDar Zin
Page 2
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Abstract The title of my project is ' Cosmetic wholesale and delivery management system '. The benefits of this system are that it can make customers easily know the new information of cosmetics and easily buy product via network. Customers can choose the products with branch, type or anything that they want to buy. This system supports staff registration, customer registration, supplier registration and product registration. And it also records the delivery information and customer can ask for in system complaint page. Whenever customers need to know the information about invoice, how many times they buy cosmetic or other information, this system supports production of reports to customers and manager. It makes this system so easy to use. In this system, “Dynamic System Development Methodology (DSDM)" is used for the development. A system can be analyzed and designed in this way. “Dynamic System Development Methodology (DSDM)” is the best choice for this system. And also we used Microsoft Visual Studio 2008 for development. In Microsoft Visual Studio 2008, we use ASP.Net to develop the website of this system, with Visual Basic (VB.Net). It uses several languages. The method of storing database for this system is using SQL Server. It is the best choice for database. It is popular software and it can back up all important databases.
ThanDar Zin
Page 3
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Acknowledgement First of all I want to thank my project supervisor U SANN LWIN. He let me see how to think, how to draw diagram and how to use our knowledge to do project. He let me understand how to use learned knowledge effectively. Secondly, I want to thank my class tutor, because she is very tired for give our good study. And I want to thank my best school MCC; because of there, we have the best place to attend the best course and listens the best teachers taught. Finally, I want to thank NCC education, because they give me the good chance for our future, I will do everything for the best.
ThanDar Zin
Page 4
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Table of Contents Abstract ......................................................................................................................................................... 3 Acknowledgement ........................................................................................................................................ 4 Chapter (1) .................................................................................................................................................. 11 Overview of the system .............................................................................................................................. 11 1.1
Background of the system ........................................................................................................... 12 Organization ............................................................................................................................ 13
1.1.1
1.2 Current system ............................................................................................................................ 14 1.2.1Problem with existing system..................................................................................................... 14 1.3
Proposed system .......................................................................................................................... 15
1.4
Aim of the proposed system........................................................................................................ 17
1.5
Objective of the proposed system............................................................................................... 17
1.6
Required Resources .................................................................................................................... 18
1.7
Feasibility study report................................................................................................................ 18
1.7.1
Feasibility study .................................................................................................................. 18
1.7.2 Technical Feasibility .................................................................................................................. 18 1.7.3 Economical Feasibility............................................................................................................... 18 1.7.4 Operational Feasibility............................................................................................................... 19 1.8 Initial JAD Workshop Results .......................................................................................................... 19 1.8.1Problems with the old system..................................................................................................... 19 1.8.2Improvements in new system...................................................................................................... 20 Simple of Daily sales report ................................................................................................................ 22 Simple of Weekly customer order status report.................................................................................. 22 Simple of Monthly the best sales cosmetic report.............................................................................. 23 Simple of Product status List .............................................................................................................. 23 Chapter (2) .................................................................................................................................................. 24 Literature Review ........................................................................................................................................ 24 2. Literature review ................................................................................................................................. 25 2.1 Similar website .................................................................................................................................. 25 2.1.1 Website information................................................................................................................... 26 Chapter (3) .................................................................................................................................................. 27 System Development Approach.................................................................................................................. 27
ThanDar Zin
Page 5
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
3 System Development Life Cycle Model.................................................................................................. 28 3.1 Waterfall Model ................................................................................................................................ 28 3.1.1. Advantages of Waterfall Model................................................................................................ 29 3.1.2. Disadvantages of Waterfall Model............................................................................................ 29 3.2 Rapid Application Development (RAD)........................................................................................... 29 3.3 Dynamic Systems Development Method (DSDM)............................................................................... 30 3.3.1 Reason for choosing DSDM.......................................................................................................... 31 3.4 System Development Methodology...................................................................................................... 31 3.5 Object oriented system development methodology.......................................................................... 32 3.6. Structured Systems Analysis and Design Methodology (SSADM) ................................................... 32 ...................................... 33 3.6.1 Reason for choosing object oriented system development methodology
Chapter (4) .................................................................................................................................................. 34 System Design ............................................................................................................................................ 34 4.1. Use Case Diagram ............................................................................................................................ 35 4.2. Class Diagram .................................................................................................................................. 36 4.3. Robustness Diagram ........................................................................................................................ 37 4.4. Sequence Diagram ........................................................................................................................... 38 4.5. Activity Diagram ............................................................................................................................. 39 4.6. State machine ................................................................................................................................... 40 Chapter (5) .................................................................................................................................................. 41 Software Development Platform................................................................................................................. 41 5.1. ASP.NET ......................................................................................................................................... 42 5.2. PHP .................................................................................................................................................. 42 5.3. Reasons for choosing ASP.NET...................................................................................................... 42 5.4. Microsoft Visual Studio 2008 .......................................................................................................... 43 5.5. Java .................................................................................................................................................. 43 5.6. Reasons for choosing Microsoft Visual Studio 2008....................................................................... 44 5.7. Choice of Database Management System (DBMS)......................................................................... 44 Chapter (6) .................................................................................................................................................. 45 Fact Finding Methods ................................................................................................................................. 45 6.1. Fact Finding ..................................................................................................................................... 46 6.1.1. Reason for choosing interview and workshop.......................................................................... 48
ThanDar Zin
Page 6
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Chapter (7) .................................................................................................................................................. 49 System Security .......................................................................................................................................... 49 7.1. Database Security ............................................................................................................................. 50 7.2. Network Security ............................................................................................................................. 50 7.2.1. How the system is maintained for security................................................................................... 51 Chapter (8) .................................................................................................................................................. 52 Database Design and Specification............................................................................................................. 52 8.1. Database Design ............................................................................................................................... 53 8.1. Create Supplier table .................................................................................................................... 53 8.2. Insert Data to Supplier ................................................................................................................. 53 Chapter (10) ................................................................................................................................................ 54 Testing ........................................................................................................................................................ 54 Black Box Testing ................................................................................................................................... 55 White Box Testing .................................................................................................................................. 55 Unit Testing ............................................................................................................................................ 55 System Testing ........................................................................................................................................ 55 Testing procedure for the system........................................................................................................ 56 10.1. Test Plan ..................................................................................................................................... 57 10.2. Test Case .................................................................................................................................... 58 Chapter (11) ................................................................................................................................................ 59 Critical Appraisal ........................................................................................................................................ 59 Conclusion .................................................................................................................................................. 63 Reference .................................................................................................................................................... 64 Appendices .................................................................................................................................................. 65 A1. Project Proposal ............................................................................................................................... 66 A2. Use Case Diagrams and Description................................................................................................ 69 Detailed Use Case Diagram ................................................................................................................ 69 Customer registration process............................................................................................................. 70 Make order process ............................................................................................................................. 71 Produce invoice process ...................................................................................................................... 72 Complaint ............................................................................................................................................ 72 Produce report ..................................................................................................................................... 73
ThanDar Zin
Page 7
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Use Case Description .......................................................................................................................... 74 Create new product process ................................................................................................................ 74 Customer registration process............................................................................................................. 75 Make order process ............................................................................................................................. 76 Produce invoice process ...................................................................................................................... 77 A3. Class Diagram .................................................................................................................................. 78 A4. Robustness Diagram ........................................................................................................................ 79 Customer register process ................................................................................................................... 79 Create product ..................................................................................................................................... 80 Make order process ............................................................................................................................. 81 Produce invoice process ...................................................................................................................... 82 A5. Sequence Diagram ........................................................................................................................... 83 Customer register process ................................................................................................................... 84 Create product process ........................................................................................................................ 84 Make order process ............................................................................................................................. 85 Produce invoice process ...................................................................................................................... 85 A6. Activity Diagram .............................................................................................................................. 86 Customer register process ................................................................................................................... 86 Create product process ........................................................................................................................ 86 Make Order process ............................................................................................................................ 87 Produce invoice process ...................................................................................................................... 88 A7. State machine ................................................................................................................................... 89 Customer register process ................................................................................................................... 89 Create product process ........................................................................................................................ 89 Make Order process ............................................................................................................................ 90 Produce invoice process ...................................................................................................................... 91 ........................................... 92 A8. Requirements Catalog (Functional and Non-functional requirements)
Create Staff ......................................................................................................................................... 92 Purchase order ..................................................................................................................................... 93 Create product ..................................................................................................................................... 93 Create new customer ........................................................................................................................... 94 Make order .......................................................................................................................................... 96
ThanDar Zin
Page 8
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Produce invoice ................................................................................................................................... 96 Complaint ............................................................................................................................................ 97 Produce report ..................................................................................................................................... 97 Non-functional requirement catalog ................................................................................................... 98 A9. Report form ...................................................................................................................................... 99 Simple of Daily sales report ................................................................................................................ 99 Simple of Weekly customer order status report .................................................................................. 99 Simple of Monthly the best sales cosmetic report............................................................................ 100 Simple of Product status List ............................................................................................................ 100 A10. Interview Log ............................................................................................................................... 101 A11. Database Design and specification............................................................................................... 103 11.1.1. Supplier ................................................................................................................................. 103 11.1.2. Department ............................................................................................................................ 103 11.1.3. Manager ................................................................................................................................ 103 11.1.4. Staff ....................................................................................................................................... 104 11.1.5. Product Type ......................................................................................................................... 104 11.1.6. Product .................................................................................................................................. 104 11.1.7. Customer ............................................................................................................................... 105 11.1.8. Order Detail .......................................................................................................................... 105 11.1.9. Order ..................................................................................................................................... 105 11.1.10. Delivery ............................................................................................................................... 106 11.1.11. Invoice ................................................................................................................................. 106 11.1.12. Complaint ............................................................................................................................ 106 11.2. Insert Data .................................................................................................................................... 107 11.2.1. Insert Data to Supplier .......................................................................................................... 107 11.2.2. Insert data to Department...................................................................................................... 107 11.2.3. Insert Data to Manager.......................................................................................................... 108 11.2.4. Insert Data to Staff ................................................................................................................ 108 11.2.5. Insert Data to Product Type .................................................................................................. 109 11.2.6. Insert Data to Product ........................................................................................................... 109 11.2.7. Insert Data to Customer ........................................................................................................ 110 11.2.8. Insert Data to Order Detail .................................................................................................... 110
ThanDar Zin
Page 9
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
11.2.9. Insert Data to Order............................................................................................................... 111 11.2.10. Insert data to Delivery......................................................................................................... 111 11.2.11. Insert Data to Invoice .......................................................................................................... 112 11.2.12. Insert Data to Complaint..................................................................................................... 112 11.3. Produce Report with Database..................................................................................................... 113 11.3.1. Daily Sales report .................................................................................................................. 113 ..................................................................................... 113 11.3.2. Weekly customer order status report
11.3.3. Monthly the best sales cosmetic report................................................................................. 114 11.3.4. Product status list .................................................................................................................. 114 A12. Test Case ...................................................................................................................................... 115 A13. Operation Manual ........................................................................................................................ 121 13.1. Site Map for customer .............................................................................................................. 121 13.2. Site Map for Staff ..................................................................................................................... 132 13.3. Site Map for Manager .............................................................................................................. 144 A14. Implementation ............................................................................................................................ 154 Publish website ................................................................................................................................. 154 Backup .............................................................................................................................................. 157 Restore .............................................................................................................................................. 160 Hardware requirement....................................................................................................................... 163 Software requirement ........................................................................................................................ 163 A15. Project schedule ........................................................................................................................... 164 A16. Project plan and performance....................................................................................................... 166 A17. Bibliography ...................................................................................................................................... 167
ThanDar Zin
Page 10
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Chapter (1)
Overview of the system
ThanDar Zin
Page 11
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
1.1 Background of the system Now the times have been slowly beginning to make progress, network becomes people irreplaceable necessities. Now of the network is more and more convenient, people have started to do business on the Internet. So I want to do this project, Cosmetics whole sale and delivery management system. The cosmetic wholesale and delivery management system is fashionable for modern. There are so many types of cosmetics, from big type distinguish, have the following kinds. Hairdressing cosmetics, Skincare cosmetic’s, Special efficacy cosmetics and Male cosmetics and Children’s cosmetics. Now I want to carefully explain everything the use of cosmetics.
Hairdressing cosmetic – the function of beauty cosmetics, covers the shortage of
face, make it beautiful. Mainly including the foundation, powder kind, rouge, lipstick, mascara, eye shadow, lotion, nails cream, nail polish, etc.
Skincare cosmetics – Skincare cosmetics function is to protect the skin healthy
and prevent skin aging. Can be divided into cold cream, emulsion, mask and SOD cosmetics.
Special efficacy cosmetics – Special efficacy cosmetics main function is skin
beauty, skin disease treatment. Including anti-wrinkle cream, to dispel the spot cream, sunscreen, acne dew, slimming cream, etc.
Male
cosmetics – Mail cosmetics is suitable for men’s physiological
characteristics of cosmetics. Mainly includes the man cream, shaving cream, man hair spray, Eisenhower cologne, etc. Children’s
cosmetics–
is a kind of suitable for children’s physiological
characteristics of cosmetics. Mainly includes children wash hair supplies, children’s soap, children’s skin cream. We specialized in network wholesale cosmetics, such not only with the times, but also more let our customers convenient. Some of it is not convenient to go abroad for cosmetics customers, can through the network and contact us.
ThanDar Zin
Page 12
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
1.1.1 Organization Cosmetic wholesale and delivery management system have many departments. Such as staff department, advertise department, sales department, distribution department and Finance department. Staff department is used to record new sale staff information. Advertise department take charge of make advertise of cosmetic who made the new cosmetic and what the cosmetic is the best choice for customer. Sales department makes information for new customers, registering of details for new products, make records of information for orders and make monthly or yearly individual customer and cosmetic report. The job of distribution department is deliveries the cosmetic who customer have made order and to go to other placed to take the cosmetic when it doesn’t being exist. Department of finance put out invoice and get paid, and receive all payment when the delivery is finished and check what the customer need to give payment in deadline.
ThanDar Zin
Page 13
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
1.2 Current system 1.2.1Problem with existing system
At present, the system is not changed into a computerized one yet. Every department has its system for product or customer and data for order and producing invoice. But they did not carry out the productivity in the whole process. The present system may be costly for using many papers and when papers damage it can easily lose data of customer and product. When need to retrieve data, it is so difficulty. It will need more places to store papers for data information and need more time to record product and customer data. The security is bad difficulty to hide recorded information for customer. And one of the more important is the existing system does not have internet service, it can make can only purchase products and made order via telephone or customer need to come here. And difficulty to received product invoice. It is not suitable for customers who are short of time and want to do shopping quickly and efficiently.
It is
problematic for people who need sales service and get the products.
ThanDar Zin
Page 14
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
1.3 Proposed system This proposed system is a based computer application system which include database for data storing, modifying, deleting and retrieving customer information. By using Internet, customer can easily contact us and make order in online. And using database to easily store customer data, supplier data, and products data and produce report. The general outline of the new cosmetic wholesale and delivery management system are that include many functions and provide more service. It will register the staff details information and purchase order from supplier with online and record product details information and register customer details information. It will give customer consulting service for about the product and allow customer search product by trademark, type and prices. It will record product order details for customer and produce invoice. After produce invoice, it will give delivery command and check that delivery product received or not. And then receive payment from customer and solve complaint in online and produce report. The main functions of the system are:
To register staff information
To register supplier and purchase order from supplier
To record product information To register customer information
Give customer consulting service
Allow searched product by branch, type and prices
To record order information
To give delivery service
To produce invoice
To check feedback when receive product
To easily solve complaint with customer or supplier
Data entry includes
Register staff details information Register supplier information
Record purchase order for product type
ThanDar Zin
Page 15
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Record product details information
Register customer details information
Record order information
Record invoice information
Record delivery information
Record department of the staff
Record complaint information
Enquiry includes:
Give consulting service
Allow searched product by trademark, type
Updating includes:
Product information
Staff information
Customer information
Supplier information
Order information
Produce report includes:
Daily sales report
Weekly customer order status report
Monthly the best sales cosmetic report
Product status List
ThanDar Zin
Page 16
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
1.4 Aim of the proposed system We are doing all information by computerized and online system. Our purpose is to let more people can use the web, on the network pre-order our cosmetics. Need not specially run to a certain place to buy. And if there are any new goods, also can be in the first time know and exercise.
1.5 Objective of the proposed system
To assessment the web-based cosmetic shop structure, how web-based cosmetic shop can help the current cosmetics shop structure with the benefit of new features. Activities: Read literature and study business and entertainment journals and periodicals. Deliverables: Section report with literature review
To secure and protect the online cosmetics wholesale and delivery system from hacker, safety methods are investigation and choice some of suitable methods. Activities: Read literature and study how to keep the system from hacker, viruses. Study
books concerning about safety and threats. What kind of threats can attack? Deliverables: Enterprise Network
To improve the online cosmetic wholesale and delivery management system to meet the business requests, study Lifecycle methodologies and select one. And study development approaches. Activities: Analyses the information gathered. To drafts a requirement specification. Study
lifecycles and development approaches on books and Internet. And choose appropriate methods to improve the system. Deliverables: Requests specification. Reason for methods selected. System Analysis and
Design chapter (4, 5, 6, 7)
To design and implement the online systems, with the completely maintained background database structure. Activities: Investigate the collected information from the appropriate sources, design and
implement the online cosmetic database supported wholesale and delivery management system.
ThanDar Zin
Page 17
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Deliverables: Justification for selected programming language and database.
1.6 Required Resources
A minimum Microsoft Windows 7 Home Edition.
Microsoft Visual Studio 2008 for the application of the system.
Microsoft SQL Server 2008 or 2005 for database support and implementation.
Microsoft Office word for documenting purpose and prepare the reports.
Use to the database Use to the Internet
1.7 Feasibility study report 1.7.1
Feasibility study
In doing a feasibility study, the present situation is studied and the needs are analyzed. It can also decide if the cost for doing the project is just right. Observation can be carried out to find out these facts. Also very useful is the interview method, which can be done for a short duration. These are done so that observation can be carried out quickly on the requirements of the study. There are three aspects of this study: these are Technical feasibility, Economic feasibility and Operational feasibility. 1.7.2 Technical Feasibility
In this part of the study, a technical aspect of the system is studied. It is also important to think about whether it is technically suitable to be carried out. Unless there is enough technical feasibility, there is a possibility that the project may not be successful. Some of the ways to conduct this study are object oriented system analysis and design methodology. 1.7.3 Economical Feasibility Evaluation of cost/benefit by means of economic analysis is one of the first steps of
economic feasibility. Any new system requires cost without which it is impossible to do any project. There are two types of cost: development and operating cost. Without a careful study of the economic aspect, it will be impossible to carry out an effective project.
ThanDar Zin
Page 18
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
A rough estimate of cost will enable one to determine the time frame and the cost are sufficient to complete the project. Schedules for timeframe and managing one's staff so that they can complete the task within the time frame are part of the job. 1.7.4 Operational Feasibility
To be feasible operationally, solutions of problems is necessary to fulfill the needs during the requirement analysis. A clear understanding of operational feasibility is a prerequisite for identifying the needs of the users. It is important to know that the system is reliable and how dependable it is. Customer information can be saved for such a purpose.
1.8 Initial JAD Workshop Results 1.8.1Problems with the old system
At present, the system is not changed into a computerized one yet. Every department has its system for product or customer and data for order and producing invoice. But they did not carry out the productivity in the whole process. The present system may be costly for using many papers and when papers damage it can easily lose data of customer and product. When need to retrieve data, it is so difficulty. It will need more places to store papers for data information and need more time to record product and customer data. The security is bad difficulty to hide recorded information for customer. And one of the more important is the existing system does not have internet service, it can make can only purchase products and made order via telephone or customer need to come here. And difficulty to received product invoice. It is not suitable for customers who are short of time and want to do shopping quickly and efficiently.
It is
problematic for people who need sales service and get the products.
ThanDar Zin
Page 19
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
1.8.2Improvements in new system
Improvements system is a based computer application system which include database for data storing, modifying, deleting and retrieving student information. By using Internet, customer can easily contact us and make order in online. And using database to easily store customer data, supplier data, and products data and produce report. The general outline of the new cosmetic wholesale and delivery management system are that include many functions and provide more service. It will register the staff details information and purchase order from supplier with online and record product details information and register customer details information. It will give customer consulting service for about the product and allow customer search product by trademark, type and prices. It will record product order details for customer and produce invoice. After produce invoice, it will give delivery command and check that delivery product received or not. And then receive payment from customer and solve complaint in online and produce report. The main functions of the system are:
To register staff information
To register supplier and purchase order from supplier
To record product information To register customer information
Give customer consulting service
Allow searched product by branch, type and prices
To record order information
To give delivery service
To produce invoice
To check feedback when receive product
To easily solve complaint with customer or supplier
Data entry includes
Register staff details information
Register supplier information
Record purchase order for product type
ThanDar Zin
Page 20
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Record product details information
Register customer details information
Record order information
Record invoice information
Record delivery information
Record department of the staff
Record complaint information
Enquiry includes:
Give consulting service
Allow searched product by trademark, type and prices
Updating includes:
Product information
Staff information
Customer information
Supplier information
Order information
Produce report includes:
Daily sales report
Weekly customer order status report
Monthly the best sales cosmetic report
Product status List
ThanDar Zin
Page 21
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Simple of Daily sales report
Daily sale report Date:----/-----/----TypeName
Product_ID
Product_Name
total_sold
Amount
Simple of Weekly customer order status report
Weekly customer order status report Report Date:----/----/----
For the week date-------------to-------------
Customer_Name Order_No total_amount
ThanDar Zin
Order_Date
invoice_Date
Paid_Date
Delivery_Date
Page 22
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Simple of Monthly the best sales cosmetic report
Monthly the best sales cosmetic report From Date:----/-----/----PT_ID
To Date:----/-----/-----
Product_ID
Product_Name
total_sold
Amount
Simple of Product status List
Product status List ProductTypeID:-----------Product_ID
ThanDar Zin
Product_Name
ProductTypeName:------------Price
P_Quantity
Page 23
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Chapter (2) Literature Review
ThanDar Zin
Page 24
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
2. Literature review The title of the project is “Cosmetic Wholesale and Delivery Management System”. Before starting to do this project, I browsed and studied from many websites about my mother's friend Company and also use the resources from other sites to get advice and suggestions on the project. Now I will present the similar website for our system.
2.1 Similar website
Figure 2 Similar Website
ThanDar Zin
Page 25
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
2.1.1 Website information This website Beauty wholesaler is located in Stockport, England. Branded cosmetics and
skincare products are their mainstay to provide for sales for organizations throughout the world. It has:
products with famous brand names available extensively
Customer service is speedy and amicable
The range of colours is wide
a user-friendly online system
Orders can be done systematically and effectively with accounts
Products are delivered quickly at a reasonable price
Customer orders are taken, the site is administered and enhanced and information and confidential and can be known only for the purpose of distribution and sales. The website is “www.wholesale-cosmetics.co.uk/delivery.asp” NOTE: I think this website need consulting services, because when customers want to know effect of product, staff can answer this. And introduce the new product what the effect is good for customer. And when customer want to search product by price, how they search. It is disadvantages of this website.
ThanDar Zin
Page 26
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Chapter (3) System Development Approach
ThanDar Zin
Page 27
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
3 System Development Life Cycle Model 3.1 Waterfall Model 1
By using this model, software development is done extensively. It is user-friendly since
it has simple configuration and is easy to understand. The six phases of this model are requirements analysis and specification, analysis, design, code and test and implement and maintenance are included. The phases work one after another, the second stage not starting until the first one is finished. A big chunk is broken down into manageable parts so that an easy control is possible. Once it gets started, it cannot stop. There is repetition of some parts but we cannot roll back and get to a prior point once it starts. It does not tolerate any error. When there is an error in the implementation phase, the whole project has to be started all over again. It is not adaptive to changes.
1
http://www.rivulets.in/blog/project-management/waterfall-model-software-methodology/
ThanDar Zin
Page 28
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
3.1.1. Advantages of Waterfall Model 2 Good for small and mid-sized projects since it is linear.
Paperwork is preferred unlike new models for easy tracking of the project
Small resource required in comparison with new and modern methods.
Requires documents at every stage. As a result it is easy to know the system design and implementation.
Easy to see tasks for carrying out and completing each phase. Good for a specific time frame and schedule.
3.1.2. Disadvantages of Waterfall Model
The linear nature of the model means that another phase cannot be started unless the first one is finished. Any error will stop its progress and will have to start from the beginning all over again.
No change of feature is allowed and if it is required by the user, a lot of issues can arise.
Clear identification of requirements is needed before starting the project.
Phases lack flexibility during the progress of the project
3.2 Rapid Application Development (RAD) 3
This method combines methodologies, good staffs with the best training and experience,
and management with is very effective. It is done both manually and by computers. Only a short time is required to develop good software. Some of the features required for this method are:
2 3
Prototyping and verification designs
Minimizing the effort of reviewing, testing and other such teps.
Software essentials restructuring
Integrating all changes in the current model
www.waterfall-model.com System Development Page(3-22)
ThanDar Zin
Page 29
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
3.3 Dynamic Systems Development Method (DSDM) This method is an extension of the RAD. Its advantage is that it can be used in object oriented approach. This method can function within the constraints of schedule and budgets. The phases included in this method are Feasibility study, Functional model iteration, Business study, Design and implementation and build iteration. During the first phase, problems are identified and cost and technical feasibility are chosen so that these problems can be solved. Functions are to be identified next. In the functional model iteration phase, iterative prototyping is used for description. Design and build iteration are done for nonfunctional purpose. Documentation and user training in the use of the system are the parts of the implementation stage. Some aspects of this system include the prototype for develop, iterative and incremental development. The first method is used when it is difficult to get exact information. Only getting proper feedback can help build a complete profile and database. Evolutionary and throwaway does not serve as the final solution. System requirements are only to be verified. Mature system passing through prototype iterations series is the aim. In doing Iterative development, smaller components are made of the whole project for easier management. Inception, elaboration, construction, and transition are the four phases. One of the important aspects of this phase is time boxing. This is done to reduce the amount of time required. The system can be developed in a small series. It can also be developed as implementable sub units of the system. There is a specific time during which the project can be delivered.
ThanDar Zin
Page 30
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
3.3.1 Reason for choosing DSDM The choice of DSDM for system developments is due to the following benefits and advantages: This model cannot function without the role of users. Users' participation can find omit the right requirements and suitable solutions for business. A large amount of work is to be finished within a short time. Products are also to be delivered fast. This model is not time consuming. Incremental and iterative development is done for the right solution. Errors are reduced to a minimum by means of testing during the life cycle. Moscow prioritization can help identify which is to be done first and which next. High quality information can also be got from workshops. It is chosen for on time delivery of the good quality products, within budget.
3.4 System Development Methodology 4
The most common system development phases are:
Planning
Analysis
Design
Implementation
Deployment and Maintenance
Planning –existing problem is understood along with its scope, the reason for building a new
system and definition of its requirements. Feasibility studies are required to do this. Analysis – analysis and identification of the issue and its scope. Even after implementation and
deployment, there can be problems. After finding out the problems, facts for newer stages can be gathered. Design – deliverables from previous stages are used to design. Processes in the operation of
the system, data, hardware and network setup and design of user interfaces are included in it. Design of the system and environment are also considered. 4
www.slepi.net/blog/system-development/system-development-life-cycle-sdlc-methodologies.html
ThanDar Zin
Page 31
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Implementation – This takes the largest amount of time in the lifecycle. Resources and
activities including testing and training are part of this phase. Deployment and maintenance
– hardware and software installation are part of the phase.
There are only end-users to maintain the system with no further involvement of developers.
3.5 Object oriented system development methodology 5
OOADM has a function that is to focus on the opposite when creating stable project data.
This method can be divided into three stages:
Describe the problem of Analysis domain
The overall structure of the design system
To refine the object structure
The static structure of the object and class, object and function structure of dynamic behavior, from the three different aspects to describe the problem domain, you can know this methodology provides technology is objective, is accurate. OOADM has formal justice foundation, is based on the uniform. System's logical structure and physical structure of the system can be in the problem domain modeling OOADM form two different angles. OOADM describe various techniques to complete the static and dynamic semantic model for Angle, and it also provides a set of perfect graphic symbol.
3.6. Structured Systems Analysis and Design Methodology (SSADM) 6
SSADM is a very comprehensive method of the system. It defines the life cycle analysis
and design aspects of the module and phase. All kinds of technology including the symbols used for Jackson's favorite entity life histories, data modeling is founded on entity relation data flow modeling and data standardization methods. In addition, SSADM need three interrelated view information:
Logical Data Model - display storage and data correlation.
Data Flow Model - display system is how to accept data transfer.
5 6
Entity Life Histories - display the data changes life
http://www.dba-oracle.com/t_object_oriented_approach.html System Development page(4-14)
ThanDar Zin
Page 32
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Traditional analysis and design method to the SSADM is one of the most highly developed. In the traditional sense, this is a hypothetical general analysis and design of the lifecycle. This is a good method of free and public records.
3.6.1 Reason for choosing object oriented system development methodology 7
Object-Oriented System Analysis and Development Methodology is modern software
entrepreneurs widely adopted an effective technology. OOAD is need to design as much as possible close to the real world, namely the expression entity in the most natural way. And technology advantage is hoping to build model corresponding to the real world problem, and maintain their structure, relationships, and behavior patterns. Firstly OOAD developers that can be help us to understand the function of the whole system. Object-oriented programming is an understandable to make software development and maintenance more simple method. This concept will help us to analyze and understand the complicated directly. The second OOAD can guide us in correct thinking when writing code. When doing the OOAD, all function’s involved in the system, detailed list in the requirements specification. We can accord it to write the code. And OOAD is lead us to the correct way of thinking, because if we don't have to do according to the requirement of the OOAD, we must go detour, way of thinking is not correct, but after we did the OOAD, as long as we do a filter can be instead of a series of repeated logic code. The third OOAD is an important mark for the system to see if there is life. System refers to the life there is the function of the system to extend or change. In software engineering are often met to modify system function or adding features. But it looks although it is very difficult, like going to work to do it again, but if there is a good overall OOAD process, as long as we in the code to add or modify a piece of code to complete the task.
7
http://tech.hexun.com/2009-06-16/118656468.html
ThanDar Zin
Page 33
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Chapter (4) System Design
ThanDar Zin
Page 34
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
4.1. Use Case Diagram
Cosmetic Wholesale and Delivery Management System Register new staff info
Send purchase order
Supplier
Record new product info
Staff
Register new customer info
Give consulting service and allow searched product
Make order
Customer
Produce invoice
Manager Check feedback
Compliant
Produce report
Figure 4.1 use case diagram
ThanDar Zin
Page 35
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
4.2. Class Diagram
- Supplier_ID: String - Supplier_Name: String - Supplier_Address: String 1…* - Supplier_Email: String - Supplier_PhoneNo:String
OrderDetail - Order_ID: String - Product_ID: String - Sold_Quantity: Integer
Product Type
Product
Supplier
- Product_ID: String - PT_ID: String 1…* - Supplier_ID: String - Product_Name: String - P_Quantity: Integer - Price: Integer + is created() 1…* + is updated() + is deleted() + is searched()
1…* 1
+ is created() + is updated() + is deleted()
1…*
Customer
Order 1 - Order_ID: String - Customer_ID: String - Staff_ID: String 1 - Order_Date: Date - Delivery_Date: Date
1…* bought
- Delivery_ID:String - Invoice_No: String - Order_ID: String - Address: String - Finished: String + is created() + is updated() + is deleted()
0…*
1…*
1 1
1 1…*
Invoice
1
- invoice_No: String - Order_ID: String - Customer_ID: String - invoice_Date: Date 1 - Paid_Date: Date
Staff - Staff_ID: String - Staff_Name: String - NRC_number: String
0…*
-- Address: String Phone_number:String - Email: String
Complaint
- Complaint_ID: String - Supplier_ID: String - Customer_ID: String - Staff_ID: String - Manager_ID: String - Complaint_info: String
- Customer_ID: String - Customer_Name: String - NRC_Number: String - Password: String - Address: String 1 - Phone_number: String - Email: String 1 + create order() + is saved() + is edited() + receive invoice()
+ is created() + is updated() + is deleted()
Delivery
1…* - PT_ID: String - TypeName: String
1 0…*
+ insert product info() + Update product info() + Delete product info() + produce invoice() + Produce report()
1
1…*
- Amount: Money + is created() 1 + is updated() + is deleted()
Department 1 - Dept_ID: String - Dept_Name: String - Manager_ID: String - Staff_ID: String 1…*
+ Accept complaint() + Solve complaint() 0…*
Manager - Manager_ID: String - Manager_Name:String 1 - NRC_number:String - Address:String - Phone_number:String - Email:String
Made by
1
+ is inserted() + is Updated() + is Deleted()
+ insert staff info() + Delete staff info() + Solve complaint() + Produce report()
Figure 4.2 Class Diagram
ThanDar Zin
Page 36
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
4.3. Robustness Diagram
Home page
Load customer Login page
Click Login link
Customer
Customer Login page
Enter username & password
Read customer data
SubmitButton
Customer personal page
Checkvalid
Click add to Cart Button
Load Order page
Read product info Order page
Submit Button
OrderDetail
Fill order info
Delivery
Check order
Show customer order page
Order
Figure 1.3 Robustness diagrams for make order
ThanDar Zin
Page 37
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
4.4. Sequence Diagram
Home Page: register Customer Staff
Cosmetic product
Consulting service
Customer: Page
Report
Manager
Search product and branch type
Login or register new info Confirm account
Add to cart
Can chat with our staff to known about new cosmetic information and effective Confirm the answer that the question from customer Make order for cosmetic and give delivery info Confirm order Sent message to customer for the delivery i nformation Accept message Produce invoice Check customer feedback and does customer receive product Confirm feedback Receiver invoice Give payment Receive payment Confirm payment receive Make complaint when product is out of date or other Solve complaint Produce report Check report
Figure 4.4 Sequence diagram for system
Please see the rest of the diagram inA5. Sequence Diagram
ThanDar Zin
Page 38
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
4.5. Activity Diagram
Search product
Login or register
No [When user name or password incorrect] Yes
Add to cart
Make order No [When the product is out of stock or cancel] Yes
Fill order info
Submit order
Check order [complete]
Figure 4.5 Activity Diagram for make order
Please see the rest of the diagram inA6. Activity Diagram
ThanDar Zin
Page 39
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
4.6. State machine If new customer
Add to cart
Register
Login
If have account customer
Check user name and password If pass
Made order
If fail
Fill order info
Check order Complete
Figure 4.6 State machine for make order
Please see the rest of the diagram inA7. State machine
ThanDar Zin
Page 40
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Chapter (5) Software Development Platform
ThanDar Zin
Page 41
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
5.1. ASP.NET 8
ASP.NET is a web development model of modern often use, including the need to
develop a web services business applications, which can use less code to write. ASP.Net is part of the network framework, and is the frame of coding applications which can access types. ASP.Net runs on a web server, allowing web developers to build dynamic web pages. The Designers can use any semantic, which includes Microsoft Visual Basic and c#, which are the allowed development agents of ASP. But when benefit of the network applications from the common language runtime, to ensure the safety of the type.
5.2. PHP 9
PHP is a multi-platform server: with HTML embedded scripting language, run
developers to create dynamic, static or film and television class web page. When enabled PHP web page, can be stored as the HTML page, you can also create and edit as normal HTML document. It is mainly focused on the PHP script on the server, so developers can do any other CGI program, such as collect form data, generate dynamic page content, or send and receive cookies. And you can use PHP and MySQL programming language. Scripting, writing desktop application and scripting is the server side of the three main point area for used PHP scripts.
5.3. Reasons for choosing ASP.NET Era of progress slowly, the demand of the market is more and more broad, so Microsoft created ASP.Net, ASP.Net to develop dynamic web pages and web applications. As a kind of special features of ASP.Net, is a very valuable tool, you can use to develop the web pages, and developing the rich site, is a kind of web-based applications. .Net is not confined to the ASP, like Java, VB.Net, and c #, and so on, these popular programming languages developers are free to use. Microsoft Visual Studio is a software development, application; web developers can be based on the ASP application under simple to create a Visual Studio, Window Web server for ASP.Net and the basis of the application, so ASP.Net is a perfect server-side scripting technology. ASP.Net has a lot of advantages, compared to some platforms in the construction of applications on the web. The benefit of using 8 9
http://www.itegritygroup.com/asp-net-advantages/ http://www.java-samples.com/showtutorial.php?tutorialid=973
ThanDar Zin
Page 42
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
this is it has its server for the Windows and tools for building programs. ASP.Net can more easily create, debug, and deploy Web applications. Because all task ’-s are performed in a single development environment.
5.4. Microsoft Visual Studio 2008 10
Visual Basic is the most widely used computer programming software for of the system
development. , and also can be said to be in the history of programming software is undoubtedly the most widely used software. When initially created using Visual Basic, it is very easy to write programs in the Windows PC operating system. This is a computer program system development. VB.Net is like other language programming technologies. In fact, the latest generation of the program use version, has become a C #.net C programming language, it is almost the same language written in VB.Net, but the only difference is that now the programmer. Great basic application window, build web applications, can shorten the placement, great, flexible access and to simplify the data, by means of platform access, the entire object oriented structure of XML web services, mobile applications and COM interoperability. Above all is the use of the VB.Net to create.
5.5. Java 11
in the different applications of the computer system to realize the translation in a
specific application in most browsers is especially used on the Internet and the virtual machines. It may be found with in many programming languages, which makes it convenient to run on your computer to create or interpret. This is one of the most frequently used Java applications, because the Java programming language is unusual, and it can easily be compiled and explanation. Like hot Java browser is a very independent applications. The applications applets are similar, but it is run all alone. But it is easier to support Java browser run, this is not an Applet.
10
11
http://social.msdn.microsoft.com/Forums/en/netfxnetcom/thread/a5c456c8-e432-4b46-b963-3b4559e0a81d
http://www.internet-guide.co.uk/java.html
ThanDar Zin
Page 43
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
5.6. Reasons for choosing Microsoft Visual Studio 2008 Microsoft SQL Server 2008 can provide for multiple users accessing the database at the same time and can store large amounts of data, can say Jane for the storage of customer data in the database. Many websites use SQL server, because it can simplify the installation and deployment process, and contains useful development tools and a management database. But the user must use his own ID used by the server. And can use Microsoft SQL server2008 side by side, because it can reduce the programmer is responsible for handling a large number of files. Database table, query, report forms and modules in an exclusive file, can be said to be a single file, these by embedding all objects are the programmer is responsible for handling the documents. SQL provides the search service, such as familiar to the user information. This is a powerful feature, and it provides powerful search abilities. So if you need to use to a large amount of data, most programmers will choose to use a SQL server because it can be easy to use and to learn for beginner.
5.7. Choice of Database Management System (DBMS) 12
I will choose DBMS because it is a practical operation of storage, maintenance and
application of the system to provide the data of the software system. Are a storage medium, processing object and a set of management system? Unified management by the database management system database insert, modify, and retrieve data are made through the management system. In order to realize rapid access to any part of the data to study many optimization techniques. These optimization techniques are often very complex, and for an ordinary user are difficult to achieve, so they are done by the database management system, and enables the user database language to be simple and easy to use. The operation of the database is done by the database management system, so the database can be independent of a specific application, thus the database can be shared by multiple users. Therefore, the independence of the data and sharing is an important characteristic of database system. Data sharing is to save a large amount of manpower, which laid a foundation for the wide application of the database system. The emergence of the database system enables the ordinary users to easily deposit the daily data in computer and in need of quick access to them, so that the computer migrates out of the scientific research institution into all walks of life, and into the family.
12
http://technet.microsoft.com/en-us/sqlserver/default
ThanDar Zin
Page 44
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Chapter (6) Fact Finding Methods
ThanDar Zin
Page 45
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
6.1. Fact Finding 13
Fact finding when doing research or a project, is a very important process. In order to
get more accurate facts and know the real situation, we only use this method. In fact finding, we can use many methods, thus to find a suitable method to find out the truth of the matter. Analysts need to choose the suitable way to investigate and establish proper schedule, in order to facilitate the find out the truth, have the following methods:
Observation
Record searching
Special-purpose records
Sampling
Questionnaires
Interviewing
Workshops
Observation 14
Formal or informal observation requires two types of observation. Even if they are
different, results can still be useful. We can see a priest or manual operation, through our use of formal observation. Paperwork is made of the priests to operating personnel, such as - fill out the form and writes a report. In the use of manual operation, some physical task is to must do the work. When we are using this method, you can see for the interpretation of the system and user feedback. Also can know through the observation, the system can solve and identify problems. Informal observation can pass all the time to investigate how the user operation. In the process of investigation, each investigation must pay attention to the specific facts of health care. If you want to do this, we need to concentrate. Questionnaires
can be called a special type of document; it uses analysis to collect data, information and a group of people from a certain point of view. It needs to collect views based on facts. The 13 14
http://www.scribd.com/doc/6902721/Fact-Finding-Techniques System Analysis and Design
ThanDar Zin
Page 46
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
questionnaire should not only include personally, for the problem of prejudice and information to production. The questionnaire can be divided into two types. There are the questionnaires with a free format which give people freedom to make any response they want to make. Also, there are questionnaires with a fixed format can be said to be the single choice, multiple choices, scores and rankings Interviewing
The interview is also a way to find out the truth, and many analysts will use this method to find out the facts. This is a very useful method; because we can investigate the levels of users are used directly. Through the interview, we can know the views of the current users of the system. In this way, we can find the related problems and possible solutions. We can also look for what we do interview and environment of the organization. When we interview, we must see that there are three levels of users, their senior management, line management and staff. During the interview, we must pay attention to their respect and their personal space. The interview process should start from top management level. Analysts should seek permission from other employee’s interview. She should know that when there are some problems the correct answer may be found at an appropriate level. Workshop
For joint development and application, has caused the demand of the system, in order to meet the proposed by other factors related to system requirements of the business, you can choose to shop good technology. Because it is a very flexible technology, it may require time constraints and extracting told the requirements. In the workshop, participants can actively participate in; because it can improve quickly understand the project. Developers can also clear description and clearly know the process to produce output and customer demand. The structure of the workshop is to work with in the workshop, such as developers, users and the key is because of the stakeholder needs, and a mechanism and can solve problems and have clear objectives. By doing so, staff working in the workshop, in order to can share their views and contributions to people, so they thought of the system. Because it can easily solve the conflict of the project, and can quickly define the problem, it can also reduce the elapsed time of projects.
ThanDar Zin
Page 47
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
6.1.1. Reason for choosing interview and workshop Interview has many advantages. We can cover all the detailed information that our want to know. And we can test the system how to run and we can meet the company manager. Now I want introduce that the interview of my mother’s friend’s company. When I first went to my mother’s friend’s company, I saw a busy crowd! There have respective events. The divisions of the company there are several kinds of classification.
It has a sales department, planning
department and many other departments. First is the sales department, a group of people to introduce to the guest on the Internet all kinds of products and customers purchase in advance, then customers purchased products sent to the person responsible for delivery and sent on to the customer. As for the planning department, is planning a variety of holidays should be how to better sales each kind of product. The interview log sees in A10. Interview Log "Cosmetic Wholesale and delivery management system" is to use the workshop method to collect information and the demands of the system are discussed. Because using the JAD workshop, it produced despite time constraints, a quality system. Participants can share each other's views, and can provide a system to meet the demand. It can not only save time and money, but also can quickly provide customers with high quality projects for the delivery of products. JAD workshop can be used in any project delivery system during early development, and it is in the DSDM. JAD methods seminars, not only the demand of the system are discussed, and also meet the requirements of the system, so the JAD workshop is very suitable.
ThanDar Zin
Page 48
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Chapter (7) System Security
ThanDar Zin
Page 49
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
7.1. Database Security In the application of data security, protection is given for the database. There can be different kinds of threats. These can be done intentionally or accidentally. All the resources in the organization are stored in the database. Without proper ways and means to control and protect the database, it is risky. Some of the situations that can be encountered in threats to data security are as follows:
Theft and fraud
Damage of confidentially
Damage of privacy
Damage of integrity
Damage of availability
7.2. Network Security 15
It is not enough to provide protection to separate databases. It is also essential to
provide security for the whole network. Hardware and software of the system as well as the means for data protection are part of the network security. Protection is provided so that data cannot be destroyed, changed or leaked. There is no interruption by the network when there is a proper and continuous running of systems. The development of network security begins when the scope becomes larger than single documents. Later comes the development of intranet and extranet for sharing information and process data more extensively. Connectivity of the system is also an important issue. How information is connected, how it flows as well as how much of it flows becomes improved at all time. There should be security at the physical level, network structure, system security, application security and security of network management.
15
http://www.vsharing.com/k/others/2008-1/606897.html
ThanDar Zin
Page 50
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
7.2.1. How the system is maintained for security 16
This network security and database security has been chosen for such protection as the
physical protection, access control, and data encryption. At the physical level, key equipment, rules and regulations of the network are protected.
There should also be a strict network security against physical damages against heat and radiation. In access control, strict certification and control for the sake of user permission. Authentications,
password
encryption,
update,
identify
and
control
network
devices
configuration permissions are part of the access control. In Data encryption, it protects the safety of data. Although information is intercepted, it cannot be read for its meaning. Protection is provided against computer network virus, network antivirus system installation. For multi-user environment, the following controls based on computer are used:
Permission
Integrity
Access controls
Backup and Recovery
Opinions
Backup and r ecover y - Database log files are copied and saved to an offline resource. Backup
facilities are given by DBMS so that in the case of failure, backup can be provided. Backup copies of database should be made regularly. And to ensure a secure location, log files should also be back-upped.
16
http://www.vsharing.com/k/others/2008-1/606897.html
ThanDar Zin
Page 51
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Chapter (8) Database Design and Specification
ThanDar Zin
Page 52
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
8.1. Database Design In database design, we used SQL to create table. For create table, it consist data name, data type and constraints or it have other way for create table. First way is insert column name in table and another way is used Create keywords of SQL query to create. After create table, I am insert data for each table. More example sees in A11. Database Design and specification 8.1. Create Supplier table
Figure 8.1. Database Design for Supplier
8.2. Insert Data to Supplier
Figure 8.2. insert data to supplier
ThanDar Zin
Page 53
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Chapter (10) Testing
ThanDar Zin
Page 54
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Black Box Testing 17
This type of testing is built upon the system description. The testers do not require to known
any information of the structure inside the system and its performance.
The
functional
performance of the system is concerned with the input and output of the testing system. Its attention is in searching situation where observation is not used in the system. It is are consequent from the measurement and are only joined to the system by its usual input machines. This kind of testing is certainly not comprehensive. In more cases, it is not able to assessment how comprehensive a set of checks. So we need to know the system and how it is structured inside. It is possible to develop a treatment which is appropriate for cost benefits set of checks.
White Box Testing This testing looks at the system's internal structure to get complete information. It supposed the white box testing agrees a closer method to the bound of comprehensive testing; however this is not always useful. If the programmers are correctly paths to fulfill the description, the training of all the internal tracks within a program will only be usual. Though it is likely to train all the tracks in other words, it will silent be an unlimited number of secreted errors because it tracks are required or some tracks does not shown. It is likely to have a program that is within right in several current, but is still the false program.
Unit Testing
White box testing is practice for unit, package and integration tests. The other is all black
boxes. Unit testing can be done with module testing so that it fulfills its description, normally a minispec. The smallest unit of code is a module, but what a module is support language used for programming, it has been used and on the base for program description. A module is lesser than a subroutine or greater than a 'C' language file having some purposes. Typically the programming team moves out unit testing.
System Testing 18
This type of testing can be used to find out discrepancies between description of the system
and the resultant system. This is similar to black box testing. It is typically moves out by the team and an external team is also needed to ensure perfect condition. The management of testing teams will be conferring laded. 17 18
System Development (course book) page 6-7 and page 3-14 System Development (course book) page 6-7 and page 3-14
ThanDar Zin
Page 55
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
The system testing has a number of different types, it can be useful for highpoint particular types of errors: Documentation testing, Functional testing, Stress testing Volume testing, Usability testing, Performance and Security testing.
Testing procedure for the system System test is to have confirmed that software, computer hardware, peripherals, network
and so on other elements together, various information system assembly test and validation test, its purpose is through compared with the demand of the system, found that the developed system does not accord with user requirements or contradictions, and then puts forward the improved plan. Its task is to check out as completely as possible errors in the program, and improve the reliability of software system; its purpose is to test the system. This stage can be divided into three steps:
Module test: test each module of the program if there is a mistake
Assembly test: test module interface between is correct;
Confirm test: test the entire software system whether meet the requirements of user functionality and performance.
End of this phase should deliver the test report, explained the selection of test data, test case and test result is in line with the expected results. After testing found that the problem should pass debug to find out the reason for the error and location, and then correct them. Is based on the overall system requirements specification of black box testing, and should cover all components of the joint of the system. System testing is aimed at testing the whole product system, the purpose is to verify whether system can meet the definition of requirements specification, requirements specifications does not conform with or to the place of contradictions. So it is the best choice for our system.
ThanDar Zin
Page 56
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
10.1. Test Plan Source: The frame of the test plan is the supervisor provided and I used the time table. References: Project Test Plan
ThanDar Zin
Page 57
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
10.2. Test Case
Test Case is test about the data of the form. It test does the data can insert, update and delete. And test the login of the account. In test case, Test description and purpose and expected result and actual result is the column name. Test description means what step I am testing and purpose means the target of the step. And the expected result means the result that we want and actual result means the real result of the step. More example see in A12. Test Case
Test case for Login No 1
2
3
Test Description
Purpose
Expected result
Actual result
Check correct username
Successfully
Correct data and login
Correct data and
and password
Login
success
login success
If wrong user name
Show error
Show incorrect
Error Message
message
username and password
Show error
Show incorrect
message
username and password
If wrong password
ThanDar Zin
Error Message
Page 58
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Chapter (11) Critical Appraisal
ThanDar Zin
Page 59
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Over time there has been more and more progress, more and more people are slowly began to choose to use the network, such as there are a lot of people or companies who start thinking about their work on the net, to open a belong to their own nets, special sell anything you want to sell. Or a company can use the network to achieve the effect of promotional products, and the company can create their own web site, can make customers more convenient to order products. Our family is doing business, so I plan a project proposal about my family business and detailed development plan, the name is "Cosmetic wholesale and delivery management system". For find the likely book for cosmetic, I find difficulty, I am met with my supervisor, the supervisor referred me some text books and e-books. I record that the book supervisor referred. And then study this book. Before my system has not yet developed, I need to go to the company. I asked my mother about those who are doing business in cosmetics and know about it very well. My mother told me about a lady and the lady asked me to call. So I called that lady, consulted her about cosmetics. She is very enthusiastic to tell me about it. I srcinally thought may require the school approval, though she said I do not need it because she knew I was her friend's daughter. I'm really very grateful to the lady. I finally can develop the new system. First of all, I think I need to make a plan first, careful assessment of the scope of the project, to determine the basic request once again. Then I'll go to each big web, thinking, and to find faults, to decide if this system is not perfect. I explored many virtual online, but I saw a lot of the network, I found they just provide customer order, I think it is not perfect for some customers, if customers want to order something with the price, or is looking for a brand, I find that many of the network do not have this function. So I on my system added "looking for" the function, and online services. Such as some doubt there will be a lot of customers, so as long as there is any problem or concern the customer can use online services that function to achieve the things they want. I am going to use RAD technology to develop the new system, because it can meet the demand of recognition of JAD organization. Then I started to use case diagram to describe in detail my new system design, because I choose OOADM method for analysis and design. I have to use figure to describe the new system, such as class diagram, sequence diagram and state machine. For drawing diagram, I have to revisit the teacher for the things taught in the books, and visit each big web page the information on these graphs. I think the book and website give me more idea for doing my project.
ThanDar Zin
Page 60
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
For drawing use case diagram, I need to find the main process of the system, and then divide the sub process for each main process. For drawing class diagram, it is the important figure for the project, because if the class diagram does not correct, I can’t continue to create the database. In order to get the exact figure, I have to read again and again, I have taught in SAD how to draw the class diagram, then see the example in the textbooks, and then search on the net of about class diagram, to see how the man who is online. Think i can draw, and then give it a try. Finished, show it to the supervisor, so I can get some advice from supervisor. For drawing the robustness diagram, I need to see more books, because this is my first time to draw. Before painting it, I have to think about what my system should be step by step. For drawing activity diagram, I need to finished robustness first, because the robustness is related with the activity diagram. Before start to painting it, I need to produce list and step about my process. After I draw the diagrams finished, supervisor suggested my diagram and told me what the diagram is needed to amend and give me some advice for my diagram. The figure is finally complete, so I started thinking about the database. For create database, I need to review the text book and if something error from database I can’t solve, I will view in website that can know how the other people solve the error. I started to create the table first, and then input the data. For me to create the table is not difficult, but the input data is difficult. Maybe it is easy for many people, but I must put in symmetrical input data, because the data is one of the important key tests right in report. In order to get the correct report, I have a headache for a long time, the data input of time and time again. Through great efforts I succeeded in my report. After the test of the database creation that only need the software development. Before start to create the program, I need to produce the query of report first. Produce SQL query for report is the difficult step of the project, because it need to join the table for produce report. For join the table, I need to think about how to join the table and how the data will be produce. In my project, the weekly order status report is difficult than the other report. For this report, I need to joint five tables: customer, Order detail, Invoice, Product and order. The attributes that I want to produce for report are in these five tables. For this report, I've been racking my brains, thinking and thinking, the experiment again and again, to get a satisfactory result. Develop software; I use ASP.net because I am familiar with this software. We have to create the database, and then write the query in the database, because the software will use the query to
ThanDar Zin
Page 61
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
insert, update, delete and produce the report. First is to draw the design, the design is not difficult. After the Design, coding begins. This is a place where I faced the greatest difficulty. Because the design has a lot of the form, we want to test every form can insert, update, delete and produce the report. For insert and update and delete, I need to create the procedure, because this procedure will be used in the program. Again and again I tested for error. Slowly the software development progressed. For me, delete process is difficult, because of the key. Keys have many types; Primary key, Foreign key and compound key. If the key is primary key, it can easily delete data. If the key is compound key, it need to think a lot of what the key is join with the table. Compound key consists of 2 or more primary key. So if I want to delete the data of table that consist the compound key, I need to think the query for delete. When software development is completed I started documentation and documentation is not too difficult for me. When my project finished, I used Gmail to send to my supervisor, but sometime the connection of school is down, I need to go to other internet bar for send my project. As long as a day according to the teacher's plan, the schedule will be finished slowly. But sometimes because I was ill, or because I went home, there are several days I couldn’t do according to plan and the schedule is the right thing to do. So I have to find time to repair back. I use my leisure time to do the project and slowly to catch up with the plan and it should be finished in the schedule; the date of my project is over, just like that.
ThanDar Zin
Page 62
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Conclusion The system titled "Cosmetic wholesale and delivery management system" is about cosmetic sales system. In this system, "Dynamic System Development Methodology (DSDM)" is used for the development. A popular "Object Oriented Analysis and Design (OOAD)" also called "Unified Modeling Language (UML)". It is used to analyze and design the new system. DSDM is the best choice for this system. And also we used Microsoft Visual Studio 2008 to develop. In Microsoft Visual Studio 2008, we used ASP.Net to develop website of this system, with Visual Basic (VB.Net). It uses the several languages. How this system store database? The best answer is that we used SQL Server. It is the best choice for database. It is the popular software; it can back up all important databases. In the modern society, more and more people use the Internet. So I wonder if I can use the Internet platform to develop software. I developed software about cosmetics; it should be convenient for the customer a lot. Because the customer does not need to be on the move, as long as there is network, a network platform can be used to purchase in advance. Then we will purchase in advance the product to the customer address. But I have a disadvantage of this software that is I have to pay to the bank. Because there is no online banking to pay for the service, so need the customer to transfer money to the bank. But if you can use the Internet to pay service, I will once again improve this software; this software is getting better and better.
ThanDar Zin
Page 63
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Reference Enterprise Networking (Text Book) Date: July, 10, 2013 System Development (Text Book) Date: June, 12, 2013 B. PAUL, G. ANDREW, H. SIMON, Business Information Systems - Technology, Development and Management (Fourth Edition) (Text Book) Date: July, 12, 2013 http://www.waterfall-model.com/ Date: May, 20, 2013 http://www.rivulets.in/blog/project-management/waterfall-model-software-methodology/ Date: May, 20, 2013 www.slepi.net/blog/system-development/system-development-life-cycle-sdlcmethodologies.html Date: May, 20, 2013 http://www.scribd.com/doc/6902721/Fact-Finding-Techniques Date: June, 10, 2013 http://technet.microsoft.com/en-us/sqlserver/default Date: June, 10, 2013 http://www.dba-oracle.com/t_object_oriented_approach.html Date: May, 20, 2013 http://searchsoftwarequality.techtarget.com/definition/rapid-application-development Date: May, 20, 2013 http://social.msdn.microsoft.com/Forums/en/netfxnetcom/thread/a5c456c8-e432-4b46-b9633b4559e0a81d Date: June, 10, 2013 http://www.vsharing.com/k/others/2008-1/606897.html Date: July, 05, 2013 http://tech.hexun.com/2009-06-16/118656468.html Date: May, 20, 2013 http://www.itegritygroup.com/asp-net-advantages/ Date: June, 15, 2013 http://www.java-samples.com/showtutorial.php?tutorialid=973 Date: June, 15, 2013 http://www.internet-guide.co.uk/java.html Date: June, 15, 2013
ThanDar Zin
Page 64
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Appendices
ThanDar Zin
Page 65
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
A1. Project Proposal
I ntroduc tion Now the times have been slowly beginning to make progress, network becomes people irreplaceable necessities. Now of the network is more and more convenient, people have started to do business on the Internet. So I want to do this project, Cosmetics whole sale and delivery management system. The cosmetic wholesale and delivery management system is fashionable for modern. There are so many types of cosmetics, from big type distinguish, have the following kinds. Hairdressing cosmetics, Skincare cosmetic’s, Special efficacy cosmetics and Male cosmetics and Children’s cosmetics. Now I want to carefully explain everything the use of cosmetics.
Hairdressing cosmetic – the function of beauty cosmetics, covers the shortage of
face, make it beautiful. Mainly including the foundation, powder kind, rouge, lipstick, mascara, eye shadow, lotion, nails cream, nail polish, etc.
Skincare cosmetics – Skincare cosmetics function is to protect the skin healthy
and prevent skin aging. Can be divided into cold cream, emulsion, mask and SOD cosmetics.
Special efficacy cosmetics – Special efficacy cosmetics main function is skin
beauty, skin disease treatment. Including anti-wrinkle cream, to dispel the spot cream, sunscreen, acne dew, slimming cream, etc.
Male
cosmetics – Mail cosmetics is suitable for men’s physiological
characteristics of cosmetics. Mainly includes the man cream, shaving cream, man hair spray, Eisenhower cologne, etc. Children’s
cosmetic s
– is a kind of suitable for children’s physiological
characteristics of cosmetics. Mainly includes children wash hair supplies, children’s soap, children’s skin cream. We specialized in network wholesale cosmetics, such not only with the times, but also more let our customers convenient. Some of it is not convenient to go abroad for cosmetics customers, can through the network and contact us.
ThanDar Zin
Page 66
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Aim We are doing all information by computerized and online system. Our purpose is to let more people can use the web, on the network pre-order our cosmetics. Need not specially run to a certain place to buy. And if there are any new goods, also can be in the first time know and exercise.
Objectives
To assessment the web-based cosmetic shop structure, how web-based cosmetic shop can help the current cosmetics shop structure with the benefit of new features. Activities: Read literature and study business and entertainment journals and periodicals. Deliverables: Section report with literature review
To secure and protect the online cosmetics wholesale and delivery system from hacker, safety methods are investigation and choice some of suitable methods. Activities: Read literature and study how to keep the system from hacker, viruses. Study
books concerning about safety and threats. What kind of threats can attack? Deliverables: Enterprise Network
To improve the online cosmetic wholesale and delivery management system to meet the business requests, study Lifecycle methodologies and select one. And study development approaches. Activities: Analyses the information gathered. To drafts a requirement specification. Study
lifecycles and development approaches on books and Internet. And choose appropriate methods to improve the system. Deliverables: Requests specification. Reason for methods selected. System Analysis and
Design chapter (4, 5, 6, 7)
To design and implement the online systems, with the completely maintained background database structure.
ThanDar Zin
Page 67
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Activities: Investigate the collected information from the appropriate sources, design and
implement the online cosmetic database supported wholesale and delivery management system. Deliverables: Justification for selected programming language and database.
Required resources
A minimum Microsoft Windows 7 Home Edition.
Microsoft Visual Studio 2008 for the application of the system.
Microsoft SQL Server 2008 or 2005 for database support and implementation.
Microsoft Office word for documenting purpose and prepare the reports.
Use to the database
Use to the Internet
Initial References
Avison,D. and Fitzgerald, G. (2006) Information Systems Development – th
methodologies, techniques * tools, 4 edition nd
NCC Education, (2008) Business System Design, 2 Edition
NCC Education System Development
NCC Education, (2008) Business System Analysis, 2nd Edition
NCC Education Enterprise Networking
Bocij, P., Greasley, A. and Hickie, S., (2008) Business Information Systems – Technology Development & Management, 4 th Edition, Pearson Education limited
Key phrases
Online make up selling
Online make up market
Online girl beautify the features
Online cosmetics order and payment
Women cosmetic, Men cosmetic and baby cosmetics advertisement
ThanDar Zin
Page 68
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
A2. Use Case Diagrams and Description Detailed Use Case Diagram
Cosmetic Wholesale and Delivery Management System Register new staff info
Send purchase order
Supplier
Record new product info
Staff
Register new customer info
Give consulting service and allow searched product
Make order
Customer
Produce invoice
Manager Check feedback
Compliant
Produce report
Figure A2 detailed use case diagram
ThanDar Zin
Page 69
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Customer registration process
Customer Registration process Search product
Create account Customer
Accept account Staff
Figure A2.1 use case for customer registration process
ThanDar Zin
Page 70
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Make order process
Make order process
Login account
Add to cart Customer
Make order
Accept order
Delivery product Staff
Receive product
Figure A2.22 use case for make order process
ThanDar Zin
Page 71
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Produce invoice process
Produce invoice process
Produce invoice
Check feedback
Give payment
Staff
Customer
Receive payment
Figure A2.3 use case for produce invoice process
Complaint
Complaint process
Make complaint
Staff
Sent complaint
Accept complaint
Manager Customer
Solve complaint
Figure A2.4 use case for complaint
ThanDar Zin
Page 72
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Produce report Produce report process
Daily sales report
Weekly customer order status report
Staff
Monthly the best sell cosmetic report
Manager
Product status list
Figure A2.5 use case for produce report
ThanDar Zin
Page 73
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Use Case Description Create new product process Number
C001
Req Doc Ref:
Name
Create new product process
Status
Working
Actors
Staff
Pre-Requisites
Staff to create new product at the website
Goal
Staff successfully create new product at the website
1
Use-case Relationships Extend: Include: Association: Staff Generalization: Description Index
Actor event
1
Staff login to the system
2
Staff load the product entry page
3
Staff enter the new product information
4
Staff add product type for the new product
Alternatives Index
Actor event
A1
Incorrect user name or password
A1.1
Show unsuccessful login error
A1.2
Go to step 1
A2
Incorrect or incomplete product information
A2.1
Show error
A2.2
Go to step 2
ThanDar Zin
Page 74
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Customer registration process Number
C002
Req Doc Ref:
Name
Customer registration process
Status
Working
Actors
Customer
Pre-Requisites
Customer to register at the website
Goal
Customer successfully registered at the website
2
Use-case Relationships Extend: Include: Association: Customer Generalization: Description Index
Actor event
1
Customer request to register at the website
2
Customer register page is loading
3
Customer enter the personal registration information into the form
4
Customer submit the entered registration information
Alternatives Index
Actor event
A4
The registration information is incomplete or contain valid information
A4.1
Show incomplete or invalid information error
A4.2
Go to step 2
ThanDar Zin
Page 75
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Make order process Number
C003
Req Doc Ref:
Name
Make order process
Status
Working
Actors
Customer ,Staff
Pre-Requisites
Customer want to make order
Goal
Customer successfully make order
3
Use-case Relationships Extend: Include: Association: Customer ,Staff Generalization: Description Index
Actor event
1
Customer search the product they want and login account
2
Add product to cart
3
Customer request to make order, check product available
4
Staff accept the order that customer request
5
Staff accept the order, Check the product to delivery
6
Customer receive the product
Alternatives Index
Actor event
A3
When the product no inventory
A3.1
Show message
A3.2
Go to step 3
A6
When customer does not receive the product, Customer sent message or call phone to staff
A6.1
Go to step 5
ThanDar Zin
Page 76
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Produce invoice process Number
C004
Req Doc Ref:
Name
Produce invoice process
Status
Working
Actors
Customer ,Staff
Pre-Requisites
Staff produce invoice for receive payment
Goal
Staff successfully receive payment
4
Use-case Relationships Extend: Include: Association: Customer ,Staff Generalization: Description Index
Actor event
1
Staff Search order from order database
2
When order result show, Staff choose order.
3
Staff produce invoice for the order that customer make
4
Staff check the customer feedback and product good or not
5
Customer receive invoice and give payment
6
Staff receive payment
Alternatives Index
Actor event
A3
When invoice incorrect
A3.1
Go to step 1
ThanDar Zin
Page 77
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
A3. Class Diagram Product Type
Product
Supplier - Supplier_ID: String - Supplier_Name: String - Supplier_Address: String 1…* - Supplier_Email: String - Supplier_PhoneNo:String
OrderDetail - Order_ID: String - Product_ID: String - Sold_Quantity: Integer
- Product_ID: String - PT_ID: String 1…* - Supplier_ID: String - Product_Name: String - P_Quantity: Integer - Price: Integer + is created() 1…* + is updated() + is deleted() + is searched()
1…* 1
+ is created() + is updated() + is deleted()
1…*
Customer
Order 1 - Order_ID: String - Customer_ID: String - Staff_ID: String 1 - Order_Date: Date - Delivery_Date: Date
1…* bought
1…*
- Delivery_ID:String - Invoice_No: String - Order_ID: String - Address: String - Finished: String + is created() + is updated() + is deleted()
0
…
*
0
1 1
1 1…*
Invoice
1
- invoice_No: String - Order_ID: String - Customer_ID: String - invoice_Date: Date 1 - Paid_Date: Date - Amount: Money
Staff - Staff_ID: String - Staff_Name: String - NRC_number: String - Address: String - Phone_number:String - Email: String
…
Complaint
- Customer_ID: String - Customer_Name: String - NRC_Number: String - Password: String - Address: String 1 - Phone_number: String - Email: String 1 + create order() + is saved() + is edited() + receive invoice()
+ is created() + is updated() + is deleted()
Delivery
1…* - PT_ID: String - TypeName: String
*
- Complaint_ID: String - Supplier_ID: String - Customer_ID: String - Staff_ID: String - Manager_ID: String - Complaint_info: String
1
Made by
1 0…*
+ insert product info() + Update product info() + Delete product info() + produce invoice() + Produce report()
1…*
Department 1 - Dept_ID: String - Dept_Name: String - Manager_ID: String - Staff_ID: String 1…*
+ Accept complaint() + Solve complaint() 0… *
Manager - Manager_ID: String - Manager_Name:String 1 - NRC_number:String - Address:String - Phone_number:String - Email:String
+ is created() 1 + is updated() + is deleted()
1
+ is inserted() + is Updated() + is Deleted()
+ insert staff info() + Delete staff info() + complaint() + Solve Produce report()
Figure A3 detailed class diagram
ThanDar Zin
Page 78
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
A4. Robustness Diagram Customer register process
Home page
Click register link
Customer
Customer register page
SubmitButton
Customers
Load customer register page
Enter customer details
Save
Show customer ID and information
Figure A4.1 Robustness Diagram for customer register
ThanDar Zin
Page 79
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Create product
Login
Staff Home page
Staff
Product link
Product list page
Save button
Click product link
Enter new product info
Click save button
Products Figure A4.2 Robustness Diagram for create product
ThanDar Zin
Page 80
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Make order process
Home page
Load customer Login page
Click Login link
Customer
Customer Login page
Enter username & password
SubmitButton
Customer personal page
Order page
Submit Button
OrderDetail
Checkvalid
Load Order page
Click add to Cart Button
Fill order info
Delivery
Check order
Show customer order page
Order
Figure A4.3 Robustness Diagram for make order process
ThanDar Zin
Page 81
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Produce invoice process
Login
Staff Home page
Staff
Invoice link
Invoice page
Load invoice page
Search order
Result show
Choose order
Create invoice
Insert invoice info
Invoice
Order
Search
Show invoice information
Figure A4.4 Robustness Diagram for produce invoice process
ThanDar Zin
Page 82
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
A5. Sequence Diagram
Home Page: register Customer Staff
Cosmetic product
Consulting service
Customer: Page
Report
Manager
Search product and branch type
Login or register new info Confirm account
Add to cart
Can chat with our staff to known about new cosmetic information and effective Confirm the answer that the question from customer Make order for cosmetic and give delivery info Confirm order Sent message to customer for the delivery information Accept message Produce invoice Check customer feedback and does customer receive product Confirm feedback Receiver invoice Give payment Receive payment Confirm payment receive Make complaint when product is out of date or other Solve complaint Produce report Check report
Figure A5 Sequence diagram for detail
ThanDar Zin
Page 83
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Customer register process
Homepage:Register
Register:Page
Customer:Page
Customer Click register Loading register page
Enter detail customer information Save Confirm customer ID and information
Figure A5.1 sequence diagram for customer registration process
Create product process
Home Page: Log in
Product:Page
Log in Product page Enter product information Confirm product information
Figure A5.2 sequence diagram for create product process
ThanDar Zin
Page 84
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Make order process
Home Page: register Customer
Cosmetic product
Customer: Page
Staff Login Add to cart
Make order for cosmetic Accept order Confirm order
Delivery product to customer place Confirm product receive or not
Figure A5.3 sequence diagram for make order process
Produce invoice process
Home Page: register
Order: Page
Invoice: Page
Staff Login Search order Confirm order result
Choose order Create order info Enter order info Confirm order info
Figure A5.4 sequence diagram for produce invoice process
ThanDar Zin
Page 85
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
A6. Activity Diagram Customer register process
Customer request to register
Enter customer information [incomplete or Invalid]
Submit No [complete]
Figure A6.1 Activity diagram for customer register process
Create product process
Staff login [incomplete] No Yes
Enter product information
[incomplete or Invalid]
Submit No [complete]
Figure A6.2 Activity diagram for create product process
ThanDar Zin
Page 86
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Make Order process
Search product
Login or register
No [When user name or password incorrect] Yes
Add to cart
Make order No [When the product is out of stock or cancel] Yes
Fill order info
Submit order
Check order [complete]
Figure A6.3 Activity diagram for make order process
ThanDar Zin
Page 87
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Produce invoice process
Login
Search order
Order result show
Choose [incomplete]
No
Yes
Create invoice info
Insert invoice info [complete]
Figure A6.4 Activity diagram for produce invoice process
ThanDar Zin
Page 88
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
A7. State machine Customer register process Go to register page
Register page Create account
Enter information Accept account
Submit Complete Cancel
Figure A7.1 State machine for customer register process
Create product process Login to administrator
Login Create new product
Enter product information Incorrect
Accept new product
Submit Complete
Figure A7.23 State machine for create product process
ThanDar Zin
Page 89
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Make Order process If new customer
Add to cart
Register
Login
If have account customer
Check user name and password If pass
Made order
If fail
Fill order info
Check order Complete
Figure A7.34 State machine for make order process
ThanDar Zin
Page 90
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Produce invoice process Staff login
Login
Order confirm
Searchorder
Show order result
Choose order
Create invoice
Insert invoice info Complete
Figure A7.4 State machine for produce invoice process
ThanDar Zin
Page 91
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
A8. Requirements Catalog (Functional and Non-functional requirements) Create Staff
Source:
Staff
Sign Off:
Manager
Requirement ID:C001
Functional Requirement : Input staff details information
Non-Functional Requirement (s) : Description: Volume
Target Value : 300Perday
Acceptable Value :
Comments:
100-300 per day
Figure A8.1 for input staff info
Source:
Staff
Sign Off:
Manager
Requirement ID:C002
Functional Requirement : Update staff details information
Non- Functional Requirement (s) : Description: Volume
Target Value : 300perday
AcceptableV alue:
Comments :
100-300 per day
Figure A8.2 for update staff details info
ThanDar Zin
Page 92
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Purchase order
Source:
Supplier
Sign Off:
Staff
Requirement ID:C003
Functional Requirement : Purchase order
Non- Functional Requirement (s) : Description: Volume
TargetV alue : 500perday
AcceptableV alue:
Comments :
250-500 per day
Figure A8.3 for purchase order
Create product
Source:
Supplier
Sign Off:
Staff
Requirement ID:C004
Functional Requirement : Input product details
Non- Functional Requirement (s) : Description: Volume
TargetV alue : 1000perday
AcceptableV alue:
Comments :
250-1000 per day
Figure A8.4 for input product info
ThanDar Zin
Page 93
B.Sc. (Hons.) Business IT Project
Source:
Supplier
Title: Cosmetic wholesale and delivery management system
Sign Off:
Staff
Requirement ID:C005
Functional Requirement : Update product details
Non- Functional Requirement (s) : Description: Volume
TargetV alue : 1000perday
AcceptableV alue:
Comments :
250-1000 per day
Figure A8.5 for update product info
Create new customer
Source: Customer
Sign Off:
Staff
Requirement ID:C006
Functional Requirement : Create new account
Non-Functional Requirement (s) : Description:
Target Value:
Volume
2000 new account
Acceptable Value:
Comments :
1000- 2000 new account
Figure A8.6 for create new account
ThanDar Zin
Page 94
B.Sc. (Hons.) Business IT Project
Source: C ustomer
Title: Cosmetic wholesale and delivery management system
Sign Off:
Staff
Requirement ID:C007
Functional Requirement : Input customer details information
Non- Functional Requirement (s) : Description:
Volume
TargetV alue :
2000 Per day
AcceptableV alue:
Comments :
1000- 2000 Per day
Figure A8.7 for input customer details info
Source: C ustomer
Sign Off:
Staff
Requirement ID:C008
Functional Requirement : Update customer details information
Non- Functional Requirement (s) : Description:
Volume
TargetV alue :
2000 Per day
AcceptableV alue:
Comments :
1000- 2000 Per day
Figure A8.8 for update customer details info
ThanDar Zin
Page 95
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Make order
Source: C ustomer
Sign Off:
Staff
Requirement ID:C009
Functional Requirement : Make order
Non- Functional Requirement (s) : Description: Volume
Target Value : 500perday
AcceptableV alue:
Comments :
300-500 per day
Figure A8.9 for make order
Produce invoice
Source:
Staff
Sign Off:
Manager
Requirement ID:C010
Functional Requirement : Produce invoice
Non- Functional Requirement (s) : Description: Volume Printing speed
TargetV alue : 500perday
AcceptableV alue:
Comments :
300-500perday
10Perminute
8-10Perminute
- use little head
Figure A8.10 for produce invoice
ThanDar Zin
Page 96
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Complaint
Source :
Customer, supplier
Sign Off:
Manager
Requirement ID:C011
Functional Requirement : Complaint
Non- Functional Requirement (s) : Description: Volume
TargetV alue : 100perday
AcceptableV alue:
Comments :
0-100perday
Figure A8.11 for complaint
Produce report
Source:
Staff
Sign Off:
Manager
Requirement ID : C012
Functional Requirement : Produce report
Non-Functional Requirement (s) : Description:
- printing speed
TargetV alue :
- 1 0 per minute
Acceptable Value :
- 8-1 0 per minute
Comments:
- Use little head
Figure A8.12 for produce report
ThanDar Zin
Page 97
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Non-functional requirement catalog
Source :
Sign Off :
Requirement ID : C013
Functional Requirement : Non- Functional Requirement (s) : Target Value :
Description :
Acceptable Value :
Comments :
The new system include - Complete System access- Staff have access to customer details - Customer can searched product by branch type or product type or price Make order Printing Process and speed The volume of create New account
500 per day
300-500 per day
10 Per minute
8-10 Per minute
2000 new account
1000-2000 new account
The volume of customer details information
2000 Per day
1000-2000 Per day
The volume of product
1000 per day
250-1000 per day
The volume of staff
300 per day
100-300 per day
500 per day
250-500 per day
- Use little head
The volume of purchase order from supplier The volume of complaint
100 per day
0-100 per day
Figure A8.13 for non-functional requirement catalog
ThanDar Zin
Page 98
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
A9. Report form Simple of Daily sales report
Daily sale report Date:----/-----/----TypeName
Product_ID
Product_Name
total_sold
Amount
Simple of Weekly customer order status report
Weekly customer order status report Report Date:----/----/----
For the week date-------------to-------------
Customer_Name
ThanDar Zin
Order_No total_amount
Order_Date
invoice_Date
Paid_Date
Delivery_Date
Page 99
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Simple of Monthly the best sales cosmetic report
Monthly the best sales cosmetic report From Date:----/-----/----PT_ID
To Date:----/-----/-----
Product_ID
Product_Name
total_sold
Amount
Simple of Product status List
Product status List ProductTypeID:-----------Product_ID
ThanDar Zin
Product_Name
ProductTypeName:------------Price
P_Quantity
Page 100
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
A10. Interview Log When I asked my mother, my mother did know open cosmetics company, my mother said, her understanding of the cosmetics company, called the city beautiful. I have to call her aunt. My mother told me her telephone number, so I make a phone call to ask her: I: Hello, aunt. I is two elder sister's daughter, can you do me a favor? May I ask you about your
cosmetics company? Aunt: oh, you are her daughter. Although I don't know you ask this want to do! But I would be
happy to help you. I: Aunt, can you tell me what time you do in company? I can come to company for you? Aunt: Of course, I'm in the company right now
When I first to aunts, I see the people in the company, busy. When aunt came to my side, took me to her company to visit. Her company has three floors, her office on the third floor. When she took me to her office, I asked her. I: aunt, I want to ask you, your company is divided into several departments? Aunt: Have many departments, I tell you, firstly is the sale department, a group of people to introduce to the guest on the Internet all kinds of products and customers purchase in advance,
then customers purchased products sent to the person responsible for delivery and sent to. As to the planning department, is planning a variety of holidays should be how to better sales each kind of product. I: It seems many departments. What did that make you very trouble? Aunt: Very much, such as conflict with a client, send the item not arrive within the estimated
time, money, staff issues and so on I: That you ever want to solve the strategy? Aunt: There is thought, but often are not useful to management. I: That I can see the system is how to use the company?
ThanDar Zin
Page 101
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Aunt: Of course, now I will take you to see I: thank you very much
Aunt took me to see all of the system, but the only thing that makes me confused is "why not sell these products on the Internet". So I asked the aunt, aunt saw their sigh shook his head Aunt: These talk easy? I: Have any trouble? Aunt: first are the network problem, and then the regional issues. Anyway there are a lot of
problems exist. The most important is in Myanmar doing is enough. I: Even so, but you have to keep up with The Times. Look at the people abroad, not all use the
Internet in business online? Aunt: Yes. But I think I'm quite good. I: Aunt, very thank you for taking me to visit your company, I believe that to me do planning
will be very helpful.
Aunt: there is nothing to thank, let alone your mother or my friends. If you need anything, come to me again I: Aunt thank you, I go back first
Aunt enthusiasm to help, I appreciate it. Aunts Company I also clearly understand how to use the system. I believe my project will very good. Her help will make me feel better; I will not live up to the anniversary aunt help.
ThanDar Zin
Page 102
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
A11. Database Design and specification 11.1.1. Supplier
Figure 11.1.1 Database Design for Supplier
11.1.2. Department
Figure 11.1.2 Database Design for Department
11.1.3. Manager
Figure 11.1.3 Database Design for Manager
ThanDar Zin
Page 103
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
11.1.4. Staff
Figure 11.1.4 Database Design for Staff
11.1.5. Product Type
Figure 11.1.5 Database Design for Product Type
11.1.6. Product
Figure 11.1.6 Database Design for Product
ThanDar Zin
Page 104
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
11.1.7. Customer
Figure 11.1.7 Database Design for Customer
11.1.8. Order Detail
Figure 11.1.8 Database Design for Order Detail
11.1.9. Order
Figure 11.1.9 Database Design for Order
ThanDar Zin
Page 105
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
11.1.10. Delivery
Figure 11.1.10 Database Design for Delivery
11.1.11. Invoice
Figure 10.1.11 Database Design for Invoice
11.1.12. Complaint
Figure 10.1.12 Database Design for Complaint
ThanDar Zin
Page 106
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
11.2. Insert Data 11.2.1. Insert Data to Supplier
Figure 11.2.1 insert data to su pplier
11.2.2. Insert data to Department
Figure 11.2.2 Insert data to Department
ThanDar Zin
Page 107
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
11.2.3. Insert Data to Manager
Figure 11.2.35 insert data to Manager
11.2.4. Insert Data to Staff
Figure 11.2.4 insert data to Staff
ThanDar Zin
Page 108
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
11.2.5. Insert Data to Product Type
Figure 11.2.5 insert data to Product type
11.2.6. Insert Data to Product
Figure 11.2.6 Insert Data to Product
ThanDar Zin
Page 109
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
11.2.7. Insert Data to Customer
Figure 11.2.7 insert data to C ustomer
11.2.8. Insert Data to Order Detail
Figure 11.2.8 insert data to Order detail
ThanDar Zin
Page 110
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
11.2.9. Insert Data to Order
Figure 11.2.9 insert data to order
11.2.10. Insert data to Delivery
Figure 11.2.10 insert data to delivery
ThanDar Zin
Page 111
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
11.2.11. Insert Data to Invoice
Figure 11.2.11 insert data to Invoice
11.2.12. Insert Data to Complaint
Figure 11.2.12 inset data to complaint
ThanDar Zin
Page 112
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
11.3. Produce Report with Database 11.3.1. Daily Sales report
Figure 11.3.1 Report for Daily sales
11.3.2. Weekly customer order status report
Figure 11.3.2 Report for Weekly customer order status report
ThanDar Zin
Page 113
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
11.3.3. Monthly the best sales cosmetic report
Figure 11.3.36 Report for monthly the best sales cosmetic report
11.3.4. Product status list
Figure 11.3.4 Report for product status list
ThanDar Zin
Page 114
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
A12. Test Case (1) Test case for Login No 1
2
3
Test Description
Purpose
Expected result
Actual result
Check correct username
Successfully
Correct data and login
Correct data and
and password
Login
success
login success
If wrong user name
Show error
Show incorrect
Error Message
message
username and password
Show error
Show incorrect
message
username and password
If wrong password
Error Message
(2) Test Case for Customer Register No 1
Test Description Enter customer info
Purpose Successfully Save
Expected result Show message “Save
Actual result Like expected
complete” 2
If any textbox is blank
Show error
Show message “Please
message
fill data”
Like Expected
(3) Test case for order No
Test Description
Purpose
Expected result
Actual result
2
Enter order info
Successfully save
Go to order detail page
Like Expected
3
If any textbox is blank
Show error
Show message “Please
Error message
message
fill data”
Clear order info
Show order page
4
Click Cancel button
ThanDar Zin
Like Expected
Page 115
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
(4) Test case for order detail No 1
Test Description Click New to fill info
Purpose
Expected result
Create order detail
Show create order detail
Actual result Like Expected
page 2
Enter order detail
Successfully save
Show message “Save
Error Message
complete” 3
If any textbox is blank
Show error message
Show message “Please fill data”
Like Expected
4
Select data and click Edit
Edit order detail
Show message “Edit
Like Expected
button 5
Click Cancel button
complete” Clear order detail
Show order detail page
Like Expected
The existing order detail
Like Expected
info 6
Select data and click
Delete order detail
Delete button
data will delete
(5) Test Case for product No 1
Test Description Click New to fill info
Purpose Create product
Expected result Show create product
Actual result Like Expected
page 2
Enter product detail
Successfully save
Show message “Save
Like Expected
complete” 3
4
If any textbox is blank
Select data and click Edit
Show error
Show message “Please
message
fill data”
Edit product
Show message “Edit
button
Like Expected
Error Message
complete”
5
Click Cancel button
Clear product info
Show product page
Like Expected
6
Select data and click
Delete product
The existing product
Like Expected
Delete button
ThanDar Zin
data will delete
Page 116
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
(6) Test Case for product Type No 1
Test Description Click New to fill info
2
Enter product type detail
Purpose
Expected result
Create product
Show create product
type
type page
Successfully save
Show message “Save
Actual result Like Expected
Like Expected
complete” 3
If any textbox is blank
Show error message
Show message “Please fill data”
Like Expected
4
Select data and click Edit
Edit product
Show message “Edit
Like Expected
button 5
Click Cancel button
6
complete” Clear product type
Show product type
info
page
Select data and click
Delete product
The existing product
Delete button
type
type data will delete
Like Expected
Like Expected
(7)Test Case for Supplier No 1
Test Description Click New to fill info
Purpose Create Supplier
Expected result Show create Supplier
Actual result Like Expected
page 2
Enter Supplier detail
Successfully save
Show message “Save
Like Expected
complete” 3
4
If any textbox is blank
Select data and click Edit
Show error
Show message “Please
message
fill data”
Edit Supplier
Show message “Edit
button
Like Expected
Like Expected
complete”
5
Click Cancel button
Clear supplier info
Show Supplier page
Like Expected
6
Select data and click
Delete Supplier
The existing Supplier
Error Message
Delete button
ThanDar Zin
data will delete
Page 117
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
(8) Test Case for Manager No 1
Test Description Click New to fill info
Purpose Create Manager
Expected result Show create Manager
Actual result Like Expected
page 2
Enter Manager detail
Successfully save
Show message “Save
Like Expected
complete” 3
If any textbox is blank
Show error message
Show message “Please fill data”
Like Expected
4
Select data and click Edit
Edit Manager
Show message “Edit
Like Expected
button 5
Click Cancel button
complete” Clear Manager
Show Manager page
Like Expected
The existing Manager
Like Expected
info 6
Select data and click
Delete Manager
Delete button
data will delete
(9) Test Case for Staff No
Test Description
Purpose
Expected result
Actual result
1
Click New to fill info
Create Staff
Show create Staff page
Like Expected
2
Enter Staff detail
Successfully save
Show message “Save
Like Expected
complete” 3
If any textbox is blank
4
Select data and click Edit
Show error
Show message “Please
message
fill data”
Edit Staff
Show message “Edit
button
Like Expected
Like Expected
complete”
5
Click Cancel button
Clear Staff info
Show Staff page
Like Expected
6
Select data and click
Delete Staff
The existing Staff data
Like Expected
Delete button
ThanDar Zin
will delete
Page 118
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
(10) Test case for department No 1
Test Description Click New to fill info
Purpose
Expected result
Create department
Show create department
Actual result Like Expected
page 2
Enter department detail
Successfully save
Show message “Save
Like Expected
complete” 3
If any textbox is blank
Show error message
Show message “Please fill data”
Like Expected
4
Select data and click Edit
Edit department
Show message “Edit
Like Expected
button 5
Click Cancel button
complete” Clear department
Show department page
Like Expected
The existing department
Error Message
info 6
Select data and click
Delete department
Delete button
data will delete
(11) Test case for invoice No 1
Test Description Click New to fill info
Purpose
Expected result
Create department
Show create department
Actual result Like Expected
page 2
Enter department detail
Successfully save
Show message “Save
Error Message
complete” 3
If any textbox is blank
4
Click Cancel button
5
Select data and click
Show error
Show message “Please
message
fill data”
Like Expected
Clear department
Show department page
Like Expected
The existing department
Like Expected
info
Delete button
ThanDar Zin
Delete department
data will delete
Page 119
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
(12) Test case for delivery No 1
Test Description
Purpose
Click New to fill info
Create delivery
Expected result Show create delivery
Actual result Like Expected
page 2
Enter delivery detail
Successfully save
Show message “Save
Like Expected
complete” 3
If any textbox is blank
Show error message
Show message “Please fill data”
Like Expected
4
Select data and click Edit
Edit delivery
Show message “Edit
Like Expected
button
complete”
5
Click Cancel button
Clear delivery info
Show delivery page
Like Expected
6
Select data and click
Delete delivery
The existing delivery
Error Message
Delete button
data will delete
(13) Test case for complaint No 1
Test Description Enter complaint info
Purpose Successfully save
Expected result Show message “Save
Actual result Like Expected
complete” 2
If any textbox is blank
Show error message
Show message “Please
Like Expected
fill data” 3
Click Cancel button
ThanDar Zin
Clear complaint info
Show complaint page
Like Expected
Page 120
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
A13. Operation Manual 13.1. Site Map for customer HomePage
Customer login
Product
Search product
Customer personal
Knowledge of beauty
Complaint
Edit personal info
About us
Manager Login
Help
Add to cart Make order
Make order detail
Add delivery info
Sent feedback
Figure 13.1. Site Map for customer
ThanDar Zin
Page 121
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
13.1.1. Home Page for customer Home page for customer is the start page of the system. In customer home page,
customer, staff and manager can login. And customer home page include customer register, Product, Search product, Make order, Add delivery info, Sent feedback and complaint.
Figure 13.1.1 Home page for customer
ThanDar Zin
Page 122
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
13.1.2. Customer Register When customer added detail information finished, click “register” and data will save in
database. After register, customer used this account to login.
Figure 13.1.2 Customer register
13.1.3. Login with account
Figure 13.1.3 Login with account
ThanDar Zin
Page 123
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
13.1.4. Product page In product, customer can search product by product type, and then view the price of the
product and add to cart.
Figure 13.1.4 Product page
ThanDar Zin
Page 124
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
13.1.5. Edit personal information Click “Select” word in grid view, data will be filling in textbox. Edit that the information
customer want to update, but ID cannot update. Example, customer address srcinal is “Mandalay, Myanmar”, now I was update as “Yangon, Myanmar” Click “Edit” to update the information. If not, click “cancel”. After click “Edit”, message box will be shown, click “Ok” to continue.
Figure 13.1.5 edit information page for edit personal information
ThanDar Zin
Page 125
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
13.1.6. Order page After customer login, this page will be shown. Customer can make order in this page.
When customer insert detail information finished, click “Save” button and then order detail page will be shown.
Figure 13.1.6 Order page for make order
13.1.7. Order detail page When customer made order finished, order detail page will be shown. Customer need to insert data detail. After insert finished, click “Save” button to save data. If not, click “cancel” button. After click “Save” button, Message box will be shown and then click “Ok” to continue.
Figure 13.1.7 Order detail page
ThanDar Zin
Page 126
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Update order detail
Please click “Select” word in grid view and update the data and click “Edit” to save the update data. Message box will be shown, click “OK” to continue. The data will be update in grid view. Please viewed the next figure, the change data have the red border.
ThanDar Zin
Page 127
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Delete order detail
Please select the data, that customer want to delete. After selected, customer click “delete” button to clear data. In this figure customer can see that the new data doesn’t exist in this form. 13.1.8. View invoice
Figure 13.1.8 View invoice
ThanDar Zin
Page 128
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
13.1.9. Delivery Page
Figure 13.1.9 Delivery Page
Customer need to fill the delivery information of the product. Update and delete like the order detail figure shown.
ThanDar Zin
Page 129
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
13.1.10. Send feedback In this page, customer can send feedback about the product. After customer insert mail and description finished, click “sent” button.
Figure 13.1.10 Send feedback page
13.1.11. Knowledge of the beauty
Figure 13.1.11 Knowledge of the beauty
ThanDar Zin
Page 130
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
13.1.12. Complaint page
Figure 13.1.12 Complaint page
13.1.13. About us
Figure 13.1.13 about us page
ThanDar Zin
Page 131
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
13.2. Site Map for Staff HomePage
Staff login
Staffregister
Product
Add product
Add product Type
Add supplier
Customer
View customer
View Order
Invoice
Help
Report
Search Order
Daily sales report
Add invoice
weekly customer order status report
View delivery info
Monthly the best sales cosmetic report
Product status list
Figure 13.2 Site Map for Staff
ThanDar Zin
Page 132
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
13.2.1. Home page for staff Firstly staff must login in customer page; staff home page will be shown. Staffs have two
accounts, the first is for all staff, and the second is for only one. When form show needed to click “New” button and fill data detail. After insert data detail finished, click “Save button”. When grid view shown, click “Select” to edit or delete.
Figure 13.2.1 Home page for staff
ThanDar Zin
Page 133
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
13.2.2. Staff register page
Figure 13.2.2 Staff register page
Staff need to fill information, and click “Save” to continue. After click “Save” button, message box will be show. Click “OK” to continue.
ThanDar Zin
Page 134
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Update staff
In this page, staff needs to click “select” word that the information will be filling in textbox. Example: we can see that the staff srcinal name is “kimi” and we will change the name as “kimi John”. Staff can change any information, but only ID is not. Click “Edit” to update information. If not, click “cancel”. After click “Edit”, message box will be shown, click “OK” to continue.
ThanDar Zin
Page 135
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Delete staff
Click “select” word to select the data that staff wants to delete. Example: now I will delete that the data I am insert, name is “kimi”. After click “delete” data will be clear.
ThanDar Zin
Page 136
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
13.2.3. Product page for add product type
Figure 13.2.3 Product page for add product type
13.2.4. Product page for add product
Figure 13.2.4 Product page for add product
ThanDar Zin
Page 137
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
13.2.5. Product page for add supplier
Figure 13.2.5 Product page for add supplier
13.2.6. Customer page for view customer
Figure 13.2.6 Customer page for view customer
ThanDar Zin
Page 138
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
13.2.7. Customer page for view order
Figure 13.2.7 Customer page for view order
13.2.8. Invoice page for search invoice Firstly staff needed to search order where the order does not record in invoice.
Figure 13.2.8 invoice page for search invoice
ThanDar Zin
Page 139
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
13.2.9. Invoice page for add invoice
Figure 13.2.9 Invoice page for add invoice
13.2.10. Invoice page for view delivery info
Figure 13.2.10 invoice page for view delivery info
ThanDar Zin
Page 140
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
13.2.11. Report page for Daily sales report
Figure 13.2.11 Report page for Daily sales report
13.2.12. Report page for weekly customer order status
Figure 13.2.12 Report page for weekly customer order status
ThanDar Zin
Page 141
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
13.2.13. Report page for monthly the best sales cosmetic
Figure 13.2.13 Report page for monthly the best sales cosmetic
ThanDar Zin
Page 142
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
13.2.14. Report page for product status
Figure 13.2.14 Report page for product status
ThanDar Zin
Page 143
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
13.3. Site Map for Manager HomePage
ManagerPage
Manager Login
Staff
Product
Complaint
Report
Add manager
Daily sales report
View staff info
weekly customer order status report
Add department
Monthly the best sales cosmetic report
Help
View complaint
Product status list
Figure 13.3 Site Map for Manager
ThanDar Zin
Page 144
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
13.3.1. Home page for manager Firstly Manager must click “Manager Login” in customer page; Manager home page will
be shown. When form show needed to click “New” button and fill data detail. After insert data detail finished, click “Save button”. When grid view shown, click “Select” to edit or delete.
Figure 13.3.1 Home page for manager
ThanDar Zin
Page 145
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
13.3.2. Staff page for Manager Register
Figure 13.3.2 Staff page for Manager Register
Manager need to fill information, and click “Save” to continue. After click “Save” button, message box will be show. Click “OK” to continue.
ThanDar Zin
Page 146
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Update manager
In this page, Manager needs to click “select” word that the information will be filling in textbox. Example: we can see that the Manager srcinal email name is “KW” and we will change the name as “KwanM”. Manager can change any information, but only ID is not. C lick “Edit” to update information. If not, click “cancel”. After click “Edit”, message box will be shown, click “OK” to continue.
ThanDar Zin
Page 147
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Delete manager
Click “select” word to select the data that manager wants to delete. Example: now I will delete that the data I am insert, email name is “kW”. After click “delete” data will be clear.
ThanDar Zin
Page 148
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
13.3.3. Staff page for view staff info
Figure 13.3.3 Staff page for view staff info
13.3.4. Staff page for Add department
Figure 13.3.4 Staff page for Add department
Manager can add the new department, and fill the data information and click “Save” to insert data. Data will be including in grid view, and likely manager form. It can update and delete too.
ThanDar Zin
Page 149
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
13.3.5. Product page for view product
Figure 13.3.5 Product page for view product
13.3.6. Report page for Daily sales
Figure 13.3.6 Report page for Daily sales
ThanDar Zin
Page 150
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
13.3.7. Report page for weekly customer order status
Figure 13.3.7 Report page for weekly customer order status
ThanDar Zin
Page 151
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
13.3.8. Report page for monthly the best sales
Figure 13.3.8 Report page for monthly the best sales
ThanDar Zin
Page 152
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
13.3.9. Report page for product status
Figure 13.3.9 Report page for product status
13.3.10. Complaint page for view complaint
Figure 13.3.10 Complaint page for view complaint
ThanDar Zin
Page 153
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
A14. Implementation Publish website
ThanDar Zin
Page 154
B.Sc. (Hons.) Business IT Project
ThanDar Zin
Title: Cosmetic wholesale and delivery management system
Page 155
B.Sc. (Hons.) Business IT Project
ThanDar Zin
Title: Cosmetic wholesale and delivery management system
Page 156
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Backup
ThanDar Zin
Page 157
B.Sc. (Hons.) Business IT Project
ThanDar Zin
Title: Cosmetic wholesale and delivery management system
Page 158
B.Sc. (Hons.) Business IT Project
ThanDar Zin
Title: Cosmetic wholesale and delivery management system
Page 159
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Restore
ThanDar Zin
Page 160
B.Sc. (Hons.) Business IT Project
ThanDar Zin
Title: Cosmetic wholesale and delivery management system
Page 161
B.Sc. (Hons.) Business IT Project
ThanDar Zin
Title: Cosmetic wholesale and delivery management system
Page 162
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
Hardware requirement
Processor (Core 2 Duo 2.0 GHz)
Hard Disk free space 5GB
Printer for report
Memory 4GB
Graphic Card RAM 1GB
Monitor resolution 1280 x 800
Optical Drive is CD-ROM RW Drive
Network Card
Software requirement
Microsoft Windows based PC with a minimum Microsoft Windows 7 Home Edition.
Microsoft Visual Studio 2008 for the implementation of the system.
Microsoft SQL Server 2008 or 2005 for database support and implementation.
Microsoft Office word for documentation purpose
Use to the database
Use to the Internet
ThanDar Zin
Page 163
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
A15. Project schedule Source: The frame of the schedule is the supervisor provided and I used the time table. References: Project Schedule and Development Plan
ThanDar Zin
Page 164
B.Sc. (Hons.) Business IT Project
ThanDar Zin
Title: Cosmetic wholesale and delivery management system
Page 165
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
A16. Project plan and performance Sr.
Task
1
Attachment to the Supervisor
Jun
Jul
Aug
Set
Oct
Plan Actual
2
Title discussion/approval
Plan Actual
3
Case study and Proposal
4
Proposed system building
Plan Actual Plan Actual
5
Systems scope/Output approval
Plan Actual
6
Documenting, developing
Plan Actual
7
Draft documentation, system
Plan Actual
8
Final documentation and system
Plan Actual
9
Final System upload
Plan Actual
For title discussion, I am start offer one week later and I take one week more schedule.
For case study and proposal, I am start offer one week later too, because I late in doing for title discussion.
For proposed system building, I am start offer one week later. Because of case study and
proposal finish late. For Documenting and developing, I am start offer one week later, because of proposed system building finish late.
ThanDar Zin
Page 166
Nov
B.Sc. (Hons.) Business IT Project
Title: Cosmetic wholesale and delivery management system
A17. Bibliography Enterprise Networking. (n.d.). Text book. System Development. (n.d.). Text book. B. PAUL, G. ANDREW, H. SIMON, Business Information Systems - Technology, Development and Management (Fourth Edition) (Text Book) Date: July, 12, 2013
ThanDar Zin
Page 167