Docsity
Log inSign up
Docsity
Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity

Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips
Guidelines and tips
Sell on Docsity
Sell on Docsity
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search Store documents

The best documents sold by students who completed their studies

Search through all study resources
Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

University Rankings

Discover the best universities in your country according to Docsity users

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

From our blog

Exams and Study
Go to the blog

online book store using amazon web servic, Summaries of Computer Science

AMET UniversityComputer Science

it contains the document and Its basic table,structure,diagram and syntax have been there

Typology: Summaries

2022/2023

Uploaded on 01/04/2023

Mathivanans
Mathivanans 🇮🇳

3 documents

1 / 76

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
1
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.
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe
pff
pf12
pf13
pf14
pf15
pf16
pf17
pf18
pf19
pf1a
pf1b
pf1c
pf1d
pf1e
pf1f
pf20
pf21
pf22
pf23
pf24
pf25
pf26
pf27
pf28
pf29
pf2a
pf2b
pf2c
pf2d
pf2e
pf2f
pf30
pf31
pf32
pf33
pf34
pf35
pf36
pf37
pf38
pf39
pf3a
pf3b
pf3c
pf3d
pf3e
pf3f
pf40
pf41
pf42
pf43
pf44
pf45
pf46
pf47
pf48
pf49
pf4a
pf4b
pf4c

Partial preview of the text

Download online book store using amazon web servic and more Summaries Computer Science in PDF only on Docsity!

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.

Table of Contents

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

  • Interest to develop a good user friendly website with many online transactions using a database.
  • To increase my knowledge horizon in technologies like .NET, SQL, CSS, HTML.
  • To gain good experience in .NET before joining in a full time job.
  • 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 application 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 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.

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 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. ***** Excellent **** Very Good *** Good ** Regular
    • Deficient

Maintain Account

1) Register

  • 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
  1. Username
  2. Password
  3. confirm password
  4. first name
  5. last name
  6. email
  7. Address
  8. Phone
  9. 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 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
  • 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 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.

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 registration 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.

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 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. Time = 2.5 * (Effort) ^ 0. 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 number of months.

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.
  • DATA Database size 0.94 – 1.
  • CPLX Product complexity 0.70 – 1.
  • TIME Execution time constraint 1.00 – 1.
  • STOR Main storage constraint 1.00 – 1.
  • VIRT Virtual machine volatility 0.87 – 1.
  • TURN Computer turnaround time 0.87 – 1.
  • ACAP Analyst capability 1.46 – 0.
  • AEXP Applications experience 1.29 – 0.
  • PCAP Programmer capability 1.42 – 0.
  • VEXP Virtual machine experience 1.21 – 0.
  • LEXP Language experience 1.14 – 0.
  • MODP Use of modern practices 1.24 – 0.
  • TOOL Use of software tools 1.24 – 0.
  • SCED Required development schedule 1.23 – 1.

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. TIME = 4.

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.

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

  • Presentation tier - ASP.NET Web forms, Master Pages, Images.
  • Middle tier – C# classes.
  • Data tier- Database Fig.1 below shows the model of 3-tier architecture.

The main reason for considering three-tier architecture for the Online Book store is as follows:

Flexibility:

  • Management of data is independent from the physical storage support,
  • Maintenance of the business logic is easier,
  • Migration to new graphical environments is faster.
  • 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:

  • 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.