Updated date:

Synopsis for MCA Mini Project at IGNOU (sample)

Author:

Master of Computer Application : MCA at IGNOU

IGNOU, Indhira Gandhi National Open University , or otherwise known as the People University is one of the largest open university. It offers a wide variety of courses and the distance education offered by IGNOU is accepted all over India.

Master of computer Application at IGNOU is 3year course, maximum duration given up to 6years. Total Course fee is Rs 54000/- No Age Bar to join the course.

Mini project needs to be submitted during the fourth semester of the course and before submitting, we need to submit the Project Synopsis for approval at the study center.

Here is a sample Synopsis for the students to refer.

Order of Items to be kept in the Synopsis

  1. Proforma of Synopsis [find the screen shot attached]
  2. Resume of the Guide
  3. Covering letter [find the screen shot attached]
  4. Index page [find the screen shot attached]
  5. Introduction
  6. Objective.
  7. Project Category.
  8. Software Specification.
  9. Hardware Specification
  10. Problem Definition
  11. Requirement Specifications.
  12. Project Planning and Scheduling.
  13. Analysis.
  14. Implementation of security mechanisms at various levels.
  15. Future scope and enhancement
  16. Bibliography.

Introduction

Technology has developed a lot during these years and is trying to bring everything under the shade of its umbrella. Let us think of the governmental sectors the private firms etc, all are using the features and functionality of the emerging technology for showing of their growth and also to get into the fast world. With the implementation of newer systems of information collection, compilation, storage and retrieval, it is becoming increasingly possible to provide the necessary information on time.

The demand of the public - now exposed to the possibilities offered by modern systems and technology - is becoming stronger than ever before. They are impatient for faster and more accurate information. Though the technology had reached all the ways in the fields of industries, the same has little reach in the fields of sectors like churches, and other similar institutions. Though lot many managerial matters are included in these institutions, all the functionalities are still managed manually.

One of the major responsibilities of the church is ensuring the welfare of its parishners. To do this the church needs to be able to communicate better with the people, take steps to redress grievances and ensure that systems are put in place to make life easier and benefit the parishioners. Nowadays, most of the people are having high standards of life and also with a busy schedule that it would be a grace if one could know the details of church and other related institutions with one or two clicks.

The strategy of this project is to provide a website for the most greatest and famous Syrian catholic church in Kerala, the Lourdes Forane church, Trivandrum. Almost all the parishioners of this church are basically from outside Trivandrum and if they are provided a facility to keep in touch with the events and other functions of the church and also to access the church, even from their hometown it would be of great exploit.

Sample Proforma

Screen Shot

Screen Shot

Objective

The main objectives of the project is as explained below

  • To make the functionality of the church more efficient than that now
  • To provide more transparency to the working or the functionality of the church to the Parishioners
  • To provide needed information and other details to the Parishioners in time

Some of the major roles and responsibilities of any Church is to interact with the parishioners, grievance addressed of the parishioners, execution of plans, and execution of events, data collection and other related activities. Due to the huge and ever increasing work load in a church and also because of less manpower in these areas, its efficiency has fallen significantly over time.

The proposed project specifically addresses most of these issues to improve the general efficiency of the typical church and related activities in the same.

Project Category

Web based PHP application with MySQL as back end

Sample Covering Letter for MCA Mini project synopsis

Covering Letter for MCA mini project synopsis

Covering Letter for MCA mini project synopsis

Software Specification

It is a web based environment with PHP 5.0 as the server side scripting language and MySQL 5.0 as the relational DBMS. Clients will be internet Explorer based. Mozilla, FireFox etc can also be used.

All front-end design is done using PHP with JavaScript, HTML and Cascading Style Sheets (CSS).

IGNOU University

Hardware Specification

Server:

Internet Technologies: JavaScript, HTML

PHP 5.0 and Apache Server

RDBMS/Back End: MySQL DB

Clients:

Operating System: Windows 2000/XP

RAM: 256MB, 40 GB hard disk

Browsers- IE, Mozilla or FireFox

Problem Definition

  • Details regarding the church like mass timings, procedures to get married etc can be known only by enquiring to the office
  • It is difficult in following up the requests forwarded by most of the Parishners in time.
  • Most of the time the needs can be fulfilled only if one comes and meets the parish priest and work along with the priest till the end of the event.
  • Lack of proper way to approach the church for any type of request.
  • Lack of efficient co-ordination of the request and tasks among the office staffs and other administrators.
  • Lack of skills in the modern tools of automation that enhance the efficiency and productivity.
  • People have to travel long distances to come to church to know about the news and other related information and also to get certain certificates and other notices.
  • Mostly the details of the organizations and other related information are known only to limited groups in the church. Any new updates in the organizations and other information are not noticed to all at church.
  • The working of Sunday school and the results of exams are not known to the parents, for that parents needs to come to church.
  • Now registering to the church and related procedures are unknown to most of people, even to the Parishners.
  • There is no way to let other Parishners know the personal events that occurred in church recently.
  • No way to request for prayers and all from home, without going to church.

Requirement Specifications

Website for Lourdes Forane church

The site will be able to handle and automate all the functionalities of the church. It shall be able to do the following functionalities.


The following figure shows the structure of the website of the Lourdes Forane church

Structure of website

project-synopsis-sample-for-mca-at-ignou

Index Page of Mini project Synopsis of MCA

Index Page of Mini project Synopsis of MCA

Index Page of Mini project Synopsis of MCA

The following figure shows the structure of the website of the Lourdes Forane church

Main Modules

  • User Registration

In this site each family will be having a login and for the same they have to register using their family name and with ward name. They can use their registration for uploading their details, events and image galleries. Also they can request for the alerts of events and other details of the church through email.

On the other hand admin users has access to the church related management areas like, managing the Sunday schools, institutions, organizations, mass timings, parish directories, feasts and events of church, ward details etc.

Admin will have the over all power to enter into the other user’s login and make needed changes or modifications if necessary.

  • Parish Directory management

Parish directory contains information regarding the whole members of the parish. It will be in directory format and will be supplied to the Parishners. But it will be an added advantage if an online copy of the same is also maintained. Users will be having option to search using family name, dioceses etc.

  • Institution and Organization Management

Institutions or organization can be managed by admin user. The details of the organization, the history etc can be published. Timely updating of the administrators and events occurring in the same or the events and charity done by the organization like Pithruvedi, Mathruvedi and Yuvadeepthi will let the Parishioners know about the activities of the same.

  • Events Management

Events of the church and even personal events can be managed over here. Admin will be entering the church related events and individuals and organization can enter their events so that, it will be shown in the home page section of the site.

Recent events will be shown in the first and events that had already occurred will be moved to the past event section.

  • Sunday School Management

The school management includes the details of teachers and students, class wise list. The details of students mark and academic marks. The same can be seen to the parents through request. The option will be there to request the results of the exams held to be known through email.

  • Enquiry Section

Any type of enquiry regarding the church and other related institutions will be entertained through the enquiry section. Any body can request or post their enquiries and the same will be replied to the email provided by the requester with a day’s time. Also contact number for immediate enquiry will also be provided.

  • Gallery management

Gallery management usually comes under the event management section. Based on the events happened, users can upload photos for others to view. Individuals can upload their photos related to their family, groups etc. Admin will be uploading the photo regarding the church and related institutions related photos. Admin will be having the full power to screen the photos and delete them if needed.

  • Mass time Management

The main functionality of the church is mass and every body will be having a question as when is the next mass on a particular day. The change of mass time will be entered periodically and will be seen in the site. In addition to the same, any change in the timings will be alerted to the Parishioners through their emails provided, at times.

  • Ward Management

Each wards of the church will be having their own functionalities as similar to the organizations. The same will be managed by the ward leaders. The events happening in the ward, the activities etc can be entered and displayed for the public to view the activities. Ward leader will be having access to control the login and other management details.

  • Static pages
  1. Home
  2. History
  3. Pastoral centers
  4. Road maps
  5. Institutions
  6. Prayers
  7. General Information

Project Planning and Scheduling

The development time including database design, screen designing and coding and testing is one month. First two months the screen, database design and system design will be over. Second and third month is for developing modules, architecture design and coding the site. Rest will be for testing and error correction.

project-synopsis-sample-for-mca-at-ignou

Analysis

System analysis is a detailed study of various operations performed by a system and its relationships within and outside the system. The commonly used tools for analysis are DFD (the logical representation of the analyzed system), interviews, onsite observations etc.

Analysis ( DFD Diagrams)

project-synopsis-sample-for-mca-at-ignou
project-synopsis-sample-for-mca-at-ignou
project-synopsis-sample-for-mca-at-ignou

The table structure of the developing system is shown below:

Table Name: tbl_user

Purpose: to store details of users

Field NameData TypeDescriptionNullKey Constraints

User_ID

Number

Auto Number, the primary key

Not Null

Primary Key

First_Name

Varchar2

First Name

Not Null

 

Last_Name

Varchar2

Last Name

Not Null

 

Ward_ID

Number

Ward id

Not Null

Foreign key from ward table

Job

Varchar2

Job description

 

 

DOB

Datetime

Date of Birth

 

 

Add_Address

Varchar2

Additional address if any

 

 

User_type

Number

 

Not Null

Foreign Key from usertype table

User_email

Varchar2

 

 

 

Table name: tbl_usertype

Purpose: to store user types

Field NameData TypeDescriptionNullKey Constraints

id

Number

Autonumber the primary key

Not Null

Primary Key

Usertype Name

Varchar2

Administrator, user , organization owner, ward member, leader

Not Null

 

Table Name: tbl_ward

Purpose: to store ward details

Field NameData TypeDescriptionNullKey Constraints

Ward_id

Number

Autonumber the primary key

Not Null

Primary Key

Ward_Name

Varchar2

 

Not Null

 

Location

Varchar2

 

 

 

Ward_leader

Number

 

Not Null

Foreign key from tbl_user

Table Name: tbl_Family

Purpose: to store family details

Field NameData TypeDescriptionNullKey Constraints

Family_Id

Number

Autonumber the primary key

Not Null

Primary Key

Family Name

Varchar2

 

Not Null

 

Address

Varchar2

 

 

 

Ward_ID

Number

 

Not Null

Foreign Key from ward table

Table Name: tbl_Members

Purpose: to store member details

Field NameData TypeDescriptionNullKey Constraints

Member_ID

Number

Autonumber the primary key

Not Null

Primary Key

Family_ID

Number

 

Not Null

Foreign Key from family table

User_Id

Number

 

Not Null

Foreign Key from user table

Member_Type

Number

 

Not Null

Foreign key from member type table

Table Name: tbl_MemberType

Purpose: to store member type

Field NameData TypeDescriptionNullKey Constraints

Type_ID

Number

Autonumber the primary key

Not Null

Primary Key

Member_Type

Varchar2

Father, Mother

Not Null

 

Table Name: tbl_SundaySchool

Purpose: to store school details

Field NameData TypeDescriptionNullKey Constraints

School_id

Number

Autonumber the primary key

Not Null

Primary Key

User_ID

Number

 

Not Null

Foreign Key from user id

Table Name: tbl_Class

Purpose: to store the class details

Field NameData TypeDescriptionNullKey Constraints

Class_ID

Number

Autonumber the primary key

Not Null

Primary Key

ClassName

Varchar2

 

Not Null

 

Table Name: tbl_Marks

Purpose: to display the marks of Sunday school

Field NameData TypeDescriptionNullKey Constraints

Marks_ID

Number

Autonumber the primary key

Not Null

Primary Key

School_id

Number

 

Not Null

Foreign key from school table

Table Name: tbl_Organization

Purpose: to manage organization details

Field NameData TypeDescriptionNullKey Constraints

Orga_ID

Number

Autonumber the primary key

Not Null

Primary Key

Orga_Name

Varchar2

 

Not Null

 

HeadUser_ID

Number

 

Not Null

Foreign Key from user table

Vice_presi_ID

Number

 

Not Null

Foreign Key from user table

Description

Varchar2

 

 

 

Table Name: tbl_GalleryEvents

Purpose: to manage both events and gallery information

Field NameData TypeDescriptionNullKey Constraints

Event_ID

Number

Autonumber the primary key

Not Null

Primary Key

Event_Name

Varchar2

 

Not Null

 

Event_creator

Number

 

Not Null

Foreign Key from user table

Created_Date

Datetime

 

Not Null

 

EventBy

Int

0- User 1- admin

Not Null

 

Event_Type

Int

0-GalleryImages 1- events

 

 

Table Name: tbl_GalleryData

Purpose: to display and store gallery images

Field NameData TypeDescriptionNullKey Constraints

Gallery_ID

Number

Autonumber the primary key

Not Null

Primary Key

Event_ID

Number

 

Not Null

Foreign Key from tbl_GalleryEvents

Gallery_Image

Varchar2

Filepath

Not Null

 

Gallery_title

Varchar2

 

 

 

Table Name: tbl_EventData

Purpose: to display and store events

Field NameData TypeDescriptionNullKey Constraints

Event_ID

Number

Autonumber the primary key

Not Null

Primary Key

Event_ID

Number

 

Not Null

Foreign Key from tbl_GalleryEvents

EventDescription

Varchar2

Detail description

Not Null

 

EventTitle

Varchar2

 

 

 

Table Name: tbl_Mass

Purpose: to store details of mass

Field NameData TypeDescriptionNullKey Constraints

Mass_ID

Number

Autonumber the primary key

Not Null

Primary Key

MassTitle

Varchar2

 

Not Null

 

Time

dateTime

 

Not Null

 

Description

Varchar2

 

 

 

Table Name: tbl_MassTiming

Purpose: to manage the timing of mass at various centers

Field NameData TypeDescriptionNullKey Constraints

Time_ID

Number

Autonumber the primary key

Not Null

Primary Key

Mass_ID

Number

 

Not Null

Foreign Key from Tbl_Mass table

Centre_ID

Number

 

Not Null

Foreign Key from tbl_Centre table

Table name: tbl_Churchcentre

Purpose: details of church centers

Field NameData TypeDescriptionNullKey Constraints

Centre_ID

Number

Autonumber the primary key

Not Null

Primary Key

Centre_Name

Number

 

Not Null

 

Centre_Cheif

Number

Name of administrator

Not Null

Foreign Key from user table

Table Name: tbl_Feasts

Purpose: to update and display the details of feasts

Field NameData TypeDescriptionNullKey Constraints

Feast_ID

Number

Autonumber the primary key

Not Null

Primary Key

Feastname

Varchar2

 

Not Null

 

FeastDate

Number

The date without year

Not Null

 

Table Name: tbl_Enquiry

Purpose: to get the enquiry request by the members

Field NameData TypeDescriptionNullKey Constraints

Enquiry_ID

Number

Autonumber the primary key

Not Null

Primary Key

Enquiry

Varchar2

 

Not Null

 

Enquiry_By

Varchar2

Email id

Not Null

 

Table Name: tbl_AlertRequest

Purpose: to get the details of users who had registered for alerting them for any changes

Field NameData TypeDescriptionNullKey Constraints

Alert_ID

Number

Autonumber the primary key

Not Null

Primary Key

User_ID

Number

 

Not Null

Foreign Key from user table

Table Name: tbl_Timing

Purpose: to display the timings of Sunday school in various sub centers

Field NameData TypeDescriptionNullKey Constraints

School_time_ID

Number

Autonumber the primary key

Not Null

Primary Key

SubcentreID

Number

 

Not Null

Foreign Key from subcentres

Implementation of security mechanisms at various levels

The modules data is stored in the database. It can be accessed only by user who is having access permission. Access control module also gives security to all application modules. This module is for administrative purpose for giving task level permission to users of the Application.

Security refers to the protection of data against unauthorized access, alteration, or destruction. Security measures are applied to the proposed system at different levels. There are two type of access to the system, one for administrative purposes and other for the client activities. It provides high security because a client can modify only permitted areas. Primary Key validation is used in this project Password protection is provided at the application level, so that the unauthorized users have no access to the application.

Future scope and enhancement

This software will help to reduce manual effort and time. It also provides security. The proposed system is user-friendly and every aspects of this system can be easily understood and the user can operate the system easily. We have planed to develop this software as independent in nature and cost effective. As the saying goes “There is always scope for the improvement in every system”, even this system could be improved at various stages.

The enhancements are

  • Additional modules such as payment for various registration and other fees.
  • Alerts through SMS and fax etc.

Bibliography

© 2013 DEEPA JOHN

Related Articles