TABLE OF CONTENTS

Contents

1. Introduction
2. Objectives
3. Project category
4. Tool/ Platform hardware and software
5. Proposed System Description
6. Module Description
7. Dataflow Diagram (DFD)
8. Scope of The Project
9. Report Generation
10. Project Scheduling
11. Further Enhancement of the Project
12. Bibliography

TITLE OF PROJECT
“E-LEARNING – ONLINE EDUCATION AND TRAINING OPERATIONS”

1. INTRODUCTION

2. OBJECTIVES

3 .PROJECT CATEGORY

4. TOOLS / PLATFORM, HARDWARE AND SOFTWARE REQUIREMENT SPECIFICATION

HARDWARE:
Processor : Pentium 2.4 GHz or above
Memory : 256 MB RAM or above
Cache Memory : 128 KB or above
Printer : Laser Printer
Pen Drive : 5 GB
FRONT END : ASP.Net
BACK END : SQL Server
SCRIPTING LANGUAGE : Java Script, HTML
WORD EDITORS : MS-WORD, NOTEPAD
GRAPHIC TOOLS : Paint, Flash

PLATFORM
● Operating System : Windows XP(or later)
● RAM : Min 256MB
● Hard Disk Space : 40GB
● Processor : Pentium 4(or higher) or equivalent AMD
● Printer : Compatible
● Screen Resolution : 1024*768
5. PROPOSED SYSTEM DESCRIPTION

6. MODULE DESCRIPTION

DATA MODELING
Data modeling defines primary data objects, composition of each data object, and attributes of the object,
relationships between each object and other objects and between objects and the processes.
List Of Tables:
1. Login
2. Students
3. Courses
4. Fee
5. Teachers
6. Resume
7. Notes
8. Result
9. Payroll
10. Notes
11. Feedback
12. Holidays
13. Teachers Feedback
14. Students Feedback

Tables
Admin Table

Field Type Constraint

ID Number(5) Primary Key

Email VarVarchar (50) Not Null

FullName VarVarchar(40) Not Null

Password VarVarchar (50) Not Null

Status VarVarchar (1) NotNull

Student Details Table

Field Name Data Type Constraint

Enrollment_No. Character(20) Primary Key

Student_Name Character(20) Not Null

Father_Name Character(20) Not Null

Date_of_Birth Date Not Null

Address Character(30) Not Null

Telephone_No. Number Not Null

Attendance Details Table

Field Name Type Constraint

Student_Roll_No. Character(25) Primary Key

Course_Name Character(25) Not Null

Month Character(20) Not Null

Date_of_Joining Date Not Null

Total_Classes Number Not Null

Class_Attendance Character(25) Not Null

Courses Table

Field Name Type Constraint

Student_Name Character(30) Primary Key

Student_Roll_No. Number Not Null

Course_Name Character(30) Not Null

Start_Date_of_Course Date Not Null

Time_Slot_Theory Character(25) Not Null

Time_Slot_Lab Character(25) Not Null

Days_of_Theory Character(20) Not Null

Days_of_Lab Character(20) Not Null

Feedback Table

Field Name Type Constraint

ID Number(10) Primary Key

Email VarVarchar (50) Not Null

Name VarVarchar (50) Not Null

Feedback Varchar (450) Not Null

Question Table

Field Type Constraint

ID Number(10) Primary Key

Question no Varchar (50) Not Null

Name Varchar (50) Not Null

Email Varchar (50) Not Null

Question Varchar (50) Not Null

Registration Table

Field Type Constraint

ID Number(10) Primary Key

Email id Varchar (50) Not Null

Password Varchar (50) Not Null

Secret Question Varchar (50) Not Null

Secret Answer Varchar (50) Not Null

First Name Varchar (50) Not Null

Last Name Varchar (50) Not Null

Topic Table
Field Type Constraint

ID Number(10) Primary Key

Topic Name Varchar (50) Not Null

Summery Varchar (510) Not Null

Files Varchar (50) Not Null

Tutorial Table

Field Type Constraint

ID Number(10) Primary Key

Topic Name Varchar (50) Not Null

Heading Varchar (50) Not Null

Detail Varchar (30) Not Null

Files Varchar (50) Not Null

Answer Table

Field Type Constraint

ID Number(10) Primary Key

Ans_no Number (10) Not Null

repname Varchar (50) Not Null

Repemail Varchar (50) Not Null

Answer Varchar (250) Not Null

Q.no Varchar (50) Not Null

Askname Varchar (50) Not Null

Askemail Varchar(50) Not Null

Question Varchar (100) Not Null

Quiz Table

Field Type Constraint

ID Number(10) Primary Key

Date Varchar (50) Not Null

Time Varchar (50) Not Null

Score Varchar (50) Not Null

Topic Varchar (50) Not Null

Result Table

Field Type Constraint

ID Number(10) Primary Key

Student Id Number (10) Not Null

Class Varchar (50) Not Null

Section Varchar (50) Not Null

Marks Varchar (50) Not Null

Max_Marks Varchar (50) Not Null

Notes

Field Type Constraint

ID Number(10) Primary Key

Teacher_ID Number(10) Not Null

Title Varchar (50) Not Null

Subject_Name Varchar (50) Not Null

Remarks Varchar (50) Not Null

Department

Field Type Constraint

Department_ID Number(10) Primary Key

Department_Name Varchar (50) Not Null

Fee

Field Type Constraint

ID Number(10) Primary Key

Student_ID Number(10) Not Null

Class Varchar (50) Not Null

Date Timestamp Not Null

Amount Currency Not Null

Remarks Varchar (50) Not Null

Course Table

Field Type Constraint

ID Number(10) Primary Key

Course_Name Varchar (10) Not Null

Duration Varchar (50) Not Null

Remarks Varchar (50) Not Null

The ‘Student Registration Form’ is designed for registering the new student details and course details.
The ‘Student Fee Form’ is used to enter the student’s fee details.
The ‘Student Marks Form’ is designed for submitting the semester or exam marks of the students for a particular
course or an individual student.
The ‘Student Id Form’ is used to create the identity number for each student for different course.
The ‘Employee details Form’ is designed for entering the staff details and other relevant details.
The Employee Id used to create the identity number for each student for different course.
The ‘Salary Form’ is used to derive the salary for employees
The ‘Course details Form’ is designed for entering the different course available in the campus and other relevant
details.
The ‘Library module’ is used for the data process of library and book accessing for students and staffs.
Main Description of the module ‘Reports’ are:-
All the above mentioned data are stored in the back end and can be retrieved as reports with filtering options.
The following are the reports can be taken from this system
1. Student Report
2. Employee Report
3. Course Detail Report
4. Book Detail Report
5. Issued Book Report
6. Fee Detail Report
7. Marks Detail Report
8. Generate Pay Slip

ER-DIAGRAM
In software engineering, an entity-relationship model (ERM) is an abstract and conceptual representation of data.
Entity-relationship modeling is a database modeling method, used to produce a type of conceptual schema or
semantic data model of a system, often a relational database, and its requirements in a top-down fashion.
An entity may be defined as a thing which is recognized as being capable of an independent existence and which can
be uniquely identified. A relationship captures how two or more entities are related to one another.

7. DATAFLOW DIAGRAM(DFD)

Data flow diagrams (DFD) are part of a structured model in the development of software. They are a graphical
technique that depicts information flow and the transforms that are applied as data move from input to output.
Basically, the function of DFDs is to show the user a graphical analysis of a software system. It is like a flowchart,
except DFDs show the flow of data throughout the system.
● The rectangle represents an external entity. The external entity is a producer or consumer of information that resides
outside the bounds of the system to be modeled.
● The circle (process) is a transformer of information that resides within the bounds of the system. The line with an
arrow (data item) is a single item, or a collection of data items. The arrow head represents the directions of the data.
● The Parallel line (data store) represents a repository of data that is to be stored for use by one or more processes;
maybe as simple as a buffer or a queue or as sophisticated as a relational database.

SCOPE OF THE PROJECT

Scope of the System
This system provides the detail structure of the college campus and its departments. ‘E-Learning – Online Education
and Training Operations’ synchronizes the working of all the departments. It looks on all aspects of acollege, its
students, faculties, Departments, marks and other co – curricular activities.
E-Learning – Online Education and Training Operations is the easiest way to manage all functionalities of a college,
which facilitates colleges to maintain the functionality related to college employees and their students.

9. REPORT GENERATION

‘Crystal Reports’ is a popular third party package that is included with in ASP.NET, which allows you to create
reports for your application. The package consists of a designer – where you can design and test the reports, Crystal
Reports API calls and Crystal Report Viewer control. The reports generated by the administrator are
● Fee Details
● Students Details
● Admissions Details
● Teachers Details
● Course Details

10.PROJECT SCHEDULING
GANTT CHART

Tasks Week 1 Week 2 Week3 Week 4

 a) Requirement Analysis

b) Report Generation
Milestone

a) Input/Output Design
b) File Design
c) Processing Logic
Design
d) Design of Control
Milestone

a) Coding
Milestone

a) Module Testing
b) System Testing
Milestone

11. FURTHER ENHANCEMENT OF THE PROJECT

As this project is made using the most security programming language that is ‘JAVA’, there is no issue regarding
security problems but every software that is designed and developed has some scope foe future applications, so the
‘E-Learning – Online Education and Training Operations’ also has some scope for future applications. In future we
can able to add more modules in this project. In the proposed system, user is provided with choice of screens which
are similar in formats with the source document. Data entry errors can be minimized using validity checks. So after
this we are able to provide quality of IT Education at affordable cost for all.

12. BIBLIOGRAPHY

● AN INTRODUCTION TO DATABASE SYSTEM

AUTHOR- BIPIN C. DESAI
● SOFTWARE ENGINEERING
AUTHOR- R. PRESSMAN
● SYSTEM ANALYSIS AND DESIGNING (SAD)
IGNOU REFERENCE BOOKS