Download Online book store online book store report is a paragraph of the body has get fired,I m bi and more Summaries Project Management in PDF only on Docsity!

Project Report

On

“Online Book Store Management System”

Submitted for the partial fulfillment of the

requirements of the BCA 6

th

semester

Submitted By Under the Guidance of

TABLE OF CONTENTS

CHAPTER 1: INTRODUCTION 1.1 Background 1.2 Objective 1.3 Purpose, Scope and Applicability 1.3.1 Purpose 1.3.2 Scope 1.4 Achievements 1.5 Organization of Report CHAPTER 2: SERVEY OF TECHNOLOGY CHAPTER 3: REQUIREMENTS AND ANALYSIS 3.1 Problem Definition 3.2 Requirement Specification 3.3 Software and Hardware Requirements 3.3.1 Hardware Requirements 3.3.2 Software Requirements 3.4 Preliminary Product Description 3.5 Conceptual Models 3.6.1 Module Specifications 3.6.2 Screen Views 3.6.3 Data Flow Diagrams CHAPTER 4: SYSTEM DESIGN 4.1 Basic Modules 4.2 Data Design 4.2.1 Schema Design 4.2.2 Data Integrity and Constraints 4.3 Procedural Design 4.3.1 Logic Diagrams

Introduction:

Online shopping is the process whereby consumers directly buy goods, services etc. from a seller interactively in real-time without an intermediary service over the internet. Online shopping is the process of buying goods and services from merchants who sell on the Internet. Since the emergence of the World Wide Web, merchants have sought to sell their books to people who surf the Internet. Shoppers can visit web stores from the comfort of their homes and shop as they sit in front of the computer. Consumers buy a variety of items from online stores. In fact, people can purchase just about anything from companies that provide their books online. Books, clothing, household appliances, toys, hardware, software, and health insurance are just some of the hundreds of books consumers can buy from an online store. Many people choose to conduct shopping online because of the convenience. For example, when a person shops at a brick-and-mortar store, she has to drive to the store, find a parking place, and walk throughout the store until she locates the books she needs. After finding the items she wants to purchase, she may often need to stand in long lines at the cash register.

1.1 Background

Online shopping allows you to browse through endless possibilities, and even offers merchandise that's unavailable in stores. If you're searching for a niche product that may not be distributed locally, you're sure to find what you're looking for on the internet. What's even more useful is the ability to compare items, similar or not, online. You can search through multiple stores at the same time, comparing material quality, sizes and pricing simultaneously. Say 'goodbye' to the days when you stood in line waiting, and waiting, and waiting some more for a store clerk to finally check out your items. Online shopping transactions occur instantly-saving you time to get your other errands done! Additionally, unlike a store, online shopping has friendly customer service representatives available 24 hours a day, 7 days a week

to assist you with locating, purchasing and shipping your merchandise.

1.2Objective

My objective is to design such an application using which one can say 'goodbye' to the days when you stood in line waiting, and waiting some more for a store clerk to finally

check out your items. Online shopping transactions occur instantly-saving you time to get your other errands done! Additionally, unlike a store, online shopping has friendly customer service representatives available 24 hours a day, 7 days a week to assist you with locating, purchasing and shipping your merchandise. My main aim is to design such a book store where customer can visit our site anytime of the day from anywhere to view the available books, choose any of them and can order by paying online or can opt for cash on delivery as well. The administrator will regularly add any new books available to them for sale. The administrator will take books from the reputed publishers and vendors only. 1.3 Purpose and Scope 1.3.1 Purpose Online Shopping system would have the following goals.  Provide a web user interface to add, view, delete records in different areas.  Provide a user interface to enter computer details.  Provide a user interface to change details of all the computers and accessories.  Provide a user interface for users to explore the store and choose items to buy. 1.3.2 Scope The main scope and deliverables of the project would be to:  Understand and prepare detailed requirement and specifications  Prepare high level and detailed design specifications of the system  Prepare Test Plan and Test cases  Develop the system and coding  Perform unit testing, integration and system testing  Demonstrate a bug free application after suitable modification if needed. 1.4 Achievements  By successfully implementing the project, a substantial knowledge has been acquired on the implementation of a database system using .net technologies.

2. SURVEY OF TECHNOLOGY

In a desktop application like Laboratory Management System, there is a scope for a large number of platforms, languages and frameworks to choose from. Before selecting from this large array of technologies, the following aspects, which are characteristic to windows based application like this one, have been kept in mind:  Data validation  Performance  Reliability  Scalability  Security  Portability  Performance  Time constraint  Cost constraint The various technologies available for consideration are as follows: Operating System: Windows 7 Client Side Scripting:  HTML  CSS  JavaScript Server Side Scripting: PHP Database Tool: My SQL Testing Server: Apache Other Software Used:  Adobe Dreamweaver  Adobe Photoshop

 Wamp Server

HTML

HTML or HyperText Markup Language is the standard markup language used to create web pages. HTML is written in the form of HTML elements consisting of tags enclosed in angle brackets (like ). HTML tags most commonly come in pairs like

and

, although some tags represent empty elements and so are unpaired, for example . The first tag in a pair is the start tag , and the second tag is the end tag (they are also called opening tags and closing tags ). The purpose of a web browser is to read HTML documents and compose them into visible or audible web pages. The browser does not display the HTML tags, but uses the tags to interpret the content of the page. HTML describes the structure of a website semantically along with cues for presentation, making it a markup language rather than a programming language. HTML elements form the building blocks of all websites. HTML allows images and objects to be embedded and can be used to create interactive forms. It provides a means to create structured documents by denoting structural semantics for text such as headings, paragraphs, lists, links, quotes and other items. It can embed scripts written in languages such as JavaScript which affect the behavior of HTML web pages.

CSS

CSS was first developed in 1997, as a way for Web developers to define the look and feel of their Web pages. It was intended to allow developers to separate content from design so that HTML could perform more of the function that it was originally based on the markup of content, without worry about the design and layout. CSS didn't gain in popularity until around 2000, when Web browsers began using more than the basic font and color aspects of CSS. Web Designers that don't use CSS for their design and development of Web sites are rapidly becoming a thing of the past. And it is arguably as important to understand CSS as it is to know HTML - and some would say it was more important to know CSS.

 MySQL is a database management system. A database is a structured collection of data. It may be anything from a simple shopping list to a picture gallery or the vast amounts of information in a corporate network. To add, access, and process data stored in a computer database, you need a database management system such as MySQL Server. Since computers are very good at handling large amounts of data, database management systems play a central role in computing, as standalone utilities, or as parts of other applications.  MySQL databases are relational. A relational database stores data in separate tables rather than putting all the data in one big storeroom. The database structures are organized into physical files optimized for speed. The logical model, with objects such as databases, tables, views, rows, and columns, offers a flexible programming environment. You set up rules governing the relationships between different data fields, such as one-to- one, one-to-many, unique, required or optional, and “pointers” between different tables. The database enforces these rules, so that with a well-designed database, your application never sees inconsistent, duplicate, orphan, out-of-date, or missing data. The SQL part of “MySQL” stands for “Structured Query Language”. SQL is the most common standardized language used to access databases. Depending on your programming environment, you might enter SQL directly (for example, to generate reports), embed SQL statements into code written in another language, or use a language-specific API that hides the SQL syntax. SQL is defined by the ANSI/ISO SQL Standard. The SQL standard has been evolving since 1986 and several versions exist. In this manual, “SQL-92” refers to the standard released in 1992, “SQL:1999” refers to the standard released in 1999, and “SQL:2003” refers to the current version of the standard. We use the phrase “the SQL standard” to mean the current version of the SQL Standard at any time.

 MySQL software is Open Source. Open Source means that it is possible for anyone to use and modify the software. Anybody can download the MySQL software from the Internet and use it without paying anything. If you wish, you may study the source code and change it to suit your needs. The MySQL software uses the GPL (GNU General Public License), http://www.fsf.org/licenses/, to define what you may and may not do with the software in different situations. If you feel uncomfortable with the GPL or need to embed MySQL code into a commercial application, you can buy a commercially licensed version from us. See the MySQL Licensing Overview for more information (http://www.mysql.com/company/legal/licensing/).

User Class and Characteristics:

 General public  Customers  Administrator  General public can use the system to see the books, their prices and quantity available.  Non registered user cannot buy the books.  Customers are using for viewing and buying the books.  Customer can also write feedbacks for books and services  Administrators can add, edit & delete books and provide services to the customer.  Administrator can see the daily sell. Can also see the feedback given by the customer.  Administrator maintaining the deliveries.

Functional Requirements:

 The System must provide following functionalities—  Keeping records of registration of customers.  Keeping the records of books.  Keeping the daily sell.  Storing the feedback given by the customer.  Keeping details about the product it is delivered or not. etc.  Storing the items selected by the customer in the temporary storage.

Non Functional Requirements:

Following Non-functional requirements will be there in the online shopping portal.  Secure access of confidential data (customer’s details).  24 X 7 availability.  Better component design to get better performance at peak time. Flexible service based architecture will be highly desirable for future extension Non functional requirements define system properties and constraints It arise through user

needs, because of budget constraints or organizational policies, or due to the external factors such as safety regulations, privacy registration and so on. Various other Non-functional requirements are:

1. Security
2. Reliability
3. Maintainability
4. Portability
5. Extensibility
6. Reusability
7. Application Affinity/Compatibility
8. Resource Utilization

External Interface Requirements:

User Interface:

User of the system will be provided with the Graphical user interface, there is no command line interface for any functions of the product. Hardware Interface : Hardware requirements for running this project are as follows: Processor: - Pentium I or above. RAM: - 128 MB or above. HD: - 20 GB or above.

Software Interface :-

Software required to make working of product is:- Front end- HTML/PHP Back end- My SQL

DataFlows DFDs show the flow of data from external entities into the system, showed how the data moved from one process to another, as well as its logical storage. There are only four symbols:  Squares representing external entities , which are sources or destinations of data.  Rounded rectangles representing processes , which take data as input, do something to it, and output it.  Arrows representing the data flows , which can either, be electronic data or physical items.  Open-ended rectangles representing data stores , including electronic stores such as databases or XML files and physical stores such as or filing cabinets or stacks of paper. There are several common modeling rules for creating DFDs:  All processes must have at least one data flow in and one data flow out.  All processes should modify the incoming data, producing new forms of outgoing data.  Each data store must be involved with at least one data flow.  Each external entity must be involved with at least one data flow.  A data flow must be attached to at least one process. DFDs are nothing more than a network of related system functions and indicate from where information is received and to where it is sent. It is the starting point in the system that decomposes the requirement specifications down to the lowest level detail. The four symbols in DFD, each of which has its meaning. They are given below:  External entities are outside to system but they either supply input data in the system or use the system output. These are represented by square of rectangle. External entities that supply data into a system are sometimes called Sources. External entities that use system data are sometimes called sinks.

 Dataflow models that passages of data in the system and are represented by line by joining system components. An arrow indicates the direction of the flow and the line is labeled by the name of the dataflow.  Process show that the systems do. Each process has one or more data inputs and one or data outputs. Circles in DFD represent them. Each high level process may be consisting of more than one lower level processes. Process will be expanded in sequent level DFD. A circle or a bubble represents a process that transforms incoming data flow into outgoing dataflow. The high level processes in a system are:  Receivable process.  Verifiable process.  Disposal process.  File or data store is a repository of data. They contain data that is retained in the system. Process can enter data into data store or retrieved data from the data store. An open rectangle is a data store, data at rest.

Enter data View Profile Edit data User Details User Register Registration Process

status Profile Update

User (^) Updates DFD For User Registration and Profile Update

order Details Confirmation & receipt confirms Cart Details Place Order Selected Product Book info Login User Select Product

Add to Cart

Checkout

Order Book Cart User

DFD for shopping and checkout process