WIZ APPLICATION” BANSAL COLLEGE A project report submitted to Rajiv Gandhi Proudyogiki Vishwavidyalaya, Bhopal in partial fulfillment for the award of the degree of Bachelor of Engineering in Computer Science & Engineering DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING SUSHILA DEVI BANSAL COLLEGE OF TECHNOLOGY INDORE- 453331 2019“QUIZ APPLICATION” B Ss COLLEGE A project report submitted to Rajiv Gandhi Proudyogiki Vishwavidyalaya, Bhopal in partial fulfillment for the award of the degree of Bachelor of Engineering in Computer Science & Engineering PROJECT GUIDE SUBMITTED BY Ms. Sameeksha Khandelwal Bhumika Kanojin (0829CS 161033) Durgesh Mishra (0829CS161043) Harsh Verma (0829CS161048) DEPARTMENT OF COMPUTERSCIENCE & ENGINEERING SUSHILA DEVI BANSAL COLLEGE OF TECHNOLOGY INDORE- 453331 2019ACKNOWLEDGEMENT We have titken efforts in this project. However, it wouk! not have been possible without the kind support and help of many: individuals and organizations, We woukl like to extend my sincere thanks to all of them. ‘We are highly indebted to Sushila Devi Bansal college of Technology, Department of “Computer Science and Engineering” for their guidance and constant supervision as well as fr providing necessary information regarding the project & also for their support in completing the project. We woukl like to express our gratitude towards the guidance of Ms, Sameeksha Khandelwal & Facully member for their kind co-operation and encouragement which help us in completion of this project We would fike to express my special gratitude and thanks to my team mates without team Work the project was out of bound, (Our thanks and appreciations ako go to my colleague in developing the project and people who have willingly helped me out with their a Bhumika Kanojia (0829CS161033) Durgesh Mishra (0829CS161043) Harsh Verma (0829CS 161048)SUSHILA DEVI BANSAL COLLEGE OF TECHNOLOGY INDORE, 453331 B Ss COLLEGE CERTIFICATE This is to certify that Bhumika Kanojia (0829CS161033), Durgesh Mishra (0829CS161043), Harsh Verma (0829CS161048) have completed their project work, titled “QUIZ APPLICATION” as per the syllabus and have submitted a satisfactory report on this project as a part of fulfillment towards the degree of “BACHELOR OF ENGINEERING” (Computer Science & Engineering) from RAJIV GANDHI PROUDYOGIKI = VISHWAVIDYALAYA, BHOPAL. HEAD OF THE DEPARTMENT PROJECT GUIDE DIRECTORSUSHILA DEVI BANSAL COLLEGE OF TECHNOLOGY INDORE, 453331 Ss COLLEGE CERTIFICATE This is to certify that Bhumika Kanojia (0829CS161033), Durgesh Mishra(0829CS 161043), Harsh Verma(0829CS161048)have completed their project work, titled “QUIZ APPLICATION” as per the syllabus and have submitted a satisfactory report on this project as a part of fulfillment towards the degree of “BACHELOR OF ENGINEERING” (Computer Science & Engineering) from RAJIV GANDHI PROUDYOGIKI VISHWAVIDYALAYA, BHOPAL, INTERNAL EXAMINER EXTERNAL EXAMINERTABLES OF CONTENTS CHAPTER No. TITLE PAGE NO. ABSTRACT i LIST OF TABLES ii LIST OF FIGURES CHAPTER 1. INTRODUCTION 1.1 Purpose 1.2 Scope 1.3 Problem Definition 1.4 Proposed solution wee CHAPTER 2.SYSTEM REQUIREMENT ANALYSIS 2.1 Overall Description 2.1.1 Product Perspective 2.1.2 Product Function 2.1.3 User Classes And Characteristics 2.1.4 Operating Environment 2.1.5 Design And Implementation Constraints 2.1.6 Assumptions And Dependencies ee 2.2 External Interface Requirement 2.2.1 User Interfaces 2.2.2 Hardware Interfaces 2.2.3 Software Interfaces 2.2.4 Communications Interfaces ee IAD 2.3 Functional Requirement 2.3.1 System Feature oe 2.4 Non Functional Requirement 2.4.1 Performance Requirement 2.4.2 Safety Requirement 2.4.3 Security Requirement woes2.5 Project Plan 2.5.1 Team Members 2.5.2 Division Of Work 2.5.3 Time Schedule CHAPTER 3, ANALYSIS 3.1 Methodology Used 3.2 Use Case Diagram 3.3 Sequence Diagram 3.4 Activity Diagram 3.5 Class Diagram 3.6 Data Flow diagram CHAPTER 4. DESIGN 4.1 Architectural Design 4.1.1 System Architectural Design 4.1.2 Deseription Of Architectural Design 4.2 Database Design 4.2.1 Normalization 4.3 Component Design 4.3.1 Flow Chart 4.4 Interface Design 4.4.1 Screenshots CHAPTER 5. IMPLEMENTATION 5.1 Language And Database System Used 5.2 Features Of Language And Database Used 5.3 Description Of Third party tools Used CHAPTER 6. TESTING 6.1 White Box Testing 6,2 Black Box Testing 10 10 10 i 13 17 21 24 25 26 26 26 36 x7 38CHAPTER 7, FUTURE SCOPE AND LIMITATION 39 CHAPTER 8. CONCLUSION 40 CHAPTER 9. REFERENCE 41ABSTRACT The project: “Quiz Application” is a collection of number of different types of quizzes like technical, games, sports, etc. A user can access/play all of the quiz and can attempt any of the one. There will be limited number of questions and for each correct answer user will get a credit score. User can see answers as well as can ask a query related to it’ There are many quiz applications available currently on internet. But there are few Which provide better understanding between users and the application like, providing proper answers, user query solving, uploading user questions as well as answer to it, etc. To develop a user friendly quiz application which will contain ; Numbers of quiz , Answers to every question, Query solving regarding any question, Uploading of user question and answer , and to improve the knowledge level of users. To develop a application which will contain solution to the above problems, By ‘this application the user will come to know about his/her level and can leam additional knowledge. Also by this application a user can expand his/her knowledge among the world.Table no. 2.14.1 2.2.2.1 2.2.3.1 LIST OF TABLES Title Operating Environment Hardware Interfaces Software Interfaces Use case specification for Registration Use case specification for Log-In Use case specification for Home Page Use case specification for Admin Home Page Use case specification for Result Use case specification for Log-Out Normalization database table Page no.LIST OF FIGURES Title Login Page Registration Page Waterfall life cycle Model Use Case Diagram Sequence Diagram for Login Sequence Diagram for play Quiz Sequence Diagram for Submit Question Sequence Diagram for Logout Activity Diagram for Login Activity Diagram for Submit Quiz Activity diagram for Play Quiz Class Diagram for Quiz Application Data Flow Diagram for Quiz application A3-Tier Architecture diagram Flow Chart for Quiz Application Screenshot for Home Page Screenshot for About Quiz Page Screenshot for Registration Screenshot for Login page Screenshot for Forgot Password Screenshot for Admin Page Screenshot for Submit Question Page Screenshot for User Home Page Screenshot for Attempting Quiz Page Screenshot for Result Page Screenshot for Feedback Page Diagram for Black Box Testing Page no. 261, INTRODUCTION 1.1 Purpose This web application provides facility to Play online quiz and practice Grammar, Aptitude, and G.K. It provides a good platform, where a student not only judges there knowledge/skill but also they can improve knowledge/skill at the same time. 1.2 Scope The Scope of this project is very broad in terms of gaining knowledge and sharing knowledge among world. Few points are:- © Can be used anywhere any time as it is a web based application. © This application will be used in educational institutions as well as in corporate world.13 Problem Definition “Our aim is to develop a application for the users in which a user can attempt any number of quiz related to his/her choice.” Firstly, we have to make interfaces for Home Page, Registration, Login Page, Questions Attempting forum, Result Page, & Profile of user. These all pages have connectivity with the server and database. So, that it can work properly. Currently, there are websites which only provide limited number of quizzes related to different domain. Many websites do not have a single platform for quizzes related to technical, G.K, Aptitude, Games, etc. And there is not a website where the users can upload his/her questions and answers for the others. We have to develop a application which can resolve all of the above problems. By this user can gain knowledge, can solve his/her query, and spread his/her knowledge among the world.14 Proposed Solution The main requirement of application is to find questions and answers. In this application firstly the user need to register or login using user-id and password. Then the user can choose-any ‘of the quiz of his/her choice. Before starting the quiz there is a instruction window in which there are instruction related to attempt the quiz. After it user can start attaining the quiz. Here user can see his/her answers are right or wrong and can also see the answer of each. If there is any query related to it user can.ask it. After completion of the quiz user will get credit score for each ‘of its correct answers. Initially the questions are given by the admin but after sometime the user itself can submit questions and its answers. After verification by the admin the questions are shown on the window. The query related to a question can we solved by admin as well as the users of this application. This application initially contain admit and some higher prior user which can submit question and answers. The user profile will contain its name, age, qualification, gender, mobile number, credit score, ete, This application will provide link to additional useful website for learning purpose.2. SYSTEM REQUIREMENT ANALYSIS 2.1 Overall Deseription- 2.1.2 2.1.2 Product Prespective It is a quiz application which is based on web application. It usually interacts with user and students. Mainly it is quiz application in which there are 4 categories. Individual category will held 10 questions, and cach question carries | mark. There is no negative marking. If we do not attempt any question then it will show “not attempted” mark. In result screen, it will show total marks obtain in quiz, wrong answer will also been shown with correct answer, Main purpose of this application is to develop knowledge and skills in students and user. Product Function Account login: Student/user can login using login id and password Account logout: Student/user can logout the account whenever required. Result; Studen/user attempted the quiz and gets a result. Feedback: Student/user can give a feedback. Play quiz: StudenVuser can play the quiz according to his/her choice, Add Questions: Admin can add the question by selecting the topic.2.1.3 UserClasses And Characteristics Users of the product must possess a minimal level. Users must know how to access the functionality of this system and get benefited. 2.1.4 Operating Environment S.NO. NAME HARDWARE 1 Processor Intel dual core(32 bit) Z. RAM 2GB 3 Processor Speed 2GHz Table 2.1.4.1 Operating Environment 2.1.5 Design And Implementation Constraints © Language of choice: JAVA. © Platform for deployment: NETBEANS. * Database: MySQL. 2.1.6 Assumptions And Dependencies We assume that the users of our website should have a minimal knowledge of computer system and should have an availability of internet, We are dependent on the sources from where we have gathered. the data and the data are authenticated.2.2 Enternal interface Requirements 2.2.1 User Interfaces The Admin has the access to overall control the functionalities. of the system. The platform users i¢., admin studenvuser will be protected by login and password since; the platform allows the users to make some changes that can have propagating effects in the system, They can upload their updates and details in the system, Login Page: Fig: 2.2.1.1 LoginRegistration page: Fig : 2.2.1.2 Registration page 2.2.2 Hardware Interfaces S.NO. NAME HARDWARE Processor Intel dual core(32bit) RAM 2GB 3, Processor Speed 2GHz ‘Table 2.2.2.1 Hardware Interfaces2.2.3. Software Interfaces S.No NAME SOFTWARE 1 Platform Windows 7 2 Database tool MySql Table 2.2.3.1 Software Interfaces 2.2.4 Communications Interfaces *® Windows 2.3 Functional Requriement 2.3.1 System Feature This section gives a functional requirement that applicable to the online exam system. There are three modules in this phase: 1. Student/user module. 2. Admin module. Functionality of each module are: Student/user module: The student/user have to login in application. They can chooseany of the given quiz. Then the student/user will get result immediately after the completion of test. Admin module: The admin can see all the tables in the Database and can add the question by selecting the particular topic.2.4 Non Functional Requriemet 2.4.1 Performance Requirements 1. Response Time- The system shall give responses in 2 sec after user login. 2, Capacity- The system can support multiple computer but it need to be install on every computer separately, 2.4.2 Safety Requirements All logged information, updates, user activities are securely stored. 2.4.3 Security Requirement Any modification for the Database shall be synchronized and done by system admin.2.5 Project Plan 5.1 Team Members Name: Harsh Verma Email:harshverm776@gmail.com Name: Durgesh Mishra Email: durgeshmishral999@email.com Name: BhumikaKanojia Email: bhumika.kanojia 1|@gmail.com 2.5.2 Divi “A team is on success gate if every individual is loyal to his/her nof Work responsibility.” Harsh Verma: Front End, Back End, UML Diagram, Database Management. Durgesh Mishra: Front End, Back End, Session Management, Database Connectivity Bhumika Kanojia: Front End, UML Diagram, Documentation, 2.5.3 Time Schedule 1. Requirement Analysis: Approximately 15 days 2, Design: Approximately 25 days 3, Coding : Approximately 30 days 4, Testing: Approximately 10 days3 3. ANALYSIS. Methodology Used The programming linguage tised for the development of the project is JAVA and the software model used is the classic lifecycle model. Waterfall Process modet The Classical Life Cycle or waterfall Process Made! was the first process model to present a sequential framework, describing basic stages that are mandatory for a successful software development model. It formed the basis for most software development standards and consists of the following phases: Requirement analysis. design, coding, testing, and maintenance. Advantages of waterfall model: vvvy nye wv Simple goal. Simple to understand and use. Clearly defined stages. Easy to arrange tasks. Process and result are well documented. ‘Customers / end users already know about it, Easy to manage. Disadvantage of Waterfall model: » Rigid design and inflexible procedure, > Waterfall model faced “Inflexible paint solution” which meant even small amendments in the design were difficult to incorporate later design phase. ® As the requirement were froze before moving to the design phase, using the incomplete set of requirement.a complete design was worked amendments Incase ofa large project, completing a phase and then moving back to reconstruct the same phase, incurred a large overhead® Once a phase is done, it is not repeated again that is movement in the waterfall goes one to the next and the vice versa is not supported, deadlines are difficult to meet | case of large projects. 7 [eae = Fig. 3.1.1 Waterfall life Cycle model Maintenance3.2 USECASE DIAGRAM USECASE DIAGRAM A.use case diagram at its simplest is a representation of user’s interaction with the system that shows the relationship between the user and the different use casein which the users is involved. A use case diagram can identify the different types of user of a system and the different use cases, QUZAPPLICATION Fig: 3.2.1 Use Casell, USE CASE SPECIFICATION Name of the usecase Registration Actor User/student Precondition None Primary flow of events Email id, password, dob, mobile no., Security code, Alternate flow of events Ifemail, password, dob, mobile no. is wrong shows message “incorrect the some details”. Post condition If successfulregister and come to log in page. Use case termination Cancel Table 3.2.1 Use Case Specification for Registration Name of the usecase Log-In Actor User/student Precondition None Primary flow of events Email id , password Alternate flow of events Ifusername or password is wrong, shows message “incorrect email id and password”. Post condition IFsuccessfullog andcome to home page. Use case termination Cancel Table 3.2.2 Use Case Specification for Log— InName of the usecase Home page Actor User/student Precondition Login Successfully Primary flow of events Can Access any of the given quizzes. Alternate flow of events None. Post condition Use casetermination Will Attempt Quiz. Cancel Table 3.2.3 Use Case Spe ification for Home Page Name of the usecase Home page ‘Actor ‘Admin Precondition Login Successfully. Primary flow of events ‘Can Submit question and can see any of the Database. Alternate flow of events None. Post condition None. Use case ter: Ca Table 3.2.4Use Case Specificati ion for Admin Home PageAlternate flow of events None. Name of the use case Result page | ‘Actor User/student | Precondition ‘Submit quiz. Primary ow of events Can see result, | Post condition Use case termination Can give feedback and go back to Home Page. Cancel Table 3.2.5 Use Case Specification of Result Name of the usecase Logout Actor User/student Precondition Successfullog in to the account Primary ow of events No primary flow. Alternate flow of events Session expired, Post condition Use case termination User will be redirected to application home page. Cancel Table 3.2.6 Use Case Specification for Logout3.3 SEQUENCE DIAGRAM Password 1 | I | Emeruseraty | I ' 1 [Accepted]: Fig: 3.3.1 Sequence Diagram For LoginFesea | = Question for selected catagory Display Verify Answer Verification Result 23.3.2 Sequence diagram For Play Quiz FigSelect Choice (Not Sucdesstu] . Fig : 3.3.3 Sequence Diagram for Submit Questioni e g - 3 4 5 ML In 3.3.4 Sequence Diagram For Logout Fig:3.4 ACTIVITY DIAGRAM UsefD, Password Fig :3.4.1 Activity diagram for LoginLogin Sul Question: nec Fill Question, Options, &comect answer can't submit (Already exists) Fig: 3.4.2 Activity Diagram For Submit QuizFig : 3.4.3 Activity Diagram For Play quiz3.5 CLASS DIAGRAM Fig: 3.5.1 Class Diagram for quiz Application3.6 Data flow diagram chk tte ——— oom —— ey foo aceat be oe na suey aves vets —— see cunt ri . == Seton ran i. emeea areaenacouz ashes —_| ‘union sant reset a, recoonce rete btaa -—_—__—_| aay Fig: 3.6.1 Data Flow Diagram For Quiz Application4, DESIGN 4.1 Architectural Design 1.1 System Architectural Design Three-tier architecture is a client- server software architecture pattem in which the use interface (presentation), functional process logic (“business rules”), computer data storage and data access are developed and maintained as independent modules , most often on separate platform. Apart from the usual advantages of modular software with well-define interface , the Three- tier architecture is intended to allow any of the three — tier to be upgraded or replace independently in response to changes in requirements or technology . For example, a change of operating system in the presentation tier would only affect the use of interface code. Typically, the user interface runs on a desktop pe or workstations and uses a standard graphical user interface functional process logic that may consist of one or more separate modules running on workstations on application server, and RDBMS on a database server or mainframe that contains the computer data storage logic. The middle tier may ‘be multi-tiered itself (in which case the overall architecture is called an “n-tier architecture”), 4.1.2 Description of Architectural Diagram PRESENTATION BUSINESS LOGICS DATA MANAGEMENT TIER TIER TER Fig: 4.1.2.1 A 3-Tier Architecture DiagramPresentation tier This is the top most level of the application .The presentation layer provides the applications user interface Typically, this involves the use of GUI for smart client interaction, and web based technologies for browser-based interaction. The presentation tier displays information related to such services as browsing, merchandise, purchasing, and cart contents Logic tier (called also business logic, data access tier, or middle tier) The logic tier is pulled out from the presentation tier and, as its on layer it controls an application functionalities by performing detailed processing -Logic tier mission critical business problems are solved. The component that makes up this layer can exist on server machine, to assist in resource sharing. These components can be used to enforce business rules, such as business algorithms and legal or governmental regulations, and data rules which are designed tw keep the data structures consistent within either specific or multiple databases, Data tier This tier consist of data base server , is the actual DBMS access layer .It can be accessed through the business services layer and on occasion by the user services layer. Here information is stored and retrieved. This tier keeps data natural and independent from application server or business logic. Giving data is on tier also improves scalability and performance -This layer consist of data access component to aid in resources sharing and to allow clients to be configured without installing the DBMS libraries and ODBC drivers on each client,4.2 Database Design 4,2,1 Normalization Database normalization is a technique of organizing the data in the database. Normalization is systematic approach decomposing table to eliminate data redundancy an undesirable characteristics like insertion, update and deletions Anomalies. Ti is a multi state process that puts data into tabular form by removing duplicated data fram the relation tables. Normalization is used for mainly two purposes: © Eliminating redundant data. * Ensuring data dependence makes sense i.e. data is logically stored. Our table in the database is in | NF form. A table is said to be in 1 NF if both the following conditions hold: A relation will be | NF if it contains an atomic value. It states that an attributes of a table cannot hold multiple values. It must hold single valued attributed, | NF disallows the multi-valued attribute, composite attribute, and their combinations. Name Password Email id Mobile no. Fig:4.2.1.1 Database Table4.3 Component Diagram 4.3.1 Flow chart A flow chart is a type of a diagram that represents an algorithm, workflow or process, showing the steps as boxes of various kinds, and there order by connecting them with arrows. This diagrammatic representation illustrates a solution model to a given problem. Flow charts are used in analyzing, designing, documenting or managing a process program in a various field. Fig4.3.1.1 Flowchart4.4 Interface Design User interface is the front-end application view to which user interacts in order to use the software. User can manipulate and control the softwareas well as hardware by means of user interface. Ulcan be graphical, text based, audio-video based, depending uponthe under lying hardware and software combination. Ul can be hardware or software or a combination of both. 4.4.1 ScreenShots Fig: 4.4.1.1 Home Pageplease Ch ‘ continoe Fig: 4.4.1.2About Quiz Page Fig: 4.4.1.3 Registration Pagelash Rela las} Cs lane Se Fig-4.4.1.5 Forgot PasswordDoreen unt [tc] pron Fig: 4.4.1.6 Admin Page Fig: 4.4.1.7 Submit Question Pageot aS Rig skills Fig: 4.4.1.8 User Home Page Fig: 4.4.1.9 Atempting Quiz PageRESULT on s salvedcienehanaidadenadaieaendaianeniaal pein Fig: 4.4.1.10 Result Page Nag sae ola g — Lr Feedback: 1.11 Feedback Page5. Implementation 5.1 Language And Database Used For The Implementation . For the frontend development of the a fore mentioned project: HTML 5,CSS , JavaScript and Bootstrap has used. For the backend development of the a fore mentioned project: Java i.e., the .jsp pages are used. For the Database Management of the a fore mentioned project; MySqlis used. 5.2 Feature Of language & database used for the project HTML: Widely used for creating web page & pioneer in web application development. My-SQL: Single & integrated environment, Analysis Services, Reporting Services Supports, Administrative Tasks. 5.3 Description Of Third Party tools used © An IDE, called Netbeans using Glass fish server. * For the designing phase, UML Diagram maker fram Draw.io. © For CSS, bootstrap.6 TESTING 6.1 White Box Testing White box testing is defined as the testing of software solution’s internal structure, design, and coding. In this type of testing, the code is visible to the tester. It focuses primarily on verifying the flow of inputs and outputs through the application, improving design and usability, strengthening security. White box testing is also called Clear testing, Open Box Testing, Structural testing, Transparent Testing, Code-Based Testing and Glass Box Testing. Test Cases of White Box Testing © Test Case Name: Registration Input: Enter name, dob mail-id, mobile no., Outcomes: Successfully register. Expected Outcomes: Successfully register. Result: Pass. * Test Case Name: Login. Input: Enter Username correct, password correct. Outcomes: login successful. Expected Outcomes: login successful Result: Pass. © Test Case Name: Login. Input: Enter Username correct, password wrong. Outcomes: login fail. Expected Outcomes: login fail. Result: Fail. * Test Case Name: Login. Input: Enter Username null, password null Outcomes: login fail. Expected Outcomes: login fail. Result: fail.6.2 Black box Testing Black box testing is also known as Behavioral Testing, is a software testing method in which the _ internal structure/design/implementation of the item being tested is not known to the tester. These tests can be functional or non- functional, through usually functional. This method is named so because the software program, in the eyes of the tester, is like a black box; See. inside which one cannot ouput iter, Black Box Fig: 6.2.1 Black Box Testing Test cases of Black Box Testing * Test Case Name: Registration. Input: Enter required details for registration. Outcomes: Registered successfully. Expected Outcomes: Registered successfully. Result: Pass. * Test Case Name: Registration. Input: Enter required details for registration. Outcomes: Validation not correct. Expected Outcomes: Registered not successfully. Result : Fail.7 FUTURE SCOPE AND LIMITATION Scope:- The Scope of this project is very broad in terms of gaining knowledge and sharing knowledge among world. Few points are: * Can be used anywhere any time as it is a web based application * This application will be used in educational institutions as well as in corporate world. Limitation:- * Wewant to implement a concept where user itself can add question for others. We want to implement a concept where the user can solve any query related to each question at that time only. * Wealso wantto implement a concept where every user can see profile of other user.8 CONCLUSION This online quiz application provides facility to play quiz anywhere and anytime. It save time since user does need to wait for result. So student/user cannot wait for the result. All Student/ user get extra knowledge and skills. Administrator has a privilege to put as much as question in any category given in application. User can register, log-in, and give the test with his/her speci id, and can see the results as well.9 REFERENCE https://www.W3schools.com/ ¢ https://stackoverflow.com/ ® https://www.quora.com/ © https://www.draw.io/