Waves of Boracay Website submitted by Team Leader: Cristina Ubaldo Team Members Katrina Dee Rhochella dela Cruz Madelaine Mapile
A Software Engineering Project
Submitted to
Mr Joel Pira March 21, 2009
Table of Contents I.
Introduction................................................................................. 5
II.
Project Background........................................... .............................6
III.
Requirements Analysis.................................... ..............................7
Analysis Model............................................................. ............10 Scenario-Based Model.............................................. ...................10 i. UML Activity Diagram............................................................................10 ii. Swimlane Diagram.................................................................................16 B. Class-Based Models............................................................ ........45 i. Class Diagram......................................................................................45 C. Behavioral Models............................................... ......................47 i. Sequence Diagram.................................................................................47
IV. A.
V.
Design Model............................................................................ ..49 A. Data Design.................................................. ......................50 B. Architectural Design......................................................... ..........51 C. Interface Design.................................................................. ......60 D. Component-Level Design.................................................... ..........74 E. Deployment-Level Design.............................................................76
VI. A. B. C.
Product Scope........................................................... ...............77 Context..................................................... ............................77 Informational Objective.............................................. .................78 Function and Performance.......................................... ..................78
VII. A. B.
Software Team........................................ .................................79 Profile.................................................................................. .79 Capability.............................................. ................................80
VIII. A.
Estimation................................................................. .............80 Function-Based Estimation.......................................................... ..80
IX. A.
Schedule........................................................... .....................82 Gantt Chart................................................. ...........................82
X.
Software Testing............................................... .....................85
XI. Risk Management.......................................................... .......172 XII. I. II.
Deployment................................. .....................................178 System Configuration........................................................178 Client Testing Procedure....................................................180
XIII.
Conclusion........................................... .............................184
IX. Index.......................................................... ............................185
2
Figure 28 - Class Diagram of Administrator................................................................47 Figure 46 - Waves of Boracay View Product in Category................................................66 Figure 58 - Gantt Chart (Continuation)......................................................................84
3
I. Introduction E-commerce serves to be one the most effective marketing and business strategy in today’s Internet driven society. What better way to get your business discovered other than having a website specifically for your store? E-commerce sites provide a service of an online shopping experience with only a click on the mouse. A student from University of Asia and the Pacific wishes to take his handicraft business to a higher level. He aims to export handicrafts products both locally and internationally. Despite already having the store located in Robison’s Ermita, he believes that a store website is necessary promote and sell his products. This e-commerce site made especially for Mr. Daniel Cleak's business will basically provide an online shopping experience for public viewers and site members. It feels as if you are actually shopping in the real store. It will provide a gallery of all handicraft products and 4
its details. A search engine will help viewer check product availabilities and specifications. Members have the privilege to purchase the product they have added, deleted, or edited in their own shopping carts. This site is linked with secured payment systems such as PayPal. (Katrina Dee and Rhochella dela Cruz)
II. Project Background The client of the group is Daniel Cleak, owner and manager of the Waves of Boracay gift shop. The business primarily sells local handcrafted products that are mainly made out of Capiz shells. However, the products are not just limited to Capiz shell products; the business also sells native jewelries from Cebu, made from Filipino indigenous materials like straws, shells, wood, nuts, etc. The target market of the business is not limited to the OFW's, tourists, and foreigners, but it is open for anyone who is likely interested to the products. The Waves of Boracay gift shop currently has no other way of commercializing the business, but the store itself. Mr. Cleak told the group that he has been looking for an I.T. professional who can produce a website to attract foreign buyers and other possible customers for his business. The project team will be developing a website for the Waves of Boracay gift shop. This website features online buying, where the products of the shop is categorized, which can be easily searched. The site also features a shopping cart for its customers. The only 5
restriction that the website has is that only members can purchase the products. The nonmembers can use the shopping cart, but can no longer purchase them. (Cristina Ubaldo)
III.Requirements Analysis The use-case diagram contains actors and use-cases. Actors are entities that interact with the system. They can be human users or other machines or systems that have defined interfaces to the software. Use cases are collections of user scenarios that describe the thread of usage of a system.
6
Figure1 - Public User Use Case Diagram
Figure 2 contains the use-case diagram of the actor, public user. Public users are unregistered members that visit the site. These users can search for products and can view all the products’ information.
Public users can add products and delete products from the
cart even if they haven’t even registered yet. When the public users proceed to checkout, they will be asked to sign in with their email address and password if they are already a member or sign up to make an account. (Katrina Dee
7
Figure 2 - Member Use Case Diagram
Figure 3 shows the use case diagram of the actor, member. Members are registered users of the site. The email address, password, full name, address and contact number of each member are already saved in the website’s database. Only a registered member can proceed to checkout and purchase the item. When the member proceeds to checkout, he confirms his delivery address ad his purchase on the items in his cart. (Katrina Dee)
8
Figure 3 - Administrator Use Case Diagram Figure 4 shows the use case diagram of the actor, administrator. The administrator manages all the activities in the website. Only the administrator can add a new product, delete a product and edit a product from the website’s database. The admin can also view member, edit member, delete member and search member. The administrator can also manage and view the orders in the website. He can view order delete order and search for orders. (Katrina Dee
IV. Analysis Model A. Scenario-Based Model 9
i.
UML Activity Diagram
Figure 4-
Administrator Activity Diagram
10
The Activity Diagram provides a representation of the procedural flow of all userrelated functions that are applicable in the site. This diagram includes all the administrator functions that an administrator has an access to. An administer can perform all these activities once he is signed in with his valid username and password. In the Admin Home, the administrator can edit, maintain, delete, add, view and check the different modules presented in this activity diagram. (Rhochella dela Cruz)
11
Figure 5 – Member Activity Diagram
12
The Member Activity Diagram provides a representation of the procedural flow of all user-related functions that can be accessed by members only. This diagram includes all the member function modules that mostly require the member to successfully sign in. The buy product module is one of the functions that only registered and signed in members can access. A complete checkout process is prohibited if the user is only a Public User. The viewing of basket and searching are some of the functions that are shared by both Public User and members. Only members have access to their Profiles and Order History. The links for these features and functions can only be accessed if the member is signed in. They get to benefit from more functions in contrast to the limited functions that Public Users only have access to. (Rhochella dela Cruz)
13
Figure 6 - Public User Activity Diagram
The Public User Activity Diagram represents all the activities that a Public User can perform as he broses the site. If he wished to purchase a product, he would have to become a member first, he can do this using the registration function. He can also manage his own Shopping basket but he would not be able to purchase it. He is free to browse all the links in the site. (Rhochella dela Cruz) 14
ii.Swimlane Diagram Swimlane Diagram represents the flow of activities described by the use-cases by indicating the main controllers that are responsible in the performing or receiving the activity rectangles. In
this
system,
the
main
controllers
who are
involve
in performing or
receiving the functions and activities are the Administrator, Public User, and Members. Each lane represents the process that belongs to the respective controller. The controller is in charge of executing the process and activities contained in its specific grouping. (Rhochella dela Cruz)
ADMINISTRATORISTRATOR MANAGE PRODUCTS MODULE 15
Figure 7 -Administrator Adds Product Function
The administrator logs in with his username and password. The administrator manages the table of products in the database. He is in charge of adding the products, product details and upload pictures of each item. All these added products will appear in the site’s gallery.
16
Figure 8 - Administrator Searches for Product Function
One of the privileges of the administrator is that he is able to search for the products. Once he is successfully logged in using his valid username and password, he is directed to the Administrator Page. The Administrator Page provides a product search engine, where the administrator can input product keywords such as the Product Name. If there are available products, 17
the page is directed to the Product Inventory Page that will display results of the search along with the product details.
18
19
Figure 9 - Administrator View, Edit, Delete Product Function
Given that the administrator is successfully signed in with his valid username and valid password, he can view all the products in the database. This includes viewing each product’s details and image. The View Product link is clicked to display the Product Inventory. Along with this, two functions are connected with each product, Delete product and Edit product. At the end of each product entry, the Delete and Edit links are provided in case the administrator wants manage the specific product. Using the Edit Product function, the administrator edits the product details or changes the uploaded picture as requested by the storeowner. All changes in the database will be reflected in the actual site. Using the Delete Product function, the administrator manages the table of products in the database. Besides being in charge of adding the products, part of managing the product data table is being able to delete unwanted or unavailable products. The storeowner will be the one to decide which products are to be deleted, added, and edited.
20
MANAGE CATEGORIES MODULE
Figure 10 - Administrator Adds Category Function
The administrator logs in with his username and password. The administrator is the only user who can add a category in the database. The administrator will have to enter the category name and upload the category’s image. All products sold in the site are grouped in a specific category. 21
Figure 11 - Administrator View, Edit, Delete Category
Given that the administrator is successfully signed in with his valid username and valid password, he can view all the categories in the database. 22
This includes viewing each category’s details and image. The View Category link is clicked to display the Categories list. Along with this, two functions are connected with each category, Delete category and Edit category. At the end of each category entry, the Delete and Edit links are provided in case the administrator wants manage the specific product. Using the Edit Category function, the administrator edits the category details or changes the uploaded picture as requested by the storeowner. All changes in the database will be reflected in the actual site. Using the Delete Category function, the administrator manages the table of categories in the database. Besides being in charge of adding the categories, part of managing the category data table is being able to delete unwanted or unavailable category. The storeowner will be the one to decide which category are to be deleted, added, and edited. (Rhochella dela Cruz)
ADMINISTRATORISTRATOR MANAGE ORDERS MODULE
23
Figure 12 - Administrator Search Order Function
One of the privileges of the administrator is he is able to search for the orders of the members. This is easier than viewing all the orders using the View Order link.. Once he is successfully logged in using his valid username and password, he is directed to the Administrator Page. The Administrator Page provides a order search engine, where the administrator can input order number as keyword. If there are available order corresponding to that 24
keyword,, the page is directed to the Orders Page that will display results of the search along with the order details. (Rhochella dela Cruz)
25
26
Figure 13 - Administrator View, Edit, Delete Order Function
Once a member completely and successfully makes a transaction, it will be saved in the database. The administrator logs in with his username and password. The function will enable the administrator to view all order transactions of all members who have purchased from the site. All transaction details such as order id, date of transaction, member and other information in the tracking history will be also be shown using this function. Clicking View Orders under Customers will enable the administrator to view all orders. The Edit and Delete functions can be used for each transaction to help the administrator manage the orders. Using the Edit Order function by clicking the order number of the order, the current status of the order can be changed. This way, the administrator can keep track of the transaction progress. The changes to the status is reflected in the Orders Page Using the Delete Order function, the administrator can delete cancelled or fraudulent transactions. (Rhochella dela Cruz)
MANAGE MEMBERS MODULE
27
Figure 14 - Administrator View, Edit, Delete Member
Once a public user has successfully registered, he becomes a member. His account will be added to the database. All members and their account details are viewable by the administrator.
28
Along with viewing the members, he can also edit their account if there are changes and delete their account. Using the Edit Member function by clicking Edit link, the administrator can update the personal details of that given member. Updating member profile is very important especially that this site should provide real time transactions. Using the Delete Member function, the administrator, the administrator can delete members. (Rhochella dela Cruz)
29
Figure 15 - Administrator Search Member Function
One of the privileges of the administrator is that he is able to search for the members of the site. Once he is successfully logged in using his valid username and password, he is directed to the Administrator Page. The Administrator Page provides a order search engine, where the administrator can input the member’s detail as the search keyword. If there are available 30
member corresponding to that keyword, the page is directed to the Customer page that will display results of the search along with the member’s details. (Rhochella dela Cruz)
Figure 16- Administrator View, Edit Delete Administrator Users Function
31
Given that the administrator is successfully signed in with his valid username and valid password, he can view all the administrator accounts if there is more than one administrator. This includes viewing each administrator’s account details. The Administrator link is clicked to display the admin users of the site. Along with this, two functions are connected with each account. Delete administrator and Edit administrator. At the end of each administrator entry, the Delete and Edit links are provided in case the administrator wants manage that specific administrator account. Using the Edit Administrator function, the administrator edits the personal information of the administrator. Using the Delete Administrator function, the administrator can delete that specific administrator user. Once deleted, he can no longer log in with his username and password in www.wavesofboracay.com/administrator. (Rhochella dela Cruz)
32
Figure 17 - Administrator Manage Store Settings Function
33
The administrator maintains not only the functionalities of the site but also all the data and settings that appear in the site. Under Store Config, the administrator has access to Store Settings function. Whatever changes made by the administrator using this section will appear in the online site. Since this is an e-commerce site, the currencies are important to be configured. According to Mr.Cleak, his main target is to promote and sell his products to customers living abroad. The administrator can use the sub-function of configuring the currencies to a uniform U.S dollar ($) monetary unit. (Rhochella dela Cruz)
Figure 18 - Administrator Manages Shipping and Billing
34
The administrator maintains not only the functionalities of the site but also the maintenance of shipping and billing configurations with third party companies. Under Module, the administrator has access Shipment and Gateway (billing companies). For this site, Mr.Cleak wanted to have PayPal integrated for the monetary transactions. Whatever changes made by the administrator using this section will appear in the online site. Cube Cart provides an easier way to configure the integration with billing companies. (Rhochella dela Cruz)
Figure 19 - Administrator View Feature Status
35
Once the administrator has successfully logged in, he can view the 10 most popular products. Under View Stats, the administrator can click on Popular Product link to see the poll of top 10 products. This is judged by the number of time the product is viewed. (Rhochella dela Cruz) MEMBER MODULE
36
Figure 20 - Member Buys Product Function
37
To purchase the products in your cart, one has to be a member and signed in to complete the checkout process. The first step is the View Basket Step where the member can edit, add, delete product/s in his basket. Clicking “Continue button” will lead him to the second step which is the Address step. This displays the Billing information and ordered product list. The member can edit his billing information before he completely checks out his transaction. The third step is the Payment step where the member selects the payment method. If he chooses “Credit Card”, he will be directed to the PayPal site. This requires a PayPal account. Waves of Boracay holds a merchant account in PayPal. If he chooses the Postal Order form, he can print out his invoice. The administrator will view this transaction using the same invoice. The last is the Complete step, where the member has successfully made his transaction. (Rhochella dela Cruz) MEMBER ACCOUNT MODULE
38
Figure 21 - Member Sign in Function
The member has to sign in with his valid email address (username) and password to be able to proceed to purchasing and checkout of the products in his or her shopping basket. Only registered members have access to the sign in, purchasing functions, profile accounts of the site. (Rhochella dela Cruz) 39
Figure 22 - Member View Order History Function
40
The member has to sign in with his valid email address (username) and password to be able to proceed to purchasing and checkout of the products in his or her shopping basket. Only registered members who are currently signed in have access to the Order History feature. Under “Accounts”, the member can view his Order History. It has the records of his transactions. (Rhochella dela Cruz)
41
Figure 23 - Member Edit Profile Module
42
The member has to sign in with his valid email address (username) and password to be able to proceed to access his profile. Only registered members who are currently “Accounts: link which will lead the member to the Profile. The member can update his personal details. (Rhochella dela Cruz) PUBLIC USER MODULES
Figure 24 - Public User Register Function
43
A public user can register to become a member to fully enjoy the all the functions of the site. A public user would not be able to purchase his or her desired products if he or she does now sign up for membership. The user has to complete the registration form with his details. It is important to have a valid email address in order to become a member of the site. This email address should be unique for it will serve as the username of the member. Once registered, his or her details are saved in the member table of the database. (Rhochella dela Cruz) SHARED MODULES
44
Figure 25 - Public User and Member Search Function
All public users and members can search for certain products in the site. They do not need to sign up for this feature. A member (signed in or signed out) can browse the site. (Rhochella dela Cruz)
Figure 26 - Public User and Member Manage Basket
45
A public user can add products to his basket. Even without an account, he can also edit the quantity and content of his basket. He can also delete the products in the basket. He only has access to the first step of the checkout process, which is the View Basket. Clicking “Continue” will prompt the public user to sign in. A member can view, edit quantity, add more products, and delete products in the basket even without signing in yet. Once he signs in after clicking “Continue” button, the basket will be considered his own and he can then proceed to the whole checkout process if he wishes to make that transaction. (Rhochella dela Cruz )
B. Class-Based Models i.
Class Diagram
A class diagram is a figure of the relationships, connections and dependencies among classes in the Unified Modeling Language (UML). A class shows the methods and variables in an object, which is a specific entity in a program or the unit of code representing that entity. In a class diagram, the classes are arranged in groups that share common characteristics. A class diagram is similar to a flowchart in which classes are inside the box. The box contains the name of the class and its attributes. Lines, with arrows at one or both ends, connect the boxes. These lines define the relationships, also called associations, between the classes. (Madelaine Mapile)
46
Figure 27 - Class Diagram of Customer
The class diagram shows that the customer signs in as member. The member’s attributes are password, name, address, email address and contact no. The P.K. or the Primary Key is a unique attribute. When the member has signed in, he may buy any product from the website. The product contains the product ID, its description and the price. After the customer has chosen the product that he wishes to buy, he may view and go to his shopping cart to distinguish the total amount of the products he purchased. He has the power to manage his cart by adding more products or deleting some of it. When the customer has signed in, he could view the catalog, search products via the search engine, buy the product, manage his shopping cart and view or edit his profile if there would be changes e.g. change of mailing address. (Madelaine Mapile)
47
Figure 28 - Class Diagram of Administrator - Class Diagram of Administrator
This next class diagram shows that when the administrator logins, generally, he could manage the store settings. The admin may configure the settings of the site. The admin could add categories, edit or delete. The categories consist of products. The admin manages the products also; he could add products, image of a certain product, and edit the description, or the price of the product/s. He could also view his added products and members’ information and manages the member’s orders. The attribute of the order class are Order ID which is the Primary Key, the orderDate, the exact date the member purchased the product, the orderList, the total list of the products the member purchased and its total cost. The Shipping address is also an attribute of the order class and the payment method that the member has chosen. (Madelaine Mapile)
C. Behavioral Models i.
Sequence Diagram
The header portion of a sequence diagram represents the components of the system being modeled. There are five components of this diagram; administrator, administrator's page, Waves of Boracay website, shopping cart, and the customer. 48
(Cristina Ubaldo)
Figure 29 - Sequence Diagram of Administrator The administrator is considered as an actor in this diagram. The administrator, who is the owner and manager of the Waves of Boracay gift shop, logs in to the administrator's page. If the username and password is valid, then the administrator's page will allow access to modify the Waves of Boracay website. The administrator's page is one of the components that represent the objects in the system. Through this page, the administrator will be able to moderate the Waves of Boracay website by managing the product, categories, orders, members, and store configuration. Also, the administrator has the privilege to access and control the database of the system. (Cristina Ubaldo)
49
Figure 30 - Sequencw Diagram of Customer The customer is the second actor in this system. The Waves of Boracay website offers a free membership for it's customers. If the customer owns an account, he/she has the privilege to manage his/her own shopping cart by adding a product. Also, he/she can delete the products that he/she no longer wants to purchase. After selecting the products to purchase, he/she has to complete the checkout procedure. He/she will confirm the delivery address, shipping method, and payment method. Once done, the administrator can access the order list of the member. The Waves of Boracay website is basically the object where all transactions happens. (Cristina Ubaldo)
V. Design Model
A. Data Design 50
Figure 31 – Entity Relationship Diagram 51
(Rhochella dela Cruz) Data design focuses on data organization that is essential in building relationship between the system data and the events and process which are all required to establish an accurate and flexible database. Data Design concentrates more in organizing and storing data, much like how the data should be organized in a database representation. To visually represent Data Design, an Entity-Relationship Diagram encompassing the data requirements of the system gathered, organized, related, and grouped. This ERD shows the data organization of the site. Once a user decides to be a member, all of his or her data will become attributes of an entity “member”. Being a member allows him or her to select a “product” and buy such item, besides being capable of performing public functions such as searching, viewing, and managing cart functions. The entity product has several attributes, but mainly grouped and identified by product_id and categories. Once the member decides to buy the products in his or her cart, an “order” will be created. An order creates a transactionHistory for the member which contains the details of his or her purchased items. The purchased order sends an email invoice to the member. A member has one-to-many relationship with the product and order. He or she also has a oneto-many relationship with the transactionHistory, depending on the number of times the member has purchased a single or numerous product items. The “admin” is responsible not only in managing the orders of each member but also updates each member of their transaction invoice via email. The ERD also shows the entities and the function of a public user, besides being able to browse and search through the site, he or she can also sign up for newsletter subscription. (Rhochella dela Cruz)
B. Architectural Design
52
Figure 32- Context Diagram of the System Level 0 (Cristina Ubaldo) This diagram is just an overview of the data flow of the Waves of Boracay website. The administrator is the one who inputs category information and picture, and product information and picture, which will be placed in the Waves of Boracay website. On the other hand, the customers are the public user and the members. The public user can access the website without logging in. The member can also access the website, as well as the shopping cart. The member has the privilege to checkout his/her shopping cart. Once the shopping cart has checked out, the administrator will view the order list. (Cristina Ubaldo)
53
Figure 33 - Data Flow Diagram of the System (Cristina Ubaldo) This diagram is a highly structured data flow of the Waves of Boracay website. It comprises of 12 process, namely administrator login, administrator add product, administrator add category, administrator edit product, administrator edit category, administrator delete product, member sign up, member sign in, member view product, member view category, member add product in shopping cart, and member delete product in shopping cart. (Cristina Ubaldo) 54
Figure 34 - Login Process of Administrator (Cristina Ubaldo) This diagram shows how the login process of the administrator. The administrator inputs the username and password which will be processed to the Waves of Boracay database, It will verify the username and password by checking if is matches the data. If the data matches, then the login is accessed. Of not, the access is denied. (Cristina Ubaldo)
55
Figure 35 - Add Product Process of Administrator
If the administrator is logged in, he can add product to the database. Adding a product requires the administrator to input the information about the product. Once the information has processed, it will then be stored in the database. (Cristina Ubaldo)
Figure 36 - Add Category Process of Administrator If the administrator is logged in, he can add category to the database. Adding a category requires the administrator to input the information about the category. Once the information has processed, it will then be stored in the database. (Cristina Ubaldo)
56
Figure 37- Edit Product Process of Administrator If the product exists in the database, the administrator can edit the product by changing the details of the selected product. Once done, the database will be updated. (Cristina Ubaldo)
Figure 39- Edit Category Process of Administrator 57
If the category exists in the database, the administrator can edit the category by changing the details of the selected category. Once done, the database will be updated. (Cristina Ubaldo)
Figure 38- Add and Delete Product in Shopping Cart of Member After viewing the category then the product, any user has the privilege to add and delete product in shopping cart. (Cristina Ubaldo)
58
Figure 40 - View Product and Category Process of Member Any user can view the product and category of the website by simply selecting the desired data. (Cristina Ubaldo)
59
Figure 41 - Sign Up Process of Member
Membership is free in this website. The customer must input the required data that the system is asking for. The information will be processed to the database so that the user can have his/her own profile. (Cristina Ubaldo)
Figure 42- Sign In Process of Member (Cristina Ubaldo) 60
If the customer has already sign up, he/she can sign in by entering the email address and password of his account. It will be processed to check if it corresponds to the data in the database. If the data matches, then he/she is logged in. If not, then he/she has to input the correct email and password. (Cristina Ubaldo)
C. Interface Design General Information about the Interface The system provides online shopping functions for users and members who wish explore the Waves of Boracay via the Internet. This website is open for everyone for viewing, searching, and member sign up, and newsletter subscription. For one to actually complete his or her shopping experience, a public user must register to become a member. This will enable one to own his or her own shopping cart. A public user can edit, add, delete products from the shopping cart, but for him to actually purchase and own anything he put in that cart, he must be a member of the system. A member can also view his or her personal details and receive email invoices once checkout and the transaction are complete. The administrator has his own administration pages secured with specific password and admin username. The administrator keeps tracks of all the processes that take event in the site. He maintains the site and controls all the data that is the user interface shows. The interface or design of the site is very user friendly and equipped with features that make e-commerce sometimes more efficient than personally visiting the store. User task, environmental analysis, and modeling User analysis: A user is classified as a member or a public user. The administrator, public users and members can view the website. Being a public user entitles a limited number of accessible functions. A member entitles an access to all functions and features of the site. Only a member can purchase the products online. The administrator manages the member accounts, transaction histories and purchasing. He is the only who has access over the site’s database. He manages all the transaction and events that occur in the site. Task analysis: The administrator can add, edit, delete product item and product details. He manages the whole site’s gallery. He is also responsible in ensuring that the site is 61
connected with their respective payment partners and all details that involve in the purchasing, checkout, and verification. The administrator also maintains the member accounts. They ensure that the members can use all functionalities of the site efficiently. The administrator is also charge of updating the features of the sites. He is also responsible in preserving a userfriendly navigation and design interface of the website. Environment analysis: •
All computers with Internet connection can access this website.
•
Administrator’s task:
•
Log in with administrator’s username and password
•
Add product item
•
Edit product detail
•
Change product item image
•
View member’s orders
•
View transaction history of member’s order
•
Sends email invoice
•
View member’s payment options
•
Update site features
•
Maintain site functionalities
•
Maintain connection with payment partners
•
Sign out of the system
•
Non-administrator’s tasks
•
Access the website
•
Select site features
•
Search for a product
•
Sign up to become a member
•
Sign in using member’s username and password
•
Add, delete, edit shopping cart
•
Select transaction details for purchasing and checkout 62
•
Edit member profiles
Implementation tools: •
The computer’s keyboard and mouse will be the main devices to be used
•
The system is flexible and user friendly which will establish easy site
navigation and feature utilization •
Anyone who views the site can contact the administrator or developers if
complains and suggestions arise. (Rhochella dela Cruz)
Figure 43 - Waves of Boracay Homepage (Madelaine Mapile and Katrina Dee) 63
Figure 44- Waves of Boracay Sign Up of Member (Madelaine Mapile and Katrina Dee)
64
Figure 45 - Waves of Boracay Sign In of Member (Madelaine Mapile and Katrina Dee)
65
Figure 46 - Waves of Boracay View Product in Category - Waves of Boracay View Product in Category (Madelaine Mapile and Katrina Dee)
66
Figure 47 - Waves of Boracay View Shopping Cart (Madelaine Mapile and Katrina Dee)
67
Figure 48 - Waves of Boracay Confirm Shipping Address (Madelaine Mapile and Katrina Dee)
68
Figure 49 – View product (Madelaine Mapile and Katrina Dee)
69
Figure 50 - Administrator Category List (Madelaine Mapile and Katrina Dee)
70
Figure 51 - Administrator Add Category (Madelaine Mapile and Katrina Dee)
71
Figure 52 - Administrator View Product List (Madelaine Mapile and Katrina Dee)
72
Figure 53 - Administrator Add Product (Madelaine Mapile and Katrina Dee)
73
Figure 54 - Receipt (Madelaine Mapile and Katrina Dee)
D. Component-Level Design 74
(Katrina Dee) Figure 55 – Component level Design Overall View Component level design shows how the pages of the system are related to each other. 75
The figure above shows overall view of the system. There are 3 types of users for the website, the admin, the member and the public user. The Public user can immediately access the website without logging in. The search page and the shopping basket will be observed oncehe visits the website. However, to purchase a product, the public user must log-in as a member. When a member logs in, he will be redirected to the member page. From there, he can edit his profile, search for a product, manage his shopping cart and buy product. The admin page contains the most pages. The admin can mange product, manage category, manage member, manage order, and manage admin users. Under these categories are more specific functionalities available for the admin. These pages with functionalities are all linked to the admin.
(Katrina Dee)
E. Deployment-Level Design A deployment diagram shows the outlook of the run-time configuration of processing nodes and the components that run on those nodes. It shows the hardware of the system, the software that is installed on that hardware, and the middleware used to connect the disparate machines to one another. (Madelaine Mapile)
Figure 56- Deployment-Level Diagram (Madelaine Mapile) 76
The administrator, the customer or the public user uses the Internet browser to view the website of the Waves of Boracay shop. The website has the main functions of user login, member sign-up, view products and purchase the products. These functions are saved in the database server using mySQL. (Madelaine Mapile)
VI. Product Scope A. Context The group interviewed Mr. Daniel Cleak, the owner of Waves of Boracay Gift Shop, on December 5, 2008 at Chiggy’s Pearl Drive in Pasig. The group interviewed him regarding the Shop and asked the following questions: •
Tell us something about your business
•
Who would benefit from the website?
•
How would the people or customer benefit from the website?
•
How would you like the website interface to look like?
•
What features would you want to have in your business website? After the group interviewed him, the group concluded that: The Waves of Boracay Website offers an online shopping of souvenirs and other
merchandises from Boracay. It is a convenient website for customers since ordered products could also be delivered right in front of their houses. It is an easy to use website. The customer will register his/her name, password, address, email address and contact number to be able to purchase one or more products. The administrator will manage the availability of the products and the orders of the customers. After deciding on the product/s to purchase, the customer will then choose what payment method he/she will be using. The purpose of Waves of Boracay Website is for interested customers that would allow them to see Mr. Cleak’s handicrafts store. At the same time, this is a way to advertise the business and also, it promotes Filipino products. (Madelaine Mapile) 77
B. Informational Objective The system is an online store that would allow local and international customers to have access to Daniel’s handicrafts store. The system will have a user-friendly interface that will let anyone who has a computer connected to the internet order from the store. The system would contain the images of the products being sold and their specific descriptions. The administrator can add products, edit products, delete products and manage orders. (Katrina Dee)
C. Function and Performance This website delivers an e-commerce service to an actual handicraft store owned by Mr. Cleak. In this case, the website functions are similar to an actual store but with more real time services accessible anywhere in the world using the Internet. The owner specifically required functionalities that should make shopping possible with a click on the mouse. Such functionalities involve Search Product, View Catalog, Search Product, Buy Product, Sign-up member, Sign-in member, and Manage Shopping cart. Member Accounts are the most beneficial for this site. A user can make use of the Sign-up functionality to create his/her own account to be able to purchase products. Each member has his/her own shopping cart which he/she can edit using the Add to Cart, Delete from Cart, Edit Cart functionalities. Only a member can edit his/her own member details, purchase a product, and select all the purchasing options (payment options) required to confirm his/her order. All purchased transactions of members are recorded and updated. All these services are accessible if the member has successfully signed in using his/her own Email Address and password. The administrator signs with his/her own username and password in order to access the site’s database and maintain that all features, and functionalities of the site are working accordingly. The Administrator has the following functionalities: Add Product, Edit Product, Delete product, View product Manage order and Add Member. The Search Product and 78
View Product Information are available to all viewers both member and non-member of the site. Other that its functionalities, the site also offers Newsletter Sign Up and Top 10 Featured Products, Along with its aim to advertise and expose the store in foreign countries, features such as Foreign Exchange and Language Selection were selected. The website presents user-friendly navigation with its readable and easy to understand user interface. (Rhochella dela Cruz)
VII.Software Team A. Profile The team is composed of four members, namely Cristina Ubaldo, Madelaine Mapile, Ma. Katrina Dee, and Rhochella dela Cruz. Our software engineering team is classified as a Controlled Decentralized team. Our defined leader is Cristina Ubaldo. She provides the motivation and maintenance of organization of the all the concepts to be accomplished in this project. Every member of the team is encouraged to share and ideas and innovative processes and techniques to accomplish the project in the most resourceful and efficient ways. As a responsibility of the team leader, she thinks ahead of time to lessen the occurrence of problems. She has to make decisions that will ease the decision, selection, evaluation, and coding of each functionality. She ensures that all the requirements of the client will be provided. The main task of the project team members, namely, Rhochella dela Cruz, Katrina Dee, and Madel Mapile, is to aid the team leader in fulfilling the assigned tasks. Each one is in constant communication with the leader in order to establish a continuous and updated pacing of all the pending and accomplished tasks. In working with a more complex division of the project, the team leader would assign partnerships to ease the difficulty of the problem to be solved. A status report is given by each member and checked by the leader. This will ensure that all objectives for the week are fulfilled and prioritize all pending tasks for the coming days of work. (Rhochella dela Cruz )
79
B. Capability The skills and capabilities of the each member are necessary to the successful completion of the project. All of the members will be part of the programming team but each will be assigned to a specific area. Rhochella dela Cruz and Madelaine Mapile, being proficient in the PHP programming language, will lead the coding the project in PHP. Katrina Dee, being interested in MYSQL, will take charge of the database queries and the integration of the databases. And Cristina Ubaldo, having web design as her forte, will be responsible for the overall design of the website. The team trusts and believes in one another each will be able to do their individual tasks. There is good communication within the group. Regular meetings are conducted by the group to talk about the progress of their project. The group also makes use of electronic communication like Yahoo Messenger and Google Documents to share their documents. (Katrina Dee)
VIII.Estimation A. Function-Based Estimation
Information Domain value External Inputs (EIs) External Outputs (EOs) External Inquiries Internal Logical Files External Interface Files Unadjusted Function Point Count (count total) FP estimated
Simple (Optimis tic) 15 20 21 7 0
Average (Most Likely) 4 15 12 10 0
High (Pessimisti c) 12 7 18 15 0
Estimated Count 10.33 17.50 17 7 0
Functio n Point Count 27 35 51 7 0 120 140.4
Table 1 - Function-Based Estimate (Rhochella dela Cruz and Katrina Dee)
Expected Value (size) 80
169
Organizational Average Productivity (OAP) Burdened Labor Rate (per month) Cost per Function Point (BLR/OAP) Total Estimated Project Cost (EFP*CPFP) Estimated Effort
7.5 2,000 266.67 37,440.00 18.72
Table 2 - Function-Based Estimated Values (Rhochella dela Cruz and Katrina Dee)
The function-based estimation is used to provide an overall estimate for the entire project. This estimation method focuses in measuring and decomposition of Information Domain Values. These Information Domain Values are as follows: External Inputs, External Outputs, Internal Logical Files, and External Interface Files. The values obtained are used mainly to analyze historical data and combine such findings to produce an estimate. Other results that can be obtained from the estimation are the cost of the system site and productivity rate of member per month.
(Rhochella dela Cruz and Katrina Dee)
COMPLEXITY WEIGHTING FACTORS 1. Backup and recovery 2. Data communication 3. Distributed processing 4. Performance critical 5. Existing operating environment 6. On-line data entry 7. Input transaction over multiple screens 8. IUFs updated online 9. Information domain-values complex 10. Internal processing complex 11. Code designed for reuse 12. Conversion/installation in design 13. Multiple installations 14. Application designed for change Total Degree of Influence Value Adjustment Factor 81
VALUE 4 2 0 4 3 4 5 3 5 5 4 3 5 5 52 1.17
Table 3 - Complexity Weighting Factors (Rhochella dela Cruz and Katrina Dee)
The Complexity Weighting Factors are indicated in this table and are numbered from 1 to 14. Each one is rated from 0 to 5 to get the Value Adjustment Factor.
(Rhochella dela Cruz and Katrina Dee)
IX. Schedule A. Gantt Chart
82
Figure 57 - Gantt Chart (Cristina Ubaldo and Madelaine Mapile)
83
Figure 58 - Gantt Chart (Continuation) (Cristina Ubaldo and Madelaine Mapile)
84
X. Software Testing Testing Methods The methods used to do the software system testing were Configuration Testing, Usability Testing and Security Testing. These methods combined resulted to different Test Conditions that revolve around finding errors in navigation, input usability, user access control, session, and error handling. Navigation is very important in the site because these will serves as guides for the members and public users in browsing the site and making use of the functions and features that the sit provides. The important links were tested to ensure that all of them work properly and are directed to the right pages based on eh command and buttons selected or clicked. Input usability is tested for the input’s validation. These inputs are necessary for the functions to fully accomplish what the users wants to achieve. Without these input, the functions will be useless. The test cases focus on the input that might cause problems with the processing. Such could be input of invalid characters and missing information. User access control test two factors namely: Identification & Authentication and Authorization. Identification & Authentication tests for the validity of members email addresses and password. The test cases focus in finding defects in signing in and registering. Error handling test involves the display messages that come up to warn the member or public user of their invalid action or page warnings. Session testing involves testing the session of logged in member and the status they should have and should end once they sign in or sign out. (Rhochella dela Cruz) Testing Requirements for Members and Public Users Member Sign In / Sign out (MS)
85
1. Once a public user has registered successfully, he becomes a member. A member signs in with his valid email address and valid password. A member who is signed in will have his name indicated on top of the site. The Log out link will then become available 2. Member can sign out by clicking the Log out link. His session will end. 3. Only a member who is signed in is authorized in using the Account feature of member and online purchasing. Public User Register (PR) 1. Public user who wants to become a member has to register. I 2. In the homepage, Register link is always available. Clicking this link will lead to Registration page that contains the form for information details that are both optional and necessary for the public user to answer. Member Purchase Product (MB) 1. Once a public user has registered successfully, he becomes a member. A member signs in with his valid email address and valid password. A member who is signed in will have his name indicated on top of the site. The Log out link will then become available 2. One advantage of being a member who is signed in is that he has the privilege of purchasing the product/s online. 3. A public user and a member can add product to his basket by clicking “Add to Basket” button. 4. He can view the basket by clicking “View Basket” located under Shopping Basket feature on the right side of the site. This will direct you to the checkout process 5. First step of the Checkout Process is the View Basket step. This will display the products in the basket. 6. The member can edit the quantity of ordered product. 86
7. The member can delete the product from the basket. 8. After clicking “Continue”, the member is directed to the Address step. This displays the personal details of the member who owns the basket. The billing information of the member will also be displayed. 9. The member can edit the member’s billing information. Clicking the edit button will lead the member to edit personal profile page. 10. The third step of the checkout process is the Payment. The member selects either to pay through PayPal or Print Invoice. 11. Paying through PayPal will direct the member to login to the PayPal site. Member’s PayPal account is necessary to be able to complete the transaction through PayPal. 12. After the PayPal has been confirmed, the transaction completion is the last step of the check out process. 13. All transactions are saved in the database and can be viewed by the administrator. Public User and Member Search (PMS) 1. A member does not have to be signed in to search 2. Public user can search the site even if he is not a registered member. 3. Public user or member inputs keyword in the search field. If the keyword is valid or available, the resulting products are posted. 4. Public user or member inputs keyword in the search field. If the keyword is invalid or unavailable, there are no results posted. Navigating Links (NL) 1. A public user and member can view the links in the site 2. A signed in member will have additional links because there are features that only authorized users (members) can have access to. 87
(Rhochella dela Cruz)
Test Conditi
Test
on No
Condition
Requireme S
Step
Expected
Pass/F
nt No.
tep
Descripti
Result
ail
No.
on
(Test
Actual
Script)
Result
NAVIGATI ON TESTING NL1
1
Directs the Public
P
public user
user
or or member Page
member
to
the remains
clicks on homepage Homepage
directed in Homepag
link
the e
Link homepage
located on of the site
1
the
left
side
of
the site
88
NL1
1
Directs the Directs the P public user public user
Public user
or or member or member
member
to a page to a page
Category
clicks on that shows that shows
links
any of the all
the all
categories
products
under
under that under that
“Shop by specific 2 NL1
1
the
products
specific
Category” Public
category category Directs the All data P
User
user to the that
clicks on page
has
that been
Previous Register
displays
previously
link
the
given
Link When public is
user
in
located on registratio
(without
top of the n form
saving yet)
page
are
the
registration page
and
clicks
on
discarded, leaving the Previous registratio Page link n blank 3
again 89
fields
2
Public
Goes back
user
to previous
p
inputs all visited Goes back the details page to previous asked
in visited
the form. page Clicks Previous 3
Page link Clicks
The
F The
“Back”
informatio informatio
from the n
details n
toolbar
should still
browser
remain
were
discarded
90
NL1
1
Member
Opens the In
the
clicks on Registratio
homepage,
Register
the Login
link
n Page
and Register links
are
Register
activated
Link
since one
no is
signed in. Page
is
directed to Registratio 4
n page
INPUT VALIDATION TESTING
91
Public User PR 1-2
1
Do
the
P
neglects
steps
required (*)
Test
results
Condition
Test
results
4
Condition 4
Test
"Register
follows
Condition 4
member information during
in
The expected of
The actual of
is provided
Link"
registration 5 2
Public user
Public user
Registratio
fills in the
has
n
registration
complete
form
the required
leaving out
information
the required fields. Clicks
to
page
warns public user with
a
message “Please make sure
“Submit
all
and
required
Continue”
fields
button.
completed
are
”. Registratio n unsuccessf 92
P
ul
Public User PR1-2 leaves
1
Do
the
steps
out
optional fields empty during registration
in
The
P
expected of
The actual
Test
results
Condition
Test
results
4
Condition 4
Test
"Register
follows
Condition 4
of
is provided
Link"
6 2
Public user
Public User
The
fills in the
will become
member
registration
a
will
form
“Registratio
leaving out
n
the
successful”
optional fields. Clicks
member.
is
P
be
automatica lly signed in
as
indicated in
the
“Submit
upper right
and
area of the
Continue”
site.
button.
Page
is
directed to 93
View Basket Page. Public User PR1-2
1
Do
the
P
registers
steps
non-
Test
results
Condition
Test
4
Condition 4
"Register
follows
numerical characters for
Cell
phone
and
in
The expected of
The actual results
of
Test Condition 4
Link"
is provided
Telephone 7
fields 2
Public user
Public User
A
fills in the
has
message,
registration
change his
form
and
registration
non-
information
put
to
numerical
.
characters
“Registratio
for
Cell
n is failed”
phone and
message is
Telephone
displayed.
P
“Telephon e number must
be
numeric only” will be displayed
fields.
on top of
Clicks
the
“Submit
registratio
94
and Continue”
n page
button.
Public User PR1-2
1
the
P
steps
optional and
Test
results
Condition
Test
results
4
Condition 4
Test
"Register
follows
Condition 4
fields
of
information with
in
The
fills in all
required
8
Do
expected of
The actual of
is provided
Link"
right
characters 2
Public user
Public
The
fills in the
User’s
member
registration
registration
will
form
will
completely
accepted.
.
He will be
Clicks
be
“Submit
automatical
and
ly signed in.
Continue” button.
P
be
automatica lly signed in
as
indicated in
the
upper right area of the site. Page
is
directed to 95
View Basket Page. MB1-4,
the
in
The
P
expected
Test
results
of
Condition
Test
"Member
Condition 4
Signs
follows
results
number to 0
of
Test in
Condition 4
clicks
“Add
the
The actual
Quantity
and
Do steps
MS1, MS3
Member change
1.
with valid is provided
to
username
Basket”
and
9
valid
password"
2
Member
The
Since 0=1, P
selects
a product
product
will
and
be
changes
to the cart will
the
because
quantity
0=1. It will 1.
to “0”
be
The
automatica
Shopping
lly
Basket box
considered
in the right
96
the
still quantity he added ordered be
changed to
as 1.
side of the site reflects the change in product quantity.
2
Member selects product
Second a
P
step (Address) will proceed. It will show the Invoice Address and
the
partial billing statement. Since 0=1, the quantity he 97
ordered will
be
changed to 1. Checkout process proceeds. In the View MS1, M3, 1.
Do
Basket
steps
MB1-6
section, member decides
to
change
the
Quantity number and types
10
in
The
P
expected
Test
results
Condition
Test
"Member
Condition 4
The actual
Signs
follows
results
in
of
of
with valid
Test
username
Condition 4
and
is provided
valid
password"
alphabets and
the
clicks
“Continue”
98
2
After
Directs to
adding
View
product to Basket
Directs to
the
Page
View
basket,
which
Basket
member
shows all Page
clicks
the
which
“View
products
the
Basket
that
is first
were step to the
“button in added
3
P
to checkout
the
the basket process
Shopping
by
Basket.” Member
member The
The
changes
alphabet
alphabet
the
will
Quantity
change the change the
number
previous
previous
and types quantity.
quantity.
alphabets
Second
the
not will
No
P
not
and clicks changes
step:
“Continue
Address,
” button
will proceed
99
showing the Invoice Address and
the
product list to be 1
Public
The
bought The added P
user
product
product
selects
will
be and
product
added
to quantity is
its
and clicks the
reflected
“Add
on
to Shopping
Basket”
Basket
the
Shopping
located in Basket in the
right the
right
side of the side of the 11 2
Public
site The
site Direct the P
User
checkout
page
changes
process
where the
the
will
quantity
continue
not Public user
and clicks because “Continue 100
the user is
can register.
”
not
a
member. It will direct to
Login
Page MB1-9, Member
1
Do
the
steps
MS1,M3
in
The
The actual
expected
results
clicks “Edit
Test
results
Invoice
Condition
Test
Condition
Address”
"Member
Condition
18
and
Signs
18 follows
provided
leaves
Test
is
with valid
missing fields
in
of
of
username
for
and
information 12
valid
password"
2
After
Page
is
having
directed to
been
View
adding
Basket
Directed to
product to Page
to View
the
complete
shopping
the
basket
part of the
Basket
first Page
checkout process 101
P
3
Member
Direct
clicks
Address
“Continue
Page
”
the second the second step
to Direct
to P
Address as Page
as
of step
of
checkout
checkout
process
process. Show the product order
list
and
the
Invoice Address 4
Member
Direct the
clicks
page
“Edit
Personal
page
Invoice
Informatio
Personal
Address”
n Page
Informatio
to edit the address
102
P
to Direct the
n Page
to
5
Member
The
Message
P
doesn’t
changes
displayed,
update the will not be “Please personal
saved
informati
the
on
in make sure all
by database
required
leaving
fields
are
some
completed
fields out.
”.
Clicks
recent
“Update
changes
Account”
are
button
updated in
The
not
the database MS1, MS3, 1 Signed
in MB1-4
member clicks “View Basket” but did not add any items in his basket 13
Do steps
the in
The
The actual
expected
results
Test
results
Condition
Test
Condition
"Member
Condition
18
Signs
18 follows
provided
in
with valid username and
valid
password"
103
of
of
Test
is
P
2
Member
Direct the The
did
not member to Shopping
add
any the
View Basket in
product to Basket
the
the
side of the
Page
Member public
or MS1, MS3, 1 user MB1-5
clicks on a product without uploaded picture
an
right
shopping
site is not
basket.
updated.
Member
Direct the
clicks
member to
“View
the
Basket”
Basket
button
Page. This
under the
is the first
Shopping
step of the
Basket
checkout
section 14
P
Do steps
View
process. the in
The
The actual
expected
results
Test
results
Condition
Test
Condition
"Member
Condition
18
Signs
18 follows
provided
in
with valid username and
104
valid
of
of
Test
is
P
password"
2
Member adds
The
The
a Shopping
P
Shopping
product
Basket
Basket in
without
will
the
an image indicate to
right
side of the
the the newly site
is
shopping
add
updated.
basket.
product.
Direct the
Clicks
Direct the member to
“Add Basket”
to member to the the
View
View Basket
Basket
Page. This
Page
is the first step of the checkout process.
USER ACCESS CONTROL – Identification and Authentication
105
Public User PR1-2
1
Do
the
P
registers
steps
with invalid
Test
results
Condition
Test
4
Condition 4
"Register
follows
email address (wrong
in
The expected of
The actual results
of
Test Condition 4
Link"
is provided
email address 15
format) 2
Public user
Public user
Registratio
inputs
has
n failed.
an
to
invalid
correct his
email
email
address
address.
format.
Registration
Clicks
failed.
“Submit and
A message, “Please enter
a
valid email address”
Continue”
will
be
button.
displayed on top of the registratio n page
106
P
Public
user PR1-2
1
Do
the
P
registers
steps
with a taken
Test
results
Condition
Test
4
Condition 4
"Register
follows
email address an
or email
in
The expected of The actual results
of
Test
Link"
address that
Condition 4
has
is provided
been
already registered in 16
the site 2
Public user
Public User
inputs
should give
an
email
another
address
email
Registratio n failed. Message
address.
displayed,
been
Registration
“Sorry that
registered
failed
email
that
has
before the
in
address is
site.
already in
Clicks “Submit and
use.”, is on top of the registratio
Continue” button.
107
n page
P
Member
MS1, MS3, 1
Do
the
The actual
expected
results
clicks “Edit MB1-9
steps
Invoice
Test
results
Condition
Test
Condition
"Member
Condition
18
Signs
18 follows
provided
Address” and replaces current
in
of
P
of
Test
is
with valid
email address
in
The
username
to
and
someone
valid
password"
else’s email 17
address 2
After
From
P
having
View
been
Basket
adding
Page , the
product to second Directed to the
step of the
shopping
product
basket.
checkout
User
directs the
clicks
page
“Continue
Address
”
Page
Address Page
108
to
3
Member
Page
Page
P
clicks on directed to directed to
4
“Edit
Personal
Personal
Invoice
Informatio
Informatio
Address” Member
n Page
n Page Page still P
replaces
remains in
current
Personal
email
Informatio
address to someone
This should not
be
n
Page.
Message
accepted.
else’s
Update
email
is
is
failed.
Member signs in with MS1, MS3 valid
email
address and valid 18
password
“Sorry
address.
that email
Clicks
address is
“Update
already in
Account” 1
displayed
Do steps
the in
use.” The
P
expected
The actual
Test
results
Condition
Test
Test
1
Condition 1
Condition 1
"Homepag
follows
is provided
e link"
109
of
results
of
2
3
Click Log
Page
is
in link
directed to
directed to
the
the
Login
Page
Page
Page
Member
Member
Page
inputs
sign
valid
successful
username and
valid
password. Clicks “Login” button
in
is
Login
is P
directed to Homepage .
The
current member’s name
is
stated
in
the upper right side of
the
homepage. Log
Out,
Your Account links
are
activated. transaction It shows 110
P
also
what
is
currently on
the
member ‘s shopping cart Member
MS1, PR1- 1
the
steps
signs in with 2 invalid email address and valid 19
Do
password 2
in
The
P
expected
The actual
Test
results
of
Condition
Test
Test
1
Condition 1
Condition 1
"Homepag
follows
is provided
e link" Click Log
Page
in link
directed to
directed to
the
the
is
Login
Page
3
Member
Member
inputs
sign failed.
results
of
Page
is
Login
Page
P Member is
invalid
prompted
username
to sign in
and
again.
valid
password.
“Login
Clicks
Failed” is
“Login” button
111
P
displayed.
Member
MS1, PR1- 1
email
address and invalid 20
the
steps
signs in with 2 valid
Do
password 2
in
The
P
expected
The actual
Test
results
of
Condition
Test
Test
1
Condition 1
Condition 1
"Homepag
follows
is provided
e link" Click Log
Page
is
“Login
in link
directed to
failed!”
the
message is
Login
Page
results
of
P
displayed. User
is
prompted to 3
retry
Member
Member
sign in “Login
inputs
sign failed.
failed!”
valid email address and invalid password. Clicks “Login” button
112
P
message is displayed. User
is
prompted to
retry
sign in
Member
MS1, PS1- 1
the
steps
signs in with 2 invalid email address and invalid 21
Do
password 2
in
The
P
expected
The actual
Test
results
of
Condition
Test
Test
1
Condition 1
Condition 1
"Homepag
follows
is provided
e link" Click Log
Page
is
“Login
in link
directed to
failed!”
the
message is
Login
Page
results
of
P
displayed. User
is
prompted to 3
retry
Member
Member
sign in “Login
inputs
sign failed.
failed!”
invalid email address and invalid password. Clicks “Login” button
113
P
message is displayed. User
is
prompted to
retry
sign in
USER ACCESS CONTROLTESTING - Authorization MS1, MS3, 1 Public PB1-2
User selects
Process
The
product
product
a will
product Checkout
The
P
be will
be
to added
to
added
and clicks the basket. the basket. (is
“Add
restricted to
to This
Basket”
Public Users
is This
reflected in
is
reflected
the in
the
Shopping
Shopping
Basket
Basket
area in the area in the right side right side 22 2
Member
of the site. The
of the site. Direct the P
clicks
second
public user
“View
step
Basket”
checkout
where they
button
(Address)
can
from the is Shopping Basket. 114
of to a page
not register
continued
Click “Continue ” button MS1, MS3
1
Do
the
steps
View Personal Info is only
in
for members
P
expected
Test
results
Condition
Test
The actual
19
Condition
results
"Member
19 follows
Test
Sign
authorized
The
of
in
of
Condition
with valid
19
email
provided
is
address and
23
valid
password”
2
Member
Directed to
P
clicks on Your Directed to “Your
Account
Account”
page
Your Account located at page. the top of the page
115
3
Member
Personal
Direct
clicks on Informatio
to P
Personal
Personal
n
of Informatio
Info link
member is n displayed
Page.
Displays details about
the
member MS1, MS3
1
Do
the
steps
View Order History
is
only authorized for members
in
P
expected
Test
results
Condition
Test
The actual
19
Condition
results
"Member
19 follows
Test
Sign
in
of
19
email
provided
and
valid
password”
116
of
Condition
with valid
address
24
The
is
2
Member
Directed to
P
clicks on Your Directed to “Your
Account
Account”
page
Your Account located at page. the top of 3
the page Member
Order/s of Directed to P
clicks on that
Your
“Your
specific
Orders
Account”
member
Page.
located at are/is
Displays
the top of displayed
details
the page
each order transaction of member
INTEGRATION TESTING
117
the
MS1,
1
Do
the
steps
MB1-12
Member pays through
in
P
expected
Test
results
Condition
Test
The actual
19
Condition
results
"Member
19 follows
Test
Sign
PayPal
The
of
in
of
Condition
with valid
19
is
email
provided
address and
25
valid
password”
2
After
Direct the Direct the P
adding
page
to page
product to View
View
shopping
Basket
Basket
basket,
page as the page as the
member
first
clicks
of
“View
checkout
checkout
Basket”
process
process
button from the Shopping Basket 118
to
step first
step
the of
the
section.
3
Member
Direct the Direct the P
clicks
page
“Continue
Address
” button
Page
to page
to
Address as Page.
the second Displays step of the the billing checkout
address
process
and
the
order details for the product/s to
be
purchased
119
4
Member
Directs to Directs to P
selects
Payment
Payment
“Credit
page
page. After
Card”
choosing
radio
“Credit
button
Card” , the
clicks
page
“Continue
directed to
” button.
PayPal site
is
SESSION TESTING MS1, Saves
MB1-12
checkout session even if
member
decides cannel paying
26
to
1
Do
the
steps
in
The
P
expected
Test
results
Condition
Test
The actual
19
Condition
results
"Member
19 follows
Test
Sign
in
of
Condition
with valid
19
email
provided
through
address
PayPal
and
valid
password”
120
of
is
2
After
Direct the
adding
page
P
to
product to View Direct the shopping
Basket
basket,
page as the
member
first
clicks
of
“View
checkout
Basket”
process
page
to
View step Basket the page as the first
step
of
the
button checkout from the process Shopping Basket 3
section. Member
Direct the Direct the P
clicks
page
“Continue
Address
” button
Page
to page
to
Address as Page.
the second Displays step of the the billing
121
the product/s to
be
purchased 4
5
Member
Directs to Directs to P
selects
Payment
Payment
“Credit
page
page. After
Card”
choosing
radio
“Credit
button
Card” , the
clicks
page
“Continue
directed to
” button. Member
is
PayPal site Should
F It
clicks
show
“Back”
previous
will
show that the
page
has
been
from the checkout browser
status expired.
toolbar
122
MS2
1
Do
the
steps
Member clicks “Log
in
P
expected
Test
results
Condition
Test
The actual
19
Condition
results
"Member
19 follows
Test
Sign
Out”
The
of
in
of
Condition
with valid
19
email
provided
is
address and
27
valid
password”
2
Member
The
Message
clicks
member
displayed
Logout
should be is “Logout
link
logged out Your
located
successfull
Session
above the y
has
site
ended.”
ERROR HANDLING TESTING
123
P
PMS1-4
1
It will return
Public User and Member
no
results
since
the
keyword
is
unavailab
invalid
or
le
unavailable
Invalid
invalid
search
search entry
PMS1-4
1
Results
the in
message, “Sorry,
engine
products
located
match
site Public
Member
results since the
search
keyword
is
inputs
invalid
or
available
unavailable
valid
search entry
no
the
query: -- “
It will return
User and
or
and
displays
above the Valid Search
is
Search
page
the search
28 29
Page
directed to
search
inputs
or
P
Page
is P
directed to Search Results page
and
displays the
in
products
the search
related to
engine
that
124
located above the site
PMS1-4
1
keyword
Member or Public User selects product
Direct
the
Direct
the
page
that
page
that
shows
the
shows
the
selected
selected
a product
product
details without
No
image
image
available
details even the
without
the
image.
Display image that says
“No
Image Available” 30
is shown
(Rhochella dela Cruz)
Testing Requirements for Administrator
Admin Log in/Log out (AL) 125
P
1. The admin is required to input his valid username and valid password. Failed log in would display an error message of password or both, an error message would appear “Login failed. Please try again.” If the user has successfully logged in, he would be able to use administrator functions and directed automatically to the admin homepage. 2. If the administrator clicked the Logout located on the upper left corner of the admin page, “No Administration session was found.” Is the message displayed? The admin is directed back to the admin login page.
Add Category (AC) 1. Once the admin is successfully logged in, he can click on the Add Category link under Catalog to add a category. 2. He would have to fill in the category details as the page is directed to Category Page, where in the form is displayed. The information that the admin has to provide in the text fields are: •
Category Name
•
Image (Optional)
View Categories (VC) 1. Once the admin is successfully logged in, he can click on the View Categories link under Catalog to view all the categories in the database. 2. All the categories in the database will be displayed along with their category details such as: •
Category Name
•
Directory
•
Image
•
Number of Products 126
•
Action (can be selected by the admin to manage the categories)
3. All categories in the database will be displayed along with the actions that can be selected by the admin to manage that category 4 Admin can click on “Delete” link to delete that specific category from the database. 5. Admin can click on “Edit” link to edit that specific category from the database. The admin can edit the following: •
Category Name
•
Image (Optional)
Add Product (AP) 1. Once the admin is successfully logged in, he can click on the Add Product link under Catalog to add a product. 2. He would have to fill in the product details as the page is directed to Category Page, where in the form is displayed. The information that the admin has to provide in the text fields are: •
Product Name
•
Category from the drop down menu
•
Image
•
Sale Price
•
Select “No” to stock level
•
Select “Yes” to include the product in the “latest products” section of the site
View Product (VP) 1. Once the admin is successfully logged in, he can click on the View Products link under Catalog to view all the products in the database. 127
2. All the products in the database will be displayed along with their product details 3. Admin can click on “Edit” link to edit that specific category from the database. The admin can edit product details. 4. Admin can click on “Delete” link. A pop up message will say “Are you sure you want to delete?” will appear. Clicking OK will delete the product from the database. View Customers (VM) 1. Once the admin is successfully logged in, he can click on the View Customers link under Customers to view all the members and their personal details. 2. All the members in the database will be displayed along with their personal details they have given during their registration. 3. Admin can click on “Edit” link to edit that personal information of that specific member. The admin can edit the personal details, as long as he inputs valid information, 4. Admin can click on “Delete” link. A pop up message will say “Are you sure you want to delete?” will appear. Clicking OK will delete the product from the database.
View Orders (VO) 1. Once the admin is successfully logged in, he can click on Orders link under Customers to view all the transactions of members. 2. All the transactions in the database will be displayed along with the transaction details 3. Admin can click on a specific Order No link to view the Invoice for that transaction. The Customer information will also be displayed to show who owns that transaction. An Order Summary is also displayed to view products ordered and the total bill. The admin can change the status of the order to the following: 128
•
Pending
•
Uncleared
•
Processing
•
Cancelled
•
Completed
•
Declined
•
Fraudulent
4. Admin can click on “Delete” link. A pop up message will say “Are you sure you want to delete?” will appear. Clicking OK will delete the order from the database. Statistics (S) 1. This is one of the added features provided by the site. Once the admin is successfully logged in, he can click on View Stats under Statistics to view the Top 10 Products of the site. This is based on the number of public users or members’ product preview. Store Configuration (SC) 1. Once the admin is successfully logged in, he can click on the General Settings link under Store Config. The admin can modify the main settings of the site in this section. Changes in this section is updated and reflected in the browser whenever the site is visited. Modules (M) 1. This is one of the third party features that were integrated to complete the e-commerce experience of the site. Once the admin is successfully logged in, he can click on the Gateways link under Store Config. The admin can select which payment company he prefers to handle online payment transactions. In this site, the client preferred to use PayPal as the main online 129
payment engine. The payment companies are easily integrated within the site using the simple configurations. 2. This is one of the third party features that were integrated to complete the e-commerce experience of the site. Once the admin is successfully logged in, he can click on the Shipping link under Store Config. The admin can select which shipping company he prefers to handle online payment transactions. It is the client’s decision to select which shipping company he prefers or if he would use the shipping feature. Admin Account (AA) 1. Once the admin is successfully logged in, he can click on Administrators under Admin Users. This function is for the security purposes. 2. After clicking Admin Users, the administrator of the site is displayed. The admin can edit his profile here. He can change the following and the changes will be updated once the “Edit User” button is clicked. This is important to secure who maintains the site. •
Full Name
•
Username
•
Email
•
Password
3. The admin can also delete admin accounts in case there are several by clicking the Delete link. Admin Search (AS) 1. Admin can search for orders using the search order function. 2. Admin inputs order number in the search field. If the keyword in available, the Orders page will be post the transactions. If the keyword in unavailable, the Orders page will post no results. 3. Admin can search for members. 130
4. Admin inputs member or any keyword that is related to personal details of the member. In the search field. If the keyword in available, the Customers page will be post the transactions. If the keyword in unavailable, the Customers page will post no results. (Rhochella dela Cruz) Testing Assumption 1. the default username is “admin” 2. The default password is “passw0rd” 3. The server connect to the admin page
Test
Test
Requirem
St
Step
conditi
condition
ent No
ep
script)
on No 1
Description
(test
Expected
Actual Result
Results
ss
No Admin logs in
with
AL1
. 1
Fai In the browser, the admin
The
page
The
page
goes
will
be
will
be to
to
valid
www.wavesofboracay.com
directed to
directed
username
/admin.
the
the
administrat
administrator
or link. The
link. The log
log in page
in page will
will
have
and
Pa
valid
password
131
have
empty
empty
username
username
and password
and
text fields
l P
password 2
Type
"admin"
on
the
text fields "admin"
P "admin"
Username text field
would
be
shown
in
would
be
shown in the the Username Username text field 3
4
Type "passw0rd" on the
text field "passw0rd"
"passw0rd"
Password text field
would
be
would
shown
in
shown in the
Click Login button
P
be
the
Password
Password
text field
text field Successful
Admin
is
login
directed
to
P
the administrator 2
Admin
AL1
1
In the browser, the admin
The
page
enters valid
goes
will
be
username
www.wavesofboracay.com
and invalid
/admin.
to
password
page
will
be
directed to
directed
to
the
the
administrat
administrator
or link. The
link. The log
log in page
in page will
will
have
empty
132
page The
have
empty
username
P
username
and password
and
text fields
password 2
Type
"admin"
on
the
text fields "admin"
P "admin"
Username text field
would
be
shown
in
would
be
shown in the the Username Username text field 3
4
Type "passw0rdko" on the
text field "passw0rd"
"passw0rd"
Password text field
would
be
would
shown
in
shown in the
Click Login button
P
be
the
Password
Password
text field
text field Failed
A
login
“Login
message,
P
failed. Please try
again”
will
appear
on top of the admin log in 3
AL1
Admin logs with
in
1
In the browser, the admin
The
page
goes
will
be
to
page The will
be to
www.wavesofboracay.com
directed to
directed
/admin.
the
the
133
page
P
invalid
administrat
administrator
username
or link. The
link. The log
log in page
in page will
will
have
and invalid password
have
empty
empty
username
username
and password
and
text fields
password 2
Type "rhochella" on the
text fields "admin"
P "admin"
Username text field
would
be
shown
in
would
be
shown in the the Username Username text field 3
4
Type "passw0rdko" on the
text field "passw0rd"
"passw0rd"
Password text field
would
be
would
shown
in
shown in the
Click Login button
be
the
Password
Password
text field
text field Failed
A
login
“Login
message,
failed. Please try
again”
will
appear
on top of the
134
P
P
admin log in 4
AL1
Admin
1
The page will be directed
The
page
to the administrator link.
will
be
The log in page will have empty
page The
page
will
be
directed to
directed
to
the
the
administrat
administrator
username
or link. The
link. The log
and valid
log in page
in page will
password
will
have
logs
in
with invalid
username
and
password text fields
have
P
empty
empty
username
username
and password
and
text fields
password text fields "admin"
2
P "admin"
"rhochella"
would
would
be
shown
in
be
would
shown in the Username
be
shown in the the
text field
Username Username text field
3
text field "passw0rd"
"passw0rd"
shown in the Password
would
be
would
text field
shown
in
shown in the
"passw0rd"
would
be
the
Password
Password
text field
text field
135
be
P
4
Admin
clicks
“Login”
button
Failed log
A
message,
in
“Login
P
failed. Please try
again”
will
appear
on top of the admin log in page 5
Admin
The The
clicks
Do
the
steps
in Test
actual
expected results
logout
in
AL1,
Condition 1 "User enters
results
valid
Test
1 the
AL2
of
of
P
Test Username
and
Condition 1 navigation
Password"
Condition is provided
bar
1 follows The would
be
directed
to
the The
user
admin
user log in page.
Click
Logout
button
would
be A message is
2
located in the upper right
directed to displayed in
side of the admin page
the admin the above the log in page page
“No
administrator session found.”
136
was
P
6
Admin
AP1-2,
adds
AL1
1
Do
the
steps
in Test
The The
a
Condition 1 "User enters
expected
valid
results
actual
results
product
Username
and
of
of
P
Test Password"
Test Condition 1 Condition is provided
2
Under Catalog, click Add Product
3
1 follows Page is
Page
is
directed to
directed
to
the Product
the
Inventory
Inventory
page
page
that
Product
that
lists all the
lists all the
Admin fills in all the
products The
products Page
is
product details needed and
product
directed
to
clicks Add Product
will
be
the
added
to
Inventory
Product
the list of
list. Display
products
message appears
“
product_nam e 7
AP1-2,
Admin adds product
a
AL1
1
added
The
successfully” The actual
Condition 1 "User enters
expected
results
valid
results
Do
the
steps
in Test
Username
Password"
but 137
and
Test
of
of
Test Condition 1
P
doesn’t put
a
Condition is provided 1 follows
Product Name 2
Under Catalog, click Page Add Product
3
Admin fills in some of the product
details
Product
Page
is
directed to
directed
to
the Product
the
Inventory
Inventory
page
page
Add
Product
that
lists all the
lists all the
products The
products
It
will
direct
will still be added
Clicks
that
but product
doesn’t put a Product Name.
is
the
administrat
to
the product
or to the
list because
product
there is still
inventory
product
page with
code
prompt message “ added successfull y”.
The
previously 138
added product is listed
in
the catalog but has a null detail under Name 8
AP1-2,
Admin adds
a
1
AL1
Do
the
steps
in Test
Condition 1 "User enters valid
new
Username
and
Password"
product but
The The
missing
actual
expected results
out some
results
product
Test
of
of Test Condition 1
Condition
informati
is provided 1 follows
on (numeric al informati on) 2
Under Catalog, click Page 139
is
Page
is
Add Product
3
Admin fills in some of the product
details
leaves
out
directed to
directed
the Product
the
Inventory
Inventory
page
page
that
numerical information
Product
that
lists all the
lists all the
products The
products
Product
but product some
to
successfull
will still be added
y added to
to
the product list because
the database.
there is still product code
Page directed to the Inventory Page
The missed detail will display “n/a” 9
Admin
AL1,
1
Do
the
steps
140
in Test
The
The
actual
adds
AP1-2
Condition 1 "User enters
expected
valid
results
results product
Username
and
of
of Test
without
a
Password"
Test Condition 1
sales price
Condition is provided 2
Under Catalog, click Add Product
3
Admin fills in some of the product
details
doesn’t
indicate
Sales Price
1 follows Page is
Page
is
directed to
directed
to
the Product
the
Inventory
Inventory
page
page
that
that
lists all the
lists all the
products The
products
Product
but product a
Product
successfull
will still be added
y added to
to
the product list because
the database.
there is still product code
Page directed to the Inventory Page
141
The missed detail will display default value $0.00 under price 10
Admin
AL1,
views the
VP1-2
1
product
Do
the
steps
in Test
Condition 1 "User enters
The
valid
expected
Username
and
Password"
with
The
actual
results results
of
of Test
Test Condition 1
missing
Condition is provided
informati
1 follows
on 2
3
Admin clicks on View
Page
Products under Catalog
is
Page
is
directed to
directed
to
the Product
the
Inventory
Inventory
page
page
that
that
lists all the
lists all the
products
products
Admin views the product
In
with missing information
Product
142
Product
the Page directed to
F
Inventory the page, the Inventory product list
Page
will
appear but
The the missed
missing
detail will
detail for display that
“n/a”
newly added product will
be
blank 11
Editing the
AL1,
product
VC1-3
1
Do
the
steps
in Test
The The
Condition 1 "User enters
expected
with
valid
results
missing
Password"
actual
results Username
and
of
of Test
Test Condition 1
information
Condition is provided 2
Admin clicks on View
1 follows Page is
Page
is
Products under Catalog
directed to
directed
to
the Product
the
Inventory
Inventory
143
Product
page
3
Admin clicks Edit
that
page
that
lists all the
lists all the
products
products
In
the In
Product
the
Product
Inventory Inventory page, the page,
4
Admin clicks Edit Product
the
product
product
form
form
appears
appears
The
The page is
product’s
directed
informatio
Product
n will be
Inventory
updated
page.
to
The
previously edited product
is
now updated 12
Admin
VC1-2,
deletes a
VC4,
Condition 1 "User enters
expected
AL1
valid
results
product
1
Do
the
steps
in Test
The The
actual
results Username
and
of
of Test
Password"
Test Condition 1 Condition is provided 1 follows
144
2
3
Admin clicks on View
Page
Products under Catalog
Admin clicks Delete
is
Page
is
directed to
directed
to
the Product
the
Inventory
Inventory
page
page
that
Product
that
lists all the
lists all the
products
products
Product
Pop
will deleted
up
be message would appear "Are
you
sure
you
want
to
delete this?”
The page is directed
to
Product Inventory page and the product is no longer listed in the list
145
13
Administra
AL1,
1
Do
the
steps
in Test
The
tor
VC1-3,
Condition 1 "User enters
expected
AC1-2
valid
results
The views
actual
results categories
Username
and
of
of Test
Password"
Test Condition 1 Condition is provided
2
Admin clicks on View
1 follows It will
Page
is
Categories
show
a
directed
to
page
with
all
14
Admin
AL1,
adds
AC1-2
1
category
the
the Categories
categories
page
in
the
lists all the
database Do the
categories. The expected
Condition 1 "User enters
steps
results
valid
Test
Test
Condition
Condition 1
1
follows.
Do
the
steps
in Test
Username
and
Password"
in
"User
that
of
enters valid Username and Under
Catalog,
admin
clicks on Add Category 2
146
Password" Page is
Page
is
directed to
directed
to
the
the
Add
Category
Category
page.
page.
Add
3
Admin fills in all category
New
Page
is
information
category is
directed
to
added
the
and
clicks
“Add” button
15
to
View
the
Categories
Category
page.
list that is
Display
viewable
message,
when View
“category_na
Products is
me” is added
clicked Do the
successfully. The expected
Condition 1 "User enters
steps
results
valid
Test
Test
Condition
Condition 1
category
1
follows.
name
enters valid
Admin adds
AL1, a
1
VC1-2
category without
a
Do
the
steps
in Test
Username
and
Password"
in
"User
of
Username and 2
Under
Catalog,
admin
clicks on Add Category
3
Password" Page is
Page
is
directed to
directed
to
the
the
Add
Add
Category
Category
Admin fills in all category
page. New
page. Page
is
information
category is
directed
to
added
the
except
the
categorny name field and
147
to
View
clicks “Add” button
the
Categories
Category
page.
list that is
Display
viewable
message, “’ ‘
when View
is
Products is
successfully.
clicked. It
”
added
will still be added because there’s 16
Admin
AC1-2,
1
Do
the
steps
in Test
a
category id The The
edits
a
AL1,
Condition 1 "User enters
expected
VC5
valid
results
actual
results category
Username
and
of
of Test
Password"
Test Condition 1 Condition is provided
2
Admin clicks on View
1 follows The
Categories
expected
The
actual
results results
of
of Test
Test Condition 1 Condition is provided 13 follows
148
3
Clicks
Edit
to
change
Direct the
Direct
page to the
page to the
Edit
Edit
Category
Category
Clicks Edit button after
page Category
page Message
updating the categories’
will
information
updated
“category_na
and
me
reflected in
successfully”
category information
4
be
the
displayed,
updated
the Categories
Directs to the
page
Categories page with the newly updated category
17
Admin
VC5,
1
Do
the
steps
in Test
The The
edits
a
AC1-2,
Condition 1 "User enters
expected
AL1
valid
results
actual
results category
Username
and
of
of Test
without an
Password"
Test Condition 1
image
Condition is provided 2
Admin clicks on View
1 follows The
The
Categories
expected
results
results Test
149
of
actual of
Test Condition 1
Condition is provided 3
4
Clicks Edit to edit the
13 follows Direct the
Direct
category. Admin doesn’t
page to the
page to the
upload an image
Edit
Edit
Category
Category
Clicks “Edit” button after
page Category
page Message
updating the categories’
will
information
updated
“category_na
even
me
without an
successfully”
be
the
displayed,
updated
image. Directs to the Categories page with the newly updated category but shows
“
“
under Image. 18
Admin
AL1,
1
Do
the
steps
in Test
The The
uploads
a
AC1-2
Condition 1 "User enters
expected
category
valid
results
image that
Password"
actual
results Username
and
of
of Test
Test Condition 1
is too big
Condition is provided 1 follows
150
2
Admin clicks on View
The
Categories
expected
The
actual
results results
of
of Test
Test Condition 1 Condition is provided 3
4
Admin clicks on Edit to
13 follows Direct the
Direct
edit the category. Admin
page to the
page to the
uploads an image that is
Edit
Edit
too big.
Category
Category
page Category
page
Clicks “Edit” button after updating the categories’
will be not
message
information
be updated
the
A pop up
will appear
because there is a
that says “
certain size
Error:
limit to an
image_na
image
me is over 512 KB
19
Admin
VC4,
1
Do
the
steps
in Test
The The
deletes
a
AL1,
Condition 1 "User enters
expected
AC1-2
valid
results
actual
results category
Username
and
of
of Test
Password"
Test Condition 1 Condition is provided 1 follows
151
2
Admin clicks on View
The
Categories
expected
The
actual
results results
of
of Test
Test Condition 1 Condition is provided 3
Admin clicks Delete
13 follows The category will
A pop up message
be
will appear
deleted from
the
database
“Are
you
sure
you
want
to
delete this?” 4
Admin clicks “OK”
The
Directs
category
page to View
will
be
deleted from database
the
the
Categories with
the
updated
list
of categories.
Display message,
“Deleted successfull 152
y.” 20
Admin
AL1,
views
VM1-2
1
Do
the
steps
in Test
The The
Condition 1 "User enters
expected
valid
results
actual
results customers
Username
and
of
of Test
Password"
Test Condition 1 Condition is provided
2
Under Customers, click
1 follows It will
Directs
View Customers
show
Customers
all
to
members in
Page
that
the
shows
all
database
members and their details.
21
Admin
AL1,
edits the
VM1-3
1
Do
the
steps
in Test
Condition 1 "User enters valid
member’
Username
and
Password"
The The
actual
expected results results
of
of Test
Test
s account
Condition 1 Condition
informati
is provided 1 follows
on 2
Under Customers, click
It
View Customers
show
will all
Directs
to
Customers
members in
Page
that
the
shows
all
database
members and their details.
153
3
Admin clicks Edit
It
will
Directs
to
show
Customers
editing
Page
form
the member’s
where
account information 4
Admin
clicks
Customer” button
“Edit
can be edited Directs to
Updates will
be
Customers
saved
in
Page that has
the
the
list
of
database
members and information.
“Customer updated successfull y” message is displayed in the top of
the
members list page
154
22
Admin
VM1-4,
deletes
AL1
1
Do
the
steps
in Test
The The
Condition 1 "User enters
expected
valid
results
actual
results member
Username
and
of
of Test
Password"
Test Condition 1 Condition is provided
2
Under Customers, click
1 follows It will
Directs
View Customers
show
Customers
all
to
members in
Page
that
the
shows
all
database
members and their details.
3
Admin clicks Delete
Deletes the
A pop up
member
message
from
the
will appear
database
“Are
you
sure
you
want
to
delete this?” 4
Admin clicks “OK”
Updates
Directs
the
will
be
page
to
saved
in
Customers
the
with
the
database
updated
list
of members
155
Display message,
“Deleted successfull y.” 23
Admin
AL1,
views
VO12
1
Do
the
steps
in Test
The The
Condition 1 "User enters
expected
valid
results
actual
results Orders
Username
and
of
of Test
Password"
Test Condition 1 Condition is provided
2
Under Customers, click
1 follows It will
Directs
Orders
show
Orders Page
all
the orders
that
stored
all
in
to
shows
the
transaction
database
and the order details
24
Admin
AL1,
1
Do the steps in Test 23
The The
views
the
VO1-4
actual
expected results
Order
result
invoice
the
of
of Test Test Condition 23
Condition is provided 23 follows
156
2
Admin clicks on an Order
It
will
Directs
to
No.
show
another page
transaction
that
opens
details
the
Invoice
for
that
selected order 25
Admin
VO5,
1
Do the steps in Test 23
The
deleted the
VO1-2,
expected
Order
AL1
result
The
actual
results
of
of Test
the
Test Condition 23
Condition is provided 2
Admin clicks Delete
23 follows Deletes the order
Pop message will appear saying “Are
you
sure
you
want
to
delete this 3
Admin clicks OK
Shows the
Directs
new list of
Orders Page
orders
with newly updated
157
to
the
orders
list.
Displays
a
message, “Deleted successfully” 26
Admin
VO1-3,
changes
AL1
1
Do the steps in Test 23
The The
actual
expected results
status
of
result
of
of Test
order
the
Test Condition 23
Condition is provided 2
Admin clicks on a specific
23 follows Selects that
order number
order
Admin changes the status
Changes
Shows
of the order and clicks
the
status
updated
“Save Order Status” Do the steps in Test
of the order The
Invoice.
Condition 1 "User enters
expected
valid
results
Opens the invoice of the order
3
27
Admin
AS1-2
1
The searches
the
actual
results invalid
or
Username
and
of
of Test
unavailable
Password"
Test Condition 1
order
Condition is provided 2
1 follows No result
Direct
admin inputs unavailable
will
Orders Page.
or invalid search keyword
provided
In
the
Admin
Home,
in Order Number field
be
Displays message, “There
158
to
are
no orders in the database” 28
Admin
AS1-2
1
Do
the
steps
in Test
The The
searched
Condition 1 "User enters
expected
for invalid
valid
results
or
Password"
actual
results Username
and
of
of Test
Test Condition 1
unavailable
Condition
order
1 follows Order will
Direct
admin inputs available or
be
Orders Page
valid
as a result
is provided 2
In
the
Admin
Home,
search keyword in
posted
Order Number field
to
and give the result correspondin g
to
that
order 29
Admin
AS3-4
1
Do
the
steps
in Test
The The
searches
Condition 1 "User enters
expected
for invalid
valid
results
or
Password"
actual
results Username
and
of
of Test
Test Condition 1
unavailable
Condition
member
1 follows No results
Direct
admin inputs unavailable
will
Customers
or
posted
is provided 2
In
the
Admin
invalid
keyword
Home,
member
be
to
Page. Displays the message “No customers exist in the
159
database” 30
Admin
AD3-4
1
Do
the
steps
in Test
The The
searched
Condition 1 "User enters
expected
for valid or
valid
results
available
Password"
actual
results Username
and
of
of Test
Test Condition 1
member
Condition is provided 2
In
the
Admin
Home,
1 follows Member
admin inputs available or
will
valid member keyword
posted
Direct be
to
p
Customers Page
and
give
the
result correspondin g
to
that
member 31
Admin
AA1-2
1
Do
the
steps
in Test
The
P The
edits
the
Condition 1 "User enters
expected
admin
valid
results
account
Password"
actual
results Username
and
of
of Test
Test Condition 1 Condition is provided
2
1 follows Direct the
Direct
Administrators link under
page
page
Admin Users
Administra
Administrato
tors page
rs
Admin
clicks
to
where
the to
page the
current admin users
160
P
are displayed along their
with admin
profile. 3
Admin clicks Edit and
Direct
inputs an invalid email
Edit
address (invalid format)
Administra tor
to the
page.
“Updated
update with
Successfully
invalid
” message.
address format
161
Displays
should not
email
(Rhochella dela Cruz)
F
XI.Risk Management The Waves of Boracay Website has functions both for the administrator and members. However, there are risks that involves in this system. These risks may be in terms of product size, business impact, customer characteristics, process definition, development environment, technology to be built, or staff size and experiences. The mentioned risks will be expected in this system. The project team should be able to analyze each risk to be able to manage each of them. In doing so, the system will be able to avoid down time in the future use. (Cristina Ubaldo) A. Risk Identification The risk identifications in Waves of Boracay Website are identified by product size, business impact, customer characteristics, process definition, development environment, technology to be built, or staff size and experiences. (Cristina Ubaldo) Category Product size
Risks The size of the system’s database might not be enough. The allowable storage size of uploaded pictures might not be sufficient. Maintenance of the system.
Business impact
Limited number of people who can access the website all at the same time 162
Customer characteristic
Miscommunication between the project leader and the client. Misunderstanding between the project leader and the client. Undecided system’s requirements. Insufficient time in meeting. Indecisiveness of the client may cause delays.
Process definition
The project team might not be able to finish the project on time. Sudden function changes. The project team might not be aware of the programs that are effective in developing the project.
Development environment
Slow system development. Compatibility of programs to each member.
Technology to be built
The project might not work efficiently on the client’s computer. Hard time in detecting and fixing errors. The number of people in the project team may not be sufficient in developing the project.
Staff size and experiences
The experience of the project team may not be enough in completing the project.
Table – Risk Identification (Cristina Ubaldo)
Product Size 163
This risk pertains to the availability of storage in the database of the website. The project team or the software engineers should estimate the available storage space. These risks will lead to system malfunctioning and incomplete user interface. Business This risk pertains to the movement within system. A risk on the limited number of users lessens the capability of the website. That could lead to a time-consuming maintenance of entire system. Customers Characteristics This risk pertains to the behavior of the client and the project team. Cooperation between the two parties is very much important to come up with a successful project. Communication is the best key in relation to producing and developing a project. Process Definition This risk pertains to the importance of being efficient in relation to time. It is important for the project team to follow the client’s requirements, and at the same time, be able to develop the project within the given due date. But this can only be achieving through the help of the client, by not being indecisive. Development Environment This risk pertains to the awareness and of being resourceful of a person. It will be difficult for the project team to be working on develop program because of this, a risk slow system development. Technology to be built This risk will happen only if the project team doesn’t cooperate with one another. Every member of the team has their own skills and methods in producing their assigned tasks, which can most likely have a risk in compatibility of programs to each member. This could also lead to a 164
problem involving the client, wherein the project will not efficiently work on his computer. Also, since the programming sill of each member differs, then there could be a possibility to have a hard time in detecting and fixing errors. Staff Size and Experience The project team is composed of four members, each of them processing their own capability. Through their capabilities, they will be able to come up with the required system. Even though they don’t have enough experience, this would not hinder them from performing this project. (Cristina Ubaldo) B. Risk Analysis Risks The size of the system’s database might not be enough.
The allowable storage size of uploaded pictures might not be sufficient. Maintenance of the system.
Limited number of people who can access the website all at the same time Miscommunication between the project leader and the client. Misunderstanding between the project leader and the client.
Undecided requirements.
system’s
Probability 10%
Impact 2
50%
3
RMMM Estimation of storage availability of the system’s database is very important. Mange the size of every upload.
60%
3
40%
2
10%
4
10%
4
20%
5
Set goals for the systems stability for future use. Make sure of the systems configurations regarding session time. There should be a strictly planned meeting regarding the systems requirements. The leader should analyze every requirement or detail that the client wants. The project team should help the client in developing ideas for the
165
20% Insufficient time in discussing important requirements and changes of the client. Indecisiveness of the client may cause delays.
20%
3
5
system to avoid a hard time in decision-making. The simplest way of communication will do. Set objective for the week to be able to finish on time.
10%
The project team might not be able to finish the project on time.
2
A reasonable date will be just right to be able to have enough time in processing the project.
4
Be ready to adopt sudden changes. A lot time for sudden changes. Gather information about the programs over the internet or through information from friends.
40%
Sudden function changes. The project team might not be aware of the programs that are effective in developing the project.
30%
2
20%
21
20%
2
40%
3
Slow system development. Compatibility of programs to each member.
The project might not work efficiently on the client’s computer.
30%
4
Hard time in detecting and fixing errors. The number of people in the project team may not be sufficient in developing the project. The experience of the project team may not be enough in
Consider the future use of the system in setting goals for the project. Use programming tools that will enable the program to every member’s computer. Use programming tools that will enable the program to the client’s computer. Check the project from time to time to update errors.
30%
3
60%
3
Assess the skills of every member. Define the tasks for each member.
Tools in the internet may help in 166
completing the project.
developing the project.
Table – Risk Analysis (Cristina Ubaldo) Legend 1 – low 2 – negligible 3 – marginal 4 – critical 5 – catastrophic The risks are identified in this table. It shows the probability, impact, and the RMMM of every risk. The probability of occurrence is measured through percentage. The highest probability of risk is maintenance of the system and experience of the project team may not be enough in completing the project. The impact pertain to the project on a scale of 1 to 5, where 1 having a low impact on project success and 5 having catastrophic impact on project success. On the last column is the RMMM, which stands for risk mitigation, monitoring, and management, where avoidances of the risk are indicated. (Cristina Ubaldo)
XII.Deployment I. 10
System Configuration
Introduction There may come a time that developers may require changes to the system. To identify the
change, control the change and report the changes made, the developers will make use the Software Configuration Plan. It is important to practice this plan in the team. 167
1.1 Scope and Intent of Software Configuration Management (SCM) The purpose of SCM is to identify change, control change, report change and inspect if the changes are properly implemented in the system. It is practiced during the whole development process to be able to keep track the changes. This practice is very important because it can minimize errors and save the developers lot of time. All the developers must see to it that they give an accurate report of the changes in the system to the other developers. 1.2 SCM organizational role The team is made up of only four members and each member will have the task to evaluate the proposed changes of the other member. Each member is also required to report all the changes to be made to all the members. 20 System Configuration Management Tasks Important tasks will be identified and these tasks will be assigned to a specific member 2.1 Identifying of Tasks When a change is requested by a member of the team, the rest of the project team will deliberate if the change should be made. The change must be evaluated and scrutinized by the group to avoid problems that may arise in the future. When approved, these changes must be implemented properly. The implementation of the change should be monitored by the team. The change must also be documented for future reference 2.2 Configuration Control The following documents will be needed when the changes are made to the system: (1) Request of change document – by the group member or the client (2) Evaluation of the change by the team members and (3) Approval or decline by the team members. If the change is approved by the team members, the change to be made and where the change will be made must be clearly defined. A back-up of the original item should be made. After making the necessary changes, the item changed should be tested. The change should be integrated to the whole system and then finally distribute the software to the team members. 2.3. Version Control
168
Every time a change would be made to the system, an updated version would be released. The version number will constantly increase every time a new change is implemented in the system. 2.4. Configuration Status reporting All the team members should be updated with all the changes made to the system. A report containing which member requested for the change, the changes made and the date the change was made. The features of the site affected by the change should also be reported to the members. The team can conduct meetings, or communicate via E-mail or SMS to inform the members. . (Katrina Dee) 3.0 . Installation Procedure
Users: 1. Install Internet Explorer or Mozilla firefox 2. Connect to the internet and visit http://wavesofboracay.com
3. Start shopping! Developers 1. XAMPP installation XAMPP is an easy to install Apache distribution containing MySQL, PHP and Perl. XAMPP is really very easy to install and to use. THe installation file can be downloaded here: http://www.apachefriends.org/download.php?xampp-win32-1.7.0-installer.exe How to install: •
Select the folder location where you want to install XAMPP
•
After the installation is complete, you will find XAMPP under Start / Programs / XAMPP. You can use the XAMPP Control Panel to start/stop all server and also install/uninstall services.
•
Start apache and mysql
2. Adobe Dreamweaver CS3 Installation 169
•
Run installer, select installation location, & follow installation process •
After installation, open Dreamweaver
•
Import wavesofboracay folder
3. Uploading to ftp server •
In the menu bar of dreamweaver, go to sites – new site
•
Click the advanced tab and click remote info
•
For access, select ftp in the drop down menu
•
Input all the ftp credentials then save and close
•
Go to sites again and select put
•
Confirm "put entire site into ftp server"
•
Site is now online (Katrina Dee)
II.
Client Testing Procedure
The team came up with functions that will be convenient to the client, the member and the public user. Functions were created and configured by the team to let the client manipulate his website store. CLIENT STEP 1 The client will open a web browser – Mozilla Firefox, IE explorer, Safari, etc. STEP 2 The client will type on the url http://wavesofboracay.com/admin then enter, to have an access on the admin page STEP 3 The client will input the administrator’s login username and password. For trial, the username is “admin” and the password is “passw0rd”. STEP 4 By pressing enter, the website will direct the client to the admin page 170
STEP 5 The functions of the admin page are located at the left part of the website. The admin can choose from the following functions: i. Add product – The client can add new products and information. Images of the newly added products can be uploaded ii.Add category – The website provides categories for the public users. The client can add categories on the website so the products will be organized based on their categories. iii.Edit product – The client can edit the products. He can change the information of the product or the image. iv.Edit category – A category can be renamed or changed and its picture. v. Delete product – The client can delete the product and its information and photos. vi.Delete category – The client can delete a category and its picture. vii.Log In – The client can log in as administrator. viii.Manage Orders – The client can view orders of his customers. ix.View product – The client can view products. x.Manage Store Configuration – The client can configure store settings. (Madelaine Mapile) MEMBER and PUBLIC USER STEP 1 The user will open a web browser – Mozilla Firefox, IE Explorer, Safari, etc. STEP 2 The user will type on the url http://www.wavesofboracay.com/ then enter, to have an access on the website of Waves of Boracay. STEP 3 The homepage of the website provides categories, located at the top-left part of the page, under the logo of the Waves of the Boracay. The function of the categories offers the member or the public user the organized list of the products and their category. The member or the user can choose any of the categories that were posted by the admin. Under the category is the information. The information shows the number of products available on the website and the number of categories. 171
The middle part of the website shows the welcome note of the website. Under the welcome note are pictures of the latest products that were uploaded by the administrator. Clicking on any of the pictures will lead to the information of the product such as its picture, product information, the product code and the price. The upper most right part of the home page is the Search Engine function. The member or the public user may wish to type keywords and it will navigate it to the exact or the nearest searched keywords available on the products by pressing the “Go” box. Under the Search Engine is sign-in for members or the registration for public users. Under the logo of the Waves of Boracay on the upper right part is the Shopping Basket where the member will be able to manage his shopping cart. After this, the top 10 popular products are shown where the member or the public user can choose from the top 10 products. By choosing one of the top 10 popular products, it will lead to the information of the chosen product. STEP 4 Before buying a product, the member or the public user should sign-in or register. Member The member clicks on the Login and he will input his email address and the password. If the memer forgets his password he will be directed to the “forgotpassword” page and he will be asked for his email. His password will be then sent to his email address. Public User The public user has limited access on the website. He may not be able to buy a product until he is registered. The public user should register first. The public user clicks on the Register and he will be directed to the registration form. The public user fills in the fields that have asterisks. Fields without asterisks are optional if the user will answer it. After inputting on the blank fields, click on the “Submit & Continue” box. The user becomes a member and will be navigated to the home page but already signed in. STEP 5 The member can now choose from any of the products available by using the functions that were explained on the first parts of the procedure. After choosing a product, the product information will be shown. The member can type on the quantity of the product that he wishes to purchase. After that, he can click on the “add to basket” box. Then the shopping basket will show the list of the items that the member wants to purchase. STEP 6
172
After shopping, the member clicks on the view basket and will be directed on the list of the products that he has chosen and their prices. He can also remove products and add more by entering the product code. STEP 7 When the member has done shopping and decided to purchase the products already, he clicks on the “continue” box on the lower right of his list. STEP 8 The next page will show the mailing address and the products that the member has chosen. He may edit his address if he wishes to send it as a gift or if he will change the shipping address. The total bill of the products is posted on the lower right before the “continue” box, then click on the continue. STEP 9 The member can choose from the payment methods available and write comments on the products or on the website for improvements or for recommendations. Available payment methods are Postal Order Form and Credit Card. Postal Order Form By choosing Postal Order Form, it will direct to the receipt of the purchased products. Credit card By choosing the Credit Card, it will direct to the PayPal. STEP 10 Then click on continue. Then it will be processed. (Madelaine Mapile)
XIII.Conclusion In going though the long process to come up with the Waves of Boracay website, the project team has already recognized and analyzed every bit of information that the system needs. The project team was able to manage the requirements of its client. In doing this system, not only the requirements of the client are needed, as well as the knowledge and skills of the project team 173
about programming to accomplish the system. Cooperation among the team members is also needed, especially in doing their assigned tasks. There are assigned tasks to every member to prevent from delays. The client was able commit himself with the project team, that’s why the team didn’t have a hard time in understanding and meeting the requirements of the client. The entire process and definition of tasks were well defined, properly executed, and dealt by the project team. The success of this project will only be known once the system has been implemented and deployed by the client. (Cristina Ubaldo)
IX. Index Analysis Model, 2, 10 Architectural Design, 2, 51 Behavioral Models, 2, 47 Capability, 2, 80 Client Testing Procedure, 3, 180 Component-Level Design, 2, 74 Conclusion, 3, 184 Context, 2, 52, 77 Data Design, 2, 50, 51 Deployment, 2, 3, 76, 77, 178 Design Model, 2, 49 Estimation, 2, 80, 81, 175 Function and Performance, 2, 78 Function-Based Estimation, 81
Gantt Chart, 2, 3, 83, 84 Informational Objective, 2, 78 Interface Design, 2, 60 Introduction, 2, 5, 178 Product Scope, 2, 77 Project Background, 2, 6 Requirements Analysis, 2, 7 Risk Analysis, 175, 177 Risk Identification, 172, 173 Risk Management, 3, 172 Schedule, 2, 82 Software Team, 2, 79 Software Testing, 2, 85 System Configuration, 3, 178
174