HOUSE CLEANING SERVICE SYSTEM
'AFFAF BINTI MOGHNI
BACHELOR OF COMPUTER SCIENCE (SOFTWARE DEVELOPMENT) WITH HONOURS
UNIVERSITI SULTAN ZAINAL ABIDIN
2021
HOUSE CLEANING SERVICE SYSTEM
'AFFAF BINTI MOGHNI
BACHELOR OF COMPUTER SCIENCE (SOFTWARE DEVELOPMENT) WITH HONOURS
Universiti Sultan Zainal Abidin 2021
i
DECLARATION
I hereby declare that the report is based on my original work except for quotations and citations, which have been duly acknowledged. I also declare that it has not been previously or concurrently submitted for any other degree at Universiti Sultan Zainal Abidin or other institutions.
_______________________________
'Affaf Binti Moghni
Bachelor of Computer Science
(Software Development) with Honours.
Date:
Affaf Moghni
ii
CONFIRMATION
This is to confirm:
The research carried out and the writing of this report was under my supervision.
_______________________________
Name: En. Abd. Rasid Bin Mamat Date:
iii
DEDICATION
First of all, thank Allah SWT for giving me the chance to finish my final year project, House Cleaning Service System. Thank you also to my supervisor, Mr. Abd. Rasid Bin Mamat, willing to teach and encourage mein order to complete the project.This work is dedicated to my parent, Moghni Bin Israri and Khadijah Binti Abu Samah.It would not have been possible without their support. Do not even forget, my friends and my classmates, thanks to them in helping me finish this project. I acknowledge and appreciate their action to me.
iv ABSTRACT
House Cleaning Service System is a web-based concept system. Lack of time due to busy working schedule causes the cleanliness of the house is often neglected.
Therefore, house cleaning services can assist users to choose the service package that suits their needs and budget. Numerous service packages are provided according to certain criteria including the size of the house and the type of services offered.
Customers may have difficulties in choosing the suitable service packages. Therefore memory-based collaborative filtering will be used to help target customer to choose the appropriate service packages based on previous customers rating and reviews or their similarity preferences. The system consists of two scopes which are customer and admin. The aim and the objectives of this project are to study Collaborative Filtering technique that recommends services to the customers,to design and developed a user- friendly and practical web-based system, as well to test and evaluate the functionality of the developed system. The expected result of the project includes a user-friendly and easy-to-use website that requires no technical expertise. Besides, users can order the desired service online easily using a reliable medium. Therefore, the website is easy to maintain after being developed. Also, the main function of the system is to provide services booking suggestion using the Collaborative Filtering method. In conclusion, technological advances make it easy for users to compare services and make choices suitably and efficiently in the future.
v ABSTRAK
Sistem perkhidmatan pembersihan rumah adalah system berasaskan web.
Kekurangan masa kerana jadual kerja yang sibuk menyebabkan kebersihan rumah sering diabaikan. Oleh itu, system ini dapat membantu pengguna memilih pakej perkhidmatan yang sesuai dengan keperluan dan anggaran bajet mereka. Banyak pakej perkhidmatan disediakan mengikut kriteria tertentu termasuk ukuran (saiz) rumah dan jenis perkhidmatan yang ditawarkan. Pelanggan mungkin menghadapi kesukaran dalam memilih pakej perkhidmatan yang sesuai. Oleh itu, penyaringan kolaboratif berasaskan memori akan digunakan untuk membantu pelanggan memilih pakej perkhidmatan yang sesuai berdasarkan penilaian dan ulasan pelanggan sebelumnya atau kesamaan pilihan mereka. Sistem ini terdiri daripada dua skop iaitu pelanggan dan pentadbir. Tujuan dan objektif projek ini adalah untuk mengkaji teknik penapisan kolaboratif yang mengesyorkan perkhidmatan kepada pelanggan, merancang dan mengembangkan sistem berasaskan web yang mesra pengguna dan praktikal, serta menguji dan menilai fungsi sistem yang dibangunkan. Hasil yang diharapkan dari projek ini merangkumi laman web yang mesra pengguna dan mudah digunakan yang tidak memerlukan kepakaran teknikal. Selain itu, pengguna boleh memesan perkhidmatan yang diinginkan secara dalam talian dengan mudah menggunakan media yang boleh dipercayai. Oleh itu, laman web ini senang dijaga setelah dibangunkan. Fungsi utama sistem ini adalah untuk memberi cadangan tempahan perkhidmatan menggunakan kaedah penapisan kolaboratif.
Kesimpulannya, kemajuan teknologi memudahkan pengguna membandingkan perkhidmatan dan membuat pilihan dengan sesuai dan cekap di masa depan.
vi
CONTENTS
PAGE
DECLARATION i
CONFIRMATION ii
DEDICATION iii
ABSTRACT iv
ABSTRAK v
CONTENTS vi
LIST OF TABLES viii
LIST OF FIGURES x
CHAPTER 1 INTRODUCTION 1
1.1 Project Background 1 1.2 Problem Statement 2
1.3 Objectives 3 1.4 Scope 3 1.5 Limitation of Work 4 1.6 Expected Result 4 1.7 Gantt Chart 5 CHAPTER 2 LITERATURE REVIEW 7 2.1 Introduction 7 2.2 Existing System 7
2.2.1 Maideasy 8
2.2.2 Maid 2 Maids 9
2.2.3 Kilat Kilat Expert Housekeeping Cleaning Services 10
2.2 4 Comparison of the Existing system 11
2.3 Research on Related Technique 12
2.4 Solution Approach 16
2.4.1 Collaborative Filtering 16
2.4.1.1 Similarity Measurements 17
2.4.1.2 Predicting Ratings 18
2.5 Summary 18
CHAPTER 3 METHODOLOGY 19 3.1 Introduction 19 3.2 Iterative Model 19 3.2.1 Planning 20
3.2.2 Analysis & Design 20
3.2.3 Implementation 21
3.2.4 Testing 21
3.2.5 Deployment 22
3.2.6 Evaluation 22
3.3 Hardware and Software Requirement 23
3.3.1 Hardware Requirement 21
3.3.2 Software Requirement 23
3.4 Framework Design 24
vii
3.5 System Design And Modelling 25
3.5.1 Context Diagram (CD) 25
3.5.2 Data Flow Diagram (DFD) 26
3.4.2.1 Data Flow Diagram Level 1 27
3.5.2.1.1 Manage Service 27
3.5.2.1.2 Booking 28
3.5.3 Entity Relationship Diagram (ERD) 29
3.6 Data Dictionary 30
3.7 Summary 32
CHAPTER 4 IMPLEMENTATION AND TESTING 4.1 Introduction 33
4.2 House Cleaning Service System Interfaces 33
4.2.1 Customer Interface 34
4.2.1.1 Customer Login and Sign Up 34
4.2.1.2 Customer Homepage 36
4.2.1.3 Customers Services 37
4.2.1.4 Booking Service 40
4.2.2 Admin Interface 41
4.2.2.1 Admin Login and Sign Up 41
4.2.2.2 Admin Homepage 42
4.2.2.3 Admin Services 43
4.2.2.4 Booking Details 47
4.3 Testing Analysis 48
4.3.1 Sign up 48
4.3.2 Login 49
4.3.3 Customer 50
4.3.4 Admin 51
4.3 Summary 52
CHAPTER 5 CONCLUSION 5.1 Introduction 53
5.2 Contributions 53
5.3 Constraint And Limitation 54
5.4 Future Work 54
5.5 Conclusion 54 REFERENCES
viii
LIST OF TABLES
Table No. Title Page
Table 1.1 Gantt Chart 5
Table 2.1 Systems comparison 11
Table 2.2 Comparison on Related Technique 13
Table 3.1 Table for customer 30
Table 3.2 Table for admin 30
Table 3.3 Table for service 30
Table 3.4 Table for booking 31
Table 3.5 Table for rating 31
Table 4.1 Test Case of Signup Customer 48
Table 4.2 Test Case of Signup Admin 49
Table 4.3 Test Case of Customer Login 49
Table 4.4 Test Case of Admin Login 49
Table 4.5 Test Case of View Service 50
Table 4.6 Test Case of Booking 50
Table 4.7 Test Case of Add Service of Basic Cleaning
51
Table 4.8 Test Case of Update Service of 51
ix Basic Cleaning
Table 4.9 Test Case of Delete Service of Basic Cleaning
52
x LIST OF FIGURES
Figure No. Title Page
Figure 2.1 interface of Maideasy application 8
Figure 2.2 interface of Maid 2 Maids 9
Figure 2.3 interface of Kilat Kilat Expert Housekeeping Cleaning Services
10
Figure 2.4 collaborative filtering method 16
Figure 3.1 Iterative model 20
Figure 3.2 Framework Design 24
Figure 3.3 Context Diagram 25
Figure 3.4 Data Flow Diagram 26
Figure 3.5 Data Flow Diagram Level 1Process 3.0
27
Figure 3.6 Data Flow Diagram Level 1 Process 4.0
28
Figure 3.7 Entity Relationship Diagram 29
Figure 4.1 Main Page of Customer 34
Figure 4.2 Customer Login Page 34
Figure 4.3 Customer Sign Up Page 35
Figure 4.4 Customer Homepage 36
xi
Figure 4.5 How It Works 36
Figure 4.6 Contact us 37
Figure 4.7 Services 37
Figure 4.8 Basic Cleaning Service 38
Figure 4.9 Spring Cleaning Service 39
Figure 4.10 Book Now 39
Figure 4.11 Booking Form 40
Figure 4.12 Main Page of Admin 41
Figure 4.13 Admin Login Page 41
Figure 4.14 Admin Sign Up Page 42
Figure 4.15 Admin Homepage 42
Figure 4.16 Admin Basic Cleaning Service 43
Figure 4.17 Add Basic Cleaning Service 44
Figure 4.18 Edit and Delete Basic Cleaning Service 44 Figure 4.19 Edit Form Basic Cleaning Service 45
Figure 4.20
Delete Pop-up of Basic Cleaning
Service 45
Figure 4.21 Admin Spring Cleaning Service 46
Figure 4.22 Edit and Delete Spring Cleaning Service
46
xii
Figure 4.23 Booking List 47
Figure 4.24 Delete Booking List 47
1 CHAPTER 1
INTRODUCTION
1.1 PROJECT BACKGROUND
Cleaning industry is one of the recession-proof industries. Gradually, house cleaning services are increasingly in demand day by day. A clean-living environment provides comfort and at once impacts on the occupant’s health as well. Cluttered and messy places may impact on mental health as it contributes to stress, anxiety, and poor concentration to the occupants. Similarly, the symptoms of allergies are likely to stem from infrequent house cleaning and ignorant of hygiene. Maintaining the cleanliness and tidiness of the house requires time and energy.
Contrarily, a tight work schedule makes it impossible for homeowners to maintain a clean home at all times. This concern generates idea for developing ‘House Cleaning Service System’. Therefore, house cleaning service system can assist users to choose the service package that suits their needs and budget. Numerous service packages are provided according to certain criteria including the size of the house and the type of services offered. With only few clicks, users can ensure service packages reservation without having difficulty to search for house cleaner manually. Besides, users also can rate and review the service they had chosen in order to guide another user based on each other valuation.
2 1.2 PROBLEM STATEMENT
The idea of developing house cleaning service system is due to some issues.
Considering many households which do not have maid or personal cleaner, house cleaning service system take initiative to offer suitable services to those who wants to spend less but still get the desired cleaning services. The system consequentially saves costs and avoid any possible risk from hired full time house cleaner.
House cleaning service system that is going to be developed specifically concentrated in the area of Sabak Bernam, Selangor district. Besides, online house cleaning service system mostly unserviceable in the areas of Sabak Bernam district.
In addition to that matter, insignificant process still used in order to hire a house cleaner. Some may get information about house cleaners from acquaintances while some may post in social medias about hiring house cleaning personally.
Therefore, house cleaning service need to be developed in order to ease the service reservation.
3 1.3 OBJECTIVES
To study Collaborative Filtering technique that recommends services to users.
To design and developed a user-friendly and practical web-based system.
To test and evaluate the functionality of the developed system.
1.4 SCOPE
1.4.1 User
Register
Login to user home page
View and update profile
View service packages
Reserve service
1.4.2 Admin
Login to admin home page
Create, view, update and delete website information.
Create, view and update service packages
Hide or delete unavailable services
4 1.5 LIMITATION OF WORK
The house cleaning service system has limitation on payment procedure.This system only allows service bookings to be made but the transaction and payment method for the service package that has been selected must be done manually. If users have any query, they need to contact the admin through the information that has been included on the page.
1.6 EXPECTED RESULT
The expected result of the project includes a user-friendly and easy-to-use website that requires no technical expertise. Besides, users can order the desired service online easily using a reliable medium. Therefore, the website is easy to maintain after being developed.
5 Activity
1.7 GANTT CHART
Table 1.1 Gantt Chart
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
Final Year Project 1
Topic discussion with supervisor
Project title proposal Proposal writing
(introduction) Proposal writing (literature review) Proposal progress
presentation Proposal writing
(methodology) Proof of concept
(POC) Drafting report of
proposal Submit draft of report to supervisor Preparation for final
presentation Final presentation Updated final report
Week
6 Activity
submission Final Year Project
2
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
Project discussion with supervisor Project development
Presentation of project progress (50% complete) Project development
(contd) Drafting final project report Project presentation
Refinement of project final report
Project documentation
Binding final project report Final report project submission
Week
7 CHAPTER 2
LITERATURE REVIEW
2.1 INTRODUCTION
A literature review is a category of review article. A comprehensive survey on relevant article journals/articles that relate to the project is conduct which may help in the developing process of house cleaning service system. Essential details will be listed and described concisely. Some existing systems are compared to depict a clear picture and ideas to design a better system in section 2.2. Then, section 2.3 concisely lays forth the comparison and variations of each related technique based on the articles. Finally, in section 2.4 the solution approach using Collaborative Filtering technique will be explained in detail.Briefly, the literature review helps enhance the understanding of the knowledge on the associated topic and at once identify the gaps of the existing system for improvement.
2.2 EXISTING SYSTEM
The existing systems may be associated with the system that is going to be developed.
Accordingly, those existing systems are Maideasy application, Maid 2 Maids website and Kilat Kilat Expert Housekeeping Cleaning Services website.
8 2.2.1 Maideasy (Maideasy, n.d.)
Azrul Rahim, CEO of Maideasy met with the founder, Bee Bee Sim late of 2014. Both are aware of the gap in the cleaning industry in Malaysia. Accordingly, Maideasy established. Recently, this system only allows users to book services through the application. They no longer receive any booking from the website. Users need to download the application and login to fill in the required personal information including contact details, home location and preferred type of cleaning before making a reservation. The app will notify users once a cleaner accepted the booking.
Figure 2.1 interface of Maideasy application
9 2.2.2 Maid 2 Maids (Maid2Maids, n.d.)
Maid2Maids incorporated on 11 October 2019. They provide well-trained cleaner to the customer's doorstep in Klang Valley. Its price ranges vary based on location and service hours. Users can use an existing Facebook account or create a new account to log in. Maid2Maids renders different service packages according to user needs. Users can choose the desired services by clicking on the service needed. Then, the system will be automatically adding those services in the cart. To complete the reservation, users have to fill in the delivery address and choose the day and date on check out page.
Figure 2.2 interface of Maid 2 Maids
10
2.2.3 Kilat Kilat Expert Housekeeping Cleaning Services (KilatKilat, n.d.)
Kilat Kilat commenced the business service back in 2009. Therefore, it has amassed vast experience in managing cleanliness and hygiene over the years. They provide dedication cleaner to achieve the promised level of cleaning. Besides, Kilat Kilat comes with an exclusive time slot where users can specify regular cleaning sessions according to their schedule. Fortunately, they also allow users to make last-minute changes up to two times every month to the reserved time slots. Users need to fill out personal information in the form to book desired services and they will reach the users via WhatsApp within 24 hours.
Figure 2.3 interface of Kilat Kilat Expert Housekeeping Cleaning Services
11 2.2 4 Comparison of the Existing system
This section summarizes the comparison of existing systems based on the logo, coverage areas of the service, system overview, the limitation of the system and the method used to present the system.
Company Maideasy Maid 2 Maids Kilat Kilat
Logo
Coverage Areas
Shah Alam
Petaling Jaya
Bangsar
Ampang
Hartamas &
Mont Kiara
Johor Bahru
Areas in Klang Valley
Taman equine
Puncak jalil
cover the entire Klang Valley areas
System Overview
Book service after log in
Notified once a cleaner accepted the booking
Choose by clicking on the services
Add chosen services in the cart
Check out to book
Reservation confirmation via Whatsapp
Limitation Only allow booking in the application
Poor user interface design
The system does not carry the whole booking procedure
Method Application for Android
Web-based system
Web-based system Web-based system
Table 2.1 Systems comparison
12 2.3 RESEARCH ON RELATED TECHNIQUE
Three related articles have been reviewed for further information on the related techniques. (Jena et al., 2017) carried out a study on the principles, techniques and evaluation of recommendation system. The paper explores the potentials and the different features of collaborative filtering and content-based filtering techniques concerning them as the compass for research and practice in the area of recommendation systems. (Raghuwanshi & Pateriya, 2019)introduce researchers and practitioner with distinct characters of possible filtering techniques applied in the recommendation systems. The filtering techniques discussed are collaborative filtering, content-based filtering, knowledge-based filtering and hybrid filtering.
Meanwhile (Lumauag et al., 2019) conducted a research on an enhanced memory- based collaborative filtering algorithm based on user similarity for recommender systems. Results of the study clarify that an enhanced memory-based collaborative filtering algorithm based on user similarity was established to overcome data sparsity issues.Hence, the differences and similarities of the articles are summarized in Table 2.2.
13
Table 2.2 Comparison on Related Technique
Author Title Objective Method Advantage/Result Limitation
Kartik Chandra Jena,
Sushruta Mishra, Soumya Sahoo,
Brojo Kishore Mishra
(2017)
Principles, Techniques and Evaluation of Recommendation Systems
Explore Collaborative Filtering and Content- based Filtering characteristics and its potentials in
recommendation systems.
Collaborative Filtering
- Easy implementation.
Search databases of similar users to recommend items for the active user based on their previous rating on items.
Only recommend items that have been previously rated (First Rater)
Content-based Filtering
- Based on the item's content (information) instead of another user's view
Hard to learn user preference as user need to explore
various items
14 Sandeep K.
Raghuwanshi and R. K.
Pateriya (2019)
Recommendation Systems:
Techniques, Challenges, Application, and Evaluation
Introduce features of possible filtering techniques in recommendation systems to the researchers and practitioner.
Collaborative Filtering (Memory-based)
- Use neighbord-based method approach where user profile and item features are unnecessary.
- Need user preferences to recommend items - Sparsity issue (few ratings values in user–
item metric) cause system performance decrease/poor
prediction.
Content-based Filtering
- Recommend new items through indirect and direct feedback of users
-Static. May produce and recommend similar results to users
Knowledge- based filtering
- Manage new user case or cold start issue and enhanced personalized prediction
- Requires external domain specific knowledge
- high-cost and complex technique.
Hybrid filtering - More reliable recommendation as it combines at least two filtering techniques
- high-cost and complex technique.
Ramil G. An Enhanced To improve the Collaborative - The proposed algorithm - It uses the entire
15 Lumauag,
Ariel M. Sison, Ruji P. Medina
(2019)
Memory-Based Collaborative Filtering
Algorithm based on User Similarity for
Recommender Systems
algorithm used in memory based collaborative filtering by identifying the co- rated items
of active and similar users
Filtering (Memory-based)
has a small prediction error and better
recommendation quality compared to the
traditional algorithm
- resolve the data sparsity issues (Users not rate most of the items)
database every time it
predicts and
recommends items which lead to slow performance
16 Collaborative
Filtering
Memory-Based Model-Based
User-Based Item-Based 2.4 SOLUTION APPROACH
The possible approach that will be implemented in the system is the Collaborative Filtering technique.
2.4.1 Collaborative Filtering
A recommender system is an information filtering system. Collaborative Filtering (CF) is one of the most used recommendation technique.(Raghuwanshi & Pateriya, 2019) The memory-based method and model-based method are two collaborative filtering methods. Meanwhile, Memory-based Collaborative Filtering consists of two methods: user-based and item-based. Therefore, House Cleaning Service System applies the user-based Collaborative Filtering technique. It uses the entire user-item database to identify users that are similar to the active user which have similar ratings for similar items (service packages) and uses their preferences to predict ratings for the active user.
17
Figure 2.4 collaborative filtering method
Generally, model-based recommender learns the user's preferences by relying on the previous interactions of the user and establishing a user profile. While memory-based recommender based on similar users and items. Hence,a product is compared to other products in an item-based approach. The more similar the interactions of customers between these two products are, the more they suit seamlessly. In the user-based approach, instead of comparing products, customers are compared with each other.
2.4.1.1 Similarity Measurements
Similarity measurement used to compute users’ similarities:
2.4.1.1.1 Pearson Correlation Coefficient
Pearson Correlation Coefficient determines the linear correlation between the two variables X and Y and has a value between −1 and 1. It determines the correlation of the users. Value 1 indicates they both rate in the same manner, while value -1 means that they rate items exactly opposite
18 2.4.1.2 Predicting Ratings
p (a,i) is the prediction rating of the target user a for item i w (a,u) is the similarity of both users a and u
K is the number of neighbors of most similar users.
To predict an item rating for an active user, we need to obtain all weights between the active user and all other users (neighbors). Then, the weighted average of deviations from neighbors mean is added to the active user's mean rating. Once the most similar users are decided, the prediction rating is measured to generate the recommended items to the active user.
2.5 SUMMARY
In short, this chapter summed the overview of the concept of a system. Significantly, the literature review is an imperative part as it helps in deciding the appropriate methodology that will be implemented in the proposed system. Therefore, House Cleaning Service System applies the user-based Collaborative Filtering technique where the main function of the system is to provide services booking suggestion using the Collaborative Filtering method based on users that have similar ratings for similar items.
19 CHAPTER 3
METHODOLOGY
3.1 INTRODUCTION
A methodology is used to develop a system. It defines the steps involved in the software development process. It is necessary to ensure that the implementation of the framework is achieved systematically and effectively. The proposed system, therefore, uses Iterative Methods as guidelines to develop it.
3.2 ITERATIVE MODEL
The iterative model is the repetition incarnate of the processes. It applies the concept of incremental development which defines the incremental changes made during the design and implementation of each new iteration.
20
Figure 3.1 Iterative model
3.2.1 Planning
Planning is the first phase of the iterative model. At this point, the project title was chosen: House Cleaning Service System. The problem statements of the system are identified through brainstorming. Meanwhile, the expected outcome would be regarded as achievable. Gantt chart will be needed as the guideline and references for the project. Besides, in this phase, project requirements needed to design and develop the system are specified. Based on the information gathered through articles, suitable method and technique for the system have been decided.
3.2.2 Analysis & Design
In this phase, every requirement identified is analysed for more understanding.
Diagrams constructed to show the flow of the system include Context Diagram (CD), Data Flow Diagram (DFD) Level 0 and 1, Entity Relationship Diagram (ERD).
21 3.2.3 Implementation
Codes will be implemented in the real system during this phase based on the dataflow and data model. User interfaces are included in this phase to deliver information to the user following the Human-Computer interaction guidelines. Accordingly, the house cleaning service system will be develop using Xampp server for the database and NetBeans to code using Java programming language. JSP language will be used to link the database and the web-based system using MySQL as the platform for the database. Collaborative Filtering method will be implemented to provide services booking suggestion to customers.
3.2.4 Testing
After the implementation of the code, further testing will be carried out to test the smoothness of the house cleaning service system. Testing will be done to detect any defects that might lead to project failure and to ensure that the functionality of the system is running well.The system will be tested throughunit testing, which used the white-box testing technique to test every module of the system. Then, the house cleaning service system will go through the integration testing which used the black box testing to test the integrated modules. Thus, black box testing will simulate the end-user experience to book the service offered. The testing occurs throughout the software development and Testing Life Cycle of the house cleaning service system to test the overall functionality.
22 3.2.5 Deployment
This stage needs to get the project ready for the end-user to use the system practically after the bugs and defects spotted during the test phase are removed. User will use it to make sure the system is precisely well functioning or not. The booking and rating feature of the house cleaning service system should work well to ensure satisfactory results for the project.
3.2.6 Evaluation
The final phase is the evaluation phase. The system that has encountered the deployment phase will be presented to the user. The user will evaluate the house cleaning service system, thus, all the feedback received gathered helps to improve the system. This phase will follow-up with the user to enhance the system to the better version in the future either in terms of features or functions of the house cleaning service system.
23
3.3 HARDWARE AND SOFTWARE REQUIREMENT
3.3.1 Hardware Requirement
Laptop: HP 15t-dy100
Operating System: windows 10
Processor: Intel 15 8th gen
RAM: 4GB
System type: 64-bit Operating System
3.3.2 Software Requirement
NetBeans
MYSQL
Xampp server
Edraw Max
Snipping Tool
Microsoft OfficeWord
24 3.4 FRAMEWORK DESIGN
Figure 3.2 presents the framework of House Cleaning Service System. It shows the process flow of what users can do with the system. Customer can register and log into the system, book the available service and rate the package after the completion of the service. While admin or the owner of the company can log in, manage the services in the system and manage booking of the customers.
Figure 3.2 Framework Design
25 3.5 SYSTEM DESIGN AND MODELLING
3.5.1 Context Diagram (CD)
Figure 3.3 Context Diagram
Figure 3.2 show the context diagram of the proposed system. This system involves two main entities which are customer and admin. Customer is able to register and login, search service package, request service booking and rate services. On the other hand, admin can log into the system, provide services info, update service availability and approve service booking.
26 3.5.2 Data Flow Diagram (DFD) Level 0
Figure 3.4 Data Flow Diagram
Figure 3.3 shows the main process and functions in the system. Five main activities are involved in the proposed system which are register, login, manage service, book andgive rating.Along with it, the entities involved are customer and admin. There are five different data stores, D1, D2, D3, D4 and D5. D1 stores all customers details and information. Whereas, D2 stores all the admin details.D3 records all data regarding the services.D4 records service booking information and D5will store rating details of the service.
27 3.5.2.1 Data Flow Diagram Level 1
3.5.2.1.1 Manage Service
Figure 3.5 Data Flow DiagramLevel 1 Process 3.0
Figure 3.3 illustrates the service management process. Admin will be able to add service info, delete service, update service details, and view services.
28 3.5.2.1.2 Booking
Figure 3.4 explains the flow of the booking process. Admin will be able to delete booking, update booking details include approving the booking status, and view the bookings made.
Figure 3.6 Data Flow DiagramLevel 1 Process 4.0
29
Rating
3.5.3 Entity Relationship Diagram (ERD)
Figure 3.7 Entity Relationship Diagram
Figure 3.5 showsthe ERD of the house cleaning service system which consists five tables.There are Customer, Admin, Service, Booking and Rating.Therefore, each table has its own attributes and id as the primary key.
30 3.6 Data Dictionary
Table 3.1 Table for customer
Name Type Null Comment
Cust ID Varchar (100) No Primary Key
Password Varchar (100) No
Cust_Name Varchar (100) No
Cust_Email Varchar (100) No
Cust_Phone Int (15) No
Address text No
Table 3.2 Table for admin
Name Type Null Comment
Admin ID Varchar (100) No Primary Key
Password Varchar (100) No
Table 3.3 Table for service
Name Type Null Comment
Service ID Varchar (100) No Primary Key
ServiceName Varchar (100) No ServiceCategory Varchar (100) No
Price Int (100) No
31
Table 3.4 Table for booking
Name Type Null Comment
Book ID Varchar (100) No Primary Key
Cust_ID Varchar (100) No Foreign key referencecustomer
Deposit Int (100) No
BookingStatus Varchar (20) No
BookingDate date No
Service_ID Varchar (100) No Foreign key reference service
Table 3.5 Table for rating
Name Type Null Comment
Rating ID Varchar (100) No Primary Key
Cust_ID Varchar (100) No Foreign key referencecustomer Service_ID Varchar (100) No Foreign key reference service
Rating Int (5) No
32 3.7 SUMMARY
This Chapter discussed the methodology, hardware and software requirement to develop this system. Every phase in the method used was explained deeply as it is crucial to choose the right methodology to fulfil the system requirement which can influence the development process. Furthermore, the design and framework of the system also were discussed to ensure the system can be thoroughly developed.
33 CHAPTER 4
IMPLEMENTATION AND TESTING
4.1 INTRODUCTION
This chapter will be presenting the implementation of the House Cleaning Service system. The output of the system engages the logical design into the physical design that can be applied by the end-user. The House Cleaning Service system was customized to suffice the functional requirement. Problem analysis, software installation and configuration, hardware setup, testing the system that has been built, and system deployment are all part of the process while developing the system.
4.2 HOUSE CLEANING SERVICE SYSTEM INTERFACES
Designing the application is one of the processes involved in developing the House Cleaning Service system. For the purpose of the website, functionalities are implemented. This section will display all the interfaces in the House Cleaning Service system. Amongst the interfaces are the user interfaces and admin interfaces.
34 4.2.1 Customer Interface
4.2.1.1 Customer Login and Sign Up
Figure 4.1 Main Page of Customer
Figure 4.1 is the main page of the system. Either customer or admin will be directed to the page as they need to log in before accessing the homepage.
Figure 4.2 Customer Login Page
35
Figure 4.2 shows the login form for customers. They need to enter a username and password that has been registered before clicking on the login button at the bottom of the form.
Figure 4.3 Customer Sign Up Page
Customers who do not have an account can register or sign up for a new account before login as depicted in figure 4.3. Customers are required to fill in the registration form. They need to enter the username, phone number and password. Passwords have to be inserted twice in order to confirm the same password entered. Sign up button will be disabled if the password does not match.
36 4.2.1.2 Customer Homepage
Figure 4.4 Customer Homepage
Figure 4.4 shows the page that will be redirected to customers after successful login.
Customers can be located on the other page by clicking on any option on the navigation bar.
Figure 4.5 How It Works
37
Figure 4.6 Contact us
Besides, figure 4.5 and figure 4.6 show customers who want to know more information related to the website can click on how it works and contact us found in the navigation bar at the top of the main page.
4.2.1.3 Customers Services
Figure 4.7 Services
38
Figure 4.7 illustrates the two main services in the House Cleaning Service System which are Basic Cleaning and Spring Cleaning. Ergo, each service contains a few packages. Customers can view the details of the packages by clicking on the desired service.
Figure 4.8 Basic Cleaning Service
Figure 4.8 displays lists of Basic Cleaning service packages in detail including the service ID, the service name, the service duration and the price of each service. By clicking on the icon in the details row, customers will be able to view the precise details of the package they choose
39
Figure 4.9 Spring Cleaning Service
Figure 4.9 displays lists of Spring Cleaning service packages in detail including the service ID, the service name, the service condition and the price of each service.
Customers will be able to view the precise details of the package they choose by clicking on the icon in the details row.
Figure 4.10 Book Now
40
If they are interested, they can book the package by clicking `BOOK NOW` at the bottom of the page as shown in figure 4.10.
4.2.1.4 Booking Service
Figure 4.11 Booking Form
Figure 4.11 shows the booking form to book any package from the services.
Customers are ought to fill in and provide the information needed in the form. They need to insert the name, email, phone number, address and the booking date of the particular package.
41 4.2.2 Admin Interface
4.2.2.1 Admin Login and Sign Up
Figure 4.12 Main Page of Admin
Figure 4.12 illustrates that admin will be directed to the main page before accessing the homepage. They need to login by clicking on the `Login For More` button.
Figure 4.13 Admin Login Page
42
Figure 4.13 shows the login form for admin. Admin need to enter a username and password that has been registered before clicking on the login button at the bottom of the form.
Figure 4.14 Admin Sign Up Page
Figure 4.14 displays an admin sign up page where new admin will be registered by entering the required details.
4.2.2.2 Admin Homepage
Figure 4.15 Admin Homepage
43
Admin will be redirected to the admin homepage after successful login as shown in Figure 4.15. The options available on the navigation bar are home, services, booking details and contact us.
4.2.2.3 Admin Services
Figure 4.16 Admin Basic Cleaning Service
Figure 4.16 displays lists of available Basic Cleaning service packages in detail.
Admin also can delete or remove unavailable service or edit any information related to the particular service by clicking on the icon in the details row.
44
Figure 4.17 Add Basic Cleaning Service
Admin is able to add a new service package as in figure 4.17. Few details need to be entered include service name, the time the service will start, the time the service will be end and the price of the service.
Figure 4.18 Edit and Delete Basic Cleaning Service
45
Figure 4.18 shows the page where the admin needs to click on the blue button to edit or update details of the particular service package while the red button will allow the admin to delete or remove the package.
Figure 4.19 Edit Form Basic Cleaning Service
Admin can edit or update any detail of the service package in the page and submit the changes as shown in figure 4.19.
Figure 4.20 Delete Pop-up of Basic Cleaning Service
46
While figure 4.20 depicts a pop-up for delete service package confirmation before the data of the package will be deleted permanently.
Figure 4.21 Admin Spring Cleaning Service
Figure 4.21 displays lists of available Spring Cleaning service packages in detail.
`ADD SERVICE` button allows the admin to add a new service package of Spring cleaning Service. Admin can click on the icon in the details row to display the other page that grants admin to edit or delete a particular package.
Figure 4.22 Edit and Delete Spring Cleaning Service
47
Figure 4.22 shows the page that grants admin to edit or delete the particular service package.
4.2.2.4 Booking Details
Figure 4.23 Booking List
Figure 4.23 displays a customer booking list where admin can view and delete customers that had booked the services.
Figure 4.24 Delete Booking List
48
Admin is granted to delete any customer booking information. A pop-up message will appear after the admin deletes the particular customer.
4.3 TESTING ANALYSIS
Test analysis is the process of inspecting and analysing the system after being developed to create test cases. The goal of test analysis is to collect requirements and define test objectives so that test conditions can be established. The process of executing test cases helps to discover problems in input, action or event and expected response to ascertaining the system is functioning properly. The table below shows the test cases for several of the processes of the House Cleaning Service System.
4.3.1 Sign up
Table 4.1: Test Case of Signup Customer
Step Procedure Expected Result Pass/ Fail
1 Click on “Register Now” link Directed to sign up form Pass 2 Enter the following details:
Username: Aina Nasha Phone Number: 01113351982 Password: 12345678
Password: 12345678
Sign up successful and customer will redirect to login page
Pass
3 Click “Sign up” button Data save into the database Pass
49
Table 4.2: Test Case of Signup Admin
Step Procedure Expected Result Pass/ Fail
1 Click on “Register Now” link Directed to sign up form Pass 2 Enter the following details:
Username: NewAdmin Password: 12345
Sign up successful and admin will redirect to login page
Pass
3 Click “Sign up” button Data save into the database Pass
4.3.2 Login
Table 4.3: Test Case of Customer Login
Step Procedure Expected Result Pass/ Fail
1 Go to login page Login page loaded Pass
2 Enter the following details:
Username: Aina Nasha Password: 12345678
Match input with the database
Pass
3 Click “Login” button Login successful.
Redirecting to the customer homepage.
Pass
Table 4.4: Test Case of Admin Login
Step Procedure Expected Result Pass/ Fail
1 Go to login page Login page loaded Pass
50 2 Enter the following details:
Username: admin Password: 12345
Match input with the database
Pass
3 Click “Login” button Login successful.
Redirecting to the admin homepage.
Pass
4.3.3 Customer
Table 4.5: Test Case of View Service
Step Procedure Expected Result Pass/ Fail
1 Click on “Services” navigation bar
Basic Cleaning page loaded Pass
2 click on “Basic Cleaning” Display lists of Basic Cleaning service packages from the database
Pass
Table 4.6: Test Case of Booking
Step Procedure Expected Result Pass/ Fail
1 Click on “BOOK NOW” button Directed to booking form Pass 2 Enter the following details:
Name: Sarah Ali
Email: [email protected] Phone Number: 01234567899 Address: No.7, Kampung Bunga,
Place booking successful and customer will redirect to service page
Pass
51 Sabak Bernam
Booking Date: 02/07/2021
3 Click “Place Booking” button Data save into the database Pass
4.3.4 Admin
Table 4.7: Test Case of Add Service of Basic Cleaning
Step Procedure Expected Result Pass/ Fail
1 Click on “ADD SERVICE”
button
Directed to add service form Pass
2 Enter the following details:
Service Name: Promo Service Start: 08:00:00 Service End: 16:00:00 Price (RM): 100.00
Add service successful and admin will redirect to service packages list page
Pass
3 Click “Submit” button Data save into the database Pass
Table 4.8: Test Case of Update Service of Basic Cleaning
Step Procedure Expected Result Pass/ Fail
1 Click on “EDIT” button Directed to update service form
Pass
2 Edit the following details:
Service Name: Limited Promo Service Start: 08:00:00
Service End: 15:00:00
Update service successful and admin will redirect to service packages list page
Pass
52 Price (RM): 99.99
3 Click “Submit” button Updated data save into the database
Pass
Table 4.9: Test Case of Delete Service of Basic Cleaning
Step Procedure Expected Result Pass/ Fail
1 Click on “REMOVE” button Pop-up message to confirm deletion
Pass
2 Click on “OK” button Delete service successful and admin will redirect to service packages list page
Pass
4.3 SUMMARY
Eventually, all of the interfaces detailed the system's operations and flow. This phase allowed for testing to see if the system had been created to the point where it could operate without issue as the testing method is applied to test the functionality of the system on every main module in the system.
53 CHAPTER 5
CONCLUSION
5.1 INTRODUCTION
This chapter will cover the project's conclusion and review for the whole of this project. All the details can be exerted into consideration to enhance the system for upcoming use.
5.2 CONTRIBUTIONS
The House Cleaning Service System has been developed respectively for areas concentrated in Sabak Bernam district, Selangor district because cleaning services in this area are very few and beforehand residents could not book these services online.
Hence, the House Cleaning Service System has been designed as a user-friendly and practical web-based system. In brief, some of the objectives have been successfully achieved but there are still many shortcomings that need to be improved in the future.
54 5.3 CONSTRAINT AND LIMITATION
Since the system is nevertheless in the development and improving stage, some of the requirements of the system are not accomplished. The booking procedure is still lacking. Admin is supposedly able to send email or message to the customer to notify the confirmation or rejection of the service but as for now, admin will manually inform the customers.
5.4 FUTURE WORK
The House Cleaning Service System requires a lot of improvement to assure the functionality of the system work to the fullest. Admin must be able to notify confirmation or rejection to customers through the website and customers also should be able to book more than one service at the same time.
5.5 CONCLUSION
In conclusion, The House Cleaning Service System is an easy-to-use website that enables customers to order the services available online. The system has two user scopes i.e admin and customer where each of the elements needs to be improved for the better as technology is always improving and moving forward.
55 REFERENCES
1. Jena, K. C., Mishra, S., Sahoo, S., & Mishra, B. K. (2017). Principles, techniques and evaluation of recommendation systems. Proceedings of the International Conference on Inventive Systems and Control, ICISC 2017, January.
https://doi.org/10.1109/ICISC.2017.8068649
2. KilatKilat. (n.d.). https://www.kilatpro.com/
3. Lumauag, R. G., Sison, A. M., & Medina, R. P. (2019). An enhanced memory-based collaborative filtering algorithm based on user similarity for recommender systems.
International Journal of Recent Technology and Engineering, 7(6), 778–782.
4. Maid2Maids. (n.d.). https://www.maid2maids.com/
5. Maideasy. (n.d.). https://www.maideasy.my/
6. Raghuwanshi, S. K., & Pateriya, R. K. (2019). Recommendation systems:
Techniques, challenges, application, and evaluation. Advances in Intelligent Systems and Computing, 817, 151–164. https://doi.org/10.1007/978-981-13-1595-4_12
