By adminOn

 

Indira Gandhi National Open University Project Synopsis Sample On MCA  At

projecthelpline.in

A

SYNOPSIS

 ON

ONLINE STUDY CENTER MANAGEMENT SYSTEM

 

UNDER SUPERVISION OF

 …………….

 

SUBMITTED BY

NAME: ……………..

ENROLMENT NO:  ……………..

 

Submitted in partial fulfillment for the award of the Degree of

Master of Computer Applications (MCA)

Indira Gandhi National Open University

Maidan Garhi

New Delhi – 110068.

2017
ONLINE STUDY CENTER MANAGEMENT SYSTEM

Under Supervision of                      :        …………..

 

Name                                                          :        ……………….

Enrollment  No.                               :        ……………..


 

Contents

  
1. Introduction
2. Objectives
3. Project Category
4. Tools/ Platform Hardware & software requirements
5. Data Flow Diagram(DFD and ER diagram)
6. Complete Structure
7. Modules of  the Project
8. Data Modeling
9. Security and Validation Checks
10. Scope of future Application
10. Conclusion
12.  Bibliography

                                                           

TITLE OF THE PROJECT

“Online Study Center Management System”

 


  1. INTRODUCTION

This is a Project work undertaken in context of partial fulfillment of the MCA. The product Online Study Center Management System offers the information and communication systems, serve as specific media to implement the learning process. The term will still most likely be utilized to refere out-of-classroom and in-classroom educational experiences via technology, even as advances continue in regard to devices and curriculum. There are many benefits to online training. E-learning is beneficial for people who are very busy. E-learning is essentially the computer and network-enabled transfer of skills and knowledge. E-learning applications and processes include Web-based learning, computer-based learning, virtual classroom opportunities. It can be self-paced or instructor-led and includes media in the form of text, image, animation, streaming video and audio.

 

  1. OBJECTIVE:

 

 

 


INPUT AND OUTPUT OF THE PROJECT 

INPUT TO THE PROJECT

Login Module: This module to authenticate Student(s) & Teacher(s) UserName & Password.

New User: This module is to register new student(s) or Teacher (s).

Admin: Administrator can:

  • Add Student profiles
  • Add Teacher Profiles
  • Add circulars & Notifications
  • Add fee details, course details, Upload notes, Video tutorials, images etc..
  • Add Online Quiz & Score board
  • Add Students & Teachers Attendance

OUTPUT OF THE PROJECT

  • Student’s Area
  • Teacher’s Area
  • Attendance Report
  • Examination’s Results
  • Circular details
  • Course details
  • Holiday’s details
  • Download tutorials (Notes, Videos, MP3, Images)
  • Feedback from users

 

ADVANTAGES:

  • The system is secured can be accessed by authorized user only, can’t be accessed by any other person.
  • Downloading, Online student registration for courses, books, projects, tutorials, Interview Questions, Online Exams etc..
  • User friendly interface of the software enables user to use this easily and conveniently, proper messages and guidelines have been provided as the user navigates through the forms.
  • Roll number is generated automatically for the student being registered.
  • Data retrieval has been done through search forms

DRAWBACKS OF CURRENT MANUAL- SYSTEM

  1. The existing manual system is not automated consequently a large number of paper works required to handle the projects and it will lead lot of financial, environmental, manpower consumptions.
  2. The retrieval of records of previously registered student will be a tedious job.
  3. Lack of security for the records and the disarrangement of the records leads system malfunction.
  4. If someone wants to check the details of the available records for his satisfaction, the existing system does not provide any necessary detail of this type.

 


3. PROJECT CATEGORY

My SQL & PHP 

PHP: PHP is a dynamic and interactive server-side, object-oriented, open source scripting language. PHP is a language used to develop interactive and dynamic content on the web and it is often used together with the Apache web server. While PHP originally stood for Personal Home Page, it now stands for PHP: Hypertext Preprocessor. PHP code is interpreted by a web server with a PHP processor module which generates the resulting web page: PHP commands can be embedded directly into an HTML source document rather than calling an external file to process data. It has also evolved to include a command-line interface capability and can be used in standalone graphical applications. PHP is free software released under the PHP License, which is incompatible with the GNU General Public License (GPL) due to restrictions on the usage of the term PHP. PHP can be deployed on most web servers and also as a standalone shell on almost every operating system and platform, free of Varcharge.

HTML: Hyper Text Markup Language and Extensible markup Language are the predominant markup languages for web pages.It provides a means to describe the structure of text-based information in a document and to supplement that text with interactive forms, embedded images, and other objects.

MySQL: MySQL is the world’s most widely used open source relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. It is named after co-founder Michael Widenius’ daughter, My. The SQL phrase stands for Structured Query Language. The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as 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. MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack (and other ‘AMP’ stacks). LAMP is an acronym for “Linux, Apache, MySQL, Perl/PHP/Python.” Free-software-open source projects that require a full-featured database management system often use MySQL.

 

HARDWARE:

Processor                     :           Inter core 2 Duo or above

Memory                       :           2 GB RAM or above

Cache Memory            :           128 KB or above

Hard Disk                   :           30 GB or above [at least 3 MB free space required]

Printer                         :           Dot Matrix / DeskJet connected to LPT port

 

SOFTWARE:

Operating System       :           Windows 7

Font-End Tool                        :           HTML, PHP

Back-End                    :           My Sql

Server                          :         Wamp Server


PRINCIPLES OF SYSTEM ANALYSIS

Principles:

  1. Understand the problem before you begin to create the analysis model.
  2. Develop prototypes that enable a user to understand how human machine interaction will occur.
  1. Record the origin of and the reason for every requirement.
  2. Use multiple views of requirements like building data, function and behavioral models.
  1. Work to eliminate ambiguity.

 

 

  1. DATA FLOW DIAGRAM (DFD)

Data flow diagrams are the most regularly utilized method for reporting the handling of the hopeful framework. As their name recommend they are a pictorial method for speaking to the stream of data into, around, and out of the framework. They are effortlessly justifiable and are less inclined to distortion than printed depiction. A complete arrangement of DFDs gives a reduced top – down representation of the framework, which makes it less demanding for the client and the investigator to conceive the framework all in all.

DFDs are built utilizing four noteworthy parts:

  • External elements – speaks to the wellsprings of the data that enter the framework or the beneficiaries of the framework that leave the framework.
  • Data stores – speak to the stores of the data inside the framework case: COMPUTER documents, databases or in the manual framework records, and so on data stores can not be connected specifically by data streams either to each other or to outer elements without an interceding procedure to change them.
  • Processes – speak to exercises in which data is controlled by being put away or recovered or changed somehow.

 

 

 

 

 

  1. COMPLETE STRUCTURE

For the optimum use of practical time it is necessary that every session is planned. Planning of this project will include the following things:

  • Topic Understanding.
  • Modular Break – Up of the System.
  • Processor Logic for Each Module.
  • Database Requirements.

Topic Understanding:

It is vital that the field of application as introduced in the project may be totally a new field. So as soon as the project was allocated to me, I carefully went through the project to identify the requirements of the project.

Modular Break –Up of the System:

  • Identify The Various Modules In The System.
  • List Them In The Right Hierarchy.
  • Identify Their Priority Of Development
  • Description Of The Modules:

 

Modules – This project consists of different interfaces, which will be accessed through an internet server. Different modules that makeup this system is briefly described below:


  1. MODULES OF THE PROJECT

MODULE 1: User Authentication Module

MODULE 2: A New Records Being Entered

MODULE 3: Deleting or Updating the Records

MODULE 4: Tutorials

 

MODULE 5: Topics

MODULE 6: Forums

MODULE 7: Searching

MODULE 8: Admin

MODULE 9: Validation of Data Entered by the User & Error Handling

MODULE 10: Feedback

 

 

PROCESS LOGIC FOR EACH MODULE:

Validation: This login and password facility has been provided to authenticate the user. The process is designing the login form.

Record Entry: Entering the records via forms designed for user convenience and finally records are stored into the database.

Editing the records: The process is to enable user to edit. Data or information changes with time therefore records need to be updated like monthly assessment of each student etc.

Deleting the Records: The process to delete records is not available as the data can be retrieved at any time of any age.

 

8. DATA MODELING

Data Structure   Requirements according to the modules:

 

  • Identify The Various Tables Required.
  • Fields for These Tables.
  • The Various Key Fields (for example Primary key and foreign key).
  • Identify The Various Constraints like Not Null, Unique etc.

 

 

Describing Data Elements:

Each entry in the data dictionary consists of a set of details describing the data used or produced in the system.  Each item is identified by a data name, description, alias, and length  and  has  specific  values  that  are  permissible  for  it  in  the  system  being studied.

LIST OF TABLES:

  1. Admin
  2. Student Table
  1. Feedback
  1. Question
  1. Registration
  1. Topic
  1. Tutorial
  1. Answer
  1. Quiz
  1. Results
  1. Notes
  1. Department
  1. Fee
  1. Course table

 

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


  1. SECURITY AND VALIDATION CHECKS

In this project we have used following validation checks.

  • While entering the data into the form it will check for the nullity of the fields in both of client machine and server.
  • While entering the data the validation will be checking the existing records, if the records found a message will be fired to the end user as “The record already exists”.
  • The students are being granted with access only to the study materials of courses for which student is registered.
  • Passwords are encrypted using PHP before storing the data into the database. And it will be decrypted and authenticated while login into the system.

 

  1. SCOPE OF FUTURE APPLICATION

The deliverable product is named as “Online Study Center Management System”.

I have designed the given proposed Website in the PHP to automate the educational department.

The complete set of rules & procedures related to educational administrative department day to day activities and generating report is called “Online Study Center Management System”. My project gives a brief idea regarding automated educational department activities.

I have tried my best to make the complicated process of System as simple as possible using Structured & Modular technique & Menu oriented interface. I have tried to design the software in such a way that user WHO ARE ONLINE may not have any difficulty in using this package & further expansion is possible without much effort. Even though I cannot claim that this work to be entirely exhaustive, the main purpose of my exercise is perform each ADMINISTRATIVE DEPARTMENT activity in computerized way rather than manually which is time consuming.

I am confident that this software package can be readily used by non-programming personal (online users as well as management of the educational department) avoiding human handled chance of error. This project can be successfully uploaded for educational and training operations.

  1. CONCLUSION:

 

 

 

 

  1. BIBLIOGRAPHY
  • PHP
  • PHP Professional Projects