INTRODUCTION

INTRODUCTION

1
1.1 GENERAL INTRODUCTION

Computer is an electronic device that accepts digital information and processes

it in a predefined function. According to a set or sequence of instructions
provided to it and produces the desired binary outputs .It is made up of input
devices, storage, arithmetic and logic circuits and a control unit.

We are living in an information age dependent upon digital

information. Digital information is electronic information, the result of computer
processing. Every type of job relies upon getting information, using it, managing
it, and relaying information to others. Computer enables the efficient processing and
storage of information.

Computers work through an interaction of hardware and software.

Hardware refers to part of a computer that you can see and touch, including the case
and everything inside it. The ability to analyze business problems and to manage the
development of a complex computer based system in an environment where
information resources are proliferating are the challenges that accompany the
opportunities of the future.

The main advantages of computer over manual processing are:

 Accuracy

 Storage

 Speed of Response

 Data Collection And Communication

 Versatility

 Diligence

Shoppers and traders are quickly changing the mode of operation from the
present way. The shopping can be done in a pretty fast and easier manner than the usual
operation.

2
 The system is fully menu driven. This application program is efficient,
user-friendly, and error free provides a suitable and creative implementation of the
system.

1.2 SOFTWARE INTRODUCTION

Online furniture shopping system is a site that handles furnitures and their
corresponding details about purchase, sales etc. It makes the job of the staffs easy and
efficient. A particular furniture can be easily searched by specifying a gender
through Furniture shop.This project includes modules namely purchasing and sales
management. This project also displays details of customer, supplier, date of
purchase, purchasing quantity etc.

3
1.3 SYNOPSIS

Online Furniture Shopping is a purchasing site which is easily

accessible and convenient for all people even with little
computer knowledge. This site will be implemented on a Furniture
Store and they will manage this software. This site will be managed
by an admin who has unlimited access and rights to modify, edit, insert
or delete the values of fields. A user can access the site in a limited yet
elegant way. He can view the list and categories of Furniture’s of their
interest.
The site will have a database connection and the admin can only access
this .The admin also uses a login id and password. A new user can create his
profile at a link given in the login page. The admin monitors the site from
the same another login page. The admin will be directed to his page where
he can view the stock details and other fields. He can modify, add, edit or
delete fields or values accordingly.
This online site will be an advantage to Furniture’s Store because by
implementing this they can increase their selling apart from regular
customers visiting the shop.
SOFTWARE SPECIFICATION
Web Technologies : HTML

Language : PHP

Database : MySQL Server

Web Server : XAMPP

Operating System : WINDOWS 7

4
SYSTEM STUDY

5
2 SYSTEM STUDY

2.1 SYSTEM STUDY

System study is in detailed analysis of various operations and their relationship

within and outside the system.lt is the first step in developing and managing systems.

Fact Finding Techniques:

The specific methods analysts use for collecting data about

requirements are called fact-finding techniques. These include the interview,
questionnaire, record inspection and observation.

Record Review:

Many kinds of records and reports can provide analysis with valuable
information about organizations and operations. In record reviews, analysts
examine information that has been recorded about the system and users. Records
include written policy manuals, regulations and standard operating procedures used
by most organization as a guide for managers and employees.

Observation:

Observation allows analysts to gain information they can’t obtain by any other
fact-finding method. Through observation, analysts can obtain firsthand information
about how activities are carried out. This method is most useful when analysts need
to actually observe. How documents are handled, how processes are carried out and
whether specified steps actually followed.
Interview:
Analysts use interviews to collect information from individuals or from
groups .The respondents are generally current users of the existing system or
potential users of the proposed system. In some instances, the respondents may
be managers or employees who provide data for the proposed system or who will
be affected by it.

It is important to remember that respondents and analysts converse during an

interview, the respondents and analysts with opportunities for gathering

6
information from respondents who have been chosen for their knowledge of the
system under study. This method is frequently the best source of study.

2.2 EXISTING SYSTEM

The existing system is fully manual. The details about furniture’s name,
price, quantity etc are stored by recording them in different files. Thus delays
are inevitable. Manual processing may also lead to human error. Updating
document details also requires a lot of time and effort, which could lead to errors
or omissions.

DISADVANTAGES OF EXISTING SYSTEM

o Difficult to handle the large information.

o Cost consumption is high.

o It is highly time consuming.

o It gives greater workload to each staff.

o The system is manual one so error occurs may be high

o It is very difficult to maintain and up-date information

o There may be chances for losing the records.

o Accuracy is missing.

2.3 PROPOSED SYSTEM

Due to the above mentioned disadvantages in the existing system it has been proposed
for new system, which will overcome these difficulties. So the new system is developed
with the help of PHP and SQL Server .Even though the end user of the system are well
qualified, various help message are to be given both quick references and in help file.

ADVANTAGES

o High speed and accuracy.

o Provide high security.

7
o Good user interface.

o Easy edit, delete and search functionality.

o Listing of items.

Objective of the proposed system

The objective of the project is to convert the existing system into

modules such as furniture details and sales management .It simplifies the whole
operation and makes searching and editing faster. It reduces the workload on
employees. The system is portable and flexible for further enhancement and it
provides a user-friendly environment.

8
SYSTEM ANALYSIS

9
 3.SYSTEM ANALYSIS
INTRODUCTION

The first step in developing the system is analyzing the problem. Before
developing a system the problem should be well defined. Identifying the need for
a new information system and launching an investigation and a feasible study must
be done to check whether the software is visible for the organization. This unit we have
done this study.

Lack of security is another problem of the existing system. That may lead to serious
problems. It will affect the business career. In the existing system, there is no facility for the
user to see the view his past purchases. The existing system is not reliable because of human
errors. Calculations and maintenance needs a lot of time that produce queuing.

Because of these reasons the existing system needs a change, for the easy and smooth
running of the system.

3.1 Feasibility Study

All projects are feasible given unlimited and resource and infinite time.
Unfortunately, the development of computer-based system is more likely to be plagued
by scarcity of resources and difficult delivery dates. The main objective of feasible
study is to test the technical, social and economical feasibility of developing a
computer system. This is done by investigating the existing system in the area
under investigation or generally ideas about a new system. The proposed system was
evaluated from a technical view point first. Being technically feasible, its impact on the
organization was assessed. After the proposed system was found to be social and technically
acceptable, it was tested for economic feasibility.

Technical Feasibility

10
 There are a number of technical issues, which are generally raised during the
feasibility stage of the investigation. A study of function, performance and constraints
that may affect the ability to achieve an acceptable system. The considerations that
are normally associated technical feasibility include.

 Development Risk

 Resource Availability

 Technology.

Economic Feasibility

Economic feasibility is an important task of system analysis. A system that be developed

and that will be used if installed must still be profitable for the organization. Financial
benefits must equal or exceed the costs. The analysis raises financial and economic
questions during the preliminary investigation to estimate the following.

1. The cost to conduct a full system investigation.

2. The cost of hardware and software for the class of application of the project being
considered.

3. The benefits in the form of reduced costs or fewer costly errors.

4. The cost if nothing changes.

To be judged feasible, a proposal for the specific project must pens these tests;
otherwise it is not considered as a feasible project.

Behavioral Feasibility

It centers on the reaction of the users, since the system is not so complicated it
is easily understandable by anyone. User training is also very easy. The user also does
not need to have any concept of the software used for developing the system.

Operational Feasibility

Proposed projects are beneficial only if they can be turned into information
systems that will the operating requirements of the organization. This test of
11
feasibility asks if the system will work when it is developed and installed. ONLINE
FURNITURE SHOPPING SYSTEM satisfies all the operational conditions.

The system does not require enormous amount of money to be developed.

This can be done economically if planned judicially, so it is economically feasible.
The cost of project depends upon the number of man hours required. It is mainly
related to human organizations and political aspects

3.2 SYSTEM REQUIREMENTS

The first step in selection understands user’s requirements within the framework of
the organization’s objectives and the environment in which the system being installed.

Consideration is given to user’s recourses and as well as to finances. In selecting

software, the user must decide whether to develop it in house hire a service company or
contract programmer to create it. The choice is logically made after the user has clearly
defined the requirements expected of the software.

Hardware Requirements

Processor : Dual Core or higher

RAM : 1 GB or more

Hard Disk : 250 GB or more Monitor :

VGA/SVGA Keyboard :104 keys

Software Requirement

Operating System : Windows 7 or higher

Front-end : Hypertext Preprocessor
Back-end : MySQL Server

3.3 INTRODUCTION TO FRONTEND AND BACKEND

1.PHP: HYPERTEXT PREPROCESSOR

12
PHP is a server-side scripting language designed for web development but also used as a

general purposed programming language. As of January 2013, PHP was installed on more

than 240 million websites (39% of those sampled) and 2.1 million web servers. Originally

created by Rasmus Lerdorf in 1994, the reference implementation of PHP is now produced

by The PHP Group. While PHP originally stood for Personal Home Page, it now stands for

PHP: Hypertext Pre-processor, a recursive acronym.

PHP code can be simply mixed with HTML code, or it can be used in combination

with various templating engines and web frameworks. PHP code is usually processed by a

PHP interpreter, which is usually implemented as a web server's native module or a

Common Gateway Interface (CGI) executable. After the PHP code is interpreted and

executed, the web server sends resulting output to its client, usually in form of a part of the

generated web page – for example, PHP code can generate a web page's HTML code, an

image, or some other data. PHP has also evolved to include a command-line interface (CLI)

capability and can be used in standalone graphical applications.

PHP is free software released under the PHP License. PHP has been widely ported and can

be deployed on most web servers on almost every operating system and platform, free of

charge.

2. MySQL

MySQL is the world's most popular open source database software, with over 100
million copies of its software downloaded or distributed throughout its history. With its
superior speed, reliability, and ease of use, MySQL has become the preferred choice for
Web, Web 2.0, SaaS, ISV, Telecom companies and forward-thinking corporate IT Managers
because it eliminates the major problems associated with downtime, maintenance and
administration for modern, online applications.

13
Many of the world's largest and fastest-growing organizations use MySQL to save time and
money powering their high-volume Web sites, critical business systems, and packaged
software — including industry leaders
such as Yahoo!, Alcatel-Lucent, Google, Nokia, YouTube, Wikipedia, and Booking.com.

MySQL was originally founded and developed in Sweden by two Swedes and a
Finn: David Axmark, Allan Larsson and Michael "Monty" Widenius, who had worked
together since the 1980's. MySQL, the most popular Open Source SQL database
management system, is developed, distributed, and supported by Oracle Corporation.
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.

14
 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 Database Server is very fast, reliable, scalable, and easy to use. If that is
what you are looking for, you should give it a try. MySQL Server can run comfortably on a
desktop or laptop, alongside your other applications, web servers, and so on, requiring little
or no attention. If you dedicate an entire machine to MySQL, you can adjust the settings to
take advantage of all the memory, CPU power, and I/O capacity available.

MySQL can also scale up to clusters of machines, networked together. MySQL Server
was originally developed to handle large databases much faster than existing solutions and
has been successfully used in highly demanding production environments for several years.
Although under constant development, MySQL Server today offers a rich and useful set of
functions. Its connectivity, speed, and security make MySQL Server highly suited for
accessing databases on the Internet. MySQL Server works in client/server or embedded
systems.
3. Wamp Server
WampServer is a Windows web development environment. It allows you to create
web applications with Apache2, PHP and a MySQL database. Alongside, PhpMyAdmin
allows you to manage easily your databases. WampServer refers to a software stack for the
Microsoft Windows operating system, created by Romain Bourdon and consisting of the
Apache web server, Open SSL for SSL support, MySQL database and PHP programming
language. WampServer is a Web development platform on Windows that allows you to
create dynamic Web applications with Apache2, PHP and MySQL. WampServer
automatically installs everything you need to intuitively develop Web applications. You will
be able to tune your server without even touching its setting files. Best of all, WampServer is
available for free (under GPML license) in both 32 and 64 bit versions. Wampserver is not
compatible with Windows XP, SP3, or Windows Server 2003.
SQL CONSTRAINTS
You can place constraints to limit the type of data that can go into a table. Such
constraints can be specified when the table when the table is first created via the

15
CREATE TABLE statement, or after the table is already created via the ALTER
TABLE statement.
Common types of constraints include the following:
 NOT NULL Constraint: Ensures that a column cannot have NULLvalue.
 DEFAULT Constraint: Provides a default value for a column when none is specified.
 UNIQUE Constraint: Ensures that all values in a column are different.
 CHECK Constraint: Makes sure that all values in a column satisfy certain criteria.
 Primary Key Constraint: Used to uniquely identify a row in the table.

 Foreign Key Constraint: Used to ensure referential integrity of the data.

SYSTEM DESIGN

16
4. SYSTEM DESIGN

System design involves the detailed design of the system selected in the system study
phase.

4.1 Input Design

Input design is the process of converting user-oriented inputs to computer-based

format. The input to the system can be defined as the information that is provided to
the system that is used for processing by the system to obtain meaningful information, which
helps in decision-making. Input design is the most expensive phase of the project and
may cause some major problems if not designed with care. The quality of system is
determined from the quality of system outputs which in turn is determined from input.

Input design features can ensure the reliability of the system and also determines how
efficiently the user can interact with the system. A good input screen is clear and free from
irrelevant information. Entered data has to be checked for their accuracy and detection of
errors. All the data entry screens should be of interactive nature that user can directly
input data according to prompt messages. The input design determines whether the
user can interact directly with the computer.

17
 All the input screens used here have script validations for null checking and
data types whereas required. All the programs inserting data to the table checks the length
of the values in addition to the data type verification. They also prompt the entry of
values in mandatory fields. The goal of designing input data is to make it free from
logical errors. The input data is also used for easy calculation of necessary functions.
Different forms are used for data screens in order to input data into the system. The screen
formats have options like add, delete, edit and update with buttons, which is used for
easy input and retrieving information. All the fields are validated. If the user enters
invalid data, appropriate messages are displayed.

Input specifications describe the manner in which data enter the system for
processing. The design of the input should have:

 Effectiveness Accuracy Ease to use Consistency Simplicity

 Attractiveness

4.2 Output Design

One of the most important features of the system for users is the output it
produces. Output design should improve the system relationship with the user it produces
and helps in decision making. Considering the future use of the output required and
depending on the nature, they are displayed on the monitor for immediate need or
obtaining the hardcopy.

The objective of output design is to define the control and formats of all printed,

documented, reports and screens that will be produced by the

system. Computer output is the most important and direct source of information to the
user. For many end users output is the main reason for developing the system and the
basis on which they will evaluate the usefulness of the application. Output generally
refers to the results that are generated by the system. The output of the system is
designed so as to include a number of reports. Reports reflect the output design.

18
 Objective of output design are design output to serve the intended purpose,
design output to fit the user, deliver the appropriate quantity of output, assures that
output is where it is needed, provide output on time, choose the right output method.

The CRT displays can include a title, column heading, detailed data totals; they must
be described in detailed for programmers. In the case of CRT displays layout design the area
is limited by the size of the screen as the amount of data that can displayed in the record.

The report contains: Purchase details Sales details Payment details

4.3 Database Design

A database is a collection of interrelated data stored with minimum redundancy to

serve many users quickly and effectively. The objective of the database is to make
information access easy, quick, inexpensive and
flexible for the user.

The most important aspect of building an application is the design of tables or the
database scheme. The data stored in the tables must be organized in some manner,
which is meaningful. The overall objective in the process of table design has been to
treat data as an organizational resource and as an integrated whole. The organization of
data in a database aims to achieve three major objectives, which are given below.

Data Integration Data Abstraction Data Independence

Several degree of normalization have to be applied during the process of table

design. The major aim of the process normalization is to reduce data redundancy and
prevent losing data integrity. Redundancy refers to unwanted and unnecessary repetition
of data. Data integrity has to be converted at all levels. Poor normalization can access
problem related to storage and retrieval of data. During the process of
normalization, dependencies can be identified which cause serious problem during
deletion and updating. Normalizing also helps in simplifying the structure of tables.

The theme behind a database is to handle information as an integrated

whole thus making access to information easy, quick, inexpensive and flexible for
users. The entire package depends on how the data are maintained in the system. Each
table has been designed with a perfect vision.

19
NORMALIZATION

Normalization is the process of efficiently organizing data in a database. There

are two goals of the normalization process: eliminating redundant data (for example,
storing the same data in more than one table) and ensuring data dependencies make sense
(only storing related data in a table). Both of these are worthy goals as they reduce the
amount of space a database consumes and ensure that data is logically stored.

Benefits:

1. Eliminate data redundancy

2. Improve performance

3. Query optimization

4. Faster update due to less number of columns in one table

5. Index improvement

The Normal Forms

The database community has developed a series of guidelines for ensuring that
databases are normalized. These are referred to as normal forms and are numbered
from one (the lowest form of normalization, referred to as first normal form or 1NF)
through five (fifth normal form or
5NF). In practical applications, you'll often see 1NF, 2NF, and 3NF along
with the occasional 4NF.

First normal form (1NF) sets the very basic rules for an organized database:

 Eliminate duplicative columns from the same table.

 Create separate tables for each group of related data and identify each row with
a unique column or set of columns (the primary key).

Second normal form (2NF) further addresses the concept of removing duplicative data:

 Meet all the requirements of the first normal form.

20
  Remove subsets of data that apply to multiple rows of a table and place them in
separate tables.

 Create relationships between these new tables and their predecessors through the use
of foreign keys.

Third normal form (3NF) goes one large step further:

 Meet all the requirements of the second normal form.

 Remove columns that are not dependent upon the primary key.

The Boyce-Codd Normal Form also referred to as the "third and half
(3.5) normal form", adds one more requirement:

 Meet all the requirements of the third normal form.

 Every determinant must be a candidate key. Fourth Normal Form (4NF)

Finally, fourth normal form (4NF) has one additional requirement:

 Meet all the requirements of the third normal form.

 A relation is in 4NF if it has no multi-valued dependencies.

Remember, these normalization guidelines are cumulative. For a database to be

in 2NF, it must first fulfill all the criteria of a 1NF database.

RULES OF NORMALIZATION

Rule 1: There should be a one-to-one relationship between the instances of an entity and
the rows of the table

Rule 2: A field should have the same meaning in each row of the table. Rule 3: Each

table should represent at most one entity.

Rule 4: Multiple instances of an entity should be represented by multiple rows in a

table.

Rule 5: Joins should be based only on primary and foreign-key equality.

21
4.3 Data Flow Diagram

A data flow diagram is a network that describes the flow of data throughout
a system, data stores, and the processes that change, or transform, data flows. The DFD
network is a formal, logical abstract of a system that may have many possible physical
configurations.

A graphical representation is used to describe and analyze the movement of

data through a system manual or automated including the processes, storing of data
and delays in system. Data flow diagrams are central tool and the basis from which other
components are developed.

The transformation of data, from input to output through process may be

described logically and independently of the physical components associated with the
system. They are termed logical data flow diagrams, showing the actual
implementation and the movement of data between people, departments and
workstations. DFD is one of the most important modeling tools used in system design. DFD
shows the flow of data through different process in system.

The purpose of the design is to create architecture for the evolving implementation
and established common tactical policies that must be used by desperate elements of the
system. We begin the system process as soon as we have some reasonably completed
model of the behavior of the system. It is important to avoid premature designs,
where in develop designs before analysis reaches closer. It is important to avoid
delayed designing where in the organization crashes while trying to complete and
unachievable a in the organization crashes while trying to complete and unachievable
analysis model.

Throughout my project, the context flow diagram, and flowcharts have been
extensively used to achieve the successful design of the system.

DFD are made up of a number of symbols, which represents system components.

Data flow modeling methods uses 4 kinds of symbols, which are used to represent four kinds
of system components. These are

Process

22
 Process shows in the work of the system. Each process has one or more data inputs
and produces one or more data outputs. Process are represented by rounded rectangles in
DFD. Each process has unique name and number appears inside the rectangle that
represents the process in a data flow diagram.

Data Store

A data store is a repository of data. Processes can enter data into a store or retrieve the
data from data store. Each data has a unique name.

Data flows

Data flows show the passage of data in the system and are represented
by lines joining system components. An arrow indicates the direction of flow and the
line is labeled by name of the data flow.

External Entity

External entities are outside the system but they either supply input data into the

system or use other system output. They are entities on which the designer has control. They

may be an organization customer or other with which the system interacts. It supply data

into the system called source. External entities that use the system data are sometimes
called sinks. These are represented by rectangles in DFD.

The basic data flow symbols are :

Rectangle : represents a data source or destination.

Arrow : represents a flow of data, that is, a data stream.

Circle : represents a process that transforms incoming data into

23
outgoing data.

Open rectangle : represents a data store.

Four steps are commonly used to construct a DFD.

1. Process should be named and numbered for easy reference. Each name should be
representative of the process.
2. The direction of flow is from top to bottom and left to right.
3. When a process is exploded into lower level details they are numbered.

4. The names of data stores, sources and destinations are written in capital letters.

24
25
SYSTEM TESTING

26
 Testing:

Testing is a process of executing a program with the indent of finding an error.

Testing is a crucial element of software quality assurance and presents ultimate review of
specification, design and coding.

System Testing is an important phase. Testing represents an interesting anomaly for the software.
Thus a series of testing are performed for the proposed system before the system is ready for user
acceptance testing.

A good test case is one that has a high probability of finding an as undiscovered error. A
successful test is one that uncovers an as undiscovered error.

Testing Objectives:

1. Testing is a process of executing a program with the intent of finding an error

2. A good test case is one that has a probability of finding an as yet undiscovered error
3. A successful test is one that uncovers an undiscovered error

Testing Principles:

 All tests should be traceable to end user requirements

 Tests should be planned long before testing begins
 Testing should begin on a small scale and progress towards testing in large
 Exhaustive testing is not possible
 To be most effective testing should be conducted by a independent third party

The primary objective for test case design is to derive a set of tests that has the highest
livelihood for uncovering defects in software. To accomplish this objective two different categories
of test case design techniques are used. They are

 White box testing.

 Black box testing.

White-box testing:

White box testing focus on the program control structure. Test cases are derived to ensure
that all statements in the program have been executed at least once during testing and that all logical
conditions have been executed.

27
Block-box testing:

Black box testing is designed to validate functional requirements without regard to the internal
workings of a program. Black box testing mainly focuses on the information domain of the
software, deriving test cases by partitioning input and output in a manner that provides through test
coverage. Incorrect and missing functions, interface errors, errors in data structures, error in
functional logic are the errors falling in this category.

Testing strategies:

A strategy for software testing must accommodate low-level tests that are necessary to verify
that all small source code segment has been correctly implemented as well as high-level tests that
validate major system functions against customer requirements.

Testing fundamentals:

Testing is a process of executing program with the intent of finding error. A good test case is
one that has high probability of finding an undiscovered error. If testing is conducted successfully it
uncovers the errors in the software. Testing cannot show the absence of defects, it can only show
that software defects present.

Testing Information flow:

Information flow for testing flows the pattern. Two class of input provided to test the
process. The software configuration includes a software requirements specification, a design
specification and source code.

Test configuration includes test plan and test cases and test tools. Tests are conducted and all
the results are evaluated. That is test results are compared with expected results. When erroneous
data are uncovered, an error is implied and debugging commences.

Unit testing:

Unit testing is essential for the verification of the code produced during the coding phase and
hence the goal is to test the internal logic of the modules. Using the detailed design description as a
guide, important paths are tested to uncover errors with in the boundary of the modules. These tests
were carried out during the programming stage itself. All units of Vienna SQL were successfully
tested.

28
Integration testing:

Integration testing focuses on unit tested modules and build the program structure that is
dictated by the design phase.

System testing:

System testing tests the integration of each module in the system. It also tests to find
discrepancies between the system and it’s original objective, current specification and system
documentation. The primary concern is the compatibility of individual modules. Entire system is
working properly or not will be tested here, and specified path ODBC connection will correct or not,
and giving output or not are tested here these verifications and validations are done by giving input
values to the system and by comparing with expected output. Top-down testing implementing here.

Acceptance Testing:

This testing is done to verify the readiness of the system for the implementation.
Acceptance testing begins when the system is complete. Its purpose is to provide the end user with
the confidence that the system is ready for use. It involves planning and execution of functional
tests, performance tests and stress tests in order to demonstrate that the implemented system satisfies
its requirements.

Tools to special importance during acceptance testing include:

Test coverage Analyzer – records the control paths followed for each test case.
Timing Analyzer – also called a profiler, reports the time spent in various regions of the code are
areas to concentrate on to improve system performance.
Coding standards – static analyzers and standard checkers are used to inspect code for deviations
from standards and guidelines.
Test Cases:
Test cases are derived to ensure that all statements in the program have been executed at least once
during testing and that all logical conditions have been executed.
Using White-Box testing methods, the software engineer can drive test cases that
 Guarantee that logical decisions on their true and false sides.
 Exercise all logical decisions on their true and false sides.
 Execute all loops at their boundaries and with in their operational bounds.
 Exercise internal data structure to assure their validity.
The test case specification for system testing has to be submitted for review before system testing
commences.
29
 SYSTEM
IMPLEMENTATION AND
MAINTENANCE

30
 6. SYSTEM IMPLEMENTATION
An import aspect of system analyst’s job is to make sure that the new design is
implemented to established standard. Implementation is used here to mean the process of
converting a new or a reversed system design into operational one.

There are three types of implementation,

 Implementation of a computer system to replace a manual system. The problems
encountered are converting files, training users, creating accurate and verifying print
outs for integrity.
 Implementation of a new computer system to replace the existing one.
 Implementation of modified application to replace an existing or, using the same
computer. This type of conversion is relatively easy to handle

Conversion

Conversion means changing from one system to another. The objective is to put
the system into operation while holding costs, risks and personal irritation to a minimum. It
involves

o Creating computer compatible files.

o Training the operating staff.

o Installing terminals and hardware.

User Training

The analyst must have clear idea about the user’s capacity and requirement. A well
designed system may fail because of the way are operated and used. So the user must be trained
before using the new system and the quality of the training must be high

SYSTEM MAINTENANCE

System Security and Backup

The implementation phase is the rollout of the production version of the

system to the client community. This involves tasks like backing up the existing
system, data conversions producing user documentation.
31
Security

Security is an essential part of the increased scale of computerization and the development
of the system like sensitive area.

Back up

Backups for hardware, the data and the system are inevitable factor to be considered. Data backup
represents insurance against actual loss of data due to equipment malfunction. Program failure
or accident. Hence data can be providing on hard disk or on floppy disk.

Documenting the System

After the jobs of testing were completed the whole system as well documented in
clear, Understandable and simple language. This was to ensure that if any updating
has to be performed in the future the users
would not face any difficulties in performing tasks. An acceptance was made to
attain maximum perfection in documentation the software in a simple, precise and
self-explanatory manner.

The documentations deal with the system development with maximum

clarity. Each and every process is explained in details. The various tables used
by the system with their fields are provided. Different types of programs denoting
various activities of the system are included. The testing methods adopted also from
a part of the document. The output generated by the system constitutes another part.

32
FUTURE SCOPE OF
THE PROJECT

33
CODING:
Index.php
<?php include('include/header.php');

if(isset($_SESSION['email'])){
$custid = $_SESSION['id'];

if(isset($_GET['cart_id'])){
$p_id = $_GET['cart_id'];

$sel_cart = "SELECT * FROM cart WHERE cust_id = $custid and product_id = $p_id ";
$run_cart = mysqli_query($con,$sel_cart);

if(mysqli_num_rows($run_cart) == 0){
$cart_query = "INSERT INTO `cart`(`cust_id`, `product_id`,quantity) VALUES
($custid,$p_id,1)";
if(mysqli_query($con,$cart_query)){
header('location:index.php');
}
}
if(mysqli_num_rows($run_cart) > 0){
while($row = mysqli_fetch_array($run_cart)){
$exist_pro_id = $row['product_id'];
if($p_id == $exist_pro_id){
$error="<script> alert('⚠️This product is already in your cart ');</script>";
}
}
}

}
}
else if(!isset($_SESSION['email'])){
echo "<script> function a(){alert('⚠️Login is required to add this product into
cart');}</script>";
}
?>
<!--Carousel Wrapper-->
<div class="carousel slide mt-5" id="slider" data-ride="carousel">
<!---Indicators-->
<ol class="carousel-indicators">
<li data-target="#slider" data-slide-to="0" class="active"></li>
<li data-target="#slider" data-slide-to="1" ></li>
<li data-target="#slider" data-slide-to="2" ></li>
</ol>

<div class="carousel-inner">
<div class="carousel-item active">
34
 <img src="img/cupboard.jpg" class="d-block w-100">

</div>
<div class="carousel-item">
<img src="img/couch.jpg" class="d-block w-100">
</div>
<div class="carousel-item">
<img src="img/bedset_slide.jpg" class="d-block w-100">
</div>

<!---Controlers-->
<a class="carousel-control-prev" data-slide="prev" href="#slider">
<span class="carousel-control-prev-icon"></span>
</a>

<a class="carousel-control-next" href="#slider" data-slide="next" >

<span class="carousel-control-next-icon"></span>
</a>

</div>

</div>
<!--/.Carousel Wrapper-->

<!--Latest product---->
<section >
<div class="container pt-5 pb-5">
<div >
<?php
if(isset($msg)){
echo $msg;
}
else if(isset($error)){
echo $error;
}
?>
</div>

<h1 class="text-center">Latest Products</h1>

<div class="row mt-4">

<?php
$p_query = "SELECT * FROM furniture_product ORDER BY pid DESC
LIMIT 4";
$p_run = mysqli_query($con,$p_query);

35
 if(mysqli_num_rows($p_run) > 0 ){
while($p_row = mysqli_fetch_array($p_run)){
$pid = $p_row['pid'];
$ptitle = $p_row['title'];
$pcat = $p_row['category'];
$p_price = $p_row['price'];
$size = $p_row['size'];
$img1 = $p_row['image'];
?>

<div class="col-md-3 mt-3">

<img src="img/<?php echo $img1; ?>" class="hover-effect" width="100%"
height="190px">
<div class="text-center mt-3">
<h5 title="<?php echo $ptitle;?>"><?php echo substr($ptitle,0,20); ?
>...</h5>
<h6>Rs. <?php echo $p_price; ?></h6>
</div>

<div class="row">
<div class="col-md-12 col-sm-12 col-12 text-center">

<a href="index.php?cart_id=<?php echo $pid;?>" type="submit"

onclick="a()" class="btn btn-primary btn-sm hover-effect">
<i class="far fa-shopping-cart"></i>
</a>
<a href="product-detail.php?product_id=<?php echo $pid;?>"
class="btn btn-default btn-sm hover-effect text-dark" >
<i class="far fa-info-circle"></i> View Details
</a>

</div>

</div>
</div>

<?php
}
}
else{
echo "<h3 class='text-center'> No Product Available Yet </h3>";
}

?>

</div>
</div>
</section>
<!---end latest Products-->
36
 <!---We deal with-->
<section class="bg-white">
<div class="container pt-4 pb-5">
<h1 class="text-center pt-4">We Deal With </h1>

<!---Row 1-->
<div class="row mt-5">
<div class="col-md-4">
<img src="img/bedset.jpg" class="hover-effect" width="100%" alt="bedset">
<div class="mt-3">
<h4 class="text-center">Modern Bed set Designs</h4>
<p class="text-center">We deal with modern bedset design made from
manufactured wood with solid wood veneers.Affordable price with high quality
products.</p>
</div>
</div>
<div class="col-md-4">
<img src="img/dining-set.jpg" class="hover-effect" width="100%" alt="bedset">
<div class="mt-3">
<h4 class="text-center">Modern Dining Set</h4>
<p class="text-center">We deal with dining Table It oozes class and style and is
very chic and modern in design. Dining table constructed from a durable solid wood.</p>
</div>
</div>

<div class="col-md-4">
<img src="img/chairyellow.jpg" class="hover-effect" width="100%" alt="bedset">
<div class="mt-3">
<h4 class="text-center">Modern Arm Chairs Design</h4>
<p class="text-center">We deal with All Modern Style Arm Chairs It oozes class
and style and is very chic and modern in design, constructed from a durable solid
wood.</p>
</div>
</div>

</div>
<!---end-->

<!---row 2-->
<div class="row mt-5">
<div class="col-md-4">
<img src="img/table.jpg" class="hover-effect" width="100%" alt="bedset">
<div class="mt-3">
<h4 class="text-center">New Table Designs</h4>
<p class="text-center">We deal with All Modern Style tables It oozes class and
style and is very chic and modern in design, constructed from a durable solid wood.</p>
</div>
</div>
37
 <div class="col-md-4">
<img src="img/modern-contemp.jpg" class="hover-effect" width="100%"
alt="bedset">
<div class="mt-3">
<h4 class="text-center">Modern Sofa Designs</h4>
<p class="text-center">We deal with All Modern Style Sofas/Couches ,very chic
and modern in design, constructed from a durable solid wood.</p>
</div>
</div>

<div class="col-md-4">
<img src="img/newcupboard.jpg" class="hover-effect" width="100%"
alt="bedset">
<div class="mt-3">
<h4 class="text-center">New Stylish Cupboard Designs</h4>
<p class="text-center">We deal with All Modern Style Cupboards, built-in
cupboards are storage space that forms part of the design of the room.</p>
</div>
</div>

</div>

</div>
</section>
<!--end deal with-->

<!---How to Shop -->

<section class="back-gray pt-4 pb-4">
<div class="container">
<h2 class="text-center">How It Does Work</h2>
<div class="row">

<!--choose product card-->

<div class="col-md-4 p-5">
<div class="card hover-effect" id="border-less">
<div class="card-body mt-3 text-center">
<i class="fal fa-phone-laptop fa-3x"></i>
<div class="heading mt-2">
<h4>Product</h4>
<h6 class="text-secandary">Choose your own product</h6>
</div>
<p class="mt-2">Add product to cart & proceed to checkout and put your
shipping address then checkout that. </p>

</div>
</div>
</div>
<!---end choose product-->

38
 <!--cash on deliver-->
<div class="col-md-4 p-5">
<div class="card hover-effect" id="border-less">
<div class="card-body mt-3 text-center">
<i class="fal fa-hand-holding-box fa-3x"></i>
<div class="heading mt-2">
<h4>Recieve</h4>
<h6 class="text-secandary">Recieve Your Product</h6>
</div>
<p class="mt-2">After chouckout from cart your product will be deliver at
your door step within 7 working days</p>

</div>
</div>
</div>
<!---end cash on delivery-->

<!--cash on deliver-->
<div class="col-md-4 p-5">
<div class="card hover-effect" id="border-less">
<div class="card-body mt-3 text-center">
<i class="fal fa-wallet fa-3x"></i>
<div class="heading mt-2">
<h4>Cash</h4>
<h6 class="text-secandary">Cash on delivery</h6>
</div>
<p class="mt-2">On delivery of your product hold or recieve your products
then pay cash on that moment.</p>

</div>
</div>
</div>
<!---end cash on delivery-->

</div>
</div>
</section>
<!---end How to shop-->

<?php include('include/footer.php'); ?>

OUTPUT SCREEN:
39
40
41
42
43
44
45
.

46
 7. FUTURE SCOPE OF THE PROJECT

Future expansions of the project depend upon automatically generating

reports for purchase and sales, online purchasing facility for customers. Shops

could implement the ONLINE FURNITURE SHOPPING SYSTEM, as it is simple

and user friendly.Making enhancements is all about perfective maintenance. It means

adding, modifying or redeveloping the code to support changes in the specifications. It

is necessary to keep up with changing user needs and the operational environment.

More money and time is spent on perfective maintenance than on corrective or

adaptive maintenance together. The main advantage of the proposed system is that we

can easily access and maintain the customer information and it helps in saving the time

and also reduces the cost and manual effort.

47
CONCLUSION

48
 8. CONCLUSION

It is believed that almost all system objectives have being

met. A trial run of the system has been made and is giving good results. The
procedure for processing is simple and regular in order.

The system has been developed keeping in view of the limitations of the
existing manual system and attempt has been made to overcome the limitations. It
would render faster and better services to the user. System has got the feature of
easy generation of various reports of which new system will almost definitely
be preferred over the existing system. However modification can be made
depending on the changing environment.

For maximum utilization of the system, users should make sure that all the
data entries should be complete. This project work is not without
drawbacks even though 'it is unique in its nature.

49
BIBLIOGRAPHY

50
9. BIBLIOGRAPHY

Book Referred:

 Elias M Award, “System Analysis and Design”, Galgotia

publications, New Delhi, 2002

 C J Dale, “An Introduction to Database Management”

 James Martin, “Database Management System”

 Robin Nixon, ”Learning PHP , MySql ,and JavaScript”

51