Online Book Store by Vamsi Krishna Mummaneni - People
Contents
1. Boolean end class Customer lt User attributes customerlD string password string Name string address string email string phoneno integer CClnfo string operations register Boolean login Boolean updateprofile is used to update user information updateProfile customerID string Name string address string email string phoneno integer CClnfo string Boolean 32 Customer already has an customer D pre Customer alllnstances customer D gt includes customer D post Customer alllnstances customerlD user alllnstances customerlD pre Customer name has been created post Customer alllnstances Name user alllnstances gt select C Customer C customerlD lt gt customerID Name pre gt includes Name Customer address has been created post Customer alllnstances email Customer alllnstances gt select C Customer C customerlD lt gt customer D email pre gt includes email post Customer alllnstances address Customer alllnstances gt select C Customer C customerlD lt gt customer ID address pre gt includes address Customer Phoneno has been created post Customer alllnstances phoneno Customer alllnstances gt select C Customer C customerlD lt gt customerID phoneno pre gt includes phoneno post Customer alllnstances CCinfo Customer alllnstances gt select C Customer C customerlD lt gt customerID CCInfo pre gt includes CClInfo end class Category attributes categorylD int2. Suspension criteria and resumption requirements 7 1 Suspension criteria 7 2 Resumption requirements 8 Test deliverables Section 8 Assessment Evaluation 1 Introduction 2 Manual Testing 3 Test Cases 3 1 User 3 2 Admin 4 Performance Testing 5 Observation 6 References Section 9 User Manual Section 10 References 49 49 49 50 50 51 51 52 52 53 54 55 56 59 76 Section 1 Vision Document 1 Introduction 1 1 Purpose and Motivation The main objective of the project is to create an online book store that allows users to search and purchase a book based on title author and subject The selected books are displayed in a tabular format and the user can order their books online through credit card payment The Administrator will have additional functionalities when compared to the common user The motivation to create this project has many sources e Interest to develop a good user friendly website with many online transactions using a database e To increase my knowledge horizon in technologies like NET SQL CSS HTML e To gain good experience in NET before joining in a full time job e To gain expertise using Data Grid Data Set Data Table Data Adapter and Data Readers 2 Project Overview 2 1 Background There are many online book stores like Powell s Amazon which were designed using Html I want to develop a similar website using NET SQL Server Online Book store is an online web app
3. a get book ee place order create and share your own diagrams at gliffy com glit Fig 8 User Add to Cart Sequence Diagram 29 4 Administrator n get book add category delete category add book delete book delete user 7 create and share your own diagrams at gliffy com Peiitty Fig 9 Adminstrator Sequence Diagram 30 4 Data Tier The system database has five tables Categories Items Orders Members and Card types The system database design is shown below Table Name Definition Categories Contains the Book Categories Information Items Contains the Book Information Members Contains the Members Information Orders Contains the Book Orders Information Card Types Contains the Credit Card Information Categories Members card_types card_type_id name Fig 10 System Database Design 31 Section 4 Formal Requirement Specification model OnlineBookstore Classes class User attributes UserID string password string LoginStatus string operations Verifylogin Boolean end class Administrator lt User attributes AdminlD string password string Name string email string phoneNo integer operations addCategory Boolean deleteCategory Boolean addMember Boolean deleteMember Boolean addBook Boolean deleteBook Boolean addCCtype Boolean deleteCCtype
4. criteria A dataset is created as a result of select query Later the dataset is binded to the data repeater to display the selected data 3 Give rating to a book Purpose If the user wants to give rating according to his opinion for a book he can select either Excellent Very good good regular or deficient The final rating of a book will depend on all the individual user rating Actor User Input The user will select a rating based on his opinion Output The system will display the rating of a book and the total number of votes received Below is the display for various rating nme Excellent kkk Very Good RE Good is Regular Deficient 10 Maintain Account 1 Register Oa ae ee Purpose If the user doesn t have an account then he will be asked to register Actor User Input The user will enter details in the registration form according to the required fields The fields include Username Password confirm password first name last name email Address Phone CC details Output After registration the user will be directed to the main home page 2 Login Purpose If the user wants to get access to all the functionalities of Online Book Store he should login using his username and password Actor User Input The user will enter his username and password Output If it is a successful login the user will be directed to the main home page Else if the user enters invalid information he will be asked
5. request For this he should enter his Credit Card details correctly The below page is the checkout page 65 History Bookmarks Tools Help A A C http slocalhost 3062 vamsi bookstore checkout aspx Ww ain y commerce y FreeSports4u O orkut S Dictionary 4 greatandhra E webmail Cricinfo iB The Hindu K K State Online E watch Movies Online Si Telugucinema wi http www whatsle on BollywoodHungam Book Store B z 7 E Remember Never for This Site fox to remember this password caine SD a mtn P CreditCard Type Visa CreditCard Number CVV Code Expiry Date E v 2008 v Home Registration Shopping Cart Sign In Administration After entering the card details click the submit button to process the order 66 Administration Manual The Admin should login to the Website to use his administrative options After logging in he will be redirected to the admin menu page distory Bookmarks Tools Help ay Wa http flocalhost 3062 vamsi bookstore AdminMenu aspx ity Gl in commerce FreeSportstu O orkut eS Dictionary GY greatandhra E3 webmail Cricinfo F The Hindu K K State Online EI watch Movies Online G4 Telugucinema L http www whatslate on BollywoodHungam E Book Store B ox to remember this password l Remember l Never for This Site line 8 323 8g 8 ookStore Home Registration Shopping Cart Signin Administration m
6. Administration Menu Members Orders Books Categories Editorials Editorial Categories Card Types Home Registration Shopping Cart Sign In Administration The Administrative options will be displayed in the menu He can change the details of the members books orders Categories And also can process the order and add new books and categories to the books list When the Admin clicks the Members page he will be navigated to the page below which will show all the member details The Admin can search for a member using the Search box option 67 X b http localhast 3062 vamsi bookstore MembersGrid aspx EFs Cz coosle sain pog commerce FreeSports4u O orkut Se Dictionary 94 greatandhra E webmail Cricinfo i The Hindu K K State Online E watch Movies Online G4 Telugucinema L http www whatslate eon BollywoodHungam Book Store B w Lo J kad nD PR a Cart Signin Administration ma lt Enter full or partial login first or last name Name d Search Login FirstName LastName Level dmin Administrator Account Administrator bhanu praveen muwa Member guest Guest Account Member vamsi vamsi mummaneni Member vamsim vamsi mummaneni Member Insert Home Registration Shopping Cart Sign In Administration The Admin will be directed to the books list page where he can update delete and add book details He can also search for a particular book us
7. After the first phase if any changes are required the Major Professor will discuss with the developer 4 Documentation The documentation will consist of all the deliverables They are vision document project plan software quality assurance plan formal requirements specification architecture design test plan formal technical inspection prototype user manual component design source code assessment evaluation project evaluation references and formal technical inspection letters The committee members will review all documentation for final approval All documentation will be posted on _ the developers website at http people cis ksu edu vamsim mseproject html 5 Standards Practices Conventions and Metrics e Documentation Standards The IEEE standards are used as reference for all the documents of Online Book Store project IEEE Standard for Software Quality Assurance Planning is used for SQA 1 0 e Coding Standards The project coding standards follow C As the project is developed using the C language e Testing Standards The various types of testing performed would be mentioned in the Test Plan document at the end of second phase 42 6 Reviews and Audits All the deliverables produced in each phase of project development are reviewed by the major professor and supervising committee These are evaluated by the committee at the end of each phase and provide comments on the software prototype as well a
8. China Hin Book Store B S 2 8 8 BookStore Home Registration Shopping Cart Sign In Registration Login e Password a I Confirm Password First Name Last Namet PO Email J Address Phone Credit Card Type n O Credit Card Number Home Registration Shopping Cart Sign In Administration A user should enter all the required fields information If he didn t fill all the fields he cannot create an account After entering all the required data click the submit button to register Now you can login to the Website Login page is used to login to the website Login page will appear as below 3 x D http flocalhost 3062 vamsi bookstore Lagin aspx ae orain w commerce y FreeSports4u O orkut Se Dictionary 94 greatandhra 2 webmail Cricinfo F The Hindu K K State Online ED watch Movies Online Gl Telugucinema Ck http www whatslate a Book Store Bl N line o g 38 ookStore Home Registration Shopping Cart Sign In Enter login and password Login Password Home Registration Shopping Cart Sign In Administration 60 After logging in to the website you will enter into a userinfo page which will show the account and shopping cart details A a http flocalhost 3062 vamsi bookstore ShoppingCart aspx Ww IG soog commerce pog FreeSports4u orkut eS Dictionary 4 greatandhra E webmail Cricinfo B The Hindu K K State Online
9. Document 1 0 Revision Vision Document 1 0 will be revised and updated to Vision Document 2 0 The revisions will contain a complete representation of project requirements and these requirements will be ranked according to importance and a set of critical requirements identified It also contain changes suggested by the committee members following presentation one This revision will be approved by the Major Professor 3 2 Project Plan 1 0 Revision Project Plan 1 0 will be revised and updated to Project Plan 2 0 The revisions will contain Implementation plan The Implementation plan will define the activities and actions that must be accomplished during implementation It also contain changes suggested by the committee members following presentation one This revision will be approved by the major professor 3 3 Formal Requirement Specification One part of the project will be formally specified using OCL The specification will represent the formal requirements of the project described in the Vision Document This will be approved by the major professor 3 4 Architectural Design Architectural Design will be documented using UML diagrams such as class sequence and state chart diagrams All architectural components will be documented at interface level This will be approved by the major professor 3 5 Test Plan Test Plan will be developed The document will follow the requirement listings found in Vision Document 2 0 It will
10. Elaboration Plan 3 1 Vision Document 1 0 Revision 3 2 Project Plan 1 0 Revision 3 3 Formal Requirement Specification 3 4 Architectural Design 3 5 Test Plan 3 6 Formal Technical Inspection 3 7 Architecture Prototype Section 3 Architecture Design 1 Introduction 2 Architecture 3 Presentation Tier 4 Middle Tier 5 Data Tier 6 References OO ONnANN 15 15 15 16 16 16 17 17 17 18 18 18 18 19 20 21 23 26 29 31 Section 4 Formal Requirement Specification 32 Section 5 Formal Technical Inspector Checklist 1 Introduction 2 Items to be Inspected 2 1 UML Diagrams 2 2 Formal Specification 3 Formal Technical Inspectors 4 Formal Inspection Checklist 5 Formal Technical Inspection Report Section 6 Software Quality Assurance Plan 1 Purpose 2 Reference Documents 3 Management 3 1 Organization and Responsibilities 3 2 Tasks 4 Documentation 5 Standards Practices Conventions and Metrics 6 Reviews and Audits 7 Test and Problem Reporting 8 Tools Techniques and Methodologies 9 Records collection Maintenance and Retention 10 Deliverables Section 7 Test Plan Test plan identifier Introduction Features to be tested Approach 5 1 Unit testing 5 2 Load testing 5 3 System Testing 5 4 Performance Testing NAwWN 37 37 37 38 38 39 39 40 40 40 40 40 41 42 43 44 44 44 44 45 45 45 48 48 49 49 49 6 Pass fail criteria 7
11. a f C http ftocathost 3062 vamsi bookstore Books aspx category_id Z name amp Ww 7 G 00 je rain w commerce oo FreeSports4u O orkut e Dictionary S4 greatandhra E webmail Cricinfo E The Hindu K K State Online Eo watch Movies Online 4 Telugucinema ZL https ffwww we dni Chowk To China Hin Book Store m Category Databases Y Advanced Search Tite Items found 5 Search Results AA Beginning ASP Databases gt John Kaufman Thearon Willis David Buser Kevin Spencer kauffrnan John Kauffman Price 39 99 Category Databases MySQL OTHER NEW RIDERS Paul DuBois Price 39 99 Category Databases The user can search for a book based on price range book title author and Category This option is provided in the advanced search page If the user is interested in any particular book he can click the book image to get the book details The book details page will appear as below 62 History Bookmarks Tools Help k x Qa http localhost 3062 vams bookstore BockDetall aspx7item_id 228author Gcategory_id 28name 8pricemax 8pricemin amp VY bd iG ain commerce FreeSportsdu orkut S Dictionary 4 greatandhra E webmail Ke Cricinfo B The Hindu K K State Online EQ watch Movies Online G4 Telugucinema Z4 http www whatslate ini Chowk To China Hin Book Store 6 l Book Detail Title Beginning ASP Databases John Kaufman Thearon Willis David Buser Kevin S
12. a main web browser to run the website 3 2 Critical Use Case Requirements User and Administrator are the two actors included in the Online Book Store Fig 2 shows the use case diagram for this website search fora Book Advanced Add or Delete Category Add or Delete Books Manage Orders Adminstrator User Add or Delete CC Add or Delete Member Manage shopping Cart Fig 2 Use Case Diagram Use Cases Browse Catalog 1 Search for a Book Purpose A user can search for a book of his choice by selecting category and title Then a select query is used to retrieve data from the database and display the selected information Actor User Input The user will select a category and enter title in a text box provided Output The system will display the books which matches the selected search criteria A dataset is created as a result of select query Later the dataset is binded to the data repeater to display the selected data 2 Perform Advanced Search Purpose If the user wants to perform an advanced search he can search for a book of his choice by selecting category title author and price range Then a select query is used to retrieve data from the database and display the selected information Actor User Input The user will select a category and enter title author and price range in a text box provided Output The system will display the books which matches the selected search
13. from where he will be directed to a Book description page It includes the notes on the book content and also a link to Amazon com to get the book review 5 User Voting The user can give rating to a book based on his interest He can rate it by giving a score of five as Excellent four for very good three for good two for regular and one for deficient The final rating of a book will depend on all the individual user rating 6 Shopping Cart The user can manage a shopping cart which will include all the books he selected The user can edit delete and update his shopping cart A final shopping cart summary is displayed which includes all the items the user selected and the final total cost 7 Managing user accounts Each user should have an account to access all the functionalities of website User can login using login page and logout using the logout page All the user sessions will be saved in the database 8 Administration The Administrator will be provided with special functionalities like Add or delete a book category Add or delete a member Manage member orders Add or delete a Credit Card type 3 Requirement Specifications All the requirements are specified using OCL a software specification language in the second phase of my presentation 3 1 Main Requirements The Main Requirements include Microsoft Visual Studio 2005 and ASP NET to develop the web application SQL Server 2005 to design the database and Mozilla as
14. manual component design assessment evaluation project evaluation references and formal technical inspection User Manual includes an overview and explanations of common usage user commands error messages and data formats Component Design The internal design of each component will be documented using sequence collaboration diagrams and state chart activity diagrams Source Code which corresponds to architecture and component design will be submitted Assessment Evaluation will include a document detailing the testing done on the project And Project Evaluation includes evaluation of the project ideas and quality References and Formal Technical Inspection Letters will also be documented This phase will be complete once the supervisory committee has approved all the above work 2 Cost Estimate The Cost Estimate is done using the COCOMO model 2 1 COCOMO Project effort and time will be estimated using the COCOMO estimation model Barry Boehm The Online Book store has an average complexity and fair flexibility Therefore it is classified as an organic mode project under the COCOMO model The following formula is the COCOMO model for cost estimation for organic mode projects Effort 3 2 EAF Size 1 05 Time 2 5 Effort 0 38 Where Effort number of staff months PM EAF effort adjustment factor Size number of lines of code for completed product It is measured in KLOC thousands of lines of codes Time total n
15. of critical requirements identified Appropriate changes that were suggested by the committee at the end of phase one will also be updated in the updated version of Vision Document Revision of Project Plan will include updated timeline and cost estimate for the project It also includes The Implementation plan which will define the activities and actions that must be accomplished during implementation Formal Specification will include OCL Architecture Design Plan will include the complete architectural design documentation using appropriate diagrams such as class diagrams sequence collaboration diagrams etc It also includes documentation of reuse of commercial or pre existing components Test Plan will address the required tests to show that the product satisfies the requirements The test plan will identify a set of test cases 15 the types of tests that will be used for these test cases the data that will be used for each case and the requirement traces for each test case Formal Technical Inspection will include inspections by two MSE students One of the designs formal requirement or executable prototype is subjected to inspection Architecture Prototype will address all critical requirements identified in the vision document This phase will be complete once the supervisory committee has approved all the above work 1 3 Production Phase The production phase defines the project implementation and testing This phase includes the user
16. tasks during the Project Implementation Phase Breakdown Research Documentation Design Testing ae a Design i Coding Testing oi Documentation Coding Fig 2 Task breakdown 4 Lessons Learned Programming The Online Book Store Project helped me to improve my confidence level in C Programming Though I have made many mistakes during the initial phase I have learnt how to use user controls master pages data grid data set and other data base functionalities Time Management Since MSE Project is done as an individual I have learnt how to manage time during the Software Life Cycle Process I have also learned how o face tense situations and meet the deadlines This would add as a good experience for me for my future job prospective 74 UML and Software Lifecycle As software student though I have good knowledge in UML and Software LIFE cycle I never had any good practical experience regarding them Through this project I have learnt how to develop a project following the various stages in Software Life Cycle Documentation I always had a feeling that I am not good at documentation But through this project and suggestions from my committee members I believe that I have improved my Documentation skills 75 Section 11 References e IEEE Recommended Practice for Software Design Descriptions IEEE Std 1016 1998 e IEEE Recommended Practice for Software Requirements Specifications IEEE Std 830 1998 e IE
17. to check the entered information 3 Update Profile Purpose If the user wants to change his personal account information then he can update his selected fields and the entire data will be updated in the data base through an update query Actor User Input The user will update his account information Output The system will update the entered information in the database using an update query 4 Logout Purpose If the user wants to end his session and sign out of the website then he can use the logout option Actor User 11 Input The user will click the logout button Output The user s account session comes to an end and he should login again if he wants to enter into the website Manage Shopping Cart 1 Place an order Purpose If the user wants to purchase a book then he can place an order by selecting the add to shopping cart button and entering the quantity required under the book description Actor User Input The user will enter the quantity required and click the add to shopping cart button Output The order will be added to the user s shopping cart 2 Update Shopping Cart Purpose If the user wants to change the quantity of a book or change a book then he can update his shopping cart Actor User Input The user will click the details button in the shopping cart summary to edit and update his order details Output The updated order details are reflected in the shopping cart summary 3 Vie
18. 2 1 C language The main problem encountered during the process was my inexperience in the ASP NET and C Language and environment So I used the videos in asp net website to get basic experience in C NET I tried to solve some sample applications which helped me to design the website easily It was difficult for me to format the home page of my website using the C NET code So finally I choose to use the html div tags which made my work easier I also didn t have good experience of using the J Meter testing tool for performance testing So I learnt about it using some tutorials which I found using google com 2 2 Security I also had some security issues to be resolved e Only the user who will login can order for a book and checkout e And also the user should not be able to access the Administrative options It was easy for me to create the user security options for checkout but I faced problems with protecting Admintrative options from the user But later I was able to figure it out using Google search engine and some videos about C security 3 Metrics 3 1 Lines of Code My initial estimate was 3000 LOC during Phase 1 This was calculated in the COCOMO model in Project Plan 1 0 document But now I found the total to be 3203 LOC after the coding part is completed I used the LOC metrics tool to count the total number of Lines of Code 71 The reason for increase in the size of the project may be due to my inexperience in progra
19. ADMIN INPUT RESULTS PASS CRITERIA Admin accepts Members PASSED Member is accepted Admin deletes Members PASSED Member is not accepted 4 Performance Testing The system should meet the performance requirements as mentioned in the Vision document The performance will be evaluated based on the response time of the GUI and the database commands Using JMETER tool performance testing will be done Apache JMETER is a 100 pure Java desktop application designed to load test functional behavior and measure performance Originally designed to test web applications it is now a general tool for testing client server applications like database servers FTP servers and others It lets you test your applications under different work loads and graphically represent the application s behavior I have tested the performance of three different pages of my Online Book Store Website as mentioned in the Test Plan document during Phase 2 Pages Tested e Home Page e Search Page e Shopping Cart Page The Performance testing has been done using a sample of 8 threads which are generated with a loop of 100 54 Home Page http localhost 3062 vamsi bookstore Default aspx The graph below in Fig 1 shows the test results of Homepage of Online Book Store Website Performance Graph Graph Results Name Graph Results Comments Write All Data to a File Filename Browse C Log Errors Only Graphs to Disp
20. EE Standard for Software Test Documentation IEEE Std 829 1998 e JEFE Guide for Software Quality Assurance Planning IEEE Std 730 1 1995 e http www asp net learn data access tutorial 16 vb aspx e www gliffy com e 7http msdn microsoft com en s library system security permissions securitypermissionattribute VS 71 aspx http www locmetrics com http nces ed gov nceskids createA Graph http en wikipedia org wiki Load_testing http en wikipedia org wiki Unit_test http www viveo oolobject com savoirfaire ecmfinance concepts usine 3tiers php file C Documents 20and 20Settin gs Owner Desktop jakarta jmeter 2 3RC3 docs usermanual build adv web test plan html e http en wikipedia org wiki Manual_testing 76
21. EQ watch Movies Online 94 Telugucinema L http www whatslal m gt ine eel ak To China Hin Book Store B fhline e9 B BookStore Home Registration Shopping Cart Sign In User Information Login vamsim First Name vamsi Last Name mummaneni Address o 124 vattier st apttd Email vamsim ksu edu Phone 972 313 5729 Order hem Price Quantity Total Details 19 Beginning ASP Databases 39 99 1 39 99 Total 39 99 Continue Shopping Checkout Home Registration Shopping Cart Sign In Administration If you want to update your account details click the login hyperlink and you will be directed to the update page K A D http localhost 3062 vamsi bookstore MyInfo aspx vw d G ooge Ra commerce y FreeSports4u orkut Se Dictionary 94 greatandhra E3 webmail Cricinfo F The Hindu K K State Online SD watch Movies Online 54 Telugucinema AL http fwww whatslat meaa NA e A a owk To China Hin Book Store line 8 2 8 8 BookStore Home Registration Shopping Cart Sign In Mylnfo Login Password First Name Last Name fr Email Address Phone Notes Home Registration Shopping Cart Sign In Administration 61 In the update page user can change his account information and click update The updated information will be saved in the database To search for a book the user can use the search and Advanced search options
22. Online Book Store by Vamsi Krishna Mummaneni A Report Submitted in partial fulfillment of the requirements of the degree of Master of Software Engineering Kansas State University Manhattan Kansas Committee Members Dr Torben Amtoft Major Professor Dr Dan Andresen Dr Mitchell L Neilsen Acknowledgements I would like to thank my major professor Dr Torben Amtoft who persuaded and continuously guided me during the whole course of my project I would also like to thank Dr Daniel Andresen and Dr Mitchell L Neilsen and for their assistance and insightful comments and who willingly shared their expertise with me I sincerely acknowledge and thank my family members and friends who gave moral support for me from my childhood Abstract The main objective of the project is to create an online book store that allows users to search and purchase a book online based on title author and subject The selected books are displayed in a tabular format and the user can order their books online through credit card payment Using this Website the user can purchase a book online instead of going out to a book store and wasting time There are many online book stores like Powell s Amazon which were designed using Html I want to develop a similar website using NET SQL Server Online Book store is an online web application where the customer can purchase books online Through a web browser the customers can search for a book by i
23. Web Development Bradley D Brown Brad Brown 41 99 Databases No Black Belt Web Programming Edit Methods Servers Security Databases 27 96 Programming Yes and Sites Web Development with Java Server The orders link will navigate the Admin to the orders page which will display all the orders placed by the user Vy geen eee ump 0 http flocalhost 3062 vamsi bookstore OrdersGrid aspx wy Q zoogle ie commerce We FreeSports4u orkut eS Dictionary 4 greatandhra webmail Cricinfo El The Hindu K K State Online EQ watch Movies Online Telugucinema XL http www whatslate kSt Home Registration Shopping Cart Signin Administration B00 ore ws ltem All Member All Z Search Edit Item Member Quantity Edit Web Database Development Step by Step vamsi Im dit Flash 4 Magic WITH CD ROM dit ColdFusion Fast amp Easy Web Development dit Beginning ASP Databases Im Im Im Im dit MySQL and mSQL dit Web Database Development Step by Step E m dit C Programming with the Public Beta Edit Beginning ASP Databases E 2 1 2 1 dit Black Belt Web Programming Methods Servers Security Databases and Sites bhanu 1 1 2 1 1 Home Registration Shopping Cart Sign In Administration 69 vamsi bhanu bhanu bhanu bhanu guest vamsim The Categories page will display the entire book Categories The user can update delete and add a catego
24. also identify a set of test cases the types of tests that will be used for these test cases the data that will be used for each case and the requirement traces for each test case This will be approved by the major professor 3 6 Formal Technical Inspection 18 Two MSE students will act as technical inspectors The technical inspection will assess the project architecture It will also include a formal checklist to be used by the inspectors This will be approved by the major professor 3 7 Architecture Prototype An executable prototype will be built including all critical requirements described in the vision document 19 Section 3 Architecture Design 1 Introduction The purpose of this document is to provide an architectural design for the Online Book Store The design will show the presentation tier the middle tier consisting of classes sequence diagrams and the data tier consisting of the database design diagram 2 Architecture Three tier layer is a client server architecture in which the user interface business process business rules and data storage and data access are developed and maintained as independent modules or most often on separate platforms The Architecture of Online Book Store is based on three tier architecture The three logical tiers are e Presentation tier ASP NET Web forms Master Pages Images e Middle tier C classes e Data tier Database Fig 1 below shows the model of 3 tier ar
25. b development database integration with Active Server Pages In Beginning ASP Databases a trio of authors covers the basics of working with databases from ASP especially using Activex Database Objects ADO The book is quite substantive in content but is written Notes in a somewhat light hearted style that makes readers new to the technology comfortable The authors begin with a discussion of the benefits of ASP and ADO and then explain how to configure the technology on the various flavors of Windows From there they show how to access databases using ADO demystify how it all works and focus on several key areas including debugging SQL and stored procedures Review this book on Amazon com Quantity 1 Add to Shopping Cart Current Rating veteversy Total Votes 1 Your Rating Good v 63 The user can add the book to a shopping cart by entering the quantity and clicking the add to shopping cart button The quantity value should always be a positive value The user can also provide feedback to a book in the form of user rating by selecting the Your Rating dropdown list After adding to the shopping cart if the user wants to continue shopping he should click the continue shopping link else he can checkout using the checkout link A Kk http localhost 3062 vamsi bookstore ShoppingCart aspx Ww Gc nge commerce FreeSports u Oo orkut eS Dictionary 4 greatandhra E7 webmail Cricinfo B The Hindu K K S
26. checklist passed the test criteria Item to be Inspected Pass Fail Comments Partial All the symbols used in the class diagrams are Pass according to the UML standards All the classes in the class diagram are clear as to Pass what they represent in the architecture design document The symbols used in the sequence diagram Pass correspond to UML standards Sequence diagram matches class diagram Pass All the classes in the USE model are represented in Pass the class diagram The multiplicities in the USE model have been Pass depicted in the class diagram All the requirements in the Software Requirements Pass Specification have been covered in the Architecture Design Document Thanking you Phaninder Surapaneni 38 Dr Amtoft Dr Andresen Dr Neilsen I have completed the Formal Technical Inspection for Vamsi Mummaneni s Online Book Store project All the items in the checklist passed the test criteria Item to be Inspected Pass Fail Comments Partial All the symbols used in the class diagrams are Pass according to the UML standards All the classes in the class diagram are clear as to Pass what they represent in the architecture design document The symbols used in the sequence diagram Pass correspond to UML standards Sequence diagram matches class diagram Pass All the classes in the USE model are represented in Pass the c
27. chitecture The main reason for considering three tier architecture for the Online Book store is as follows Flexibility e Management of data is independent from the physical storage support e Maintenance of the business logic is easier e Migration to new graphical environments is faster e If there is a minor change in the business logic we don t have to install the entire system in individual user s PCs Reusability e Reusability of business logic is greater for the presentation layer As this component is developed and tested we can use it in any other project and would be helpful for future use 20 Security e More secured architecture since the client cannot access the database directly Client Workstation Displays Data Modifies Inserts Data Communicates business rules fo users Provides all user interaction Communicates with webserver to process information Fig l 3 tier Architecture Receives requests rom client Communicates with the App Layer or Server Responds to client requests App Layer of server applies business logic Communicates with the dalabase 21 Manages Data Interacton Enforces Data Integrity Dogs all that OB stuff 3 Presentation tier The presentation tier for the Online Book Store is ASP NET Web Forms with Master Pages The presentation tier takes care of the user interaction and the visual part of the website The
28. correct Display message Login or Password is incorrect User logs in successfully PASS CRITERIA Book is added to the shopping cart User should create an account PASS CRITERIA Quantity and total cost of Cart should be updated Books and total cost of Cart should be updated Books and total cost of Cart should be updated 3 2 ADMIN Create and Delete a Book from Category ID TEST CASE ADMIN INPUT AD_CDB_1 Create and Delete a Admin adds a new book to PASSED Book from Category category Create and Delete a Category JD AD_CDC_1 AD_CDC_1 TEST CASE Create and Delete a Category ADMIN INPUT RESULTS Admin adds a new PASSED category Admin category Create and Delete deletes a PASSED a Category Manage Orders TEST CASE Manage Orders AD_MO_2 Manage Orders ADMIN INPUT Admin accepts an order RESULTS PASSED PASSED Admin deletes an order 53 AD_CDB 2 Create and Delete a Admin deletes a book PASSED Book from Category from category Category deleted from system PASS CRITERIA Book should be updated in Categories list Book should be deleted in Categories list PASS CRITERIA Category updated to system should be should be PASS CRITERIA Order is processed Order is not processed Manage Members TEST CASE Manage Members AD_MM_2 Manage Members
29. e Sting email String ScategorylD Int amp phoneNo String ScategoryName String Customer Snassword String Name String AbstractMethodError a YaddCategory SyetCateyoryBooks Gadiess Sting deleteCategory se re i Secinio Stn deleteMember Spo0k 0 nt olning addBo0k SbookName String Ren SdeleteBook iisi deleteBook ae SaddCCtype A An VupdateProfile i YieleteCCtypel ShoppingCart Q0 n 1 price Float BooksOrd cistern aoksOrder n SorderlD Int 1 SaddCart QpriceFloa eaten Toman amp CustomerlD Int Search n AdvSearch ee end SdeleteCart SudateCart ti bookTitle String SCategorylD Int pen Qn categorylD Int SybookTitle String orice Float VplaceOrder SbookAuthor String Srating nt SbookLowCost Float SAuthomame String S bookHighCost Float imageurl Sting notes String SyetAdvBookSet Soroducturl Sting i ScategorylD Int VyetBook Fig 4 Class Diagram 26 Sequence Diagrams create and share your own diagrams at gliffy com Oaiitty 1 User Login Session Manager q Cs user userid password actor D defuatt aspx custome ogin userid assword P Ls if login succestu Fig 5 User Login Sequence Diagram 27 2 Book Search aa ___ searchititle cathy ory create and share your own diagrams at gliffy com gliff Fig 6 User Book Search Sequence Diagram 28 3 Add to shopping cart
30. eger categoryName string operations getCategoryBooks bookID int Set Book Book alllnstances gt select b Book b bookID bookID end class Book attributes bookID integer categorylD integer bookName string authorName string notes string price float imageurl string producturl string rating int operations getBook Boolean end class ShoppingCart attributes order D integer customerI D integer price float 33 operations addCart Boolean deleteCart Boolean updateCart Boolean end class BookOrder attributes order D integer customerID integer price float quantity integer operations placeOrder BO BookOrder Boolean User authentication is verified pre BO User Verifylogin BO User UserID BO User password true pre BookOrder alllnstances gt excludes BO Check whether customerid and customerid in Order is same post Customer alllnstances gt forAll C Customer C customerlID BO customerlD implies BO orderlD C orderlD post BookOrder alllnstances orderlD BookOrder alllnstances orderID pre gt includes BO orderID end class Search attributes bookTitle String categorylD integer operations getBookset Boolean end class AdvSearch attributes bookTitle String categorylD integer bookAuthor String bookLowCost float bookHighCost float operations getBooksetbyAdv Boolean end class BookSet attributes bookID Int bookName String end Assosiations Each book s
31. essing the program concurrently As such this testing is most relevant for multi user systems often one built using a client server model such as web servers 5 3 System Testing Once the entire system has been built then it has to be tested against the Software Requirement Specification and System Specification to check if it delivers the features required System testing can involve a number of specialist types of test to see if all the functional and non functional requirements have been met 5 4 Performance Testing The system should meet the performance requirements as mentioned in the Vision document The performance will be evaluated based on the response time of the GUI and the database commands Using JMETER tool performance testing will be done 5 5 Manual Testing Manual Testing will be done to ensure the correctness of various parts of the code using test cases generated by the tester 6 Pass fail criteria The system should satisfy all the functional requirements in the Vision document Each feature to be tested will be evaluated against its requirement as stated in the Vision Document The pass or fail of a test depends on whether the system meets with all the particular post conditions Test cases executed on the Online Book Store will pass if they meet the specific requirements as mentioned in the Vision Document 7 Suspension criteria and resumption requirements 7 1 Suspension criteria 49 If the system contai
32. from category in Categories list Create and Delete a Category ID TEST CASE ADMIN INPUT PASS CRITERIA AD_CDC_1 Create and Delete a Admin adds a new Category should Category category updated to system AD_CDC_1 Create and Delete a Admin deletes a category Category should be Category deleted from system 47 Manage Orders ID TEST CASE ADMIN INPUT AD_MO_1 Manage Orders Admin accepts an order Order is processed AD_MO_2 Manage Orders Admin deletes an order Order is not processed Manage Members ID TEST CASE ADMIN INPUT Manage Members Admin accepts Members Member is accepted AD_MM_1 AD_MM_2 Manage Members Admin deletes Members Member accepted 5 Approach This section describes the overall approach of the testing which ensures that the each feature and the combination of the features are adequately tested The major tasks that are used are 5 1 Unit testing Unit testing is a method of testing that verifies the individual units of source code are working properly The goal of unit testing is to isolate each part of the program and show that the individual parts are correct The NUnit a testing tool for C will be used for unit testing 48 5 2 Load testing Load testing is the process of creating demand on a system or device and measuring its response It generally refers to the practice of modeling the expected usage of a software program by simulating multiple users acc
33. garding the project Major Professor e Dr Torben Amtoft The major professor will be responsible for supervising and evaluating the work and progress done by the developer on a weekly basis Developer e Vamsi Mummaneni The developer should submit all the deliverables and complete the project functionalities on time He should keep updating his weekly progress to the Major Professor Formal Technical Inspectors The formal technical inspectors will be responsible for a technical review of the architecture design artifacts and the formal requirements specifications and will also be required to submit a formal report based on their findings Formal Technical Inspection Checklist Item to be Inspected Pass Fail Comments Partial All the symbols used in the class diagrams are according to the UML standards All the classes in the class diagram are clear as to what they represent in the architecture design document The symbols used in the sequence diagram correspond to UML standards Sequence diagram matches class diagram All the classes in the USE model are represented in the class diagram The multiplicities in the USE model have been 41 depicted in the class diagram All the requirements in the Software Requirements Specification have been covered in the Architecture Design Document 3 2 Tasks All tasks to be performed are mentioned in the Project Plan1 0
34. hould belong to only one Category 34 association bookCategory between Category 1 role subCategory Book 1 role allBook end Each BooksOrder should contain atleast one Book association BooksOrderHasBook between BooksOrder 1 role the BookOrder Book 1 role theBook end Each BooksOrder should belong to exactly one Customer association CustomerHasOrder between Customer 1 role belongstocustomer BooksOrder 0 role thecustomerbook end Each Shopping cart should belong to only one Customer association CustomerrelatedtoShoppingCart between Customer 1 role thecustomer ShoppingCart 0 role thecart end Each shoppingcart should have atleast one BooksOrder association ShoppingCartHasOrder between ShoppingCart 1 role thebookCart BooksOrder 1 role theorder end Each search should result some bookset association searchhassomebookset between Search 1 role thesearch BookSet 0 role thesearchset end Each Advsearch should result some bookset association Advsearchhassomebookset between AdvSearch 1 role theAdvsearch BookSet 0 role theAdvsearchset end Constraints Each user should have different userID context User inv distinctuserlD User alllnstances gt forAll user1 user2 user1 lt gt user2 implies user1 userlD lt gt user2 userID 35 Each Book should belong to exactly one Category context Category inv BookHasoneCategory Category alllnstances gt forAl
35. ing this page 68 Cc xX L htteifecahest 3052 vamsi bookstore AdminBocks aspx w G Google idlebrain commerce Me Freesports4u orkut Dictionary OY greatandhra E3 webmail Cricinfo The Hindu K K State Online EB watch Movies Online 4 Telugucinema XL http www whatslati Pe E EEA L Book Store B n Category All x Recommended All x Edit Title Author Price Category Recommended Web Database Development Step b Edit Step P poy Jim Buyens 39 99 Databases Yes m 7 fy Larry Wall Tom Christiansen Jon y Edit Programming Perl 3rd Edition Orwant 39 96 Programming No Perl and CGI for the World Wide Web _ X Edit Visual QuickStart Guide Elizabeth Castro 15 19 Programming No Edit MySQL OTHER NEW RIDERS Paul DuBois 39 99 Databases No Edit PHP and MySQL Web Development Luke Welling Laura Thomson 39 99 Programming No Edit MySQL amp PHP From Scratch Wade Maxfield 23 99 Programming Yes 3 Randy Jay Yarger George Reese Tim Edit MySQL and mSQL King 27 96 Databases Yes r David J Emberton J Scott Hamlin HTML amp Web Edit Flash 4 Magic WITH CD ROM David Emberton 36 design No di Web Application Development with Tobias Ratschiller Till Gerk 36 p 4 N Edit 5up 4 9 with CD ROM obias Ratschiller Till Gerken rogramming o John Kaufman Thearon Willis David Edit Beginning ASP Databases Buser Kevin Spencer kauffman John 39 99 Databases Yes Kauffman Edit Oracle8i
36. itecture Prototype Phase III e Action Items identified during phase I e User Manual e Component Design e Source Code e Assessment Evaluation e Project Evaluation e References e Formal Technical Inspection 44 Section 7 Test Plan 1 Test plan identifier CIS 895 MSE Project Test plan Online Book Store V1 0 2 Introduction The goal of this document is to develop a test plan for the Online Book Store design system This document defines all the procedures and activities required to prepare for testing of the functionalities of the system which are specified in Vision document The objectives of the test plan are to define the activities to perform testing define the test deliverables documents and to identify the various risks and contingencies involved in testing 3 Features to be tested The following list describes the features to be tested USER Registration Login Add To Cart Edit Cart ADMIN Create and Delete book from Category Create and Delete a Category Manage Orders Manage Members 45 4 Test Cases 4 1 USER Registration TEST CASE User Registration User Registration User Registration User Registration Login ID TEST CASE U_LOG_1 User Login U_LOG_2 User Login U_LOG_3 User Login Add to Cart TEST CASE Add to Cart Add to Cart USER INPUT User selects already existing user name Display message to choose different u
37. l C1 C2 C1 lt gt C2 amp amp C1 getCategoryBooks gt includes book implies C2 getCategoryBooks gt excludes book Each Book should have a different bookID context Book inv DistinctBookID Book alllnstances gt forAll B1 B2 B1 lt gt B2 implies B1 bo0okID lt gt B2 bookID The OrderlD for each Order must be different context BookOrder inv DistinctOrderID BookOrder alllnstances gt forAll BO1 BO2 BO1 lt gt BO2 implies BO1 orderlD lt gt BO2 orderID Each BookOrder should have some books context BookOrder inv BookOrderHasbooks self contains gt notEmpty Each BookOrder belongs to exactly one customer context BookOrder inv OrdertoOneCustomer Order alllnstances gt forAll BO1 BO2 BO1 orderlID lt gt BO2 orderID implies BO1 customerlD lt gt BO2 customerID Quantity should always be a positive value context BookOrder inv BookOrder Positive self quantity gt 0 Each Shopping cart belongs to only one customer context ShoppingCart inv CarthasOneCustomer ShoppingCart alllnstances gt forAll SC1 SC2 SC1 orderlID lt gt SC2 orderID implies SC1 customerlD lt gt SC2 customerlID In search Low price should be less than High Price context AdvSearch inv PriceCompare self bookLowCost lt self bookHighCost Price should always be a positive value context Book inv BookPricePositive self price gt 0 36 Section 5 Formal Technical Inspectors Check
38. lass diagram The multiplicities in the USE model have been Pass depicted in the class diagram All the requirements in the Software Requirements Pass Specification have been covered in the Architecture Design Document Thanking you Snehal Monterio 39 Section 6 Software Quality Assurance Plan 1 Purpose The purpose of Software Quality Assurance Plan is to define all the techniques procedures and methodologies that will be used in the project to assure timely delivery of the software that meets specified requirements within project resources Software Quality Assurance involves reviewing and auditing the software products and activities to verify that they comply with the applicable procedures and standards and providing the software project and other appropriate managers with the results of these reviews and audits 2 Reference Documents e Project Plan 1 0 e Vision Document 1 0 e TIEFE standard for Software Quality Assurance plans IEEE STD 730 1998 3 Management 3 1 Organization and Responsibilities The organization consists of supervisory committee major professor developer and formal technical inspectors Supervisory Committee e Dr Torben Amtoft e Dr Daniel Andresen e Dr Mitchell Neilsen 40 The committee will be responsible for attending the presentations and reviews at the end of each phase After each presentation the committee will provide feedback and suggestions re
39. lay Vv Data v Average v Median v Deviation V Throughput SERER yo a Le sm EM Miad a Adm hta A ais Vy ney P A AE N p AAAA EEATT T TEN aaa TE atadas ta na an os PT pele Agr I Py ride _ ea wero nhs h t me f ea i a 4 d I a oms f4 i D gt No of Samples 800 Latest Sample 16 Average 98 Deviation 20 Throughput 4704 498676859747 minute Median 94 Fig 1 55 Search Page http localhost 3062 vamsi bookstore Books aspx The graph results below in Fig 2 shows the test results of Search Page of Online Book Store Website Performance Graph Graph Results Name Graph Results Comments Write All Data to a File Filename Browse C Log Errors Only Graphs to Display v Data Average Median Deviation Throughput m S P ae gt porn ar Rie tn gate sem PRAA A es y p e p gu aygan y ASASAS poppa ae Foar we i me 5 a n i a Oms f4 i gt No of Samples 800 Latest Sample 78 Average 102 Deviation 17 Throughput 4571 4285714285725 minute Median 94 Fig 2 56 Shopping Cart Page http localhost 3062 vamsi bookstore ShoppingCart aspx The graph results below in Fig 3 shows the test results of Shopping Cart Page of Online Book Store Website Performance Graph Graph Results Name Graph Results Comments Write All Data to a File Filename Brow
40. lication where the customer can purchase books online Through a web browser the customers can search for a book by its title or author later can add to the shopping cart and finally purchase using credit card transaction The user can login using his account details or new customers can set up an account very quickly They should give the details of their name contact number and shipping address The user can also give feedback to a book by giving ratings on a score of five The books are divided into many categories based on subject Like Software Database English Architecture etc This project has the following functionalities 1 A Home page with product catalog This is the page where the user will be navigated after a successful login It will display all the book categories and will have a search keyword option to search for the required book It also includes some special sections like recommended titles weekly special books 2 Search A search by keyword option is provided to the user using a textbox The keyword to be entered should be the book title 3 Advanced Search Advanced search helps the user to search for a book based on Title Author Category and price range All the books which match the particular search criteria and their total count will be displayed From here the user can select a book and add to the shopping cart 4 Book Description If the user would like to know details about a book he can click on the title
41. list 1 Introduction The document specifies checklist to be inspected by the technical inspectors of Online Book Store The main purpose of the formal technical inspection process is to ensure quality of the software design Two MSE students will perform the inspection and provide the formal report on the result of their inspection 2 Items to be inspected 2 1 UML Diagrams e Class diagrams e Sequence diagrams 2 2 Formal Specification e USE Model 3 Formal Technical Inspectors e Phaninder Surapaneni e Snehal Monterio 4 Formal Inspection Checklist Item to be Inspected Pass Fail Partial Comments All the symbols used in the class diagrams are according to the UML standards All the classes in the class diagram are clear as to what they represent in the architecture design document The symbols used in the sequence diagram correspond to UML standards Sequence diagram matches class diagram All the classes in the USE model are represented in the class diagram The multiplicities in the USE model have been depicted in the class diagram All the requirements in the Software Requirements Specification have been covered in the 37 Architecture Design Document 5 Formal Technical Inspection Report Dr Amtoft Dr Andresen Dr Neilsen I have completed the Formal Technical Inspection for Vamsi Mummaneni s Online Book Store project All the items in the
42. mming in C and using extra functions for functionality And it was difficult for me to estimate the exact number of lines of code during the initial phase of my Project 3 2 Time The project took 27120 minutes which is 452 hours at 22 hours a week that is 19 weeks or 4 8 months The initial estimate for my project using the COCOMO model analysis has come to 4 96 staff months Table below shows the time spent for each task at each phase Design is the most important task that was performed at last two phases Coding was performed in last two phases but mainly in the implementation phase Phases Start Date End Date Inception July 15 2008 Aug 18 2008 Implementation Aug 20 2008 Nov 20 2008 Elaboration Nov 21 2008 Dec 11 2008 Table 1 Project Phase Schedule The Table below shows the break down of time spent in each phase for Research Design Coding Testing and Documentation Inception Hours Implementation Hours Elaboration Hours Total Research 20 25 5 50 Design 17 20 5 42 Coding 0 210 37 247 Testing 0 15 30 45 Documentation 20 28 20 68 Total 57 298 97 452 Table 2 Phase Breakdown 712 The Pie chart in Fig 1 shows the hour break down for each phase Time spent for each Phase Phase 1 Phase 3 E Phase 1 E Phase 2 I Phase 3 Phase 2 Fig 1 Project Phase Schedule 73 The pie chart in Fig 2 shows the Time allocated for various
43. ns one or more critical defects like the defects in the GUI editor which provides the editing features for one line diagrams and database locking unlocking and sharing features which provides the environment for multiple users to work in parallel the entire system should be suspended The testing may also be suspended if the hardware and software components required are not available on time The failed test cases should be recorded along with the description for failure 7 2 Resumption requirements When a new version of the system is transmitted to the test group after a suspension of testing has occurred all previous tests will be rerun to ensure program changes have not inadvertently affected other portions of the program 8 Test deliverables The following documents are the available test deliverables Test plan Test case specifications Test input and output data Test procedure specifications Test logs 50 Section 8 Assessment Evaluation 1 Introduction The goal of this document is to present all the test results using the test cases defined in the Test Plan Document I have performed Manual and Performance testing for my Online Book store project 2 Manual Testing Manual testing is done to test the correctness of all the functionalities by manually entering the data Test case functionalities for manual testing include USER e Registration e Login e Add To Cart e Edit Cart ADMIN e Create and Delete b
44. ook from Category e Create and Delete a Category e Manage Orders e Manage Members 3 Test Cases 3 1 USER Registration TEST CASE j RESULT PASS CRITERIA User Registration User selects already existing user PASSED Display message to choose different user name Display message that Password and name User Registration User enters different password in PASSED password confirm field 51 User Registration required fields all the User enters details successfully User Registration Login ID TEST CASE Add to Cart TEST CASE Add to Cart User selects a book and PASSED clicks add to cart button Add to Cart clicks add to cart button Edit Cart TEST CASE Edit Cart USER INPUT User changes the Quantity PASSED Edit Cart User deletes a book from PASSED shopping Cart User selects a new book to PASSED shopping Cart Edit Cart 52 User forgets to enter a particular USER INPUT RESULT PASS CRITERIA User Login User enters a wrong PASSED username U_LOG_2 User Login User enters a wrong PASSED password User Login User enters correct PASSED username and password Guest selects a book and PASSED Confirm Password fields don t match PASSED Display message The value in field is required PASSED User account created Display message Login or Password is in
45. pencer kaufman John Kauffman Category Databases Price 39 99 Author As a tutorial Beginning ASP Databases offers an entry point to one of the most crucial aspects of Microsoft oriented Web development database integration with Active Server Pages In Beginning ASP Databases a trio of authors covers the basics of working with databases from ASP especially using Activex Database Objects ADO The book is quite substantive in content but is written Notes in a somewhat light hearted style that makes readers new to the technology comfortable The authors begin with a discussion of the benefits of ASP and ADO and then explain how to configure the technology on the various flavors of Windows From there they show how to access databases using ADO demystify how it all works and focus on several key areas including debugging SQL and stored procedures vi is b n co Quantity 1 x A El httpilocalhost 3062 vamsi bookstore BookDetail aspx item_id 22 amp author amp category_id 28name 8pricemax 8pricemin 8 WwW el rain D commerce X FreeSports4u orkut Dictionary 4 greatandhra webmail Cricinfo E The Hindu K K State Online ES watch Movies Online 84 Telugucinema http www what ini Chowk To China Hin Book Store a As a tutorial Beginning ASP Databases offers an entry point to one of the most crucial aspects of Microsoft oriented We
46. ration page where the user will select it for his future transactions 6 Add or Delete Member Purpose If the Administrator wants to add or delete a book category then he can insert or delete a book category using his administration rights and the category table will be updated in the database Actor Administrator Input If the Administrator wants to add a book category the he should click the insert link button in the category page else he can delete a particular selected book category Output The updated categories list will be displayed in the main home page 7 Logout Purpose If the Administrator wants to end his session and sign out of the website then he can use the logout option Actor Administrator Input The Administrator will click the logout button Output The Administrator s account session comes to an end and he should login again if he wants to enter into the website 3 3 Environment The Online Book store will be developed in Visual Studio 2005 environment C will be used as the programming language 14 Section 2 Project Plan 1 Task Breakdown 1 1 Inception Phase The inception phase will define all the project s requirements This phase will include the production of a Vision Document a Project Plan a Software Quality Assurance Plan and a Demonstration Vision Document will include the project s requirements and overview It includes overview of the project its purpose goals risks cons
47. ry entry to the original list cA 4 http flocathost 3062 vemsi bookstore CategoriesGrid aspx por ig id le gt commerce B FreeSportstu O orkut e Dictionary 94 greatandhra E3 webmail Cricinfo E The Hindu K K State Online EE watch Movies Online 94 Telugucinema LE http fjwww whatslate 2 g Home Registration Shopping Cart Signin Administration Databases j HTML amp Web design Programming a gt Se fe f Home Registration Shopping Cart Sign In Administration The Admin can logout at any moment by clicking the logout button wo ngay gyun Lena Lee S aA a L http slocathost 3062 vamsi bookstore Login aspx wy Gl llebrain y commerce y FreeSports4u O orkut 8 Dictionary 94 greatandhra E7 webmail Cricinfo B The Hindu K K State Online EE watch Movies Online Gi Telugucinema gi http www line re Oo k St o r e Home Registration Shopping Cart Signin Administration mS Enter login and password admin Home Registration Shopping Cart Sign In Administration 70 Section 10 Project Evaluation 1 Introduction This document evaluates the experience of the development of the Online Book Store project A brief description of the tools process techniques employed as well as the mistakes made is presented so that lessons are documented and learned 2 Problems faced The following are the problems faced during the design of Online Boos Store Website
48. s suggestions for any changes or addition to the requirements specification The two formal technical inspectors will assess the architecture design artifacts and submit a formal report based on their findings 7 Test and Problem Reporting All the testing procedures used for the project would be mentioned in the test plan document at the end of second phase The results would be reviewed and all the unresolved problems will be reported to the committee members 8 Tools Techniques and Methodologies The following tools tecnniques and methods would be used for the project for the specified purpose e Coding C CSS HTML ASP Net Microsoft VisualStudio Net 2005 IDE Microsoft SQL Server 2005 e Testing Junit e Documentation MS Word Rational Rose MS Project OCL 9 Records collection Maintenance and Retention Three sets of design documentation would be produced and distributed to the University Library Major Professor and developer The source code documentation and web pages are submitted to the Major Professor in the form of a CD 10 Deliverables The deliverables for all the three phases are listed below Phase I e Vision Document 1 0 e Project Plan 1 0 43 e Software Quality Assurance Plan Phase II e Action Items identified during phase I e Vision Document 2 0 e Project Plan 2 0 e Formal Requirements Specification e Architecture Design e Test Plan e Formal Technical Inspection e Executable Arch
49. s list MembersInfo aspx The web page displays the members personal information MembersRecord aspx The web page is used to edit and update members information OrdersGrid aspx The web page displays the orders list OrdersRecord aspx The web page is used to edit and update orders information AdminBooks aspx The web page displays the books list BookMaint aspx The web page is used to edit and update book information CategoriesGrid aspx The web page displays the members list CategoriesRecord aspx The web page is used to edit and update Categories information CardtypesGrid aspx The web page displays the members list CardtypesRecord aspx The web page is used to edit and update Credit Card information Logout aspx This web page is used for an Administrator to logout from the website The diagram below captures the page flow for Administrator in the Online Book Store System 24 create and share your own diagrams at gliffy com Oailitty Fig 3 Administrator Page Flow 25 4 Middle Tier The Middle Tier or Business Logic layer consists of eleven classes User Customer Adminstrator SessionManager Category BookSet Book BooksOrder Search Advanced Search and Shopping Cart Class Diagram SuserlD Int A ScategoryName String Adminstrator yetCategory 1 AiminiD Sting getUser a amp password String Gar
50. se C Log Errors Only Configure Graphs to Display v Data v Average v Median v Deviation v Throughput 110 ms a Wa EEO oe fh pan ie E eT E 2 fice wee Oms 4 i No of Samples 800 Latest Sample 47 Average 101 Deviation 35 Throughput 4598 582103851312 minute Median 94 Fig 3 57 5 Observations e Average response time is more for search page when compared to the Home page e Average response time is low for home page because it doesn t many database interactions e Average response time for Search page is more since it should wait for the results from the database 58 Section 9 User Manual User Manual When we run the Online Book Store Website first home page is displayed The home page will appear as below The user and Admin will have different rights g A A Bi http localhost 3062 vamsi bookstore Default aspx YY G pi sbrain gt commerce D FreeSportsdu O orkut i Dictionary 4 greatandhra E7 webmail Cricinfo Ei The Hindu K K State Online Watch Movies Online Sa Telugucinema AL http www whatslate dni Chowk To China Hin Book Store ate 8 n Shopping Cart S BookStore Search Welcome to Online Book What We re Reading Category All v Store lf you are a new user n i i A Sharp Combination me Register or else Login To get inside C hey Bos Microsoft s new OO Ay met Web Database Development More Search Options A x Advanced
51. search Step by Step igre e amp S Jim Buyens Recommended Titles n 8 39 99 lt F Development programming language use A Programming a Preview of C as a guide It Databases offers a preview of Visual i Studio NET and an overview of HIME amp Web design HBAs eaw the NET framework and Software MySOL amp PHP From Scratch demonstrates how C is integrated with ASP ADO N Wade Maxfield and COM in NET Weekly Specials Price applications You ll get 23 99 examples of C in action too Free Shipping on orders over 40 New amp Notable 1001 Web Site Construction htt For limited time only until next Sunday you can enjoy free shipping Simply order more then 40 worth of If you are a new user you can register using the register link or if you are already a user you can login to purchase book and pay using the checkout Any common user can use the search option in the home page to search for a book oh his choice by entering a Title of the book If he wants to search more precisely he can use the advanced search option on the home page The register page will appear as below 59 f x A L http ilocalhost 3062 vamsi bookstore Registration aspx i Q Google rain commerce gt FreeSports4u orkut eS Dictionary amp 4 greatandhra webmail Cricinfo QB The Hindu K K State Online ED watch Movies Online 94 Telugucinema Ok http www whatslate Ini Chowk To
52. ser name User enters different Display message that password in password Password and Confirm confirm field Password fields don t match User forgets to enter a Display message The particular required fields value in field is required User account created User enters all the details successfully USER INPUT ZNN User enters a wrong Display message Login username or Password is incorrect User enters a wrong Display message Login password or Password is incorrect User enters correct User logs username and password successfully USER INPUT PASS CRITERIA User selects a book and Book is added to the clicks add to cart button shopping cart Guest selects a book and User should create an clicks add to cart button account 46 Edit Cart TEST CASE USER INPUT Edit Cart User changes the Quantity Quantity and total cost of Cart should be updated Edit Cart User deletes a book from Books and total cost of shopping Cart Cart should be updated Edit Cart User selects a new book to Books and total cost of shopping Cart Cart should be updated 4 2 ADMIN Create and Delete a Book from Category 1D TEST CASE ADMIN INPUT PASS CRITERIA AD_CDB_1 Create and Delete a Admin adds a new book to Book should be Book from Category category updated in Categories list AD_CDB_2 Create and Delete a Admin deletes a book Book should be deleted Book from Category
53. tate Online EB watch Movies Online 94 Telugucinema LL http wwwe whatslal Wk To China Hin E Book Store B line 8 2 8 8 BookStore Home Registration Shopping Cart Sign In User Information Login vamsim First Name vamsi Last Name mummaneni Address 1214 vattier st apt 4 Email vamsim ksu edu Phone 972 313 5729 Order hem Price Quantity Total Details 19 Beginning ASP Databases 39 99 1 39 99 Total 39 99 Continue Shopping Checkout Home Registration Shopping Cart Sign In Administration The user can also edit his shopping cart details If he wants to change the quantity or cancel his order he can use this page When the user clicks the details link in the shopping cart page he will be redirected to the edit shopping cart page 64 a amp 4 http flocalhost 3062 vamsi bookstore ShoppingCartRecord aspx order_id 19 amp id Gl 1 x commerce x FreeSports4u O orkut S Dictionary 4 greatandhra E7 webmail Cricinfo 0 The Hindu K K State Online EB watch Movies Online Sd Telugucinema Z http www whatslate Chowk To China Hin A Book Store line e S ookStore Home Registration Shopping Cart Sign In ShoppingCart Item Beginning ASP Databases Quantity 1 Home Registration Shopping Cart Sign In Administration The above page shows the edit shopping cart page After proceeding to checkout the user should enter the billing details to process his order
54. traints and direction It gives a listing of the main requirements and their respective Use case models to illustrate the functionality Project Plan will detail the phases iterations and milestones that will comprise the project It will include a timeline for the project and a cost estimate for completing this project It includes the Architecture Elaboration plan will define the activities and actions that must be accomplished before the Architecture Presentation Software Quality Assurance Plan describes the required documentation standards and conventions test tracking and problem reporting and tools used during the project The plan will also identify the set of quality metrics used to assess product reliability Demonstration of at least one executable prototype is required Projects with a graphical user interface will include an executable prototype of the user interface This phase will be complete once the supervisory committee has approved all the above work 1 2 Elaboration Phase The elaboration phase defines the project s architecture This phase will include the production of revisions to the Project Plan and the Vision Document an Architecture Design Plan a formal specification Test Plan Formal Technical Inspection and Architecture Prototype Revision of Vision Document will be an updated version to provide a complete representation of all requirements These requirements will be ranked according to importance and a set
55. ts title or author later can add to the shopping cart and finally purchase using credit card transaction The user can login using his account details or new customers can set up an account very quickly They should give the details of their name contact number and shipping address The user can also give feedback to a book by giving ratings on a score of five The books are divided into many categories based on subject like Software Database English Architecture etc The Online Book Store Website provides customers with online shopping through a web browser A customer can create sign in to his account place items into a shopping cart and purchase using his credit card details The Administrator will have additional functionalities when compared to the common user He can add delete and update the book details book categories member information and also confirm a placed order This application is developed using C ASP NET programming language The Master page data sets data grids user controls are used to develop the Online Book store Table of Contents Section 1 Vision Document 1 Introduction 1 1 Purpose and Motivation 2 Project Overview 2 1 Background 3 Requirement Specifications 3 1 Main Requirements 3 2 Critical Use Case Requirements 3 3 Environment Section 2 Project Plan 1 Task Breakdown 1 1 Inception Phase 1 2 Elaboration Phase 1 3 Production Phase 2 Cost Estimate 2 1 COCOMO 3 Architecture
56. umber of months 16 The Effort Adjustment Factor is the product of the 15 adjustment parameters Each adjustment parameter is categorized as very low low nominal high or very high All the adjustment parameters are listed below RELY Required reliability 0 75 1 40 DATA Database size 0 94 1 16 CPLX Product complexity 0 70 1 65 TIME Execution time constraint 1 00 1 66 STOR Main storage constraint 1 00 1 56 VIRT Virtual machine volatility 0 87 1 30 TURN Computer turnaround time 0 87 1 15 ACAP Analyst capability 1 46 0 71 AEXP Applications experience 1 29 0 82 PCAP Programmer capability 1 42 0 70 VEXP Virtual machine experience 1 21 0 90 LEXP Language experience 1 14 0 95 MODP Use of modern practices 1 24 0 82 TOOL Use of software tools 1 24 0 83 SCED Required development schedule 1 23 1 10 Adjustment factors for the Online Book Store are listed below RELY 1 00 Nominal DATA 1 00 Nominal CPLX 0 85 Low TIME 1 00Nominal STOR 1 00 Nominal VIRT 0 87 Low TURN 0 87 Low ACAP 1 00 Nominal AEXP 1 13 Low PCAP 1 00 Nominal VEXP 1 00 Nominal LEXP 1 00 Nominal MODP 0 91 High TOOL 0 91 High SCED 1 00 Nominal The EAF value evaluated to 0 60 I have estimated the size to be around 3 00 From the calculation I got EFFORT 6 08 TIME 4 96 17 3 Architecture Elaboration Plan All the activities to be done before the Architecture Presentation are defined here 3 1 Vision
57. various Web forms used by clients are listed below ASP NET Web Forms Definition Default aspx This web page is used to browse the entire website and also displays different categories offers available Registration aspx This web page is used by a new user to register his personal information Login aspx This web page is used for a user to login and enter the website Logout aspx This web page is used for a user to logout from the website Books aspx This web page is used to search for books and displays books which matched the search criteria Advsearch aspx This web page is used to display an advanced search to find books BookDetail aspx This web page is used for displaying all the details of a book ShoppingCart aspx This web page is used to display the shopping cart and user information details ShoppingCartRecord aspx This web page is used to edit shopping cart 22 The diagram below captures the page flow for user in the Online Book Store System create and share your own diagrams at gliffy com Oeaiity Fig 2 User Page Flow 23 The various Web forms used by Administrator are listed below ASP NET Web Forms Definition Login aspx This web page is used for an Administrator to login and enter the website AdminMenu aspx The webpage displays the menu of the Administrator MembersGrid aspx The web page displays the member
58. w Shopping Cart Purpose If the user wants to view the items he added to the shopping cart then he can click the shopping cart link at the top of the page Actor User Input The user will click the shopping cart link at the top of every page Output The user s shopping cart summary will be displayed in the form of a tabular format with all the books and their quantity A total cost of all the items is also displayed at the bottom Administrator 1 Login Purpose If the Administrator wants to get access to all the functionalities of Online Book Store he should login using his username and password Actor Administrator Input The Administrator will enter his username and password 12 Output If it is a successful login the Administrator will be directed to his menu page Else if the Administrator enters invalid information he will be asked to check the entered information 2 Add or Delete Category Purpose If the Administrator wants to add or delete a book category then he can insert or delete a book category using his administration rights and the category table will be updated in the database Actor Administrator Input If the Administrator wants to add a book category the he should click the insert link button in the category page else he can delete a particular selected book category Output The updated categories list will be displayed in the main home page 3 Add or Delete Book Purpose If the Administrator
59. wants to add or delete a book then he can insert or delete a book using his administration rights and the book table will be updated in the database Actor Administrator Input If the Administrator wants to add a book the he should click the insert link button in the book page and fill the following fields related to the book 1 Title 2 Author 3 Price 4 Category 5 Notes 6 Product url If he wants to delete a book he can click the delete button to remove it from the database Output The updated books list will be displayed in the main home page under their particular category 4 Manage Orders Purpose If the Administrator wants to add or delete an order then he can insert or delete an order using his administration rights Actor Administrator Input If the Administrator wants to add an order the he should click the insert link button in the orders page else he can delete a particular selected order Output The updated orders list will be processed to the users 13 5 Add or Delete CC Credit Card Purpose If the Administrator wants to add or delete a CC type then he can insert or delete a CC type using his administration rights and the CC table will be updated in the database Actor Administrator Input If the Administrator wants to add a CC type the he should click the insert link button in the CC page else he can delete a particular selected CC type Output The updated CC list will be displayed in regist
Download Pdf Manuals
Related Search