1

1. PROJECT INTRODUCTION 1.1 Introduction 1.2 Objective of project 1.3 Goal 1.4 Scope 1.5 Project Category

Buzzibarter

2017-18

2

1.1 INTRODUCTION Buzzibarter is website which is helpful for Dealer, user and visitor for viewing all Products (Websites, Domains & Applications) details. In the current system all the activities are done manually. It is very time consuming. Our Buzzibarter deals with the various activities related to the Websites, Domains and Applications etc. The Buzzibarter is an automated version of manual Selling or Buying of internet properties. It can handle all details about an internet property (Websites, domains and Applications) and Features. The details include Car details, spare Parts details, Service details, Engine details, Feature details etc… In case of manual system, they need a lot of time, manpower etc. Here almost all work is computerized. So, the accuracy is maintained. Maintaining backup is very easy. It can do within a few minutes. Our system has two types of accessing modes, administrator and user. Buzzibarter is managed by an administrator. In the web application we can register as a user and user has three types: User, Visitor and administrator. Administrator has the power to add new features or future enhancement and can edit and delete a features & Users. A User can register as user and can edit and delete his/her profile and can upload or sell his/her products for sell or buy. The Admin can add, edit and delete Deactivate user and verified user products.

Buzzibarter

2017-18

3

Project Title:

BuzziBarter

Project Definition:

The Project aims to develop web site That can be used to buy or sell Website, domain and Application.

Front-end tool:

PHP 5.3.0

Back-end tool:

MY SQL 5.0

Miscellaneous Tools:

MS Office Word 2010, Wamp Serve 2.1, Dreamweaver 9.0, Notepad ++

Project Category:

Internet Based

Team Size:

4 members

Internal Guide:

Mrs.Krutika Patel.

Project Duration:

3 months.

Submitted by:

Mehta Moxesh P. Mistry Riya B. Ojha Harshvardhan R. Parekh Prachi K.

Buzzibarter

2017-18

4

1.2 OBJECTIVE OF PROJECT Our proposed system has several advantages.  User friendly interface  Online User registration  Fast access to database  Less error  More storage capacity  Search facility  Look and feel environment  Quick transaction A project is based on websites, domains and applications. In our project, there are mainly 3 entities. 1. Admin 2. User (Buyer, Seller) 3. Visitor Admin is our main entity that handles all the products, services, transaction, orders, customers (Buyer & Seller) etc. User is our main requirements. “Customer (user) is king of the market.” User Searches the products (Websites, Domains and Applications) make inquiry about required products, order necessary products, pay for usable products and feedback etc.

Buzzibarter

2017-18

5 User can also be a seller & sellers are our hand. They provide products which is helpful for customers and users. They provides so many type of products like  Websites with many categories...  Domain with many categories...  Applications with many categories... Visitors can only visit our website. They are only searches products. They do not make place order of products. They are make inquiry about any products. They also apply for user through Registration. We centralize all above things at one place, so user can easily get all the products using internet at home without finding professional persons and workers.

Buzzibarter

2017-18

6

1.3 GOAL 1) Increasing accuracy and work speed:  By maintaining all the work on computer will increase accuracy as well as speed of work.  The report can be generated at any time by Admin.  It will easily use and the time consuming is decreased. 2) To Store information safely:  To store the information of all the registered Users.  To keep track of information of every visitor.  To keep information about active users.  To keep all details of a uploads.  To store information of every Admin. 3) To evolve information the latest technology:  To evolve the latest technology using internet of traditional style.  To minimize the human effort made by the Admin evolved in the manual Buzzibarter. 4) Generate Reports in time:  To provide timely reports to the admin as and when required.  To produce summarized and accurate reports required for the decision making.  To get the result quicker than the manual process.

Buzzibarter

2017-18

7

1.4 SCOPE  Admin can delete or update the existing record.  Form an end-user perspective, the College Management system project consists of following functional elements:  Home It is the default page for the site. All links are available in this page.  Login User need to login to view his uploaded product information and to bid on the uploaded product of other user.  Register New user need to register to upload the product which they want to sell. Type all the details of the user like email id, name, address, contact details, password and Submit. System generates unique user id for each user and. Student need email id to login into.  Logout By clicking this link user logged out from this site all user session rest to default value.

Buzzibarter

2017-18

8

1.5 PROJECT CATEGORY In

today’s

modern,

sophisticated

and

rapidly

developing

world,

“Buzzibarter” provides facilities that user can easily use the products (Websites, Domains and Applications) at home using internet. Admin control all the service order at any place using internet. Seller easily find customer through BuzziBarter. The website developed for showing products information, customer information, seller information, orders of customers, Inquiry or feedback report, payment details etc. with the help of BuzziBarter.

Buzzibarter

2017-18

9

2.ENVIRONMENT DESCRIPTION 2.1 HARDWARE AND SOFTWARE REQUIREMENTS 2.2 TOOLS AND ENVIRONMENT USED 2.3 APPLICABILITY OF THE SYSTEM

Buzzibarter

2017-18

10

2.1 HARDWARE AND SOFTWARE REQUIREMENTS For Admin Software

Wamp Server, Adobe Dream viewer, Notepad++

Database

Mysqli

Operating System

Windows

RAM

512 MB(Minimum)

Microprocessor

Any Microprocessor can be used but latest would be better for performance

Hard Disk Space

1 GB (Minimum)

Web Browser Mozilla Firefox

Google Chrome

For Documentation Software

MS Word, Draw.io, Photoshop

Buzzibarter

2017-18

11 For User Operating System

Windows, Android

RAM

512 MB(Minimum)

Microprocessor

Any Microprocessor can be used but latest would be better for performance

Web Browser Mozilla Firefox

Google Chrome

For Visitor Operating System

Windows, Android

RAM

512 MB(Minimum)

Microprocessor

Any Microprocessor can be used but latest would be better for performance3

Web Browser Mozilla Firefox

Google Chrome

Buzzibarter

2017-18

12

2.2 TOOLS AND ENVIRONMENT USED PHP (Hypertext Pre-Processor):

PHP is a server-side scripting language designed primarily for web development but also used as a general-purpose programming language. Originally created by Rasmus Lerdorf in 1994, the PHP reference implementation is now produced by The PHP Development Team. PHP originally stood for Personal Home Page, but it now stands for the recursive acronym PHP: Hypertext Pre-processor. PHP code may be embedded into HTML or HTML5 code, or it can be used in combination with various web template systems, web content management systems and web frameworks. PHP code is usually processed by a PHP interpreter implemented as a module in the web server or as a Common Gateway Interface (CGI) executable. The web server combines the results of the interpreted and executed PHP code, which may be any type of data, including images, with the generated web page.

Buzzibarter

2017-18

13 WHY PHP? • Cost It is not a new fact that PHP is free of cost, and as you know ASP.Net is a Microsoft product and hence comes with certain charges. 1-Buying Windows is an expensive affair 2-Windows hosting • Support: As we have already discussed PHP is one of the scripting languages that is free of cost. It is open source, and also the developer’s community keeps on contributing to the PHP network. • No limitations: One of the things that a developer loves is freedom! PHP unlike ASP.Net offers you with the freedom to code anyway! • Tools and Editors: I have observed that most of the PHP developers love to use text editors such as the VIM and Notepad++, rather than implementing a full-fledged IDE. But, if you prefer to work with an IDE while using PHP, then you will get strong support from editors such as the Eclipse, which is absolutely free of cost. As you know, ASP.Net is backed up by a variety of IDE’s, but you can use it with Microsoft Visual Studio. It is not free but has ample of features and is one of the most flexible IDEs. This means that if you have some money to invest then choose ASP.Net for your needs.

Buzzibarter

2017-18

14

• Database support: Like we have discussed in almost all the points, PHP is supportive across all other platforms and processes and so is it when it comes to Databases. It is integer able and scalable and supportive to databases that includes MySQL. WordPress is one of the popular examples if you ask me. It implements PHP coding with MySQL for its content management system that makes things easier.

MY SQL My SQL is an open-source relational database management system (RDBMS). Its name is a combination of “My”, the name of co-founders Michael Widenius' daughter, and "SQL", the abbreviation for Structured Query Language. The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation. For proprietary use, several paid editions are available, and offer additional functionality. MySQL is a central component of the LAMP open-source web application software stack (and other "AMP" stacks). LAMP is an acronym for "Linux,

Buzzibarter

2017-18

15 Apache, MySQL, and Perl/PHP/Python". Applications that use the MySQL database include: TYPO3, MODx, Joomla, WordPress, phpBB, MyBB, and Drupal. MySQL is also used in many high-profile, large-scale websites, including Google (though not for searches), Facebook, Twitter, Flickr, and YouTube.  MySQL is a database server.  MySQL is ideal for both small and large application.  MySQL support standard SQL.  MySQL complies on several platforms.  MySQL is free to download and use.  MySQL is a database management system.  MySQL is a relation database management system.  MySQL software is open source.  The MySQL database server is very fast, reliable, and easy to use.  MySQL server works in client/server or embedded system.  A large amount of contributed MySQL software is available.

Why MYSQL? This is an open source. No licensing cost to pay. This it is big thing even there are not many features like Oracle RAC, but you can manage all that with multiple servers and load balancing features. Provides GUI with Command Prompt. Supports the administration using MySQL Admin, MySQL Query Browser. Latest version supports stored procedures and functions. The best thing is runs in windows and Unix/Linux.

Buzzibarter

2017-18

16 WAMP SERVER:

WAMP (Windows, Apache, MySQL, PHP/Perl/Python). WAMP is a form of mini-server that can run on almost any Windows Operating System. WAMP includes Apache 2, PHP 5 (SMTP ports are disabled), and MySQL (phpMyAdmin and SQLite manager are installed to manage your databases) preinstalled. An icon on the taskbar tray displays the status of WAMP, letting you know if, 1. WAMP is running but no services are opened (the icon will appear RED). 2. WAMP is running and one service is opened (the icon will appear ORANGE). 3. WAMP is running with all services opened (the icon will appear GREEN). Apache and MySQL are considered to be services (they can be displayed by left-clicking on the taskbar icon, guiding your cursor over the services you wish to disable and selecting “Stop Services”). WAMP is a form of mini-server that can run on almost any Windows Operating System. WAMP includes Apache 2.2.17, PHP 5.3.5 (SMTP ports are disabled), and MySQL (phpMyAdmin and SQLsitemanager are installed to manage your databases) preinstalled. An icon on the taskbar tray displays the status of WAMP, letting you know if; a) WAMP is running but no services are opened (the icon will appear red), b)

Buzzibarter

2017-18

17 WAMP is running and one service is opened (the icon will appear yellow) or c) WAMP is running with all services opened (the icon will appear white). Apache and MySQL are services (they can be disabled by left-clicking on the taskbar icon, guiding your cursor over the service you wish to disable and selecting: Stop Service”). The files/web pages that are hosted on your WAMP server can be accessed by typing http://localhost/ or http://127.0.0.1/ in the address bar of your browser. WAMP must be running to access either of the above addresses. WAMP2.1 installs automatically Apache 2.2.17, PHP 5.3.5., MySQL database, PhpMyAdmin and SQLsitemanager on your computer. Its principal aim is to allow you to easily discover the new version of PHP: PHP5.3.5. WAMP2.1 comes with a service manager installed as a tray icon. It allows you to manage WAMP2.1 and access all services. WAMP2.1's installation is compact. This means that all files are copied to WAMP2.1's directory. Only the MySQL conf file (usually my.ini) is copied to the Windows directory but as "mywamp.ini" to avoid conflicts with other installs.

Buzzibarter

2017-18

18 PHPMYADMIN:

PhpMyAdmin can manages a whole MYSQL server (needs a super-user) as well as a single database. To accomplish the latter, you’ll need a property sent up MYSQL user who can read/write only the desired database. It’s up to you to look up the appropriate part in MySQL manual. Supported features currently PhpMyAdmin can:  Browse and drop databases, tables, views, columns and indexes.  Display multiple result sets through stored procedures or queries.  Create copy, drop, rename and alter databases, tables, columns and indexes.  Maintenance server, databases and tables with proposals on server configuration.  Execute, edit and bookmark any SQL-statement, even batch-queries.  Load text files into tables.

Buzzibarter

2017-18

19 Java Script:

JavaScript is the most popular scripting language on the internet, and works in all major browsers, such as Internet Explorer, Firefox, Chrome, Opera, and Safari. What is JavaScript?  JavaScript was designed to add interactivity to HTML pages  JavaScript is a scripting language.  A scripting language is a lightweight programming language.  JavaScript is usually embedded directly into HTML pages What can a JavaScript do?  JavaScript gives HTML designers a programming tool - HTML authors are normally not programmers, but JavaScript is a scripting language with a very simple syntax! Almost anyone can put small "snippets" of code into their HTML pages.  JavaScript can put dynamic text into an HTML page - A JavaScript statement like this: document. Write ("

" + name + "

") can write a variable text into an HTML page. Buzzibarter

2017-18

20  JavaScript can react to events - A JavaScript can be set to execute when something happens, like when a page has finished loading or when a user clicks on an HTML element.  JavaScript can read and write HTML elements - A JavaScript can read and change the content of an HTML element  JavaScript can be used to validate data - A JavaScript can be used to validate form data before it is submitted to a server. This saves the server from extra processing.  JavaScript can be used to detect the visitor's browser - A JavaScript can be used to detect the visitor's browser, and - depending on the browser load another page specifically designed for that browser.

Buzzibarter

2017-18

21 OOP (Object Oriented Programming): Object Oriented is an approach to software development that models applications around real-world objects such as employees, cars, bank accounts, etc. A class defines the properties and methods of a real-world object. An object is an occurrence of a class. The three basic components of object orientation are;

 Object oriented analysis – functionality of the system  Object oriented designing – architecture of the system  Object oriented programming – implementation of the application Object Oriented Programming Principles: The three major principles of OOP are;

 Encapsulation: This is concerned with hiding the implementation details and only exposing the methods. The main purpose of encapsulation is to;

 Reduce software development complexity – by hiding the implementation details and only exposing the operations, using a class becomes easy.

 Protect the internal state of an object – access to the class variables is via methods such as get and set, this makes the class flexible and easy to maintain.

 The internal implementation of the class can be changed without worrying about breaking the code that uses the class.

 Inheritance:

Buzzibarter

2017-18

22 This is concerned with the relationship between classes. The relationship takes the form of a parent and child. The child uses the methods defined in the parent class. The main purpose of inheritance is:

 Re-usability– a few children, can inherit from the same parent. This is very useful when we must provide common functionality such as adding, updating and deleting data from the database.

 Polymorphism: This is concerned with having a single form but many different implementation ways. The main purpose of polymorphism is;

 Simplify maintaining applications and making them more extendable.

OOPs Concepts in PHP: PHP is an object-oriented scripting language; it supports all of the above principles. The above principles are achieved via;

 Encapsulation: via the use of “get” and “set” methods etc.  Inheritance: via the use of extends keyword  Polymorphism: via the use of implements keyword

Buzzibarter

2017-18

23

Apache Server:

Apache is developed and maintained BT an open. Community of developers under an auspice of the Apache Software Foundation What is the Apache software Foundation? The Apache Software Foundation (ASP) is a non-profit 501(c) (3) corporation, incorporated in Delaware, USA, in June of 1999. The ASF is a natural outgrowth of The Apache Group, a group of individuals that was initially formed in 1995 to develop the Apache HTTP Server. Feature of Apache server: Apache supports a variety of features, many implemented as compiled modules which extend the core functionality. These can range from server-side programming language support to authentication schemes. Some common language interfaces support Perl, Python, 191, and PHP. Popular authentication modules include mod_access, mod_auth, mod_digest, and mod_auth_digest, the successor to mod_digest. A sample of other features include SSL and TLS support (mod_ssl,) a proxy module mod_proxy), a URL rewriter (also known as a rewrite engine,

Buzzibarter

2017-18

24 implemented under mod_rewrite), custom log files (mod_log_config), and filtering support (mod_include A and mod_ext-filt). Virtual hosting allows one Apache installation to serve many different actual websites. For example, one machine with one Apache installation could simultaneously

serve

www.example.com,

www.test.com,

test47.text-

server.test.com etc. Apache features configurable error messages, DBMS-based authentication databases, and contact negotiation. It is also supported by several graphical user interface (GUIs) Performance of Apache server Although the main design goal of Apache is snoot be the "fastest” web server, instead of implementing a Single architecture, Apache provides a variety of Multi Processing Modules (MPMS) which allow Apache to run in a processbased, hybrid (process and thread) or event-hybrid mode, to better match the demands of each infrastructure. The Apache version considered by the Apache Foundation as providing high performances is the multi-threaded version which mixes the use of several processes and several threads per process. What are the future plans for Apache?  To continue to be an “open source” no-change-for-use HTTP server,  To keep up with advances in HTTP protocol and web development in general,  To collect suggestions for fixes/improvement from its users,  To respond to needs of large volume providers as well as occasional users.

Buzzibarter

2017-18

25 2.3 Applicability of the system As per the name of the system, “Buzzibarter”, which is derived from two words business and barters, suggests this system will be used for online auction of Websites, Domain Names and Mobile Application. With changing the requirement of the authority. This system’s functionality is based on online auction of websites and domain names. It will store information about uploaded product. By using this information system will generate necessary daily report and yearly report for the total bids on the uploaded product, total uploads and total winners.

Buzzibarter

2017-18

26

3. ANALYSIS REPORT 3.1Drawback of Current System 3.2Limitation of Current System 3.3 Requirement Analysis 3.4 Requirement Specification 3.5Proposed System 3.6 Advantage of Proposed System 3.7 System Model 3.8 Data Flow Diagram 3.9 Process Specification 3.10 Data Base 3.11 Data Dictionary 3.12 Relationship

Buzzibarter

2017-18

27

3.1 DRAWBACK OF CURRENT SYSTEM There are number of limitations of current system. They are as follows:  Lack of security, Data duplication and slow retrieval of data existed  Inconsistency of data existed. Time consuming and costly:  System is very time consuming because System re-entries of data is difficult and changing of data is difficult. It becomes very crucial and time-consuming job. Outstanding records maintenance is a time-consuming job. Maintenance is difficult:  As data are written on paper so it’s difficult to change which are files may be lost/damage.  Managing and searching records is simply a difficult task...  As it was manual, ore consumption of paper was there.

Buzzibarter

2017-18

stored

in

28

3.2 LIMITATION OF CURRENT SYSTEM Work load: Because of this manual system the load of work becomes so high and he can’t manage in proper manner. Records are stored in Registers: All the records are stored in the registers so various registers are needed for storing transactions. Lots of registers are maintained. Time consuming: Existing system is time consuming. The time of doing any transaction tales much time. Less Level of Security: The level of security and verification of uploads done by user is at very basic level so, chances of online fraud increase.

Buzzibarter

2017-18

29

3.3 REQUIREMENT ANALYSIS  A process of discovery, refinement, modelling & specification is called Requirement Analysis.  It bridges the gap between system level requirement engineering & software design.  Once the system analyst has determined that a problem exists & has obtained permission to do something about it, then Requirement Analyst can begin.  Requirement Analysis for the new system should identify the user requirement.

Requirement definition & specification

Requirement validation

Process Entry

Domian Understanding

Prioritization

Requirement collecation

conflict resloution

Classification

Buzzibarter

2017-18

30 Requirement Analysis will determine:  What outputs are needed?  What inputs are needed to obtain these outputs?  What operations it must perform to obtain these outputs?  What resources must be used?  What operational and accounting controls are needed

Activities to be performed during requirement Analysis  Domain understanding  Requirement collection  Classification  Conflict resolutions  Prioritization  Requirement validation

Buzzibarter

2017-18

31

3.4 REQUIREMENT SPECIFICATION Admin The administrator is the people who coordinates and maintain the site. The basic functionalities of the administrator are: Manage User: The admin manages the User. Admin can insert, update, delete, search and display the Users. Manage Seller: The admin manages the Seller. Admin can insert, update, delete, search and display the Seller. Manage Products: The admin manages the Products (Websites, Domain and Applications). Admin can insert, update, delete, search and display the Products. Manage Order: The admin manages the customer order. Admin can insert, update, delete, search and display the customer Order. Manage Inquiry/Feedback: The admin manages the customer/visitor inquiry and also work for their feedback satisfaction. Admin can give response and display feedback for other users. Buzzibarter

2017-18

32 User: Admin add the user and give some permission to searches the products, order the products, give feedback or make inquiry etc. The basic functionalities of the User are: Search the products: The user searches the Products they want. Upload the product: The user can upload the product which they want to sell over the world. View uploaded product: The User can view the product which is uploaded by other users and can also know the detail information of product. Bid on Product: User can bid on the interested product that is if user is interested in any uploaded product, so he/she can bid on it. Manage Bids: The user manages the bids done in their own uploaded product. Short-list and Winners: The user can short-list from all the bids and from short-listed he/she can select a winner.

Buzzibarter

2017-18

33

3.5 PROPOSED SYSTEM  Admin can login to admin site.  Admin can verify the website, domain name and applications.  Admin can view uploaded products.  Admin can view biddings.  Admin can view winners.  Admin can block unstable user.  Admin can view product of user.  Admin can view bids of product.  User can login into user site.  User can insert, update, delete and view Products.  User can view uploaded products by other users.  User can search products.  User can view detail information of product.  User can bid on product.  User can view highest bidders along with price.  User can shortlist the biddings on own product.  User can select winner from short-listed bidders.  Visitor can search the Products.  Visitor can make inquiry about Products.  Visitor does not make order of product without login or registration.

Buzzibarter

2017-18

34

3.6 ADVANTAGES OF PROPOSED SYSTEM  It Provide Login security.  The software after development will maintain the database of all the user, Products, Biddings, Winners.  Quick updating of the records.  This System Provides Flexible Products.  Low Cost of ownership.  Admin does not need to wait for the result while assessment of information.  User can easily get their own detail and can easily login to our site.  Only Admin can see the all data. So, it’s very secure that all data are not shown to all.

Buzzibarter

2017-18

35

3.7 SYSTEM MODEL

Server Side

Client Side

Client

Web Server

Browser

Applicatio n Database

Administra

Provider

Member/Gu est

Buzzibarter

2017-18

36

3.8 DATA FLOW DIAGRAM One of the tools of the structure analysis is the Data flow Diagram. A DFD is a graphical representation of the system. The data flow Diagram is used by the system analysis to explain the flow of the data in the system. A DFD uses some Element as its building blocks. The following is a brief description of this element. External entity: The external entities are a source and/or description of the data for the system as the name suggest, it lies outside the context of the system. It is represented by solid rectangles.

Process: A process represents some amount of word being performed on the data. A process truncation of the data from one form to another. A circle represents a process. The process must be named and numbered appropriately

Data flow: A data flow designates an interface among different compost in the DFD. It represents the path of data as it flows thought the system. As arrow represents a data flow. The name of the data flow is written along the line.

Buzzibarter

2017-18

37

Data store: A Data source is a repository of data. An open-ended rectangle or row horizontal parallel lines represent it.

A DFD which describes the system at a very general level is called the context diagram. It contains a single process, but it plays a very important role in studying the system.

Buzzibarter

2017-18

38 Context level of DFD of BuzziBarter

Buzzibarter

2017-18

39 1st Level DFD of Admin:

Buzzibarter

2017-18

40 1st Level DFD of User:

Buzzibarter

2017-18

41 1stLevel DFD of visitor:

Buzzibarter

2017-18

42 2nd Level DFD of Admin:

Buzzibarter

2017-18

43

Buzzibarter

2017-18

44 2nd Level DFD of User:

Buzzibarter

2017-18

45 2nd Level DFD of User:

Buzzibarter

2017-18

46 2nd Level DFD of Visitor:

Buzzibarter

2017-18

47

Buzzibarter

2017-18

48

Buzzibarter

2017-18

49

Buzzibarter

2017-18

50

Buzzibarter

2017-18

51

3.10 DATA BASE  List of Tables:  Admin  Bidding  Application  Category  City  Country  Feedback  Domains  Listing  Site setting  State  Sub-category  User  Website  Winner

Buzzibarter

2017-18

52 ADMIN Sr.no

Field

Type

Constraints

Description

1

admin_id

int(11)

Primary key

Unique and NOT NULL

2

adm_name

varchar(30)

-

Admin Name

3

email_id

varchar(30)

-

E-mail ID

4

password

varchar(30)

-

Password

BIDDING Sr. No 1

Field

Type

Constraints

Description

bid_id

int(11)

Primary key

Unique and NOT NULL

2

user_id

int(11)

Foreign Key

User_id

(user) 3

listing_id

int(11)

Foreign Key

Listing_id

(Listing) 4

amount

int(11)

-

Amount

5

status

enum('pending',

-

Status of Bid

'rejected', 'short_listed') 6

created_date

varchar(30)

-

Bidding_date

7

modified_date

varchar(30)

-

modified_date

Buzzibarter

2017-18

53 APPLICATION Sr. No 1

Field

Type

Constraints

Description

application_id

int(11)

Primary Key

Unique and NOT NULL

2

application_name

varchar(60)

-

Name of Application

3

application_topic

varchar(300)

-

Topic of Application

4

application_descrip

varchar(600)

-

Details description of

tion 5

category_id

Application int(11)

Foreign key

Category_id

(category) 6

sub_category_id

int(11)

Foreign Key

Sub_category_id

(sub_categor y) 7

user_id

int(11)

Foreign Key

User_id

(user) 9

starting_bid

int(11)

-

Starting_bid

10

upload_date

varchar(30)

-

Upload_date

11

last_date

varchar(30)

-

Last Date for BID

12

api_key

varchar(300)

-

Google API key of application

13

verified

enum('Not

-

Verified',

Status of Application after upload

'Verified') 14

publish

enum('Publish'

-

, 'Unpublish')

Buzzibarter

Publish application in listing

2017-18

54 CATEGORY Sr. NO 1

Field

Type

Constraints

Description

category_id

int(11)

Primary key

Unique and NOT NULL

2

category_name

varchar(20)

-

Category name

3

created_date

varchar(25)

-

Created date

4

modified_date

varchar(25)

-

Modified date

CITY Sr. No 1

Field

Type

Constraints

Description

city_id

int(11)

Primary key

Unique and NOT NULL

2

country_id

int(11)

Foreign Key

Country id

(‘country’) 3

state_id

int(11)

Foreign Key

State id

(‘State’) 4

City

varchar(20)

-

City Name

5

created_date

varchar(25)

-

Created Date

6

modified_date

varchar(25)

-

Modified Date

Buzzibarter

2017-18

55 COUNTRY Sr. No

Field

Type

Constraints

Description

1

country_id

int(11)

Primary key

Unique and NOT NULL

2

country_name

varchar(20)

-

Country Name

3

created_date

varchar(25)

-

Created Date

4

modified_date

varchar(25)

-

Modified Date

FEEDBACK Sr. No

Field

Type

Constraints

Description

1

feedback_id

int(11)

Primary key

Unique and NOT NULL

2

email_id

varchar(30)

-

Email Id

3

name

varchar(50)

-

Name

4

listing_id

int(11)

Foreign Key

Listing ID of review

(Listing)

5

description

varchar(1000)

-

Detail Description of feedback

Buzzibarter

2017-18

56 DOMAINS Sr. No

Field

Type

Constraints

Description

1

domain_id

int(11)

Primary key

Unique and NOT NULL

2

domain_name

varchar(200)

-

Domain Name

3

domain_topic

varchar(100)

-

Domain Topic

4

category_id

int(11)

Foreign key

Category Id

(category) 5

6

sub_category_id

user_id

int(11)

int(11)

Foreign Key

Sub

(sub_category)

Categoryid

Foreign Key

User Id

(user) 7

domain_description

varchar(600)

-

Domain Description

8

starting_bid

int(11)

-

Starting Bid

9

upload_date

varchar(30)

-

Upload Date

10

last_date

varchar(30)

-

Last BID Date

11

verified

enum('Verified',

-

Verified or not

-

Show in listing

'Not Verified') 12

publish

enum('Unpublish', 'Publish')

Buzzibarter

or not

2017-18

57 LISTING Sr. No

Field

Type

Constraints

Description

1

listing_id

int(11)

Primary key

Unique and NOT NULL

2

pro_id

int(11)

-

Product ID of Uploaded Product

3

listing_type

Enum(‘Website’,

-

‘Domain_name’,

Type of product uploaded

‘Application’)

SITE_SETTING Sr. No

Field

Type

Constraints

Description

1

field_id

int(11)

Primary key

Unique and NOT NULL

2

Field

varchar(50)

-

Field of website

3

Value

varchar(300)

-

Value of the field

Buzzibarter

2017-18

58 STATE Sr. No

Field

Type

Constraints

Description

1

state_id

int(11)

Primary key

Unique and NOT NULL

2

state

varchar(20)

-

State Name

3

country_id

int(11)

Foreign Key

Country ID

(‘country’) 4 5

created_date

varchar(25)

-

Created Date

modified_date varchar(25)

-

Modified Date

SUB_CATEGORY Sr. No

Field

Type

Constraints

Description

1

sub_category_id

int(11)

Primary key

Unique and NOT NULL

2

category_id

int(11)

Foreign Key

Category ID

(‘category’)

3

sub_category_name

varchar(20)

-

Sub Category Name

4

created_date

varchar(25)

-

Created Date

5

modified_date

varchar(25)

-

Modified Date

Buzzibarter

2017-18

59 USER Sr. No

Field

Type

Constraints

Description

1

user_id

int(11)

Primary key

Unique and NOT NULL

2

user_name

varchar(50)

-

User Name

3

address

varchar(500)

-

Address

4

city

varchar(20)

-

City

5

state

varchar(20)

-

State

6

country

varchar(20)

-

Country

7

mobile_no

Double

-

Mobile number

8

email_id

varchar(30)

-

Email ID

9

password

varchar(30)

-

Password

10

photo

varchar(300)

-

Photo

11

email_verified

enum('No',

-

Email Verified

'Yes')

Buzzibarter

2017-18

60 WEBSITE Sr. No 1

Field

Type

Constraints

Description

website_id

int(11)

Primary key

Unique and NOT NULL

2

website_topic

varchar(100)

-

Website Topic

3

website_description

varchar(1000)

-

Website Description

4

domain_name

varchar(200)

-

Domain Name

5

category_id

int(11)

Foreign key

Category Id

(category) 6 7

sub_category_id user_id

int(11) int(11)

Foreign Key

Sub Category

(sub_category)

Id

Foreign Key

User ID

(user) 8

starting_bid

int(11)

-

Starting Bid

9

upload_date

varchar(30)

-

Upload Date

10

last_date

varchar(30)

-

Last Date

11

domain_including

varchar(10)

-

Domain Inclusion

12

custom_updates

varchar(10)

-

Custom Updates

13

custom_update_price

int(11)

-

Custom Update Price

14

services

varchar(40)

-

Services

15

client_database

varchar(10)

-

Client

Buzzibarter

2017-18

61 Database 16

verified

enum('Verified',

-

Verified

-

Publish

-

Demo URL

'Not Verified') 17

publish

enum('Unpublish', 'Publish')

18

demo_url

varchar(5)

WINNER Sr. N0

Field

Type

Constraints

Description

1

winner_id

int(11)

Primary key

Unique and NOT NULL

2

listing_id

int(11)

Foreign Key

Listing ID

(‘Listing’)

3

bid_id

int(11)

Foreign Key

Bid ID

(‘bidding’)

4

user_id

int(11)

Foreign Key

User ID

(user) 5

win_date

varchar(25)

Buzzibarter

-

Winning Date

2017-18

62

3.11 DATA DICTIONARY  Data Dictionary is repository that contains description of all data object consumed by software  A Data Dictionary is a list of names used by the system arranged alphabetically.  As well as the name, the dictionary should include a description of the named entity and, if the name.  Represent of a composite oblect, there may be description of the composition.  Other information such as the date of creation, creator and the representation of Entity may also include depending on the type of model, which is deign developed.

Advantages:  The data Dictionary software can check for name uniqueness and tell requirements analyst of name duplications.  It server as store of organization information which can link analysis, design, implementations and evolution. As the system is developed, information is taken to inform the development. New information is added in it. All information about entity is in one place.

Buzzibarter

2017-18

63

Buzzibarter

2017-18

64

Buzzibarter

2017-18

65

Buzzibarter

2017-18

66

Buzzibarter

2017-18

67

Buzzibarter

2017-18

68

Buzzibarter

2017-18

69

Buzzibarter

2017-18

70

4. Designing Report 4.1 Screen Diagram (SS)

Buzzibarter

2017-18

71

CLIENT SIDE: Registration page:

Buzzibarter

2017-18

72 User verified by email:

Buzzibarter

2017-18

73 Login page:

Buzzibarter

2017-18

74 Home page:

Buzzibarter

2017-18

75 Select a plan (Package):

Buzzibarter

2017-18

76 Sell by selecting category:

Buzzibarter

2017-18

77 For sell Application fill the form:

Buzzibarter

2017-18

78 For sell Website fill the form:

Buzzibarter

2017-18

79 For sell Domain fill the form:

Buzzibarter

2017-18

80 Listing of products:

Buzzibarter

2017-18

81 Website description

Buzzibarter

2017-18

82 Domain description

Buzzibarter

2017-18

83 Application description:

Buzzibarter

2017-18

84 User dashboard:

User Profile:

Buzzibarter

2017-18

85 User can update profile:

User can change password:

Buzzibarter

2017-18

86 User can change profile image:

Uploaded website by user:

Buzzibarter

2017-18

87 Uploaded domain by user:

Buzzibarter

2017-18

88 Updated website description:

Updated domain description:

Buzzibarter

2017-18

89 Website details:

Domain details:

Buzzibarter

2017-18

90 Pending bid by bidder on user product:

Buzzibarter

2017-18

91 Short-list bid by user:

Buzzibarter

2017-18

92 Winners of products:

Buzzibarter

2017-18

93 Total bidding by user on other products:

Winning by user:

Buzzibarter

2017-18

94 About us page:

Buzzibarter

2017-18

95 Contact us page:

Buzzibarter

2017-18

96

ADMIN Admin Dashboard:

Buzzibarter

2017-18

97 Latest products lists:

Buzzibarter

2017-18

98 Highest bid on products:

Pending products of users:

Buzzibarter

2017-18

99 Verified products by admin:

Buzzibarter

2017-18

100 Website details:

Buzzibarter

2017-18

101 Domain details:

Buzzibarter

2017-18

102 Categories details:

Buzzibarter

2017-18

103 Sub-Categories details:

Buzzibarter

2017-18

104 Country description:

Buzzibarter

2017-18

105 State description:

Buzzibarter

2017-18

106 City description:

Buzzibarter

2017-18

107 Running bidding list:

Buzzibarter

2017-18

108 Site setting:

Buzzibarter

2017-18

109

5.1 TESTING MODULE  Testing is the process carried out on software to detect the differences between its behaviour and desired behaviour as stipulated by the requirements specifications.  Testing is advantageous in several ways. Firstly, the defects found help in the process of making software and reliable. Secondly, even if the defects found are not corrected, testing gives an idea as to how reliable the software is.  Thirdly, over time, the record of defects found reveals the most common kinds of defects, which can be used for developing appropriated preventive measures such as training proper design and reviewing.

Buzzibarter

2017-18

110  The uncovered weaknesses that were not found in earlier tests are removed in system testing. The system is corrected such a way that it does not affect the forced system failure. This testing is done with low volume of transaction based on live data. Finally, the total system is also tested to ensure that no data are lost.  Following testing on the completed system will be performed to find the errors before they become defects and correct them.  In order to eliminate navigational errors, the site will be reviewed and tested. The use cases scenarios that I have developed in the same document while requirement analysis activity will be considered to uncover errors in the navigational links.  Web pages of the site will be unit tested. For the web pages sometimes, the smallest testable unit is the single web page itself. Each web page contains content, navigational links, and processing elements (scripts, event handlers, etc.). The testing will be driven by the content processing, and links contained in the site.  The separately generated web pages will be integrated and for checking that they work properly after their integration, tests will be conducted to ensure their proper functionality. The functionality of the site will be checked with the different versions of the Internet Explorer, Netscape Navigator, etc. and wherever necessary it will be attempted to change the implementation of the not working for some browsers for some case and of course without losing the purpose of the functionality, if possible.

Buzzibarter

2017-18

111

5.2 TESTING PLAN The testing sub process includes the following activities in phase depended manner:  Create test plans  Create test specifications  Review test plans and test specifications  Conduct tests according to the test specifications, and log the defects  Fix defects, if any  When defects are fixed continue from activity Unit Testing

Module Testing

Sub-System Testing

System Testing

Acceptance Testing

Buzzibarter

2017-18

112  Unit Testing  As per as unit testing is concerned I did it at the time of the coding in an informal but extensive way, so as to reduce number of problems arising out of incorrect variable, function names etc.. Care was taken to check for any infinite loop that exists in code before executing the code. Each module was tested whether they cover the functionalities specified by the client or not? The functionalities were performed for valid data or not? For invalid data proper messages were displayed or not? etc.  Integration Testing  Unit testing tests a unit of code (module or program) after coding of that unit is completed. Integration testing tests whether the various programs that make up a system, interface with each other as desired, fit together and whether the interfaces between the programs are correct. System testing ensures that the system meets its stated design specifications. Acceptance testing is testing by the users to ascertain whether the system developed is correct implementations of 1the Software Requirements Specifications.

Buzzibarter

2017-18

113

5.3 TEST CASE DESIGN  A rich variety of test case design methods have evolved for software. These methods provide the developer with a systematic approach to testing. More important, methods provide a mechanism that can help to ensure the completeness of tests and provide the highest likelihood for uncovering errors in software.  Any engineered product can be tested in one of the two ways:  Knowing the specified function that a product has been designed to perform test can be conducted to demonstrate that each function is fully operational. While at the same time searching for errors in each function.  Knowing the internal working of a product, tests can be conducted to ensure that “all gear mesh” that is, internal operations are performed according to the specifications and all internal components have been adequately exercised.  The first test approach is called “Black Box Testing” and second is called “White Box Testing”.

Buzzibarter

2017-18

114

TEST CASE: Registration: Sr.

Field Name

Input

No. 1. 2. 3.

Usertype Usertype Email

Not null Not null

Condition Expected

Actual output

check

output

Not null

Please select

Please select

any one item

any one item

Please enter

Please enter

your name

your name

Not null

Invalid

Invalid

Please

Please include

format

format

include an

an ‘@’in the

‘@’in the

email address

email address 4.

5. 6.

7.

Contact No.

UserId Password

Capcha

Character

Please enter

Please enter

10 digit

10 digit

number only

number only

Invalid

Enter your

Enter your

user

valid userid

valid userid

Not match

Your

Your

invalid

password is

password is

password

not match

not match

Your capcha

Your capcha is

is not match

not match

Invalid user Enter

Enter

Digit

Not match

invalid capcha

Buzzibarter

2017-18

115

Login: Sr. No.

Field

Input

Condition Expected

Actual

check

output

output

Invalid

invalid

Enter your

Enter your

user

user

invalid

invalid

userid

userid

Name 1.

2.

Userid

Password

Enter

Not match your

your

invalid

password is

password is

password

not match

not match

Buzzibarter

2017-18

116 Domain: Sr. No. Field Name 1.

Input

Domain_name Digit

Condition Expected

Actual output

check

output

Character

Domain

Domain Name

Name must

must not contain

not contain

digit

digit 2. 3.

Domain_topic Not null Domain

Not null

Not null Not null

Description

Please Topic

Please Topic of

of domain

domain

Description

Description must

must be

be greater than

greater than

100 digits

100 digits 4.

Starting Bid

Character Digit

Please enter

Please enter digit

digit number

number only

only 5. 6. 7.

Last Date Category Sub Category

Not null Not null Not null

Not null Not null Not null

Please select

Please select any

any one item

one item

Please select

Please select a

a category

category

Please select

Please select a

a sub

sub category

category

Buzzibarter

2017-18

117

5.4 TESTING ISSUE Black box testing:  Black box testing takes an external perspective of the test object to derive test cases. These tests can be functional or non-functional, through usually functional.  The test designer selects valid and invalid input & output.  This method of test design is applicable to all levels of software testing: unit, integration, functional testing, system and acceptance.  The higher the level & hence the bigger and more complex the box, the more one is forced to use black box testing to simplify.  While this method can uncover unimplemented parts of the specification, one cannot be sure that all existent paths are tested.

User input validation:  User input must be validated to confirm to expected values.  If the user enters invalid input for any of the criteria, my software checks to make sure all invalid cases are handled.

Buzzibarter

2017-18

118  These are possible test scenarios that should be entered for each point of user input, which restricts the user to enter invalid data.

White box testing strategy:  White box testing strategy deals with the internal logic and structure of the code.  White box testing is also called as glass, structural, open box or clear box testing.  The tests written based on the white box testing strategy incorporate coverage of the code written, branches paths, statements and internal logic of the code etc.  In order to implement white box testing are have to deal with the code and hence is needed to possess knowledge of coding and logic.

The basic testing techniques are:  UNIT TESTING  PROGRAM TESTING  PROCESS VALIDATION AND OUTPUT PROCESSING  INTEGRATED TESTING

Buzzibarter

2017-18

119

Unit Testing:  A unit testing is the portion of system implemented by a single programmer. Unit testing means exercising a unit in isolation from the rest of the system.  Testing was done and each module was compiled, tested and actual output was compared with the expected output.

Program Testing:  Testing was done by giving the arbitrary data and then verified against expected output.

Process Validation & Output Processing:  While testing only the necessary validation were given and the output generated on the account of the processing on the transactions were Yes accordingly.

Integrated Testing: Integrated testing is done to uncover the errors that are associated with the interfacing. Hence the main form is tested then the corresponding modules are yes

Buzzibarter

2017-18

120

6 LIMITATIONS OF SYSTEM An every system has its own advantages and disadvantages this proposed has also advantages as well as the limitations. The limitation of this site is describing below:  Admin cannot enter in the system without their correct email id and password  Admin can have all the data of user so admin provide them their particular user name and passwords.  Admin has their user name and password with the help of it they can access the system without user name and password they cannot do login.  Admin has only view and search internet Products. They cannot delete and update permission for customer.  User has their user name and password with the help of it they can enter in to the system without user name and password they cannot do login. 

Client can view only properties uploaded on site.

Buzzibarter

2017-18

121

7 FUTURE ENHANCEMENT OF THE PROJECT  We can make this system platform independent which means that it can work on any operating system.  The project has a very fast scope in future.  The project can be implemented on intranet in future.  Project can be updated in near future as and when requirement for the same arises.as it is very flexible in terms of expansion.  With the proposed software of database Space Manager ready and fully functional the client is now able to manage and hence run the entire work in a much better, accurate and error free manner.  More security is maintained.  Searching of any details can also be added. it becomes speed retrieval.  A method to transfer the web properties can be provided direct on the website.  A online payment gateway can make an effective way to transfer money over two user.  A E-wallet can also transaction easy and safe.

Buzzibarter

2017-18

122

8 BIBLIOGRAPHIES During the development of this project, we have referred following books. SR. No.

Name of books

Author

Publisher

1.

Beginning PHP4

Wankyu Choi , Allan

Wrox Press

Kent , Chris Lea ,Ganesh Prasad , Chris Ullman , Jon Blank , Sean Cazzell 2.

MySQL Bible

Steve Suehring

Wiley Publishing

3.

The Complete Reference

Thomas A. Powell

HTML 4.

Hill

Software Engineering A

Roger S. Pressman

practitioners Approach 5.

Analysis & Design Of An Integrated Approach to

Tata McGraw Hill

James A. Sen.

Information System. 6.

Tata McGraw

Tata McGraw Hill

PankajJalote

Software Engineering

Nasora Publishing House

Buzzibarter

2017-18

123

9 REFERENCES

http://www.php.net http://www.mysql.net http://wiki.php.net https://www.w3school.com https://stackoverflow.com/

Fontawesome.io/icons/ https://jsfiddle.net/ https://ckeditor.com/

https://github.com/

Buzzibarter

2017-18