Chapter-1

INTRODUCTION OF THE PROJECT KBC QUIZ

SYSTEM

The “KBC quiz System” has been developed to override the problem
prevailing in the practicing manual system. This software is supported to
eliminate and in some cases reduce the hardships faces by this existing
system. Moreover this system is designed for the particular need of the
company to carry out operations in a smooth and effective manner.
This application is reduced as much as possible to avoid errors while entering
the data. No formal knowledge is needed for the user to use this system. Thus
by this all it proves it is user-friendly. KBC Quiz System, as described above,
can lead to error free, secure, reliable and fast management system. It can
assist the user to concentrate on their other activities rather to concentrate on
the record keeping. Thus it will help organization in better utilization of
resources.
Every organization, whether big or small, has challenges to overcome and
managing the information of Answers, Questions, Participants, Levels, Points.
Every KBC Quiz System has different Questions need, therefore we design
exclusive employee management systems that are adapted to your managerial
requirements. This is designed to assist in strategic planning, and will help
you ensure that your organization is equipped with the right level of
information and details for your future goals. Also, for those busy executive
who are always on the go, our systems come with remote access features,
which will allow you to manage your workforce anytime, at all times. These
systems will ultimately allow you to better manage resources.
ABSTRACT OF THE PROJECT KBC QUIZ SYSTEM:
The purpose of KBC Quiz System is to automate the existing manual
system by the help of computerized equipment and full-fledged computer
software, fulfilling their requirements, so that their valuable data/information
can be stored for a longer period with easy accessing and manipulation of the
same. The required software and hardware are available and easy to work
with.
KBC Quiz System, as described above, can lead to error free, secure,
reliable and fast management system. It can assist the user to concentrate on
their other activities rather to concentrate on the record keeping. Thus it will
help organization in better utilization of resources. The organization can
maintain computerized records without redundant entries. That means that one
need not to be distracted by information that is not relevant, while being able
to reach the information.
The aim is to automate its existing manual system by the help of
computerized equipment and full-fledged computer software, fulfilling their
requirements, so that their valuable data/information can be stored for a longer
period with easy accessing and manipulation of the same. Basically the project
describes how to manage for good performance and better services for the
clients.
 PLATFORMS USED:
Operating Systems: Microsoft Windows
Technologies used:
Front End: HTML and Javascript
Web designing language: PHP.
RDBMS (Back end): MySQL.
Software Requirements:
PHP 5.0
APACHE HTTP Server
Dreamweaver, FrontPage for Front End Programming
Microsoft Windows or Linux

Hardware Requirements:
Intel Pentium IV processor or equivalent or higher
512 MB RAM or Higher
20 GB HDD or Higher
Network Connectivity
OBJECTIVE OF PROJECT ON KBC QUIZ SYSTEM:
KBC Quiz System is a web based application which has been developed
over PHP and MySQL and runs on WAMP, XAMP or Apache2 server. The
main objective of the Project on KBC Quiz System is to manage the details of
Question, Answer, Patterns, Participants, Points. It manages all the
information about Questions, Levels, Points, Questions. The project is totally
built at administrative end and thus only the administrative is guaranteed the
access. The purpose of the project is to build an application program to reduce
the manual work for managing the Questions, Answers, Level, Patterns. It
tracks all the details about the Patterns, Participants, Points.

FUNCTIONALITIES PROVIDED BY KBC QUIZ

SYSTEM ARE AS FOLLOWS:
 Provides the searching facilities based on various factors. Such as
Questions, Patterns, Participants, Points.
 KBC Quiz System also manages the Level details online for
participants details, points details, questions.
 It tracks all the information of Answers, Level, Participants etc.
 Manage the information of answers.
 Show the information and description of the Questions, Patterns.
 To increase efficiency of managing the Questions, Answers.
 It deals with monitoring the information and transactions of
Participants.
 Managing the information of Questions.
  Editing, adding and updating of records is improved which results in
proper resources managements of Questions data.
 Manage the information of Participants.
 Integration of all records of Points.

SCOPE OF THE PROJECT ON KBC QUIZ SYSTEM:

It may help collecting perfect management in details. In a very
short time, the collection will be obvious, simple and sensible. It will help a
person to know the management of passed year perfectly and vividly. It
also reduced the cost of collecting the management & collection procedure
will go on smoothly.
Our project aims at Business process automation, i.e. we have tried
to computerized various processes of KBC Quiz System.

 In computer system, the person has to fill various forms & number of
copies of the forms can be easily generated at a time.
 In computer system, it is not necessary to create the manifest but we
can directly print it, which saves our time.
 To assist the staff in capturing the efforts spent on their respective
working areas.
 To utilize resources in an efficient manner by increasing their
productivity through automation.
 The system generates types of information that can be used for
various purposes.
 It satisfy user requirement.
 Be easy to understand by the user and operator.
 Be easy to operate
  Have a good user interface
 Be expandable
 Delivered on schedule within the budget.

REPORTS OF KBC QUIZ SYSTEM:

 It generates the report on Questions, Answers, Level
 Provide filter reports on Patterns, Participants, Points
 You can easily export PDF for Questions, Levels, Participants
 Application also provides excel export for Answers, Patterns, Points
 You can also export the report into CSV format for Questions,
Answers, Points

MODULES OF KBC QUIZ SYSTEM:

 Questions Management Module: Used for managing the Questions
details.
 Points Module: Used for managing the details of Points.
 Level Module: Used for managing the details of Level.
 Answers Management Modules: Used for managing the information
and details of the Answers.
 Patterns Modules: Used for managing the Patterns details.
 Participants Modules: Used for managing the Participants
information.
  Login Modules: Used for managing the users of the system.

DATABASE DEFINITION OF KBC QUIZ SYSTEM

 The detail of question is store into the questions tables respective with
all tables.
 Each entity (Levels, Patterns, Points, Answers, Questions) contains
primary key and unique keys.
 The entity Patterns, Points has bind with Questions, Answers entities
with foreign key.
 There is one-to-one and one-to-many relationship available between
points, Participants, Levels, Questions.
 All the entities Levels, Patterns, Points, Questions are normalized and
reduce duplicate of records.
 We have implemented indexing on each table of KBC Quiz System
tables for fast query execution.

SUPER ADMIN FUNCTIONALITY OF KBC QUIZ

SYSTEM:
 Admin can add edit Delete, and view records of Questions, Points,
Patterns, Level.
 Admin can manage all the details of Answers, Patterns, Participants,
Point.
  Admin can also generate reports of Questions, Answers, Patterns,
Participant.
 Admin can search the details of Questions, Points, Patterns, Level.
 Admin can apply different level of filters on report of Questions,
Patterns, Levels.
 Admin can track the detailed information of Points, Levels, Questions,
and Answers.

LIMITATIONS OF KBC QUIZ SYSTEM:

Run time report generation is not available in KBC Quiz system.
We have not implemented the dynamic report for Patterns, Participants,
Questions answers, Points, Levels.
This project KBC Quiz System has not been developed on model view
controller architecture so it is very complex to manage.
Batch mode execution for Off-line reports of Questions, Participants, Levels
cannot be generated.
Crystal report has not been integrated.
KBC QUIZ SYSTEM CLASS DIAGRAM:
KBC Quiz System Class Diagram describes the structure of a KBC Quiz
System classes, their attributes, operations (or methods), and relationships
among objects. The main classes of the KBC Quiz System are Questions,
Answers, Patterns, Participants, Points, Level.
Classes of KBC Quiz System class diagram:

 Questions Class: Manage all the operations of Questions.

 Answers Class: Manage all the operations of Answers.
 Patterns Class: Manage all the operations of Patterns.
 Participants Class: Manage all the operations of Participants.
 Points Class: Manage all the operations of Points.
 Level Class: Manage all the operations of Level.

CLASSES AND THEIR ATTRIBUTES OF KBC QUIZ

SYSTEM CLASS DIAGRAM:

 Questions Attributes: question_id, question_title, question_type,

question_description
 Answers Attributes: answer_id, answer_title, answer_type,
answer_description
 Patterns Attributes: pattern_id, pattern_title, pattern_type,
pattern_description
  Participants Attributes: participant_id, participant_title,
participant_type, participant_description
 Points Attributes: point_id, point_title, point_type, point_description
 Level Attributes: level_id, level_title, level_type, level_description

CLASSES AND THEIR METHOD OF KBC QUIZ

SYSTEM CLASS DIAGRAM:

Questions Method: addQuestions(), editQuestions() ,deleteQuestions(),

updateQuestions(), saveQuestions(), searchQuestions().
Answers Method: addAnswers(), editAnswers() ,deleteAnswers(),
updateAnswers(), saveAnswers(), searchAnswers().
Pattern Method: addPattern(), editPattern() ,deletePattern(), updatePattern(),
savePattern(), searchPattern().
Participant Method: addParticipant(), editParticipant() ,deleteParticipant(),
updateParticipant(), saveParticipant(), searchParticipant().
Point Methods: addPoint(), editPoint() ,deletePoint(), updatePoint(),
savePoint(), searchPoint().
Level Methods: addLevel(), editLevel() ,deleteLevel(), updateLevel(),
saveLevel(), searchLevel().
CLASS DIAGRAM OF KBC QUIZ SYSTEM:
INPUT DATA AND VALIDATION OF PROJECT ON
KBC QUIZ SYSTEM:

 All the fields such as Questions, Patterns, Points are validated and does
not take invalid values.
 Each form for Questions, Answers, Levels cannot accept blank value
fields.
 Avoiding errors in data.
 Controlling amount of input.
 Integration of all the modules/forms in the system.
 Preparation of the test cases.
 Preparation of the possible test data with all the validation checks.
 Actual testing done manually.
 Recording of all the reproduced errors.
 Modifications done for the errors found during testing.
 Prepared the test result scripts after rectification of the errors.
 Functionality of the entire module/forms.
 Validations for user input.
 Checking of the Coding standards to be maintained during coding.
 Testing the module with all the possible test data.
 Testing of the functionality involving all types of calculations etc.
 Commenting standards in the source files.
THE SOFTWARE QUALITY PLAN WE WILL USE
THE FOLLOWING SAQ STRATEGY:

 In the first step, we will select the test factors and rank them. The
selected test factors such as reliability, maintainability, portability
or etc., will be placed in the matrix according to their ranks.
 The second step is for identifying the phases of the development
process. The phase should be recorded in the matrix.
 The third step is that identifying the business risks of the software
deliverables.
 The risks will be ranked into three ranks such as high, medium
and low.

FEATURES OF THE PROJECT KBC QUIZ SYSTEM:

 Product and Component based.

 Creating & Changing issues at ease.
 Query Issues List to any depth.
 Reporting & Charting in more comprehensive way.
 User Accounts to control the access and maintain security.
 Simple Status & Resolutions.
 Multi-level Priorities & Severities.
 Targets & Milestones for guiding the programmers.
 Attachments & Additional comments for more information.
 Robust database back-end.
 Various levels of reports available with a lot of filter criteria’s.
 It contains better storage capacity.
 Accuracy in work.
 Easy & fast retrieval of information.
 Well design reports.
 Decrease the load of the person involve in existing manual system.
 Access of any information individually.
 Work becomes very speedy.
 Easy to update information.
Chapter2
SOFTWARE REQUIREMENT SPECIFICATION
The Software Requirements Specification is produced at the
culmination of the analysis task. The function and performance allocated to
software as part of system engineering are refined by establishing a complete
information description, a detailed functional and behavioral description, an
indication of performance requirements and design constraints, appropriate
validation criteria, and other data pertinent to requirements.

The proposed system has the following requirements:

 System needs store information about new entry of Questions.

 System needs to help the internal staff to keep information of Answers
and find them as per various queries.
 System need to maintain quantity record.
 System need to keep the records of Patterns.
 System need to update and delete the records.
 It also needs a security system to prevent data.
Use Case Model:

Identification of need:

The old manual was suffering from a series of drawbacks. Since

whole of the system was to be maintained with hands the process of
keeping, maintaining and retrieving the information was very tedious
and lengthy. The records were never used to be in a systematic order.
They are used to be lots of difficulties in associating any particular
 transaction with a particular context. If any information was to be found
it was required to go through the different registers, documents. There
would never exist anything like report generation. There would always
be unnecessary consumption of time while entering records and
retrieving records. One more problem was that it was very difficult to
find errors while entering the records. Once the records were entered it
was very difficult to update these records.
The reason behind it is that there is lot of information to be
maintained and have to be kept in mind while running the business. For
this reason we have provided features Present system is partially
automated (computerized), actually existing system is quite laborious as
one has to enter same information at three different places.

Following points should be well considered:

 Documents and reports that must be provided by the new system: there
can also be few reports, which can help management in decision-
making and cost controlling, but since these reports do not get required
attention, such kind of reports and information were also identified and
given required attention.
 Details of the information needed for each document and report.
 The required frequency and distribution for each document.
 Probable sources of information for each document and report.
 With the implementation of computerized system, the task of keeping
records in an organized manner will be solved. The greatest of all is the
retrieval of information, which will be at the click of the mouse. So the
 proposed system helps in saving the time in different operations and
making information flow easy giving valuable reports.

FEASIBILITY STUDY:
After doing the project KBC Quiz System, study and analyzing
all the existing or required functionalities of the system, the next task is
to do the feasibility study for the project. All projects are feasible- given
unlimited resources and infinite time.

Feasibility study includes consideration of all the possible ways to

provide a solution to the given problem. The proposed solution should
satisfy all the user requirements and should be flexible enough so that
future changes can be easily done based on the future upcoming
requirements.

A Feasibility study aims to objectively and rationally uncover the

strengths and weakness of an existing business or proposed venture,
opportunities and threats present in the natural environment, the
resources required to carry through, and ultimately the prospects for
success. In its simplest terms, the two criteria to judge feasibility are
cost required and value to be attained.
A well-designed feasibility study should provide a historical
background of the business or project, a description of the product or
service, accounting statements, details of the operations and
management, marketing research and policies, financial data, legal
requirements and tax obligations. Generally, feasibility studies precede
technical development and project implementation.
 A feasibility study evaluates the project’s potential for success;
therefore, perceived objectivity is an important factor in the credibility
of the study for potential investors and lending institutions. It must
therefore be conducted with an objective, unbiased approach to provide
information upon which decisions can be based.

A. Economical Feasibility:
This is a very important aspect to be considered while developing a
project. We decided the technology based on minimum possible cost
factor.

 All hardware and software cost has to be borne by the organization.

 Overall we have estimated that the benefits the organization is going
to receive from the proposed system will surely overcome the initial
costs and the later on running cost for system.

B. Technical feasibility:
This assessment is based on an outline design of system requirements,
to determine whether the company has the technical expertise to handle
completion of the project. When writing a feasibility report, the following
should be taken to consideration:

 A brief description of the business to assess more possible factors which

could affect the study
 The part of the business being examined
 The human and economic factor
 The possible solutions to the problem
At this level, the concern is whether the proposal is
both technically and legally feasible (assuming moderate cost).
The technical feasibility assessment is focused on gaining an understanding of
the present technical resources of the organization and their applicability to
the expected needs of the proposed system. It is an evaluation of the hardware
and software and how it meets the need of the proposed system

Method Of Production
The selection among a number of methods to produce the same commodity
should be undertaken first. Factors that make one method being preferred to
other method in agricultural projects are the following:

 Availability of inputs or raw materials and their quality and prices.

 Availability of markets for outputs of each method and the expected prices
for these outputs.
 Various efficiency factors such as the expected increase in one additional
unit of fertilizer or productivity of a specified crop per one dunum.

Production technique
After we determine the appropriate method of production of a commodity, it
is necessary to look for the optimal technique to produce this commodity.

Project requirements
Once the method of production and its technique are determined, technical
people have to determine the projects' requirements during the investment and
operating periods. These include:

 Determination of tools and equipment needed for the project such as

drinkers and feeders or pumps or pipes …etc.
 Determination of projects' requirements of constructions such as buildings,
storage, and roads …etc. in addition to internal designs for these
requirements.
 Determination of projects' requirements of skilled and unskilled labor and
managerial and financial labor.
 Determination of construction period concerning the costs of designs and
consultations and the costs of constructions and other tools.
 Determination of minimum storage of inputs, cash money to cope with
operating and contingency costs.

Project location
The most important factors that determine the selection of project location are
the following:

 Availability of land (proper acreage and reasonable costs).

 The impact of the project on the environment and the approval of the
concerned institutions for license.
 The costs of transporting inputs and outputs to the project's location (i.e.,
the distance from the markets).
 Availability of various services related to the project such as availability of
extension services or veterinary or water or electricity or good roads ...etc.

C.Operational Feasibility:
Operational feasibility is the measure of how well a proposed system
solves the problems, and takes advantage of the opportunities identified
during scope definition and how it satisfies the requirements identified in the
requirements analysis phase of system development.
The operational feasibility assessment focuses on the degree to which the
proposed development project fits in with the existing business environment
and objectives with regard to development schedule, delivery date, corporate
culture and existing business processes.
To ensure success, desired operational outcomes must be imparted during
design and development. These include such design-dependent parameters as
reliability, maintainability, supportability, usability, producibility,
disposability, sustainability, affordability and others. These parameters are
required to be considered at the early stages of design if desired operational
behaviors are to be realised. A system design and development requires
appropriate and timely application of engineering and management efforts to
meet the previously mentioned parameters. A system may serve its intended
purpose most effectively when its technical and operating characteristics are
engineered into the design. Therefore, operational feasibility is a critical
aspect of systems engineering that needs to be an integral part of the early
design phases.
Chapter3
SYSTEM DESIGN OF KBC QUIZ SYSTEM:

In this phase, a logical system is built which fulfills the given

requirements. Design phase of software development deals with
transforming the client’s requirements into a logically working system.
Normally, design is performed in the following two steps:

1. Primary Design Phase:

In this phase, the system is designed at block level. The blocks are
created on the basis of analysis done in the problem identification
phase. Different blocks are created for different functions emphasis
is put on minimizing the information flow between blocks. Thus, all
activities which require more interaction are kept in one block.

2. Secondary Design Phase:

In the Secondary phase, the detailed design of every block is
performed
.

The general tasks involved in the design process are the

following:
1. Design various blocks for overall system processes.
2. Design smaller, compact and workable modules in each block.
3. Design various database structures.
4. Specify details of programs to achieve desired functionality.
5. Design the form of inputs, and outputs of the system.
 6. Perform documentation of the design.
7. System reviews.

USER INTERFACE DESIGN:

User interface design is concerned with the dialogue between a
user and the computer. It is concerned with everything from starting the
system or logging into the system to the eventually presentation of desired
inputs and outputs. The overall flow of screens and messages is called a
dialogue.
User interface design (UI) or user interface engineering is the design of user
interfaces for machines and software, such as computers, home appliances,
mobile devices, with the focus on maximizing usability and the user
experience. The goal of user interface design is to make the user’s interaction
as simple and efficient as possible, in terms of accomplishing user goals (user-
centered design).

Good user interface design facilities finishing the task at hand without
drawing unnecessary attention to itself. Graphic design and typography are
utilized to support its usability, influencing how the user performs certain
interactions and improving the aesthetic appeal of the design; design
aesthetics may enhance or detract from the ability of users to use the functions
of the interface. The design process must balance technical functionality and
visual elements (e.g., mental model) to create a system that is not only
operational but also usable and adaptable to changing user needs.
Interface design is involved in a wide range of projects from computer
systems, to cars, to commercial planes; all of these projects involve much of
the same basic human interactions yet also require some unique skills and
knowledge. As a result, designers tend to specialize in certain types of projects
and have skills centered on their expertise, whether that be software design,
user research, web design, or industrial design.

The following steps are various guidelines for User Interface

Design:
1. The system user should always be aware of what to do next.
2. The screen should be formatted so that various types of information,
instructions and messages always appear in the same general display
area.
3. Messages, instruction or information should be displayed long enough to
allow the system user to read them.
4. Use display attributes sparingly.
5. Default values for fields and answer to be entered by the user should be
specified.
6. A user should not be allowed to process without correcting an error.
7. The system user should never get an operating system message or fatal
error.
Chapter4

DESIGN PHASE

1. Introduction

1.1) Scope and purpose

The purpose of the design phase is to develop a clear
understanding of what the developer want people to gain from
his/her project. As you the developer work on the project, the
test for every design decision should be “Does this feature fulfill
the ultimate purpose of the project?”
A purpose statement affects the design process by
explaining what the developer wants the project to do, rather
than describing the project itself.
The design document will verify that the current
design meets all of the explicit requirements contained in the
system model as well as the implicit requirements desired by the
customer.

1.2) Overall System Design Objectives

The overall system design objectives is to provide an
efficient, modular design that will reduce the system’s
complexity, facilitate change and result in an easy
implementation. This will be accomplished by designing
strongly cohesion system with minimal coupling. In addition,
this document will provide interface design models that are
 consistent user friendly and will provide straight forward
transition through the various system functions.

1.3) Structure of Design Document

System Architecture design— The system architecture

section has detailed diagram of the system, server and client
architecture.
Data Design— The data design include an ERD as well as
Database design.
Functional Design Description— This section has the
functional partitioning from the SRS, and goes into great detail
to describe each function.

2. System Architecture Design

2.1) System Architecture

The SIMS is a system which contains major part.
The user selects one of the available options as an input to the
system. According to the input by the user the system acts and
the rest of the functions are performed accordingly. The
administrator can operate on any user details. But the normal
users can only access their details of all the functionalities.
3. Data Design

3.1) Entity Relationship Diagram:

This ER (Entity Relationship) Diagram represents the models
of KBC Quiz System Entity. The entity-relationship diagram
of KBC Quiz System shows all the visual instrument of
database tables and the relations between Answers,
Participants, Questions, Levels, etc. It used structure data and
to define the relationships between structured data groups of
KBC Quiz System functionalities. The main entities of the
KBC Quiz System are Questions, Answers, Patterns,
Participants, Points, and Levels.
Kbc Quiz System Entities And Their Attributes:

 Questions Entity: Attributes of Questions are question_id,

question_title, question_type, question_description
 Answers Entity: Attributes of Answers are answer_id, answer_title,
answer_type, answer_description
 Patterns Entity: Attributes of Patterns are pattern_id, pattern_title,
pattern_type, pattern_description
 Participants Entity: Attributes of Participants are participant_id,
participant_title, participant_type, participant_description
 Points Entity: Attributes of Points are point_id, point_title, point_type,
point_description
 Level Entity: Attributes of Level are level_id, level_title, level_type,
level_description

Description Of Kbc Quiz System Database:

 The detail of Questions is store into the Questions tables respective

with all tables.
 Each entity (Level, Patterns, Points, Answers, Questions) contain
primary key and unique keys.
 The entity Patterns, Points has binded with Questions, Answers
entities with foreign key
 There is one-to-one and one-to-many relationships available between
Points, Participants, Level, Questions
  All the entities Questions, Points, Patterns, Level are normalized and
reduce duplicate of records
 We have implemented indexing on each table of KBC Quiz System
tables for fast query execution

4. Functional Design Description:

 4.1) Data Flow Diagram:
KBC Quiz System Data flow diagram is often used as a
preliminary step to create an overview of the Quiz without
going into great details, which can later be elaborated. It
normally consists of overall application dataflow and
processes of the Quiz process. It contains all of the userflow
and their entities such all the flow of Questions, Answers,
Login, Patterns, participants, Points, Level. All of the below
diagram has been used for the visualization of data processing
and structured design of the Quiz process and working flow.

ZERO Level Data Flow Diagram (0 level DFD) of KBC Quiz

System:
This is the Zero Level DFD of KBC Quiz System, where we have elaborated
the high level process of Quiz. It’s a basic overview of the whole KBC Quiz
System or process being analyzed or modeled. It’s designed to be an at-a-
glance view of Participants, Points and Level showing the system as a single
high-level process, with its relationship to external entities of Questions,
Answers and Login. It should be easily understood by a wide audience,
including Questions, Login and Participants. In zero level DFD of KBC Quiz
System, we have described the high level flow of the Quiz system.
High Level Entities and processes flow of KBC Quiz System:
 Managing all the Questions
 Managing all the Answers
 Managing all the Login
 Managing all the Patters
 Managing all the Participants
 Managing all the Points
 Managing all the Level
First Level Data Flow Diagram (1st Level DFD) of KBC Quiz
System:
First Level DFD (1st level) of KBC Quiz System shows how the
system is divided into sub-systems (processes), each of which deals with one
or more of the data flows to or from an external agent, and which together
provide all of the functionality of the KBC Quiz System as a whole. It also
identifies internal data stores of Level, Points, Participants, Patters, Login that
must be present in order for the Quiz system to do its job, and shows the flow
of data between the various parts of Questions, Login, Points, Level,
Participants of the system. DFD Level 1 provides a more detailed breakout of
pieces of the 1st level DFD.

Main entities and output of First Level DFD (1st level DFD):

 Processing Questions records and generate report of all Questions

 Processing Answers records and generate report of all Answers
 Processing ##keyword3## records and generate report of all Login
 Processing Patters records and generate report of all Patters
 Processing Participants records and generate report of all Participants
 Processing Points records and generate report of all Points
 Processing Level records and generate report of all Level
Second Level Data Flow Diagram (2nd level DFD) of KBC Quiz System:
DFD Level 2 then goes one step deeper into parts of Level 1 of Quiz.
It may require more functionalities of Quiz to reach the necessary level of
detail about the Quiz functioning. First level DFD (1st Level) of KBC Quiz
System shows how the system is divided into sub-systems (processes). The 2nd
Level DFD contains more details of Level, Points, Participants, Patters, Login,
Answers, Questions.
Low level functionalities of KBC Quiz System:
 Admin Login to the system and manage all the functionalities of KBC
Quiz System.
 Admin can add, edit, delete and view the records of Questions, Login,
Participants, Level
 Admin can manage all the details of Answers, Patters, Points
 Admin can also generate reports of Questions, Answers, Login, Patters,
Participants, Points.
 Admin can search the details of Answers, Participants, Points
 Admin can apply different level of filters on report of Questions,
Patters, Participants
 Admin can tracks the detailed information of Answers, Login, Patters,
Participants
5. Conclusion :

Hence we can conclude that the design phase of the SIMS gives
us the information of all the process used in the project and their relation.

Chapter6
TECHNOLOGY OVERVIEW

The technology selected for implementing KBC Quiz System is

PHP/MySQL. Apache is used as the HTTP server. The development was
done in a “windows” environment.

PHP:

PHP is a server-side scripting language designed for web

development but also used as a general-purpose programming language. It
is originally created by Rasmus Lerdorf in 1994, the PHP reference
implementation is now prodeuced by the PHP Group. PHP originally stod
for personal Home Page, but it now stand s for the recursive acronym
PHP: Hyper Text Preprocessor.

PHP code may be embedded into HTML code , or it can be used in

combination with various web template systems, web content
management systems, and web framework. 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 many bean
type of data, including images, with the generated web page. PHP code
may also be executed with a command-line interface (CLI) and can be
used ot implement standalone graphical applications.

The standard PHP interpreter, powered by the Zend Engine, 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.

The PHP language evolved without a written formal specification or

standard until 2014, leaving the canonical PHP interpreter as a de facto
standard. Since 2014, work has gone on to create a formal PHP
specification.

During the 2010s there have been increased efforts towards

standardization and code sharing in PHP applications by projects such as
PHP-FIG (http://www.php-fig.org) in the form of PSR-initiatives
(http://www.php-fig.org/psr/) as well as composer dependency manager
and the Packagist repository (https://packagist.org/). PHP hosts a diverse
array of web frameworks requiring framework-specific knowledge, with
Laravel recently emerging as a popular option by incorporating ideas
made popular from other competing non-PHP web frameworks, like Ruby
on Rails.

MySQL:

MySQL is an open-source relational database management system

(RDBMS). Its name is a combination of “My”, the name of co-founder
Michael Widenius’s daughter, and “ SQL”, the abbreviation for Structured
Query Language. The MySQL development project has made its source
code available 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 we application

software stack (and other “AMP” stacks). LAMP is an acronym for
‘Linux, Apache, MySQL, Perl/PHP/Python”. Applications that use the
MySQL database include: TYPO3, MODX, Joomla, WordPress, Simple
Machines Forum, 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.
The MySQL server software itself and the client libraries use dual-
licensing distribution. They are offered under GPL version 2, beginning
from 28 June 2000 (which in 2009 has been extend with a FLOSS License
Exception) or to use a proprietary license

Apache:

The Apache HTTP Server, colloquially called Apache, is a free and open-
source cross platform web server, released under the terms of Apache License
2.0. Apache is developed and maintained by an open community od
developers under the auspices of the Apache Software Foundation.
The Apache HTTP Server is cross-platform: as of 1 June 2017 92% of
Apache HTTPS server copies run on Linux distributions. Version 2.0
improved support for non-Unix operating systems such as Windows and
OS/2. Old versions of Apache were ported to run on OpenVMS and
NetWare.

Originally based on the NCSA HTTPd server, development of Apache

began in early 1995 after work on the NCSA code stalled. Apache played
a key role in the initial growth of the World Wide Web, quickly
overtaking NCSA HTTPd as the dominant HTTP server, and has
remained most popular since April 1996. In 2009,it became the first web
server software to serve more than 100 million websites. As of July 2016,
it was estimated to serve 46% of all active websites and 43% of the top
million websites.

Apache supports a variety of features, many implemented as complied

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, Tcl and PHP.
Popular authentication modules include mod_access, mod_auth,
mod_digest, and mod_auth_digest, the successor mod_digest. A sample
of other features include Secure Sockets Layer and Transport Layer
Security support (mod_ssl), a proxy module (mod_proxy), a URL
rewriting module (mod_rewrite), custom log files (mod_log_config), and
filtering support (mod_include and mod_ext_filter).

The Apache HTTP server Project is a collaborative software development

effort aimed at creating a robust, commercial-grade feature-rich and freely
available source code implementation of an HTTP (Web) server. The
project is jointly managed by a group of volunteers located around the
 world, using the internet and the Web to communicate, plan, and develop
the server and its related documentation. This project is part of the Apache
Software Foundation. In addition, hundreds of users have contributed
ideas, code, and documentation to the project.

Apache 2.4 dropped support for BeOS, TPF and even older platforms.

XAMPP:
XAMPP is a small and light Apache distribution containing the
most common web development technologies in a single package. Its
contents, small size, and portability make it the ideal tool for students
developing and testing applications in PHP and MySQL. XAMPP is available
as a free download in two specific packages: full and lite. While the full
package download provides a wide array of development tools, XAMPP Lite
contains the necessary technologies that meet the Ontario Skills Competition
standards. The light version is a small package containing Apache HTTP
server, PHP, MySQL, phpMyAdmin, Openssl, and SQLite.

Obtaining and Installing XAMPP:

As previously mentioned, XAMPP is a free XAMPP packages
and add-ons are package available for download and use distributed
through the Apache Friends website at the address:
http://www.apachefriends.org/. once on the website, navigate and find the
windows version of XAMPP and download the self-extracting Zip
archive. After downloading the archive, run and extract path for a local
Windows installation would simply be C:\. If extracted properly we will
notice a new XAMPP directory in the root of our installation disk. In
order to test that everything has been installed correctly, first start the
Apace HTTP server by navigating to the XAMPP directory and clicking
on the apache-start.bat batch file.
Next we will test if the server is running correctly by opening an internet
browser and typing http://localhost/ into the address bar.if configured
correctly, we will be presented with a screen similar to that of the one
below:

In order to stop all Apache processes we do not close the running terminal
application, but instead run another batch file in the xampplite directory
called apache_stop.bat.
Chapter7

CREATING A DATABASE AND INSERTING DATA:

Now that we have run and test Apache and PHP, the next step is running
MySQL and creating a database and table which will hold information to
be used by our website. In order to start MySQL, navigate to the XAMPP
directory and run the mysql_start.bat batch file. The XAMPP package
contains an application called phpMyAdmin which allows developers to
administer and maintain MySQL databases. We will be using
phpMyAdmin to create a database and table, and enter test data. Before
testing phpMyAdmin , make sure that both Apache and MySQL are
running by opening their respective batch files: apache_start.bat and
mysql_start.bat. along with Apache and MySQL running in the
background, we type http://localhost/phpMyAdmin/ into our web
browser. If successful we will be presented with a phpMyAdmin start
page similar to the one shown below:
Thus we have learned to create a database in MySQL by executing sql
statements. After creating the database tables we are now ready to use them in
our website “KBC Quiz System”.
PRELIMINARY PRODUCT DESCRIPTION:
The first step in the system development life cycle is the
preliminary investigation to determine the feasibility of the system. The
purpose of the preliminary investigation is to evaluate project requests. It is
not a design study nor does it include the collection of details to describe the
business system in all respect. Rather, it is the collection of information that
helps committee members to evaluate the merits of the project request and
make an informed judgment about the feasibility of the proposed project.

Analysts working on the preliminary investigation should

accomplish the following objectives:

 Clarify and understand the project request.

 Determine the size of the project.
 Access costs and benefits of alternative approaches.
 Determine the technical and operational feasibility of alternative
approaches.
 Report the findings to management, with recommendations outlining
the acceptance or rejection of the proposal.

 Benefit to organization
The organization will obviously be able to gain benefits such as
savings in operating cost, reduction in paperwork, better utilization of
human resources and more presentable image increasing goodwill.
 The Initial Cost
The initial cost of setting up the system will include the cost of
hardware software (OS, add-on software, utilities) & labor (setup &
maintenance). The same has to bear by the organization.

 Running Cost
Besides, the initial cost the term cost will include the running
cost for the system including the AMC, stationary charges, cost for
human resources, cost for update/renewal of various related software.

 Need For Training

The users along with the administrator need to be trained at the
time of implementation of the system. The client will provide the
training site.

We talked to the management people who were managing the

financial issues of the center, the staff who were keeping the records in
lots of registers and the reporting manager regarding their existing
system, their requirements and their expectations from the new
proposed system. Then, we did the system study of the entire system
based on their requirements and the additional features they wanted to
incorporate in this system.

Reliable, accurate and secure data was also considered to be a

complex task without proposed system. Because there was no such
record for keeping track of all the activities, which was done by the
KBC Quiz System on the daily basis.
 The new system proposed and then developed by me will ease
the task of the organization in consideration. It will be helpful in
generating the required reports by the staff, which will help them to
track their progress and services.

Thus, it will ease the task of Management to a great extent as

all the major activities to be performed, are computerized through this
system.
Chapter8
PROJECT CATEGORY:

Relational Database Management System (RDMS) : This is an

RDBMS based project which is currently using MySQL for all
transaction statements. MySQL is an open source RDBMS System.

Brief Introduction about RDBMS:

A relational database management system (RDBMS) is a database

management system (DBMS) that is based on the relational model as
invented by E. F. Codd, of IBM’s San Jose Research Laboratory. Many
popular database currently in use are based on the relational database
model.

RDBMSs have become a predominant choice for the storage of

information in new databases used for financial records, manufacturing
and logistical information, personnel data, and much more since the
1980s. Relational databases have often replaced legacy hierarchical
databases and network databases because they are easier to implement
and administer. Nonetheless, relational databases received continued,
unsuccessful challenges by object database management systems in the
1980s and 1990s, (which were introduced in an attempt to address the
so-called object-relational impedance mismatch between relational
 databases and object-oriented application programs), as well as by
XML database management systems in the 1990s. however, due to the
expanse of technologies, such as horizontal scaling of computer
clusters, NoSQL databases have recently begun to peck away at the
market share of RDBMSs.

Implementation Methodology:

Model View Controller or MVC as it is popularly called, is a software

design pattern for developing web applications. A model View
Controller pattern is made up of the following three parts:
 Model: The lowest level of the pattern which is responsible for
maintaining data.
 View- This is responsible for displaying all or a portion of the data to
the user.
 Controller- Software code that controls the interactions between the
Model and View.
MVC is popular as it isolates the application logic from the user interface
layer and supports separation of concerns. Here the controller receives all
the requests for the application and then works with the Model to prepare
any data needed by the View. The View then uses the data prepared by the
Controller to generate a final presentable response. The MVC abstraction
can be graphically represented as follows:-

MVC (Model View Controller Flow)

DATA FLOW DIAGRAMS

Tools/Platforms requirements H/w & S/w specifiction

Chapter9

SYSTEM ANALYSIS:
System Analysis is a process of gathering and interpreting fact, diagnosing
problems and the information about the KBC Quiz system to recommend
improvements on the system. It is a problem solving activity that requires
intensive communication between the system user and system developers.
System Analysis or study is an important phase of any system developers.
System analysis or study is an important phase of any system development
process. The system is studied to the minutest detail and analyzed. The system
analyst plays the role of the interrogator and dwell deep into the working of
the present system. The system is viewed as a whole and the input to the
system are identified. The outputs from the organizations are traced to the
various processes. System analysis is concerned with becoming aware of the
problem, identifying the relevant decisional variables, analyzing and
synthesizing the various factors and determining an optimal or at least a
satisfactory solution or program of action. A detailed study of the process
must be made by various techniques like interviews, questionnaires etc. The
data collected by these sources must be scrutinized to arrive to a conclusion.
The conclusion is an understanding of how the system functions. The system
is called the existing system. Now the existing system is subjected to close
study and problem are identified. The designer now functions as a problem
solver and tries to sort out difficulties that the enterprise faces. The solutions
are given as proposals. The proposal is then weighed with the existing system
analytically and the best one is selected. The proposal is presented to the user
for an endorsement by the user. The proposal is reviewed on user is satisfied
with proposal. Preliminary study is the process of gathering and interpreting
facts, using the information for further studies on the system. Preliminary
study is problem solving activity that requires intensive communication
between the system users and system developers. It does various feasibility
studies. In these studies a rough figure of the system activities can be
obtained, from which the decision about the strategies to be followed for
effective system study and analysis can be taken.

Existing System of KBC Quiz System:

In the existing system the exams are done only manually but in proposed
system we have to computerize the exams using the application.

 Lack of Security data.

 More man power.
 Time consuming.
 Consumes large volume of pare work.
 Needs manual calculations.
 No direct role for the higher official.

Proposed System of KBC Quiz System:

The aim of proposed system is to develop a system of

improved facilities. The proposed system can overcome all the
 limitations of the existing system. The system provides proper security
and reduces the manual work.

 Security of data.
 Ensure data accuracy’s.
 Proper control of the higher officials.
 Minimize manual data entry.
 Minimize time needed for the various processing.
 Greater efficiency.
 Better service.
 User friendliness and interactive.
 Minimum time required.

Data Dictionary:

This is normally represented as the data about data. It also

termed as metadata sometimes which gives the data about the data stored in
the database. It defines each data term encountered during the analysis and
design of a new system. Data elements can be described files or the processes.
Following are some major symbols used in the data dictionary:

 = equivalent to
 + and
 [] either/or
 () optional entry
Following are some rules, which defines the contruction of data
dictionary entries:

1. Words should be defined to understand for what they need and not
the variable need by which they may be described in the program.
2. Each word must be unique. We cannot have two definition of the
same client.
3. Aliases or synonyms are allowed when two or more enters shows the
same meaning. For example a vendor number may also be called as
customer number.
4. A self-defining word should not be decomposed. It means that the
reduction of any information into subpart should be done only if it is
really required that is it is not easy to understand directly.
Data dictionary includes information such as the number of records in
file, the frequency a process will run, security factor like passwords
which user must enter to get excess to the information.

CONCLUSION OF THE PROJECT KBC QUIZ

SYSTEM:
Our project is only a humble venture to satisfy the needs to
manage their project work. Several user friendly coding have also
 adopted. This package shall prove to be a powerful package in
satisfying all the requirements of the school. The objective of software
planning is to estimates made within a limited timeframe at the
beginning of the software project and should be updated regularly as the
project progresses.

At the end it is concluded that we have made effort on the

following points:
 A description of the background and context of the project and its
relation to work already done in the area.
 Made statement of the aims and objectives of the project.
 The description of purpose, scope and applicability.
 We define the problem on which we are working in the project.
 We describe the requirement specifications of the system and the
actions that can be done on these things.
 We understand the problem domain and produce a model of the
system, which describes operations that can be performed on the
system.
 We included features and operations in detail, including screen
layouts.
 We designed user interface and security issues related to system.
 Finally the system is implemented and tested according to test
cases.

Future Scope of the Project KBC Quiz System:

 In a nutshell, it can be summarized that the future scope of the
project circles around maintaining information regarding:

 We can add printer in the future.

 We can give more advance software for KBC Quiz System including
more facilities.
 We will host the platform on online servers to make it accessible
worldwide.
 Integrate multiple load balancers to distribute the loads of the system.
 Create the master and slave database structure to reduce the overload of
the database queries.
 Implement the backup mechanism for taking backup of codebase and
database on regular basis on different servers.

The above mentioned points are the enhancements which can be done to
increase the applicability and usage of this project. Here we can maintain the
records of Questions and Answers. Also, as it can be seen that now-a-days the
players are versatile, i.e. so there is a scope for introducing a method to
maintain the KBC Quiz System. Enhancements can be done to maintain all
the Questions, Answers, Patterns, Participants, Point.

We have left all the options open so that if there is any other future
requirement in the system by the user for the enhancement of the system
then it is possible to implement them. In the last we would like to thanks all
the persons involved in the development of the system directly or
indirectly. We hope that the project will serve its purpose for which it is
develop there by underlining success of process.