ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel
  • »
  • Education and Science»
  • Colleges & University

Synopsis for MCA Mini Project at IGNOU (sample)

Updated on February 19, 2014

Ignou Logo

Source

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 | Source

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 | Source

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

Are you a student of IGNOU?

See results

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

Source

Index Page of Mini project Synopsis of MCA

Index Page of Mini project Synopsis of MCA
Index Page of Mini project Synopsis of MCA | Source

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.

Source

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)

Source
Source
Source

The table structure of the developing system is shown below:

Table Name: tbl_user

Field Name
Data Type
Description
Null
Key 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
 
 
 
Purpose: to store details of users

Table name: tbl_usertype

Field Name
Data Type
Description
Null
Key Constraints
id
Number
Autonumber the primary key
Not Null
Primary Key
Usertype Name
Varchar2
Administrator, user , organization owner, ward member, leader
Not Null
 
Purpose: to store user types

Table Name: tbl_ward

Field Name
Data Type
Description
Null
Key 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
Purpose: to store ward details

Table Name: tbl_Family

Field Name
Data Type
Description
Null
Key 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
Purpose: to store family details

Table Name: tbl_Members

Field Name
Data Type
Description
Null
Key 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
Purpose: to store member details

Table Name: tbl_MemberType

Field Name
Data Type
Description
Null
Key Constraints
Type_ID
Number
Autonumber the primary key
Not Null
Primary Key
Member_Type
Varchar2
Father, Mother
Not Null
 
Purpose: to store member type

Table Name: tbl_SundaySchool

Field Name
Data Type
Description
Null
Key Constraints
School_id
Number
Autonumber the primary key
Not Null
Primary Key
User_ID
Number
 
Not Null
Foreign Key from user id
Purpose: to store school details

Table Name: tbl_Class

Field Name
Data Type
Description
Null
Key Constraints
Class_ID
Number
Autonumber the primary key
Not Null
Primary Key
ClassName
Varchar2
 
Not Null
 
Purpose: to store the class details

Table Name: tbl_Marks

Field Name
Data Type
Description
Null
Key Constraints
Marks_ID
Number
Autonumber the primary key
Not Null
Primary Key
School_id
Number
 
Not Null
Foreign key from school table
Purpose: to display the marks of Sunday school

Table Name: tbl_Organization

Field Name
Data Type
Description
Null
Key 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
 
 
 
Purpose: to manage organization details

Table Name: tbl_GalleryEvents

Field Name
Data Type
Description
Null
Key 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
 
 
Purpose: to manage both events and gallery information

Table Name: tbl_GalleryData

Field Name
Data Type
Description
Null
Key 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
 
 
 
Purpose: to display and store gallery images

Table Name: tbl_EventData

Field Name
Data Type
Description
Null
Key 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
 
 
 
Purpose: to display and store events

Table Name: tbl_Mass

Field Name
Data Type
Description
Null
Key Constraints
Mass_ID
Number
Autonumber the primary key
Not Null
Primary Key
MassTitle
Varchar2
 
Not Null
 
Time
dateTime
 
Not Null
 
Description
Varchar2
 
 
 
Purpose: to store details of mass

Table Name: tbl_MassTiming

Field Name
Data Type
Description
Null
Key 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
Purpose: to manage the timing of mass at various centers

Table name: tbl_Churchcentre

Field Name
Data Type
Description
Null
Key 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
Purpose: details of church centers

Table Name: tbl_Feasts

Field Name
Data Type
Description
Null
Key Constraints
Feast_ID
Number
Autonumber the primary key
Not Null
Primary Key
Feastname
Varchar2
 
Not Null
 
FeastDate
Number
The date without year
Not Null
 
Purpose: to update and display the details of feasts

Table Name: tbl_Enquiry

Field Name
Data Type
Description
Null
Key Constraints
Enquiry_ID
Number
Autonumber the primary key
Not Null
Primary Key
Enquiry
Varchar2
 
Not Null
 
Enquiry_By
Varchar2
Email id
Not Null
 
Purpose: to get the enquiry request by the members

Table Name: tbl_AlertRequest

Field Name
Data Type
Description
Null
Key Constraints
Alert_ID
Number
Autonumber the primary key
Not Null
Primary Key
User_ID
Number
 
Not Null
Foreign Key from user table
Purpose: to get the details of users who had registered for alerting them for any changes

Table Name: tbl_Timing

Field Name
Data Type
Description
Null
Key Constraints
School_time_ID
Number
Autonumber the primary key
Not Null
Primary Key
SubcentreID
Number
 
Not Null
Foreign Key from subcentres
Purpose: to display the timings of Sunday school in various sub centers

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

Comments

    0 of 8192 characters used
    Post Comment

    No comments yet.