Online Auction Report
Online Auction Report
Online Auction Report
ON
(PROJECT TITLE)
Submitted To
Mam Tanzila
Submitted By
Naseem Akhtar
Registration No
2017-2019
____________________
Student Name Naseem Akhtar
Registration No
____________________
Supervisor
Mam Tanzila
Institute of Computer Science and Information Technology
The Women University, Multan
____________________
External Examiner
Examiner Name
____________________
Director
Director Name
Institute of Computer Science and Information Technology
The Women University, Multan
EXORDIUM
I would like to express our special thanks of gratitude to our teacher “mam
tanzila” who gave me the golden opportunity to do this wonderful project on the topic
of “Auction system” which also helped me in doing a lot of research and I came to
know about so many new things. I am really thankful to my gratitude teacher.
Secondly, I would also like to thanks my parents and friends who helped me a
lot in finalizing this project within limited time.
Thank You
ABSTRACT
This project, An Online Auction System has two parts- customer interface and
admin interface. Customer Panel permits a customer to upload a product for sale and
bid on a particular product to buy. This system presents an online display of category
wised products they want to sell or bid. There is an admin panel by which an admin
can control the whole bidding system. Admin can approve products by the categories
and also can control the registered custoers. There is fixed delivery policy. After
finishing the bidding process there is a notify system to notify the sellers and bidders.
This is a fully dynamic system which can be easily operated by the users.
PROJECT BRIEF
The online auctioning system is a flexible solution for supporting lot- based
online auctions. The thesis explains the construction of an auction website. The
system has been designed to be highly-scalable and capable of supporting large
numbers of bidders in an active auction. The online auction system lets you easily
browse lots and place bids using a secure server. All cost of mailing lots will be paid
by the buyer. The objective is to develop a user-friendly auctioning site where any
kind of product can be auctioned and provide value added services to the bidders and
the sellers. The products will be authenticated and the site provides a safe
environment for online users.by using XAMPP, and MySQL database was used to
store the application data.
TABLE OF CONTENT
CHAPTER 1 INTRODUCTION 1
1.1. INTRODUCTION 2
1.2. OBJECTIVE OF PROJECT 2
1.3. SCOPE OF PROJECT 2
1.4. BENEFITS 3
1.5. SYSTEM REQUIREMENTS 3
1.5.1. SOFTWARE REQUIREMENTS 3
1.5.2. HARDWARE REQUIREMENTS 3
1.6. ORGANIZATION OF THESIS 4
1.7. SUMMARY 4
2.1. INTRODUCTION 6
2.2. EXISTING SYSTEM 6
2.3. ANALYSIS OF EXISTING SYSTEM 6
2.3.1. UNDERSTANDING THE SYSTEM 6
2.3.2. UNDERSTANDING INVOLVEMENT 6
2.3.3. DATA GATHERING 6
2.3.4. DATA ANALYSIS 6
2.3.5. SYSTEM REQUIREMENT 7
2.4. REQUIREMENT ANALYSIS 7
2.4.1. RAD MODEL 7
2.5. ADVANTAGE OF REQUIREMENT ANALYSIS 8
2.6. SUMMARY 8
4.1. INTRODUCTION 19
4.2. SOFTWARE REQUIREMENT SPECIFICATION 19
4.3. FUNCTIONAL REQUIREMENTS 20
4.3.1. ADMINS FUNCTIONAL REQUIREMENTS 20
4.3.2. USERS FUNCTIONAL REQUIREMENTS 20
4.3.3. COMMON FUNCTIONAL REQUIREMENTS 20
4.4. NON-FUNCTIONAL REQUIREMENTS 20
4.5. OPERATING ENVIRONMENT 20
4.6. USER CHARACTERISTICS 20
4.7. DESIGN & IMPLEMENTATION CONSTRAINTS 20
4.8. ASSUMPTIONS & DEPENDENCES 21
4.9. SUMMARY 21
5.1. INTRODUCTION 23
5.2. NORMALIZATION 23
5.3. HOW TO DESIGN DATABASE 23
5.4. ENTITIES OF THE SYSTEM 23
5.5. SUMMARY 24
7.1. INTRODUCTION 32
7.2. ADMIN PANEL 32
7.3. USER SITE 32
7.4. SUMMARY 32
8.1. CONCLUSION 34
8.2. HURDLES 34
8.3. FUTURE WORK 34
8.4. FEW WORDS IN THE END 34
REFERENCES 35
LIST OF FIGURES
1.7. Summary
This chapter explain the introduction of the project. It introduces about the
background of the project. Tells what is the scope of the projects, what are the
objectives of the project, what are the software requirements and as well as hardware
requirements and, in the end, tell organization of thesis.
CHAPTER 2
EXISTING SYSTEM &
REQUIREMENT ANALYSIS
2.1. Introduction
In this step the system before doing something is understood to improve its
functioning. In other words, we must first find out what is going on. It is essential for
system designer to understand the functioning of the system so that he can improve
the existing system. To understand the system, we must first involve in the system.
And sometimes this involvement in the system become very deep. During this system
designer greatly deals with the subject matter. So that he can know what is going on
and what he must do.
This can quickly give the customer something to see and use and to provide feedback
regarding the delivery and their requirements.
Diagram of INCREMENTAL-Model:
3.10. ER Diagram
An entity-relationship diagram (ERD) is a graphical representation of an information
system that shows the relationship between people, objects, places, concepts or events
within that system. An ERD is a data modeling technique that can help define
business processes and can be used as the foundation for a relational database.
While useful for organizing data that can be represented by a relational structure, an
entity-relationship diagram can't sufficiently represent semi-structured or unstructured
data, and an ERD is unlikely to be helpful on its own in integrating data into a pre-
existing information system.
Three main components of an ERD are the entities, which are objects or concepts that
can have data stored about them, the relationship between those entities, and the
cardinality, which defines that relationship in terms of numbers.
For example, an ER diagram representing the information system for a company's
sales department might start with graphical representations of entities such as the sales
representative, the customer, the customer's address, the customer's order, the product
and the warehouse. (See diagram) Then lines or other symbols can be used to
represent the relationship between entities, and text can be used to label the
relationships.
Finally, cardinality notations define the attributes of the relationship between the
entities. Cardinalities can denote that an entity is optional (for example, a sales rep
could have no customers or could have many) or mandatory (for example, the must be
at least one product listed in an order.)
Relationships: A relationship, in the context of databases, is a situation that exists
between two relational database tables when one table has a foreign key that
references the primary key of the other table. Relationships allow relational databases
to split and store data in different tables, while linking disparate data items.
Cardinality and ordinality, respectively, refer to the maximum number of times an
instance in one entity can be associated with instances in the related entity, and the
minimum number of times an instance in one entity can be associated with an instance
in the related entity. Cardinality and ordinality are
When it comes to notation, data modelers have many options to choose from. While
crow's foot notation is widely accepted as the most intuitive style, some developers
use OMT, IDEF, Bachman, or UML notation to indicate cardinality. Since crow's foot
notation shows both minimum and maximum cardinality in an easy-to-read graphic
format.
The three main cardinal relationships are:
One-to-one (1:1). For example, if each customer in a database is associated with one
mailing address.
One-to-many (1:M). For example, a single customer might place an order for multiple
products. The customer is associated with multiple entities, but all those entities have
a single connection back to the same customer.
Many-to-many (M:N). For example, at a company where all call center agents work
with multiple customers, each agent is associated with multiple customers, and
multiple customers might also be associated with multiple agents.
While there are tools to help draw entity-relationship diagrams, such as CASE
(computer-aided software engineering) tools, some relational database management
systems also have design capabilities built in.
Figure 7 Er Diagram
3.12. Summary
This chapter explain the proposed system and also describe the objective of it.
It tells the only a computerized system can fulfil our needs. Further it describes the
system design which is first step in development phase. It also explains the UML,
Goals of UML and usage scenario.
CHAPTER 4
SOFTWARE REQUIREMENT
SPECIFICATION
4.1. Introduction
This chapter presents the functional and non-functional requirement of the
system and it also discuss the guideline for system designer to start working on the
system.
4.9. Summary
This chapter is about the requirements of the system being developed. It
contains the features that present in the proposed system. It also describes working of
the system. It explains the operational, functional & non-functional requirement of the
system. Further, it contains environment in which the system will operate and the
users who will use the system.
CHAPTER 5
DATABASE DESIGN
5.1. Introduction
The most important phase of any project is design of database i.e. the
designing of different normalized tables and then the relationship between those
normalized tables. So, after a Comprehensive study of the existing system it is
decided to develop the normalized tables for the database. Before describing those
normalized tables, it will be better to understand the term normalization.
5.2. Normalization
Database Normalization is a technique of organizing the data in the database.
Normalization is a systematic approach of decomposing tables to eliminate data
redundancy(repetition) and undesirable characteristics like Insertion, Update and
Deletion Anomalies. It is a multi-step process that puts data into tabular form,
removing duplicated data from the relation tables.
Normalization is used for mainly two purposes,
• Eliminating redundant (useless) data.
• Ensuring data dependencies make sense i.e. data is logically stored.
The inventor of the relational model Edgar Codd proposed the theory of normalization
with the introduction of First Normal Form, and he continued to extend theory with
Second and Third Normal Form. Later he joined with Raymond F. Boyce to develop
the theory of Boyce-Codd Normal Form.
Theory of Data Normalization in SQL is still being developed further. For example,
there are discussions even on 6th Normal Form. However, in most practical
applications, normalization achieves its best in 3rd Normal Form. The evolution of
Normalization theories is illustrated below-
5.5. Summary
This chapter explains the database, structure of the database, the design of the
database. It discusses the entities of the database and their attributes. It also shows the
structure of the tables stored in the database of the proposed system.
CHAPTER 6
SYSTEM DEVELOPMENT &
TESTING
6.1. Platform Selection
Platform selection is very important step in software development. Because
software that you needed to develop or run may not be able to if a wrong platform is
selected. But since I am developing a php website which can be done on any platform
so I selected Windows 10 for OS. Because I am very much familiar with it.
6.2.1. PHP
The PHP Hypertext Pre-processor (PHP) is a programming language that
allows web developers to create dynamic content that interacts with databases. PHP is
basically used for developing web-based applications. PHP is an HTML-embedded
Web scripting language. This means PHP code can be inserted into the HTML of a
Web page. When a PHP page is accessed, the PHP code is read or "parsed" by the
server the page resides on. The output from the PHP functions on the page are
typically returned as HTML code, which can be read by the browser. Because the
PHP code is transformed into HTML before the page is loaded, users cannot view the
PHP code on a page. This make PHP pages secure enough to access databases and
other secure information.
A lot of the syntax of PHP is borrowed from other languages such as C, Java
and Perl. However, PHP has a number of unique features and specific functions as
well. The goal of the language is to allow Web developers to write dynamically
generated pages quickly and easily. PHP is also great for creating database-driven
Web sites.
6.2.2. JavaScript
JavaScript is a programming language commonly used in web development. It
was originally developed by Netscape as a means to add dynamic and interactive
elements to websites. While JavaScript is influenced by Java, the syntax is more
similar to C and is based on ECMAScript, a scripting language developed by Sun
Microsystems.
JavaScript is a client-side scripting language, which means the source code is
processed by the client's web browser rather than on the web server. This means
JavaScript functions can run after a webpage has loaded without communicating with
the server. For example, a JavaScript function may check a web form before it is
submitted to make sure all the required fields have been filled out. The JavaScript
code can produce an error message before any information is actually transmitted to
the server.
Like server-side scripting languages, such as PHP and ASP, JavaScript code
can be inserted anywhere within the HTML of a webpage. However, only the output
of server-side code is displayed in the HTML, while JavaScript code remains fully
visible in the source of the webpage. It can also be referenced in a separate .JS file,
which may also be viewed in a browser.
6.2.3. HTML/CSS
Hypertext Markup Language (HTML) is the standard markup language for
creating web pages and web applications. With Cascading Style Sheets (CSS) and
JavaScript, it forms a triad of cornerstone technologies for the World Wide Web.
Web browsers receive HTML documents from a web server or from local
storage and render the documents into multimedia web pages. HTML describes the
structure of a web page semantically and originally included cues for the appearance
of the document.
HTML can embed programs written in a scripting language such as
JavaScript, which affects the behavior and content of web pages. Inclusion of CSS
defines the look and layout of content. The World Wide Web Consortium (W3C),
maintainer of both the HTML and the CSS standards, has encouraged the use of CSS
over explicit presentational HTML since 1997.
Cascading Style Sheets (CSS) is a style sheet language used for describing the
presentation of a document written in a markup language like HTML. CSS is a
cornerstone technology of the World Wide Web, alongside HTML and JavaScript.
CSS is designed to enable the separation of presentation and content, including
layout, colors, and fonts. This separation can improve content accessibility, provide
more flexibility and control in the specification of presentation characteristics, enable
multiple web pages to share formatting by specifying the relevant CSS in a separate
.css file, and reduce complexity and repetition in the structural content.
The CSS specifications are maintained by the World Wide Web Consortium
(W3C). Internet media type (MIME type) text/css is registered for use with CSS by
RFC 2318 (March 1998). The W3C operates a free CSS validation service for CSS
documents. In addition to HTML, other markup languages support the use of CSS
including XHTML, plain XML, SVG, and XUL.
6.3.1. XAMPP
XAMPP is a free and open-source cross-platform web server solution stack
package developed by Apache Friends, consisting mainly of the Apache HTTP
Server, MariaDB database, and interpreters for scripts written in the PHP and Perl
programming languages. Since most actual web server deployments use the same
components as XAMPP, it makes transitioning from a local test server to a live server
possible.
XAMPP's ease of deployment means a WAMP or LAMP stack can be
installed quickly and simply on an operating system by a developer. With the
advantage a number of common add-in applications such as Wordpress and Joomla!
can also be installed with similar ease using Bitnami.
The term XAMPP is an apparent acronym. However, there is no official
acronym expansion specified on the Apache Friends website. Their homepage header
reads "XAMPP Apache + MariaDB + PHP + Perl", indicating that this abbreviation is
a recursive acronym.
6.3.3. MS Word
Word processing is an application program. It provides different tool to create
all kind of text documents. With word processor images, sounds, chart and graphics
can be added to the documents. Word processor can also be used to create web
documents. Hyperlinks, text and graphics can also be added to the web documents.
Different type of Word processing software is available as open source. Microsoft
office one of the famous that are available freely to be used different users.MS word
in also the component of the suite which is used in the project for documentation.
6.3.4. MS Visio
Microsoft Visio is software for drawing a variety of diagrams. These include
flowcharts, org charts, building plans, floor plans, data flow diagrams, process flow
diagrams, business process modeling, swimlane diagrams, 3D maps, and many more.
6.6. Summary
This chapter explains the platform selection and selections of tools which were
needed for the development of the project. It also discusses different type of testing
phases from which software has passed through to make sure this software is efficient.
It also explains some test cases.
CHAPTER 7
USER GUIDE
7.1. Introduction
This chapter will discuss the user interface. It describes all the modules of the system.
Working of the modules will be described with the help of screenshots. This will help
the users to easily understand the system.
7.3.2. Login
7.3.3. Register
7.3.4. Account
7.4. Summary
This chapter explain the user interface and working of all the modules with the help of
screenshots. Which make it very easy for user to understand the working of the
system.
CHAPTER 8
CONCLUSION & FUTURE
WORK
8.1. Conclusion
Online Auction System will give new approach and dimension to auction
system
It will encourage both Buyers and Sellers to participate in auction process
Removes geographical boundaries, location constraint and time constraint
Transparent process
No manual work
8.2. Hurdles
I have to face many hurdles. Few of them are listed below:
• This project is about Ecommerce. It was hard to find interface best suited for
this project and even making my own design
• Creating new design that is easy to understand
• Implementation of this design in the project
• TECHNOPEDIA
https://www.techopedia.com
• UML-DIAGRAM
http://www.uml-diagrams.org
• GURU99
https://www.guru99.com/
• W3SCHOOL
https://www.w3schools.com/
• WIKIPEDIA
https://www.wikipedia.org/