By adminOn

Indira Gandhi National Open University BCA Project Synopsis Sample At

projecthelpline.in

 

“E-Learning – Online Education and Training Operations”  

By

NAME:…………..

ENROLLMENT NO……………….

 

UNDER GUIDANCE OF  ……………………

 

Submitted to the School of Computer and Information Sciences, IGNOU

in partial fulfilment of the requirements

for the award of the degree

Bachelor of Computer Applications (BCA)

Indira Gandhi National Open University

Maidan Garhi

New Delhi – 110068.

2016

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

 

 

 

  1. OBJECTIVES

 

3 .PROJECT CATEGORY

 

  1. 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

 

  1. PROPOSED SYSTEM DESCRIPTION

 

  1. 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.

  1. 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.

  1. 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

 

  1. 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.

 

  1. BIBLIOGRAPHY
  • AN INTRODUCTION TO DATABASE SYSTEM

AUTHOR- BIPIN C. DESAI

  • SOFTWARE ENGINEERING

AUTHOR- R. PRESSMAN

  • SYSTEM ANALYSIS AND DESIGNING (SAD)

IGNOU REFERENCE BOOKS