Project Proposal
Sarasavi Book Shop - Colombo
UNIVERSITY: UNIVERSITY OF COLOMBO FACULTY: SCIENCE COURSE UNIT: MANAGING INFORMATION SYSTEMS GROUP: BIOINFORMATICS
1
Project Proposal
Sarasavi Book Shop - Colombo
Declaration
Members of the project group “BIOINFORMATICS”, hereby declare that all designing and documentation are original work produced by the group members. Except for referencing, no duplication of any other work is done.
Member Name
Index No.
Kushan Gunawardane
S 8066
Sutharzan Sreeskandarajan
S 8149
Ramesh Gunaratne
S 8060
Prinosha Kiriwandelege
S 8039
Hasika Jayawickrama
S 8075
Sathishka Epa
S 8056
Shashika Ranasinghe
S 8036
2
Project Proposal
Sarasavi Book Shop - Colombo
Abstract A solution for the routine time consuming barcode readers!! A gateway gateway to refrain from a payment gateway. This is the proposed system for Sarasavi Book Shop Colombo. This is the proposal of the system which provides a basic understanding about the system. It comprises of following tasks and covers the specified information under each task.
Task 01
Introduction & Objectives This task introduces the proposed system and its obje object ctiv ives es,, cons constr trai aint nts s and and scop scope. e. Also lso feas feasib ibil ilit ity y of implemen implementati tation, on, scalab scalability ility and extendi extendibili bility ty of the solution solution will also be discussed in brief in this section.
Task 02
Analysis of the existing system This task provides a clear idea about the existing systems used in the bookshop and the problems and limitations found in those systems.
Task 03
Analysis of the proposed system This task provides a clear idea about the proposed system for the bookshop and the advantages gained from the system for the company and the design for the proposed system.
Task 04
Implementation Plan This task contains the implementation plan of the proposed book shop system. system. Supporting Supporting documents documents (i.e. (i.e. Gantt charts, budget estimations etc.) for the implementation plan also included in this task. Also this task introduces testing strategies employed for unit, syste system, m, interf interface ace and and integr integrati ation on testin testing g carrie carried d out in latte latter r stages of the development life cycle.
Task 05
Conclusion This task gives the conclusion of the overall proposed system in brief.
Task 06
References & Bibliographies This task gives the references & bibliographies for the proposed system.
3
Project Proposal
Sarasavi Book Shop - Colombo
Table of content 1.
2.
3.
4.
Introduction & Objectives 1.1
In I ntroduction
1.2
Objectives
1.3
Challenges
5 6–9 9
Analys lysis & De Design ign of of th the ex exist isting sy system 2.1
Existing systems
10-11
2.2 2.2
Serv Servic ices es prov provid ided ed by the the syst system ems s
11-24 1-24
2.3 2.3
Draw Drawba back cks s of the the exis existi ting ng syst system ems s
25
Analysis & Design of the proposed system 3.1 System Transitions
26-27
3.2 Proposed system
28-44
Implementation 4.1
Tools and Technologies
45
4.2
Gantt chart for the Implementation Process
46
4.3
Testing Plan
5.
Conclusion
6.
Reference and bibliography
47-49
50-52 53
4
Project Proposal
Sarasavi Book Shop - Colombo
1. Introduction & objectives 1.1 Introduction
“Sara “Sarasa savi vi book book selle sellers” rs” is the book book selli selling ng divis divisio ion n of Saras Sarasav avii Group Group of companies in Sri Lanka.
It was established in 1955.
Recently it won the state award for the best bookshop in Colombo and its suburbs.
Since they strive to maintain excellence in customer service and customer satis satisfac factio tion n they they guar guarant antee ee the cond conditi ition on of every every book book deliv deliver ered ed to the the customer as the item will be dispatched after thorough examination.
To facilitate the customers to order a particular book without wasting time to visit the bookshop, they use an online purchasing system for the company.
Books are reasonably priced and most of the best selling Sarasavi books are made available online at the Sarasavi.lk website for world wide shipping.
The existing system uses a Point Of Sale (POS) System to input the bar code entry and manual entry at the cash counter to input sales item code to the system. Through the company website, the customers can perform online book purchase.
The customer can search for a particular book or a magazine via the Book title, Author name or by the Edition.
The customer can view the latest arrivals such as new novels, story books or magazines.
5
Project Proposal
1.2
Sarasavi Book Shop - Colombo
Objectives
The main objective of the system is to integrate a comprehensive book reservation system for Sarasavi Bookshop existing website and also to introduce a new tracking device which uses radio wave based tagging system which is known as RFID (Radio Frequency Identification) technology. While this is the main objective, the system design should adhere with the following objectives.
Enhance day to day businesses Feasibility of implementation Scalability and extendibility. The system must win the confidence of the public
Enhance day to day businesses
Day to day business activities will be easier with the RFID technology because repetitive input of item details might be avoided by this new technology.
Along with item-level tagging it reduces the risk of books being out of stock and it gives the ability to track which books are flying off the shelves and which haven't moved in a while.
In addition, taking an inventory will become less of a headache and it would not be necessary to shutting up of shop for stock taking purposes.
All the above uses allow the company to take competitive advantage from the environment and allow to increase the company’s productivity.
Since the company uses a website the company should be benefited from it in its business perspectives such as increasing promotions for the company, competitive advantage, increase of sales, new markets and etc.
Since Since the booksho bookshop p is maintai maintaining ning sales sales details details,, differe different nt statisti statistical cal analysis methods can be used to analyze the trend of sales.
With this bookshop can publish about the “Best Seller” books weekly or monthly as the company needs.
6
Project Proposal
Sarasavi Book Shop - Colombo
This permits the readers to know about the latest trends in the society and go for them, which indirectly increases productivity.
Also with data mining company can identify the probable book/books a regular customer is going to buy and also can analyze who are the probable customers of a new release and let them know via Newsletters.
Feasibility of implementation
This This syste system m is devel develope oped d to enha enhance nce comp company any activ activiti ities es from from the existing manner of performing into a digitized format through the use of Internet and desktop computers.
The system must be able to implement implement with a feasible budget affordable by the project sponsors.
For example the system cannot afford to use a satellite aided parcel tracki tracking ng syste system m to moni monitor tor whet whether her the book book parce parcels ls orde ordered red are deli delive vere red d to the the corr correc ectt cust custom omer er or not, not, monit onitor or secu securi rity ty nor nor implemented artificial intelligence which regularly examines whether the parcel is delivered to the correct place or got misplaced on the way and reflect those changes into the system by regular examination of the geographical changes in the city and roads.
Since the proposed system tries to eliminate the useless traverse for building a payment gateway within the own domain, the system will have to store Credit card details within the customer details data store.
This is less cost and easy to implement than a payment gateway and but to provide security and privacy different approaches should be taken. The site has to use standard Secure Socket Layer (SSL) encryption to ensure the highest security for credit card and personal details submitted to us over the Internet.
The site will have to use a security certificate issued by VeriSign.
Scalability and extendibility
Due to the changing nature of the world and rapid advancement in Informat Information ion Technology echnology and Communi Communicat cation, ion, the system system will will always always tends to change to accommodate the new requirements.
7
Project Proposal
Sarasavi Book Shop - Colombo
Also the project sponsors might later decide to implement any expensive features such as using satellite technology for monitoring purposes of the delivery system such as parcel tracking system in the future.
In any such situation the system must support the system advancements and and upgr upgrad ades es with withou outt requ requir irin ing g the the syst system em to unde underg rgo o comp comple lete te changes or dump the existing system and developing a new system from scratch to meet the upgrades.
For For examp example le if new new meth method ods s discov discovere ered d to provid provide e monit monitor oring ing and and secu securi rity ty serv servic ice, e, it shou should ld be poss possib ible le to refl reflec ectt the the chan change ges s by application of logic to acquire information from that method to the system without completely changing the system.
Public confidence
The system must win the public confidence as something that they can rely on when it comes to online purchasing.
This should ensure that the information about the books published by the system must be factual and accurate.
Also the system should handle the credit card transactions in a more secure manner by ensuing the privacy of the customers in their account numbers numbers and should should handle handle the transaction transactions s careful carefully ly & securely securely to prevent any fraud.
The proposed system will prioritize customer needs and delivery will be done according to these categories. Delivery will be categorized in to three basic classes, viz Standard, Priority and Express.
Depending on the class site will show how the delivery charges and the duration vary. vary.
Due to this since deliveries are happening on time and at the time which the books are required, better customer satisfaction can be gained and the public will be more confident about the system as well as the company.
With the advancement and complicated life styles visiting a bookshop has become really difficult.
8
Project Proposal
Sarasavi Book Shop - Colombo
To facilitate these customers customers the reading corner of the online book store allow them to glance through the pages of the book before purchase the book.
Due to “Reserve Online Collect In-store” process, process, customers are able to reserve a book of interest and collect it later which will give customer satisfaction about the system.
1.3 Challenges
It was a difficult task to convince the staff members and the management about the new technologies that are going to use in the proposed system and it was difficult to win over them.
It was difficult to get the confirmation and the approval for the cost estimation for the proposed system form the top management.
It was a time consuming task to make the staff members convince about the proposed system and make the cashiers at the counter sure about that they will not lose their jobs because of the system.
It was time consuming to collect the relevant information form the users due to the busy environment in the company.
There was resistance resistance from the cashiers for the system due to the fear of losing their jobs and had to face this challenge also during that period.
9
Project Proposal
Sarasavi Book Shop - Colombo
2. Analysis & Design of of the Existing System 2.1
Existing systems
System Study
During the system analysis three systems ( or sub systems) were identified and modeled
They are Store Sales System, Online Sales System and Inventory Control System
Business Processes During the system study the following types of business processes were identified:
Business processes related to Store Sales Business processes related to Online sales Business processes related to Inventory Management Store Sales o Customer book searching o Book reservation o Book purchase – Generating invoice, Billing the customer and Entering sales order
10
Project Proposal
Sarasavi Book Shop - Colombo
Online Sales Customer registration o Login o Online book searching – searches based on title, code, author and category o Customer adding books to shopping card o Payment – Credit card o Shipping books to customer o
Inventory Management o Searching inventory - searches based on title, code, author and category Buying books from supplier and adding them to inventory ( also entering the o new books details in the database) Removing books which are not fast moving or which are damaged and sending o them back to supplier Other Processes (related to manager) o
Viewing sales records
o
Generating sales summaries
o
Understanding the sales trends
2.2 2.2
Serv Servic ices es pr prov ovid ided ed by the the sys syste tems ms The Business processes and the Information flows are showed here using UML: – Use Case – Class – Sequence – Activity Diagrams
11
Project Proposal
Sarasavi Book Shop - Colombo
Use Case Diagram for Entire System
12
Project Proposal
Sarasavi Book Shop - Colombo
Use Case Diagram for Computerized Parts of the System
13
Project Proposal
Sarasavi Book Shop - Colombo
Class Diagram for Entire System
14
Project Proposal
Sarasavi Book Shop - Colombo
Searching Books and Reservation – Sequence Diagram
Searching Books and Reservation – Activity Diagram
15
Project Proposal
Sarasavi Book Shop - Colombo
Store Sales Sequence Diagram
Store Sales – Computerized Part - Sequence Diagram
16
Project Proposal
Sarasavi Book Shop - Colombo
Store Sales – Activity Diagram
Online Sales - Sequence Diagram
17
Project Proposal
Sarasavi Book Shop - Colombo
Online Sales - Computerized Part - Sequence Diagram
Online Sales – Activity Diagram
18
Project Proposal
Sarasavi Book Shop - Colombo
Inventory Management - Search Books
19
Inventory Management -Computerized Part - Search Books
Project Proposal
Sarasavi Book Shop - Colombo
Inventory Management - Search Books – Activity Diagram
Tile based search
Code based search
20
Project Proposal
Sarasavi Book Shop - Colombo
Author based search
Category based search
21
Project Proposal
Sarasavi Book Shop - Colombo
Inventory Management - Add and Remove Books - Sequence Diagram
Inventory Management - Computerized Part-Add and Remove Books Sequence Diagram
22
Project Proposal
Sarasavi Book Shop - Colombo
Adding Books to Inventory
Removing Books from Inventory
23
Project Proposal
Sarasavi Book Shop - Colombo
Inventory Management - Viewing Sales Records and Sales Summary - Sequence Diagram
Inventory Management - Computerized Part - Viewing Sales Records and Sales Summary - Sequence Diagram
24
Project Proposal
2.3 2.3
Sarasavi Book Shop - Colombo
Draw Drawba back cks s of of the the exis existi ting ng syst system ems s
Several drawbacks in existing systems were identified. Store Sales System drawbacks
The barcode system which used for book identification and sales tracking is inefficient
Do not have a effective computerized reservation system
Book searching is sometimes problematic for customers as most of the time they have to search manually without the help of an computerized searching system,
Online Sales System drawbacks
User has to access payment gateways provided by each bank to proceed transaction. This process waste up lot of time as the customer needs to browse through many sites to do a purchase.
Online reservation is not available
25
Project Proposal
Sarasavi Book Shop - Colombo
3. Analysis & Desig Design n of the Proposed System 3.1 System Transitions In this section we will be discussing the how the above mentioned functionalities of the exis existi ting ng syst system em chan change ges s with ith the the prop propos osed ed syst system em.. Als Also some some inno innova vati tive ve functionalities which are lacking in the existing system will be introduced. Sales tracking System Currently this system utilizes bar code entry and manual entry methods at the cash counter to input sales item code to the system. With the proposed system we try to introduce a new tracking device which uses radio wave based tagging system. This technology is known as RFID (Radio Frequency Identification) technology. Once the books are arrived from the suppliers they are chipped with a unique number (Item code system that is in use). With the help of a system staff can check exactly where a book is in the supply chain - whether it is been shipped, if it is in store and, if so, where exactly to find it - and so can customers. Using the system management tract the inventory details too. Along with item-level tagging it reduces the risk of books being out of stock, and the ability to track which books are flying off the shelves and which haven haven't 't moved moved in a while while.. In addit addition ion,, taking taking an inven inventor tory y will will becom become e less less of a headache and it would not be necessary to shutting up of shop for stock taking purposes. Online purchase With the current system we need to access the payment gateways provided by the each bank to proceed with a transaction. But this process waste up lot of time as the custom customer er need needs s to brows browse e throug through h many many sites sites to do a purch purchas ase. e. The The propo propose sed d system we try to eliminate this useless traverse building a payment gateways within the own domain. For this purpose system will have to store Credit card details within the customer details data store. In order to provide security and privacy different approa approach ches es are taken taken.. The The site site will will use use stand standard ard Secur Secure e Sock Socket et Layer Layer (SSL (SSL)) encryption to ensure the highest security for credit card and personal details submitted to us over the Internet. The site will have to use a security certificate issued by VeriSign eriSign (Normal (Normally ly High High Grade Grade encrypt encryption ion of 256bit 256bit recomme recommende nded). d). And the site recognizes the concerns of customer regarding privacy of information. All information submi submitte tted d by custo custome mers rs will will be secu securel rely y stored stored,, and and is not acces accessi sible ble to other other unauthorized parties.
26
Project Proposal
Sarasavi Book Shop - Colombo
Product delivery is a dependable process of the Purchase functionality. The existing system provides provides a Shipping Shipping facility to purchased purchased items. But as the team has identified all the delivery will be done at a basic flat rate. But this does not prioritized the need of the customer. Therefore with the proposed system will be modifying and introduce a method of prioritizing customer need. Delivery will be categorized in to three basic classes, viz Standard, viz Standard, Priority and Express. Depending on the class site will show how the delivery charges and the duration vary. Online Reservation This is a new functionality added to the system. With this customers are able to reserve a book of interest and collect it later. This will be addressed as “Reserve Online Collect In-store” process. As an exception customers will be able to purchase the reserved book online without going to the In-store. The reservation can be handled only only by regis register tered ed user user and and custo custome merr will will be asked asked to agree agree with with certai certain n set set of conditions before reserving the book of interest. Customer Forum Existi Existing ng syste system m provid provides es a metho method d of conta contacti cting ng the the compa company ny throug through h virtue virtue of making enquiries. But it does not help to convey news about the bookshop to the customer, such exhibitions, book stalls, book sales etc. Therefore team suggested a custom customer er foru forum m to publi publish sh new new updat updates es abou aboutt the the book booksho shop p as an advert advertis ising ing strategy. Data Mining Since Since the book booksho shop p is maint maintain aining ing sales sales deta details ils we can can use use differ differen entt statis statistic tical al analysis methods methods to analyze the trend of sales. With this bookshop can publish about the “Best Seller” books weekly or monthly as the company needs. This permits the readers to know about the latest trends in the society and go for them. Also with data mining we can identify the probable book/books a regular customer is going going to buy. buy. So with with that that data data in hand hand we can analy analyze ze who are are the the prob probab able le customers of a new release and let them know via Newsletters. Readers Corner This is an essential component of an online book store. With the advancement and complica complicated ted life styles visiting visiting a booksh bookshop op has become become really really difficu difficult. lt. But most readers have the thirst to read. To facilitate these customers modern society came up with online book stores. But most of them are reluctant to purchase online without glancing through the pages. But with readers corners this facility will be fulfilled. There site can publish publish critics, critics, reviews reviews etc made made regardin regarding g books. books. So the customer customer can evaluate the quality of the book reading these articles and purchase good books.
27
Project Proposal
Sarasavi Book Shop - Colombo
3.2 Proposed System After analyzing the existing system the team came up with most optimised solution to handle all vital bookshop transactions. The detailed Functional Requirements of the proposed system are given bellow. Functional Requirement: Sales Tracking Process (FR 1) Description: Each sales item data are tagged with a RFID chip. At the Sale Desk, operator enters the data to the system with the chip reader. And Sales data will be sent to the central data repository to update inventory details. FR 1.1: Enter Item Details Description: Using the RFID reader enter Item Details Input:
RFID chip
Process:
Sale Assistant enter sales details with the RFID reader Reader process information and provide access to item
information An invoice will be produced at the end of transaction The inventory will be updated appropriately A sales record will be added to the Sales table Output:
Invoice
Post conditions: Collect the payment as mentioned in the invoice Usecase Diagram (FR 1): <> Add sales Record
Enter Item Data Sales Assistent <>
Update Inventory
28
Project Proposal
Sarasavi Book Shop - Colombo
Class Diagram (FR 1): Invoice
Item itemCode type price quntity name
fullAmt SalePersonId noOfItems customerId date 1..n
1 GetPayments() ProduceBill() UpdateInventory() AddSales Rec()
CheckAvailbility() GetPrice() UpdateInventory()
1
1 1
1
SalesRecord
Payment
amount customerId date
amount date GetCash() GiveBalance() GetCreditCardDetails()
Sequence Diagram (FR 1): SalesPerson Sales Pers on
It em
Invoic e
Pay m me ent
SalesRecord Sales Re Rec or ord
1: GetPrice() 2: ProduceBill() ProduceBill() 3: Invoice Invoice 4: GetCash() 5: GiveBalance() 6: Balance 7: CreateSalesRec() 8: SalesRecord
29
Project Proposal
Sarasavi Book Shop - Colombo
Functional Requirement: - Online Purchase (FR 2) Description: Allowing a registered customer to log into the system, Display a list of books available or he/she can use the available search process to find the book of interest. Then it will be added to the shopping cart. Once the customer is finished with online shopping can go to the “Shipping” menu and select the delivery criteria. criteria. Then go to the payment portal and do the the paym paymen entt usin using g the the cred credit it card card info inform rmat atio ion n subm submit itte ted d on registration FR 2.1: Authentication process. Description: Authenticating a registered customer under Sarasavi Online shopping system. Preconditions: Custome Customerr is already already register registered ed under under Sarasav Sarasavii Online Online shopping shopping system and possesses a user name and password. Input:
User name, password
Process:
Get the username and password entered by the customer and send it to the DB stored in the central Validate the user-entered data If they match then authenticate customer.
Output:
Display a Welcome message.
Post condition: The Customer is logged on.
FR 2.2: Searching for books. Description:
Allowing the `purchaser to search for any books entering either the Book title, Authors name or the ISBN number. Then search results will be displayed.
Preconditions: User is logged in to the system. Input: Input :
Book title/ Authors name / ISBN number
Process:
System search for matching database entries and extract them to the web site. Each book entry will be displayed with basic information of the book, a check box add to shopping cart and a link to access its critics published in the readers corner.
Output: entries).
List List of book books s which which matc matches hes searc search h key (Eac (Each h page page conta containi ining ng 10
30
Project Proposal
Post condition: condition :
Sarasavi Book Shop - Colombo
Custo Custome merr sele selects cts a boo book k from from the list list and and add adds s to the cart cart or goes goes for advanced search option.
FR 2.3 –: Select Delivery Conditions. Description: Determine the delivery need and choose the best suited rate and confirm the delivery agreements. Preconditions: Users cart has at least single book. Input:
List of rates and options available for delivery
Process:
Customer will be displayed with the different delivery options. Customer selects best option and confirms the conditions which apply with it.
Output:
None
Post condition: Directed to the payment portal FR 2.4 –: Online payment. Description: Determine Determine the cost of material and delivery and prepare the total cost. Then customer will be prompted to enter the password again to proceed with payment. And online bill will be displayed with printing option. Preconditions: Users cart has at least single book and confirmed delivery method. Input:
password
Process:
Custo Custome merr will will be displa displaye yed d with with the detai details ls of the the trans transact action ions s and and prompted to confirm if he/she wants to proceed. Then again password will be requested to confirm identity. Once the payment deducted from the customer’s account book shop account will be credited. Bill of the transaction will be displayed.
Output:
Bill
Note: Online Refunds or exchanged will not be handled.
31
Project Proposal
Sarasavi Book Shop - Colombo
Usecase Diagram (FR 2): <>
Enter Username & password
User Authentication <> Registered Registered Customer
<> <> Online Purchase Search the Book <>
Payment
Enter Search Key
<>
<> Select Delivery Option
Get Customer Details
Class Diagram (FR 2): Book
Customer cName cID cAdress cUserName cPassword
bookList
1 Register() Confirm() Deny() LogIn()
bName bISBN bAuther bPublisher bPrice
SearchResult
1..n
AddBook() RemoveBook() MatchSearchKey() GetSearchKey()
1..n
1
1..n 1 OnlinePayment
DeliveryOption selectedOption listOfOptions DisplayOptions() SelectOption() ConfimOption()
1..n
amount date bankOfAutherization GetCCnumber() GetPINnumber() ConfirmPayment() GetPassword() GetAuthorization()
32
0..n AddToCart() GetPrice() GetQty() GetDescription()
Project Proposal
Sarasavi Book Shop - Colombo
Sequence Diagram(FR 2): RegisteredCust omer
SearchList Sea SearchL chList ist
Deliv lliive iv veryOp yOptio ttiion io on
P Paym Pa ay yme ment
Bank Bank
1: LogIn()
2: WelcomeMsg 3: EnterSearchKey() EnterSearchKey() 4: MatchSeachKey() 5: SearchList 6: DisplayOptions() 7: DeliveryOptionList 8: SelectOption() 9: GetPassword() GetPassword() 10: ConfirmPayment() 11: GetAuthorization() GetAuthorization() 12: Online Bill
Functional Requirement: - Online Reservation (FR 3) Description:
Allowing a registered customer to reserve a book for a particular period. For that customer customer should into the system. Then using the search functionality search for the book and select the nearest store (where he/sh he/she e plan plans s to purch purchas ase e the the book book). ). Then Then agree agree with with reser reservat vatio ion n agreements.
FR 3.1: Authentication process. Description: Authenticating a registered customer under Sarasavi Online shopping system. Preconditions: Custome Customerr is already already register registered ed under under Sarasav Sarasavii Online Online shopping shopping system and possesses a user name and password.
33
Project Proposal Input:
Sarasavi Book Shop - Colombo User name, password
Process:
Get the username and password entered by the customer and send it to the DB stored in the central Validate the user-entered data If they match then authenticate customer.
Output:
Display a Welcome message.
Post condition: The Customer is logged on.
FR 3.2: Searching for books. Description: Allowing the `purchaser to search for any books entering either the Book title, Authors name or the ISBN number. Then search results will be displayed. Preconditions: User is logged in to the system. Input: Input :
Book title/ Authors name / ISBN number
Process:
System search for matching database entries and extract them to the web site. Each book entry will be displayed with basic information of the book, a Chec Checked kedBo Box x add add to reser reservat vatio ion n cart cart and and a link link to acces access s its criti critics cs published in the readers’ corner.
Output: entries).
List List of book books s which which matc matches hes searc search h key (Eac (Each h page page conta containi ining ng 10
Post condition: condition :
Cust Custom omer er sel selec ects ts a book book fro from m the the list list and and add adds s to the the rese reserv rvat atio ion n cart or goes for advanced search option.
FR 3.3 –: Select Store of Collection and confirm Reservation. Description: From From the the list list of stores stores select select the store store that that you you are are plann planning ing to purchase it. And confirm the reservation. Preconditions: Users reservation cart has at least single book. Input:
List of Stores/Bookshops Confirmation of the reservation.
Process:
Customer will have to select a store from the displayed list.
34
Project Proposal
Sarasavi Book Shop - Colombo
Once the reservation is done checks the customer information to find out cust custom omer ers s reco record rds s on brea breach ch of trus trust. t. And And do the the rese reserv rvat atio ion n if management have not put any restriction to that user. Else display the message to notify him/her regarding the condition. Both inventory and store manager will be notified about the reservation. Output:
Confirmed Reservation or Apology message. Reservation number.
FR 3.4 –: Cancel Reservation. Description: Customer cancels a previous reservation made by him/her. Preconditions: user with a previously made reservation. Input:
reservation number
Process:
Reservation conditions will be checked to determine whether they are violated. If violated record will be added and managers will be notified. Both inventory and store manager will be notified about the cancellation.
Output:
None
Usecase Diagram (FR 3): <>
Enter Username & password
User Authentication
<> <>
<>
Search the Book
Enter Search Key
<> Registered Customer
Online Purchase <> <> Select Store to collect
Confirm Reservation Cancel Reservation Reservation <> <>
Notify Inventory and Store manager
35
Project Proposal
Sarasavi Book Shop - Colombo
Class Diagram (FR 3): Customer cName cID cAdress cUserName cPassword
Book bName bISBN bAuther bPublisher bPrice
Register() Confirm() Deny() LogIn()
Reservation
1
1..n
0..n
Store selectedStoreID listOfStores
AddToCart() GetPrice() GetQty() GetDescription()
cID listID StoreID
0..n
CheckRestrictions() NotifyStoreMnger() NotifyInventory() CancelReservation()1 NotfyManagement()
1..n SearchResult 1..n
1
DisplayStoreList() SelectStore() ConfimStore()
listID bookList AddBook() RemoveBook() MatchSearchKey() GetSearchKey()
Sequence Diagram (FR 3): Regi Registe RegisteredCustomer stere redC dCus usto tome merr
Sear Se S earchL archList c hList is t
S t ore
R Rese Re es serv errv va atio attiion on
Mana Ma ManagementRecords nage geme ment ntRe Recor cords ds
1: LogIn() 2: WelcomeMsg 3: EnterSearchKey() EnterSearchKey() 4: MatchSeachKey() 5: SearchList 6: DisplaySt oreList() oreList() 7: StoreList 8: SelectS tore() tore() 9: CheckRestrictions() 10: Restriction Records 11: Noti fyInventory() fyInventory() 12: NotifyStore()
13: CancelReservation() 14: NotifyManagement() 15: Record
36
Project Proposal
Sarasavi Book Shop - Colombo
Functional Requirement: Customer Forum Maintenance (FR 4) Description: Top level managers or site maintainers can publish new event details for customers. The forum feeders should log in to the system with appropriate privilege levels. Then add the information to the forum and select the period of time it should be displayed. FR 4.1: Authentication process. Description: Authenticating a site maintainer of Sarasavi Online shopping system. Preconditions: User with an account of forum feeding privileges. Input:
User name, password
Process:
Get the username and password entered by the user and send it to the DB stored in the central Validate the user-entered data If they match then authenticate customer.
Output:
Display a Welcome message.
Post condition: The user is logged on. FR 4.2:
Forum update
Description: Enter new event details to the forum. Post condition: Logged in with right privileges. Input:
Event Details.
Process:
Enter event details and select the time period for it to be displayed. After the specified time period the post should be automatically automatically added to archive.
Output:
None.
Post condition: Item posted on the forum
37
Project Proposal
Sarasavi Book Shop - Colombo
Usecase Diagram (FR 4):
<>
User Authentication
Manager
Enter UserName & Password
<> <>
Furum Update
<>
Archive Post
Repost
Forum Feeders
Class Diagram (FR 4): ForumFeeder
SiteManager Post
mID mName mUserID mPassword mPrivilages LogIn() AddPost() DeletePost() UpdatePost() AddToArchive()
eID eName eUserID ePassword ePrivilages
postID mID/eID date 1
1..n
Add() 1..n Delete() Update() Archive() SetArchiveDate()
Archive postID mID/eID date Repost()()
38
1
LogIn() AddPost() DeletePost() UpdatePost() AddToArchive()
Project Proposal
Sarasavi Book Shop - Colombo
Sequence Diagram (FR 4): Feeder F eeder
P os t
Archive A rc hi ve
1: LogIn()
2: WelcomeMsg 3: Add() 4: SetA rchiveDate() rchiveDate() 5: Delete() 6: Update() 7: Archive() 8: post 9: Repost() 10: post
Functional Requirement: Data mining Process (FR 5) Description: Here we analyse the sales data and determine the best seller books of the week and publish on the site’s home page. So all the site users and information seekers can find information about sales trends in the book market. Also we try to forecast probable customers of a newly released book by analysing the sale history records. FR 5.1: Determine Best Selling and publish. Description: Find weekly Best Selling books and publish Input: Process:
Weekly Sales Detail of books Get the sales records records of individ individual ual book and analyse analyse with statisti statistical cal models to determine whether they can be categorised as bestselling book. Publish all the bestselling books in a section which is reserved as ‘Best Seller’
39
Project Proposal
Sarasavi Book Shop - Colombo
Output:
Best selling books
FR 5.2:
Determine probable customers and send news letters
Description: Forecast the customers for a particular new arrival and send newsletters to notify them about the release. Input:
Customer-wise Sales record.
Process:
Analy Analyse se the the Sales Sales record records s and and deter determin mine e the the pref prefere erence nces s of each each customer. Then identify the customers who prefer books belonging to category of new release. Send Send news news letter letters s to them them notif notifyi ying ng the the infor informa matio tion n rega regardi rding ng new new release
Output:
News Letter to each probable customer.
Usecase Diagram (FR 5): <> Publish Best Sellers
<>
Marketing Manager
Analyze Sales Details
Send NewsLetters
40
Project Proposal
Sarasavi Book Shop - Colombo
Class Diagram (FR 5): BestSellerList bestSellerList week Manager mID mName mUserID mPassword mPrivilages
1..n
AddBook() DeleteBook() FindBestSellers()
0..n 1..n
1..n
NewsLetter
AnalyzeSales() PublishBestSellers() SendNewsLetter() SpecifyBestSeller() FindProbableCustomers()
1..n
cID listOFbIDs month
Book bID bName bAuther bPublisher bISBN GetSalesDetails() AnalyzeDetails()
0..n
AddBooks() Deletebooks() SendNewsletter() GetCustomerDetails()
Sequence Diagram (FR 5): Manager Manager
S ales Dat a
Book B ook
1: GetSalesDetails() 2: Sales Details 3: AnalyzeSales() 4: Analysis Data 5: SpecifyBestS eller() eller() 6: AddBook() 7: DeleteBook() 8: PublishBestS eller() eller() 9: FindProbableCustomers() 10: AddBook() 11: DeleteBook() 12: SendNewletter()
41
BestSellers B es t S el ellers
Newsletter News le let te ter
Project Proposal
Sarasavi Book Shop - Colombo
Functional Requirement: Readers Corner Maintenance (FR 6) Description: Top level managers or site maintainers can publish new critics or reviews about the books (normally these are written by external parties). parties). The The ‘Rea ‘Reader ders s Corne Corner’ r’ maint maintain ainer ers s shou should ld log log in to the the syste system m with with appropriate privilege levels. Then add the article to the site. FR 6.1: Authentication process. Description: Authenticating a site maintainer of Sarasavi Online shopping system. Preconditions: User with an account of Readers Corner’ feeding privileges. Input:
User name, password
Process:
Get the username and password entered by the user and send it to the DB stored in the central Validate the user-entered data If they match then authenticate customer.
Output:
Display a Welcome message.
Post condition: The user is logged on. FR 6.2:
‘Readers Corner’ updates
Description: Enter new critic or review about a book to the Readers Corner. Post condition: Logged in with right privileges. Input:
Review or critic article.
Process:
Enter Review or critic article and select book to which it is related and articulate both together.
Output:
None.
Post condition: A Review or Critic posted on the Readers Corner.
42
Project Proposal
Sarasavi Book Shop - Colombo
UseCase Diagram (FR 6): <>
User Authentication
Manager
Enter UserName & Password
<>
<> Add Critic s/Reviews s/Reviews Site Maintainers
Binds to the book
Class Diagram (FR 6): Article
SiteManager
ArticleID mID/eID date BookID Link
mID mName mUserID mPassword mPrivilages 1 LogIn() AddArticle() DeleteArticle() UpdateArticle()
1..n Add() Delete() Update() BindWithaBook()
43
SiteMaintainer
1..n
1
eID eName eUserID ePassword ePrivilages LogIn() AddArticle() DeleteArticle() UpdateArticle()
Project Proposal
Sarasavi Book Shop - Colombo
Sequence Diagram (FR 6):
Publisher Publisher
Article
Book Book
1: LogIn()
2: WelcomeMsg 3: Add() 4: BindWithaBook() 5: Link 6: Delete() 7: Update()
44
Project Proposal
Sarasavi Book Shop - Colombo
4. Implementation Plan This chapter contains the implementation plan of the proposed Online Book Store system. Supporting Supporting documents documents (i.e. (i.e. Gantt Gantt charts, charts, budget budget estimations estimations etc.) etc.) for the implementation plan are also included. Chapter introduces and focuses mainly on testing strategies employed for unit, system, interface and integration testing carried out in latter stages of the development life cycle.
4.1 Tools and Technologies Implementation Language: Microsoft Visual ASP.NET ASP.NET 2.0 The system design is done using MS ASP.NET language. It is recommended that the Visual Studio.NET 2005 to be used as the environment in developing the system. Host operating System: Microsoft Windows Server 2003/.NET Sinc Since e we decid decided ed to do the imple impleme menta ntatio tion n usin using g .NET .NET enviro environm nment ent it is necessary that the system runs under Microsoft Windows environment. Hence the recommended operating system to have the server application is Widows 2003 server. For the client application OS requirements are either any Windows 2000, XP, XP, 2003 or Vista. Database System: Microsoft SQL Server 2005 Enterprise Edition Microsoft SQL server is preference over other DBMS as it is more compatible with the development environment than any other DMBS available. Other software required: Rational Rose Enterprise edition – This is used as the UML modeling tool in the designing phase of the project. Microsoft Office Word – This This appli applicat cation ion was was used used as the the docu documen mentin ting g tool tool during during the the stage stages s of developing the final documentation.
4.2 Gantt chart for the Implementation process 45
Project Proposal
Sarasavi Book Shop - Colombo
4.3 Testing Plan
46
Project Proposal
Sarasavi Book Shop - Colombo
Test organization The Software Test Plan is designed to prescribe the scope, approach, resources, and schedule of all testing activities. In achieving this goal, it must identify the items to be tested, the features to be tested, the types of testing to be performed, the personnel responsible for testing, the resources and schedule required to complete testing, and the risks associated with the plan.
Communication & procedures This This sect sectio ion n serv serves es as a proc proced edur ural al guid guide e for for desi design gnin ing g test test case cases s and and test test documen documentati tation. on. To achieve achieve 100% 100% correct correct code, code, system system testers testers shall shall perform perform both both black box and white box testing techniques. Using these techniques will enable testers to design design test test cases cases that validate validate the correctnes correctness s of the developing developing system with respect to the requirements requirements specification. specification. The procedure shown here shall be used in conjunction with the requirements specified in this document to achieve full benefits from the testing process. When When testing testing procedure procedure conside considered red tester tester should should identify identify the require requirement ments s to be tested before actual testing is commenced. All test cases shall be derived using the current design specification. specification. Then identify which particular test(s) relevant and should be carried out for each subsystem. There after review the test data and test cases to ensure that the unit has been thoroughly verified and that the test data and test cases are adequate to verify proper operation of the unit. It is also necessary to identify the expected results for each test. Finally document document the test case configuration, test data, and expected results and perform the test(s). Succ Succes essf sful ul unit unit test testin ing g is requ requir ired ed befo before re the the unit unit is elig eligib ible le for for comp compon onen entt integration/system testing. For each unsuccessful testing it requires a Problem Trouble Repor Reportt to be gener generate ated. d. This This repo report rt shall shall descr describe ibe the the test test case, case, the probl problem em encountered, its possible cause, and the sequence of events that led to the problem. It shall be used as a basis for later technical analysis. Test documents and reports shall be submitted to the project managers and the development team should be notified about the success of their development work.
Test strategy
47
Project Proposal
Sarasavi Book Shop - Colombo
Testing is the process of analyzing a software item to detect the differences between existing and required conditions and to evaluate the features of the software item. This is carried out in sequential manner in the following order. Unit Testing - The The unit unit test test cases cases shall shall be desi designe gned d to test test the validit validity y of the the progra program's m's corre correctn ctnes ess. s. White White box box testi testing ng will will be used used to test test the modu module les s and and procedur procedures es that that support support the modules. modules. The white white box testing technique technique ignores ignores the function of the program under test and will focus only on its code and the structure of that code. To accomplish this, a Path Testing technique shall be used. Cyclomatic complexity of the module is determined by the flow graph generated for each module. Test case designers shall generate cases that not only cause each condition to take on all all possi possible ble values values at leas leastt once, once, but but that that cause cause each each such such condit condition ion to be executed at least once. Integration Integration Testing - In this this stage stage two two units units that that have have alrea already dy been been tested tested are are combined into a component and the interface between them is tested. Integration testing identifies identifies problems that occur when units are combined. combined. By using the test plan that requires you to test each unit and ensure the viability of each before combining units, you know that any errors discovered when combining units are likely related to the interface between units. It is preferred conduct the testing according to the top-down approach. This requires the the high highes estt-le leve vell modu module les s be test test and and inte integr grat ated ed firs first. t. The The stub stubs s shou should ld be implemented provide lower level functionality. Also helps early release such as beta versions with limited functionality. System Testing - System test case design starts after the requirements specification specification is baselined. The test cases generated shall directly reflect the requirements of the functional specification. The system test case designer(s) shall design appropriate test cases to validate the correctness of the system. The black box testing techniques shall primarily be used at the system test level. This technique is a comparison of the actual output with the specified output, regardless regardless of the structure structure of the code or the code unit under test. Interface Testing – This approach helps to effectively test your UI.. It allows you to validate your application logic without the need to actually interact with the UI. The view can be tested to some degree by exposing methods on it that allow you access to the various 'widgets' that display the data. By providing access to the widgets you can query them to ensure they have been correctly updated in response to a change to the Model.
48
Project Proposal
Sarasavi Book Shop - Colombo
Stress Testing – Stres Stress s testi testing ng deal deals s with with the quali quality ty of the appli applicat cation ion in the environment. environment. Since this is a web based solution stress testing is crucial. Application Application is tested with overloaded server requests and determines how such situations handled by the server. Race conditions and memory leaks are often can be easily found under stress testing.
Test deliverables Most probable deliverables after the completion of testing are Test Case Design, System/Unit Test Report and Problem Trouble Report (if any). Test Case Design document shall be the complete set of test cases to be performed during testing along with implementation of test methods. This also establishes the baseline approval for all system/unit test cases before coding begins. Unit/System Test Report covers all tests cases, unit and system, performed during testing. This will be used for either system or unit tests. Copies of the System Test Report’s will be sent to QA&I and the group conducting the tests. All problems or errors found during testing shall be documented by a Problem Trouble Report . And it shall serve as a basis for further investigation investigation of the problem. Copies of the Problem Trouble Report 's will be sent to QA&I and the group conducting the tests.
49
Project Proposal
Sarasavi Book Shop - Colombo
5. Conclusion This online book store system is an attempt to overcome the present inefficient and time time cons consum uming ing proce process ss of locat locating ing,, reser reservin ving g and and purch purchas asing ing quality reading materials available in the store. Currently, clients have to go through a time consuming proces process s to perfo perform rm afore aforemen mentio tione ned d tasks tasks whic which h cause cause waste waste of labor labor and and firms firms resour resource ces. s. Throu Through gh our our onlin online e book book store store soluti solution on,, we provid provide e an easy easy way way of searching, reserving and purchasing books using latest web based technologies. RFID technique technique has been been utilized utilized in the system system to ensure ensure efficie efficient nt and effective effective purchasing of books since RFID allows faster and robust method to provide a larger amount of information and the reading the information is very easy and efficient since it allows the reader to detect information even at a distance of few meters. Client Clients s are are alway always s verifi verified ed befo before re loggin logging g onto onto the the onlin online e syste system m to ensur ensure e the security and as a preventive measure of any cyber vandalism. User data are validated and checked for authenticity with the data stored in the system database. Reserve Online Collect In-store process enables registered clients to reserve books online saving time of both clients and employees while ensuring satisfaction of both the participating parties. Customer forum is a new advertising strategy which is coined, for the book store to announce news about the store and other affiliated tasks which will in return provide the firm more vicinity among customers and will support to attract new clients. Data mining option enables both the customers and clients to make wise decision through analysis of trends produced by the system which will be of greater use for clients to buy quality books while book store could make necessary alterations to amounts of stock limits in inventory to address the current needs. Published critics, reviews of respective books provide the customer with a chance to evaluate quality of the reading material material that they are planning on purchasing. purchasing. This will help the firm to broaden up its customer base vastly while providing a quality service to clients. All the newly coined processes will address time consuming, ineffective and inefficient areas of the existing system which has being wasting a lot of firms resources such as, labor, electricity, equipment, products and services, while discouraging customers to make purchases and repelling clients from the book store.
50
Project Proposal
Sarasavi Book Shop - Colombo
Proposed system will support both clients and the store in many areas. It’s worth analyzing and identifying the benefits as it would directly influence the productivity of the store.
Customer satisfaction plays the most vital role in any form of product and service rendering store as the existence of any firm solely depends on its customer-base. Therefore, every system should facilitate the customer satisfaction up to a certain extent which is feasible from the company perspective. Proposed system addresses customer satisfaction in following manner.
Making available details, critics and reviews of books for the clients to get an idea of the content and the standard of respective reading materials Online Online inventor inventory y provides provides a complet complete e index index of reading reading materials materials and their their availability Online reservation and purchasing saves time and money Online search option supports clients to locate the reading material that they are interested in and its information within seconds Opportunity to be updated on latest activities such as, book exhibitions, book stalls, stalls, new outlets outlets of book book store establis established hed and book book sales (at a discoun discountt price etc.) Use of modern techniques for secure transactions
The aforementioned facts ensure customer satisfaction to a greater extent benefiting the store in;
Retaining current customers Tempting current customers to attract their friends to the store Attracting new customers Enhancing the customer faith on the firm due to secure transaction techniques while temping customers to make more online purchases Identifying profitable customers Identifying different categories of customers Making necessary alterations and plans to address broader range of customers Identifying Identifying key areas of the inventory which need to be maintained at a healthy tock limit Anal Analyz yzin ing g tren trends ds to make make more more effe effect ctiv ive e mana manage geme ment nt deci decisi sion ons s and and development of new strategies to increase profit
These particulars will make sure the broadening the customer base of the store which will have good impact on the sales and revenue of the store. Employee Employee satisfaction also plays an influential role in healthy revenue revenue levels of a firm. Due to the proposed system, employees will have to handle minimum amount of
51
Project Proposal
Sarasavi Book Shop - Colombo
workload than that of the existing system which will help the employees to provide optimal service to the firm while maintaining healthy physical and mental levels. Proposed system will reduce transaction and agency cost of the store up to a certain extent since the transactions are automated and need of minimal labor to handle work as the their work has been governed by the system. Even though these advantages advantages prevail, due to lack of IT literacy and fluency of clients and lack of distribution of internet facility will have a negative impact and it will take some time to cover up the capital investment made on implementing the new system. Since Since the technica technicall facilitie facilities s are expandi expanding ng in great great heaps, heaps, propose proposed d system system will facilitate enhancing productivity immensely.
52
Project Proposal
Sarasavi Book Shop - Colombo
6. Reference and Bibliography
Australian Computer Society, 2003, ASC Code of Ethics. Retrieved March 15, 2007, from http://www.acs.org.au.htm
Elmasri, Elmasri, R. and Navathe, S. 2004. Enhanced Enhanced Entity Relationship Relationship and UML. In Fundamentals of Database Systems , 3rd Edition
Out Source 2 India n.d. : Why Do Software Projects Fail? Retrieved 22 March 2007
from http://www.outsource2india.com/software/SoftwareProjectFailure.asp Six Sigma n.d. : Applying Six Sigma to Software Implementation Projects Retrieved 22
March 2007 from http://software.isixsigma.com/library/content/c040915b.asp
2004. 2004. Object Object Oriented Oriented Design Design Software Engineering Engineering , 7th
Sommer Sommervill ville, e, Ian Edition
Start Start your your journ journey ey the easy easy way way n.d n.d : Retr Retrie ieve ved d 4 th February February 2007 from http://www.liverpooljohnlennonairport.com/TravelServices/CarParking.php
Ramakrishnan, Ramakrishnan, R. and and Gehrke, Gehrke, J. 2003. The Relational Relational Model Model In Database rd Management Systems, Systems , 3 Edition
53