Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Exampedia is an engineering encyclopedia that helps students find apt answers corresponding to exam-based questions rather than just a generic solution. The website is developed using asp.net 2.0, html, and c# as the front-end, and sql server 2008 as the back-end. The project report covers the system analysis, design, implementation, and testing of the exampedia platform. It includes details on the project modules, data dictionary, data flow diagrams, hardware and software requirements, and the software tools used. The report showcases the various features and functionalities of the exampedia system, such as user registration, chat, topic management, and answer uploads. The project aims to provide a comprehensive and interactive platform for engineering students to access exam-specific resources and collaborate with their peers.
Typology: Study Guides, Projects, Research
1 / 35
This page cannot be seen from the preview
Don't miss anything!
Exampedia
Session 2022 - 23 Submitted By:
GREATER NOIDA, UTTAR PRADESH, INDIA- 2 01306.
This is to certify that the project report entitled EXAMPEDIA submitted by Ms. Shivangi Chaudhary (1900970100110) to the Galgotias College of Engineering & Technology, Greater Noida, Utter Pradesh, affiliated to Dr. A.P.J. Abdul Kalam Technical University Lucknow, Uttar Pradesh in partial fulfillment for the award of Degree of Bachelor of Technology in Computer Science & Engineering is a bonafide record of the project work carried out by them under my supervision during the year 2021 - 2022. Mr. Pramit Kr Samant Assistant Professor Dept. of CSE Dr. Vishnu Sharma Professor and Head Dept. of CSE
LIST OF FIGURES
CHAPTER 1 INTRODUCTION EXAMPAEDIA is an engineering encyclopaedia that helps students finds apt answer corresponding to exam based questions rather than just a generic solution. The students can post answers to questions they feel is important in any language they desire. The recommended operating system is Windows 7. The website is developed using ASP.Net 2.0, HTML and C# as front end and SQL server 2008 as the back end. The purpose of EXAMPAEDIA is to support group study among geographically distinct pupil. Exampaedia provides a platform for conducting discussions about relevant topics. Our project have 3 type of users Admin, Registered users, Guest.
CHAPTER 2 SYSTEM ANALYSIS 2.1 REQUIREMENT ANALYSIS This phase is done for understanding what all are the improvements needed by the user for overcoming the drawbacks of the current system. The problem could be automating an existing manual process, developing a new automated system, or combination of these two. The emphasis in the requirement analysis is to identify what are the users expect from the system, not how the system will achieve those requirements. If the client and developers don’t understand the limitations of the system and failed to know the actual aim for developing the new one, ie., if requirement analysis is not properly done,it will lead to an inefficient system. So, before starting design, we should analyse the system and collect data from users, which are useful to our project. It must be able to get the answers of the following questions.
CHAPTER 3 SYSTEM DESIGN The most creative and challenging of the system life cycle is system design. The term design describes a final system and the process by which it is developed. The design phase focuses on the detailed implementation of the system recommended in the feasibility study. 3.1 PROJECT MODULES
Table 1: ADMIN LOGIN Column name Data type Constraints Size Admin_id Int Primary key Default Admin_username Varchar Not null 50 Admin_password Varchar Not null 50 Fig 3.2. Table 2: ANSWERS Column name Data type Constraints Size Ans_id Int Primary key Default Stud_id Int Not null Default Topic_id Int Not null Default Answer Varchar Not null Max Upload_file Nvarchar Not null 50 Post_date Date Not null Default Fig 3.2. Table 3: ANSWER UPLOADS Column name Data type Constraints Size Upload_id Int Primary key Default Upload_file Varchar Not null 50 Cmnts Nvarchar Not null Max Stud_id Int Not null Default Post_date Date Not null Default Fig 3.2.
Table 7: GROUP ANSWER Column name Data type Constraints Size grp_ans_id Int Primary key Default grp_answer Nvarchar Not null 50 stud_id Int Not null Default group_id Int Not null Default Fig 3.2. Table 8: RATING Column name Data type Constraints Size rating_id Int Primary key Default ans_id Int Not null Default rating Int Not null Default Fig 3.2. Table 10: SEMESTER Column name Data type Constraints Size sem_id Int Primary key Default sem_title Varchar Not null 50 Fig 3.2. Table 11: SUBJECT Column name Data type Constraints Size sub_id Int Primary key Default sub_name Varchar Not null 50 sem_id Int Not null Default Fig 3.2.
Table 12: SUGGESTIONS Table 9: REGISTER Column name Data type Constraints Size stud_id Int Primary key Default stud_name Varchar Not null 50 email_id Varchar Not null 50 password Varchar Not null 50 address Varchar Not null 50 pincode Varchar Not null 50 phno Varchar Not null 50 hometown Varchar Not null 50 state Varchar Not null 50 country Varchar Not null 50 batch_id Int Not null Default batch_status Bit Not null Default sem_id Int Not null Default login_status Bit Not null Default gender Nvarchar Not null 50 sec_ques Nvarchar Not null 50 sec_answ Nvarchar Not null 50 Fig 3.2. Column name Data type Constraints Size s_id Int Primary key Default e_id Nvarchar Not null 50 suggestion Nvarchar Not null Max Fig 3.2.
The DFD is a network representation of the system. They are excellent mechanism for communicating with customers during requirement analysis. A DFD, also known as bubble chart, which clarify system requirements identifying major transformations. It is the starting point in the system design and decomposes the requirement specification down to the lowest level. A DFD represents data flow between individual statement and blocks of statement in a routine, data flow between sequential routines, data flow between concurrent processes or a distributed computing system where each node represents a geographically remote processing unit. DFD are quite valuable for establishing naming conventions and names of systems, files, and data links. It describes what flow rather than how they are proposed, so it doesn’t depend on hardware, software and data structures or file organizations. NOTATIONS USED The logic data flow diagram can be drawn using four simple notations i.e. special symbols or icons and the notations that associates them with a specific system. The notations are specified below: ELEMENT REF ERENCES SYMBOLS Data flow process Source or Sink Process
Process : Describes how input data is converted to output data. Data Store : Describes the repositories of data in a system. Data Flow : Describes the data flowing between process, stores and external entities. Sources : An external entity causing the origin of data. Sink : An external entity, which consumes the data. DFD: LEVEL 0 Fig 3.3.
Fig 3.3.
Fig 3.3.
