Synopsis Matrimony 4gw6m
This document was ed by and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this report form. Report 3b7i
Overview 3e4r5l
& View Synopsis Matrimony as PDF for free.
More details w3441
- Words: 7,224
- Pages: 48
ONLINE MATRIMONIAL SYSTEM
SYNOPSIS 1. TITLE OF THE PROJECT
ONLINE MATRIMONIAL SYSTEM The project entitled Online Matrimonial Systemis web-based software developed to aid the activities of marriage bureau. Online Matrimonial System is a virtual marriage bureau, providing free service to bride and grooms world-wide.
2. INTRODUCTION & OBJECTIVES
2.1 INTRODUCTION Online Matrimonial System is a virtual marriage bureau, providing free service to bride and grooms world-wide. One can place his / her profile with photograph without any charge. Here Men or women can with or without their photos. There are umpteen -friendly search options for men to choose from to help them land at the best. A member can post their profile, add their photo to it, and receive mails of matching profiles and Use "Express Interest" to send an automated message expressing your interest to a member.
The Online Matrimonial System is designed for s to find out their best matching pair. This site includes two main modules such as side and side. Any can search the website without registration but only the ed can express his/her interest to another . The has whole power in this site such as approving registration, editing and deleting of details. The can
Page | 1 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM their photo into the site after approving his/her registration. The ed can into the site and also can change their profile.
2.2 OBJECTIVES Online Matrimonial System is a real time project to create efficient software for online marriage. This software module is designed to provide detailed information about marriage bureau. This project has a communication between different modules and a common database is created.
Online Matrimonial System provides the efficient matrimonial website, a provision for viewing the latest status of the service. The web service provides you the maximum benefit by providing the information about various s located at various places, there by managing them effectively.
3. PROJECT CATEGORY The project entitled “Online Matrimonial System” can be categorized as RDBMS(Relational Database Management System). RDBMS is a type of database management system (DBMS) that stores data in the form of related tables. Relational databases are powerful because they require few assumptions about how data is related or how it will be extracted from the database. As a result, the same database can be viewed in many different ways. One of the most outstanding systems is Microsoft SQL Server 2008. Microsoft SQL Server is a relational database server, developed by Microsoft: it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet). There are at least a dozen
Page | 2 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM different editions of Microsoft SQL Server aimed at different audiences and for different workloads.
4. TOOLS/PLATFORM, HARDWARE AND SOFTWARE REQUIREMENT SPECIFICATIONS. 4.1 TOOLS/PLATFORM Online Matrimonial System uses .NET platform for design and Microsoft SQL Server as
RDBMS. .NET allows applying common skills across a variety of devices, application types, and programming tasks. It enables integration with other tools and technologies to build the right solution with less effort and time. Microsoft SQL Server is a computer application used to create desktop, enterprise, and web-based database systems. It is used at different levels and with various goals. Frond End: ASP.Net 4.0 with C# ASP.NET is a Web application framework developed and marketed by Microsoft to allow programmers to build dynamic web sites, web applications and web services. In this project, asp.net application could be written in C# language. Back End: SQL SERVER 2008 Express Edition Microsoft SQL Server 2008 Express is a powerful and reliable data management system that delivers a rich set of features, data protection, and performance for embedded application clients, light Web applications, and local data stores. Web Server: Internet Information Services (IIS) IIS formerly called Internet Information Server – is a web server application and set of feature extension modules created by Microsoft for use with Microsoft Windows.
Page | 3 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM
4.2 SOFTWARE SPECIFICATONS
Operating System
:
Windows XP Server
Front End
:
ASP.Net 4.0 with C#
Back End
:
SQL Server 2008
Web Server
:
IIS 7.0
Web Browser
:
Internet Explorer 7.0
Internet Technologies
:
JavaScript
4.3 HARDWARE SPECIFICATONS
Processor
:
Pentium 2 GHz
RAM
:
1GB
Hard disk
:
80 GB
Monitor
:
VGA
Keyboard
:
Standard Keyboard
Mouse
:
Standard Mouse
Page | 4 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM
4.4 SOFTWARE REQUIREMENT SPECIFICATION
A software requirements specification is a document which is used as a communication medium between the customer and the supplier. When the software requirement specification is completed and is accepted by all parties, the end of the requirements engineering phase has been reached. This is not to say, that after the acceptance phase, any of the requirements cannot be changed, but the changes must be tightly controlled.
Benefits of SRS
Forces the s to consider their specific requirements carefully.
Enhances communication between the Purchaser and System developers.
Provides a firm foundation for the system design phase.
Enables planning of validation, verification, and acceptance procedures.
Enables project planning e.g. Estimates of cost and time, resource scheduling.
Usable during maintenance phase.
Introduction In this Project basically focus on all the world of people who want to find their life partner. This system is made for connect the all these from all over the world and can provide facilities for all age of member.To provide suitable match for brides and grooms for Kerala across the world. No payments to be made by anyone for use of application. Providing these facilities for people and they can find easily information & news related the different religions. Purpose The purpose of this document is to present a detailed description of the Online Matrimonial System. It will explain the purpose and features of the system, the interfaces of the system, what the system will do, the constraints under which it must operate and how the system will react to external stimuli. The purpose of this project is
Page | 5 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM providing a platform to people for connecting from worldwide.Still there is no any platform for connect on internet through the website. Scope Online Matrimonial System provides matrimonial services to all people. In this system provide matrimonialsection where people can him/her profile and easily find life partners.The software will facilitate communication between and s.
Background This Website is based on ASP.NET with C# include 4.0 .NET framework with the securities of managing the s and the resources. The SQL Server is used as database.
5. PROBLEM DEFINITION, REQUIREMENT SPECIFICATIONS, PROJECT PLANNING AND SCHEDULING 5.1PROBLEM DEFINITION 5.1.1 EXISTING SYSTEM Now a day a lot of Matrimonial consultancies are listed. Most of these companies are working manually without the help of a system. Checking of existing records, editing and other reporting are done manually. It is a time consuming process. Natural behaviors of these companies are o Profiles can himself in a particular Matrimony company o He or she can submit their biodata and Photo there o Staff of the company should identify each Profiles area and make a manual search for suitable requirements o If they find a matched Profile they have to inform him or her about this
Profile
o They search more about this Profile
Limitations of the Existing System
Page | 6 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM Main limitation is time consuming. Here all works are done manually. If there are a lot of applicants, it is very difficult to staff to check the profile, sort the profile and delete all expired profiles. So it will take more time and it is uncomfortable. And also company must manually keep files and maintain it manually. It is not applicable in the case of this System and it is not friendly. Another limitation is in the field of biodata submission. If a Profile wants to modify his/her biodata, it will be a Herculean task. There is no centralized control over all operations. So the existing system doesn’t work properly. So an automated service system is needed.
5.1.2 PROPOSED SYSTEM The proposed system is fully web enabled and builds with the help of Microsoft’s latest web technologies. The main objective is to provide matrimonial for Groom and Brides. Everyone can access the service through a web browser from anywhere in the world because the service is totally centralizes.
Main advantages of the proposed system The proposed system is fully web based. So it can provide centralized control over the criteria. It is fast, friendly and comfortable. The objectives of this system are: -
-
1. To save time. 2. To provide accurate information about the s. 3. Ease of use. 4. Reduce money and very less effort to take.
5.2 REQUIREMENTS SPECIFICATION A detailed statement of the exact results we or the customer want to get from a project. Page | 7 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM A condition or capability that must be met or possessed by a system, product, service, result or component to satisfy a contract, standard, specification or other formally imposed documents. Requirements include the quantified and documented needs, wants and expectations of the sponsor, customer and other stakeholders. A requirements specification is a defined goal that details the desired end result of a project. This helps project managers to ensure that they are delivering exactly what their customers want, because it is specified and communicated clearly to those involved in the project.
FUNCTIONAL REQUIREMENTS Functional requirements capture the intended behavior of the system. This behavior may be expressed as services, tasks or functions the system is required to perform. This white paper lays out important concepts and discusses capturing functional requirements in such a way that they can drive architectural decisions and be used to validate the architecture.
The following is a running list of possible Online Matrimonial System Requirements: 1. s the activation of s 2. s the search and views profile 3. the interesting profile send mail 4. the Know the profileStatistics.
TECHNICAL SPECIFICATION Technical specifications are typically written by the developers and coders, and describe how they will implement the project. The developers work from the functional specifications, and translate the functions into their actual coding practices and methodologies.
Page | 8 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM 5.3
PROJECT PLANNING & SCHEDULING
The key to a successful project is in the planning. Creating a project plan is the first thing you should do when undertaking any kind of project.Often project planning is ignored in favor of getting on with the work. However, many people fail to realize the value of a project plan in saving time, money and many problems. Project scheduling looks at which tasks need to be performed for a project and assigns deadlines for their completion. The project scheduler sets these deadlines by calculating how long each task should take to perform. Scheduling requires a comprehensive understanding of which action steps need to get done and when.
To provide a brief introduction to project planning and scheduling.The critical area where project management meets system development.
Steps in the Planning Process
1) Identify the tasks. 2) Clearly state the objective of each task. 3) Estimate the Personnel, Time and Resources to meet objectives. 4) Develop a task sequence. 5) Estimate the product development costs.
5.3.1
GANTT CHART
The bar or Gantt chart is a widely used simple project scheduling technique.Gantt chart is a type of bar-chart that shows both the scheduled and completed work over a period. A time-scale is given on the chart's horizontal axis and each activity is shown as a
Page | 9 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM separate horizontal rectangle whose length is proportional to the time required for the activity's completion. o
Advantages include:
Direct correlation with time.
Straight forward relationship with projects involving a limited number of tasks.
Straight forward integration of subtasks having separate scheduling charts.
Time schedule is flexible and is expanded to show tasks of shorter nature.
Progress against the plan is easily reflected
Following table illustrates the various project tasks and time (in Weeks and Days) required, for the synopsis development of “Online Matrimonial System”. Sl. No
ACTIVITIES
DAYS
Sl.No
Activities
Days
1
Requirement Study
5
2
System Study
5
3
System Analysis
5
4
System Design
7
6
Testing
6
5
Documentation
5
Page | 10 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM
ID
Task Name
Start
Finish
Duration
1 Requirement Study
5/25/2017
5/29/2017
5d
2 System Study
5/30/2017
6/3/2017
5d
3 System Analysis
6/4/2017
6/8/2017
5d
4 System Design
6/9/2017
6/15/2017
7d
5 Testing
6/16/2017
6/21/2017
6d
6 Doumentation
6/22/2017
6/26/2017
5d
May 2017
Jun 2017
25 26 27 28 29 30 31 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
Gantt Chart
5.3.2 PERT CHART A project management tool that provides a graphical representation of a project’s timeline. PERT, or Program Evaluation Review Technique, was developed by the United States Navy for the Polaris submarine missile program in the 1950s. PERT charts allow the tasks in a particular project to be analyzed, with particular attention to the time required to complete each task, and the minimum time required to finish the entire project.
Page | 11 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM Requiremet Study
5/30/2017
Testing
5/25/2017
5/29/2017
5/30/2017
6/3/2017
6/4/2017
6/8/2017
5/25/207
5/29/2017
5/30/2017
6/3/2017
6/4/2017
6/8/2017
System Design
System Design
Documentation
6/9/217
6/15/2017
6/16/207
6/21/2017
6/22/2017
6/26/2017
6/9/2017
6/15/207
6/16/207
6/21/2017
6/22/2017
6/26/2017
Figure: PERT CHART
6. SCOPE OF THE SOLUTION This system will provide the leadership and necessary to sustain long-term growth and customer satisfaction for our world-class customers and ionately promote quality and service at all levels while enhancing company’s competitive advantage. Requirement Analysis encomes the tasks that go into determining the requirements of the new system, taking of the possibly conflicting and requirements of the various s. In the flexibility of the uses, the interface has been developed a graphics concept in mind, associated through a browsers interface.
1. Scope determines the boundary within which the system works. 2. s of the system are and s. Page | 12 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM
7. ANALYSIS System development is having two major components: System analysis and System design. System analysis is the process of collecting and interpreting facts, understanding problems and using the information to suggest improvements on the system. This will help to understand the existing system and determine how computers make its operation more effective. System design is a process through which requirements are translated into a representation of the software. It is the activity of decision-making. The system design is concerned with in the transformation of requirements into data and software architecture. Then it focuses on the refinements for the architectural representations that lead to detailed data structures and algorithmic representation of software. Depending on the applications and project requirements, a good design is one, which allows efficient code to be produced, and whose implementation is as compact as possible.
7.1 DATA FLOW DIAGRAM Data flow diagram represents one of the most ingenious tools for structured analysis. A DFD has the purpose of clarifying system requirements and identifying major transformations that will become programs in system design. It is the major starting point in the design phase that functionally decomposes the requirement specifications down to the lowest level of detail. A DFD consists of a series of bubbles ed by lines. The bubble represents the data transformation and lines represent data flow in the system. In the normal conventional DFD have 5 major symbols. o Square which defines source or destination of data o An arrow identifies dataflow- data in motion. It is a pipeline through which information flows. Page | 13 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM o A circle or bubble represents a process that transforms incoming data flow(s) into outgoing data flow(s). o An open rectangle is a data store- data at rest or a temporary Repository of data. o An open rectangle with a bar represents a data store (file), which is repeatedly referenced Symbols used in DFD
It defines a source or destination of system data.
It represents a process that transforms incoming data flow into outgoing data flow.
It defines data flow. It is a pipeline through which information flows It is used to store data or a temporary repository of data.
Page | 14 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM
LEVEL 0 DFD
Reports
Profile
Online Matrimonial System
Manage System
Search Results
Page | 15 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM
LEVEL 1 DFD ()
Registration Details
D er
ils eta
ils eta D gin Lo
Registration
Re gis De tratio tail n s
Us
1.0 Registration
Check name & Request
2.0
alid If V
in
If Valid
ails h Det Searc
hD arc Se
If inv alid l og
2.1 View Profile
Profile Details
ils eta
Registration 3.0 Search
Us
file D
eta ils
Detai ls
er D
eta ils
Interest_Received
InterestSent
Profile Details
3.1 Express Interest
Pro
3.2 Mailing
Page | 16 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM LEVEL 2 DFD ( REGISTRATION)
Education_Category
Mother_ Tongue
Occupation
To ngu e
Height Weight Weig ht
State
He igh t
Blood group
Citizenship BloodGroup
State
City
ls tai De
nship Citize ils Deta
ion lig Re
Ca ste
Country
City
Caste
ry unt Co
tion uca Ed
Religion
O
Star
n tio a up cc
Star Details 1.0 Registration
etails tion D a r t s i Reg
Re gis tr
Details
Request
ati on D
2.0
eta ils
Profile Details Invalid Registration
Valid 3.0 View Profile
3.1.1 Photo
ew Vi
U De ser tai ls
3.1.3 Delete Profile
Up dat e De Prof tail ile s
est to Requ ad Uplo
Photo Details
Photo
3.1.2 Edit Profile
Page | 17 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM
LEVEL 2 DFD ( SEARCHING)
Details
Religion Religion
ls Detai
2.1 Search by Religion
1.0
Profile Details
Valid
Search Details
Caste Caste 2.0 Search
2.2 Search by Caste
Profile Details
Education 2.3 Search by Education
Education_Category
Profile Details
2.4 Search by ProfileId
Registration
Profile Details
2.5 Search by City
Profile Details
City
City
Page | 18 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM
U Request
Failure
Response
1.
e nam r e s sw Pas
ord
Success
2. Online Matrimonial System
Page | 19 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM FIRST LEVEL DFD FOR
Mother_tongue
Request to Manage
Response
1.0 Mother Tongue
Request to Add Religion
2.0 Religion
Request to Enter
n
Response
Caste
3.0 Cast
Request to Manage
io lig Re
s tail De
4.0 Education Category
Response
ti Educa
on De
tails
Education_Category
Response Request to Manage
Request to
5.0 Citizenship
6.0 Activate/ Reject
Citzenship
Response
Response Request to View
7.0 View Express Interst
Response
Success_stories Request to Publish
7.0 Success Story
Response
Page | 20 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM SECOND LEVEL DFD FOR ACTIVATION 6.0 Requst to
6.1. New Registration
Details Registration
Approval Response
Approval Request Approval Response
6.2 Activate or Reject
Update Status
Activated
name , 6.3 Invalid
Valid
Response
6.4 Online Matrimonial System
Page | 21 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM SECOND LEVEL DFD FOR EXPRESS INTEREST 7.0 Interest_Received
7.1 Interest Received
st re te In ved w i ie e V Rec
Interest Received Profiles Response
Interest Sent Profiles
InterestSent
View Interest Sent Request to View
7.1 Interest Sent
7.1 Express Interest
Response
Re que st t oV
Favourite Profiles
iew
Favourites 7.1 Faviourites Response
7.2ER DIAGRAM An Entity Relationship model (ER model for short) 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. Diagrams created by this process are called Entity Relationship diagrams or ER diagrams. A conceptual ER model may be used as the foundation for one or more logical data models. The purpose of the conceptual ER model is then to establish structural metadata commonality for the master data entities between the set of logical ER models. The conceptual data model may be used to form commonality relationships Page | 22 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM between ER models as a basis for data model integration. The following are some DFD symbols used in the project
Rectangles represent entity sets.
Diamonds represent relationship sets. Lines link attributes to entity sets and entity sets to relationship sets.
_________
Underline indicates primary key attributes.
Page | 23 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM
HeightId Photo
Heightcm
Heightft _Date
RegId Star_id
Height
PhotoId
StarName
_Time RegId
OccupId
Status
Has
Photos
Occupation
Star Include
Occupation LangId
BloodId
Name
Marital_Status
Age
Language RegId
Add_date FavId
NoOfChildren
ReligionId
Blood_Group
Religion CasteId
Has
Mother_Tongue
_summary
BloodGroup
Has
Registration
Caste ReligionId
Religion Caste
RegId FavRegId Favourites
From
Title
Education
EduId
CountryId
Country
Add
SDate
StoryId Has
Education_Category
IS A
Country
Message Sent_Date SentId
View
CountryId
CitizenId
Citizen
Name
State RegId
RegId
Success_Stories
StateId
ToRegId
Story
Cityzenship
State
name Status
Rec_Date FromRegId
InterestSent CityId
CityName
CountryId
d RecI
StateId
Interest_Received IS A
City
Activate
Hitdate
View
Manage
News_Date
HitNo
Hit
Mail_From News_title
News
_ID News News
Subject
_Id Mail
Mail Mail
Page | 24 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM 7.3 USE CASE DIAGRAMS ONLINE MATRIMONIAL SYSTEM Manage Religion Manage Caste Manage Education category Manage Country
Manage State
Manage City Manage Citizenship
Manage Blood_Group
Manage Mother_Tongue
Manage Occupation
Manage star Manage Height
View and activate registration View 's summary View interest received
View interest sent View and publish success
View Stories
Page | 25 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM
ONLINE MATRIMONIAL SYSTEM New Registration
Update Profile
Search profile
Add to favourites
View interest received
Send interest
View success stories
Generate hit
Page | 26 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM 7.4
STRUCTURE OF THE MODULES ONLINE MATRIMONIAL SYSTEM
Manage Religion
New Registration
Manage Caste
Update Profile
Manage Education_Category
Search profile
Manage Country
Add to favourites
Manage State
View interest received
Manage City
Send interest
Manage Cityzenship
View success stories
Manage Blood_Group
Generate hit
Manage Mother_Tongue Manage Occupation Manage Star Manage Height View and activate registration View 's summary View interest received View interest sent View and publish success View stories View hit
Page | 27 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM 7.5CLASS DIAGRAM
Page | 28 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM 8. COMPLETE DATABASE DESIGN
Registration
Religion PK
PK
ReligionId Religion
City
Caste
PK
CityId
FK1 FK2
CityName CountryId StateId
Country PK
PK
CasteId
FK1
Caste ReligionId
CountryId Country
State PK
StateId
FK1
State CountryId
_summary Star PK FK1
StarId
RegId _Date _Time Status
Star Name
Height Mail PK
PK
HeightId
Mail_ID
Heightcm Heightft
InterestSent Mail_From Mail_To Subject Mail Mail_Date Mail_Time
PK
SentId
FK1
RegId ToRegId Message Sent_Date
News PK
News_ID News_title News News_Date Status
Photos PK
PhotoId
FK1
Photo PhotoDescr RegId
PK
name Name Status
Success_Stories PK
StoryId
Cityzenship
RegId
Name Age Gender Marital_Status NoOfChildren LivingStatus Resid_Status Employ Email name BodyType Weight Complexion Physical_Status Eating_habits CasteNobar Subcaste Horos_match Chovva Adderss Phone Mobile Aboutme Profilefor Profileby Familyvalue Familytype FamilyStatus NoOfbrothers NoOfsisters AboutFamily RegDate VisitCount Int_sent Int_Rec Status ReligionId FK1 CasteId FK2 CountryId FK3 StateId FK4 CityId FK5 CitizenId FK6 EduId FK7 BloodId FK8 LangId FK9 FK10 OccupId FK11 StarId FK12 HeightId
PK
Citizen
Education_Category PK
EduId Education Blood_Group
PK
BloodId BloodGroup
Mother_Tongue PK
LangId Language
Occupation PK
OccupId Occupation
Favourites PK
FavId
FK1
RegId FavRegId Add_date
Interest_Received PK
RecId
FK1
RegId FromRegId Message Rec_Date Hit
PK Title From Story SDate
CitizenId
Hitdate HitNo
9. COMPLETE STRUCTURE Page | 29 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM This software module is designed to provide detailed information about the activities of and s.
9.1 MODULES AND DESCRIPTIONS A module is a bounded contiguous group of statements having a single name and that can be treated as a unit. In other words, a single block in a pile of blocks.
The Online Matrimonial System includes two main modules.
1. ISTRATIOR istration module consist of three sub-modules
1.1. Add Details This sub module of enables to add new items to the database. Details Such as Religion, Education category, caste, occupation etc
1.2. Edit Details At each entry into the matrimonial data base, the has got the power to edit the details before adding to its original list of items. And it is being performed within a specified time stamp. Validation of profiles is done manually. meticulously validates each and every profile carefully on specific criterion before it is added to our database. Hence, it takes 24 hrs to validate all the profiles that are being added on one particular day. Almost every word counts. categorically ignores profiles that are submitted by underage persons, and profiles that contain abusive content. reject profiles that contain invalid data such as added for fun/ looking for friendship / not related to marriage. We try and maintain the highest quality in the database we serve.
Page | 30 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM 1.3. Delete Details As of the power to edit the details, has also got the power to delete an added Item from the list.
2. module consist of three sub-modules
1.1 Registration A Member at Online Matrimonial System can
Post Profile.
Update Profile.
Delete Profile.
Know the ProfileStatistics.
1.1.1 Post Profile (Registration). Here men or women can with or without their photos. The form to add your profile will be displayed. must give all the necessary as well as optional details as possible, including the details in full. This will increase the chances of your profile being displayed when our search for matches. After you submit your information, your profile will be automatically created and you shall be given a "Matrimony ID" generated for future references.
1.1.2 Update Profile s can modify the profile contents that are displayed. 1.1.3, Delete Profile s can delete their profile .Profile once deleted cannot be restored or reactivated. 1.1.4, Know the profileStatistics. In the profile Statistics page can view their details such as name, age, education and occupation details etc. can also view their interest received details and interest sent details Page | 31 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM 1.2 Searching Online Matrimonial System provides s with the following options to search ’s soul mate. o Advanced search o Regular search o Search by Profile Number. o Search by Religion o Search by Country o Search by Caste o Search by Education
1.2.1 Advanced Search :-Advanced Search is designed to cover every aspect of your search criteria delivering such profiles. Advanced Search has additional options of searching for profiles using keywords, caste no bar option, search on the basis of residing state and physical status to further bring profiles closest to expectations.
1.2.2 Regular Search :-This is the regular search that allows you to search for based on age/ language/caste/height etc. 1.2.3 Search by profile number :-Every profile at Online Matrimonial System is identified by a unique profile number.This could be handy in a situation where you have been supplied a profile number by a member and you like to view the complete profile. You can thus skip the hassles of browsing through long pages of search results. It is a convenient way to search for a list of prospective partners based on a few basic fields.
1.2.4 Search by Religion : -It is a convenient way to search for a list of prospective partners based on religion.
1.2.5 Search by Country :-It is a convenient way to search for a list of prospective partners based on country. Page | 32 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM
1.2.6 Search by caste :-It is a convenient way to search for a list of prospective partners based on caste.
2.2.7 Search by Education :-It is a convenient way to search for a list of prospective partners based on education.
1. 3. EXPRESS INTEREST Express Interest is an exclusive feature that enables you to send automated messages to absolutely FREE. can send unlimited Express Interest messages to anyone you choose and can also accept any number of Express interest messages sent to you by other .
9.2 DATA STRUCTURES 1. Religion Constraint Name
Type
Reference Table(If any)
Remarks
ReligionId
Primary Key
Unique
Column Name
Data Type
Width
ReligionId
Int
4
Yes
Identification
Religion
Varchar
30
Yes
Name Of Religion
Not Null
Description
2. Caste Constraint Name
Type
CasteId
Primary Key
ReligionId
Foreign Key
Column Name
Reference Table(If any)
Remarks Unique
Religion
Data Type
Width
Not Null
Description
CasteId
Int
4
Yes
Identification
Caste
Varchar
20
Yes
Name Of Caste Page | 33
IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM ReligionId
Int
4
Yes
ReligionIdentification
3. Education_Category Constraint Name EduId Column Name
Type
Reference Table(If any)
Primary Key
Remarks Unique
Data Type
Width
Not Null
Description
EduId
Int
4
Yes
Identification
Education
Varchar
30
Yes
Name Of Education
4. Country Constraint Name CountryId Column Name
Type
Reference Table(If any)
Primary Key
Remarks Unique
Data Type
Width
Not Null
Description
CountryId
Int
4
Yes
Identification
Country
Varchar
30
Yes
Name Of Country
5. State Constraint Name
Type
StateId
Primary Key
CountryId
Foreign Key
Column Name
Reference Table(If any)
Remarks Unique
Country
Data Type
Width
Not Null
Description
StateId
Int
4
Yes
Identification
CountryId
Int
4
Yes
Country Identification
State
Varchar
30
Yes
Name Of State
Page | 34 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM
6. City Constraint Name
Type
Reference Table(If any)
CityId
Primary Key
CountryId
Foreign Key
Country
StateId
Foreign Key
State
Column Name
Remarks Unique
Data Type
Width
Not Null
Description
CityId
Int
4
Yes
Identification
CityName
Varchar
30
Yes
Name Of City
CountryId
Int
4
Yes
Country Identification
StateId
Int
4
Yes
State Identification
7. Cityzenship Constraint Name CitizenId
Type
Reference Table(If any)
Primary Key
Column Name
Remarks Unique
Data Type
Width
Not Null
Description
CitizenId
Int
4
Yes
Identification
Citizen
Varchar
30
Yes
Name Of Cityzenship
8. Blood_Group Constraint Name BloodId Column Name
Type
Reference Table(If any)
Primary Key
Remarks Unique
Data Type
Width
Not Null
Description
BloodId
Int
4
Yes
Identification
BloodGroup
Varchar
20
Yes
Name Of Blood group
9. Mother_Tongue Page | 35 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM Constraint Name LangId
Type
Reference Table(If any)
Primary Key
Column Name
Remarks Unique
Data Type
Width
Not Null
Description
LangId
Int
4
Yes
Identification
Language
Varchar
30
Yes
Name Of Language
10. Occupation Constraint Name OccupId Column Name
Type
Reference Table(If any)
Primary Key
Remarks Unique
Data Type
Width
Not Null
Description
OccupId
Int
4
Yes
Identification
Occupation
Varchar
30
Yes
Name Of Occupation
11. Star Constraint Name Star Id Column Name
Type
Reference Table(If any)
Primary Key
Remarks Unique
Data Type
Width
Not Null
Description
StarId
Int
4
Yes
Identification
StarName
Varchar
20
Yes
Name Of Language
12. Height
Constraint Name HeightId Column Name HeightId
Type
Reference Table(If any)
Primary Key
Unique
Data Type Int
Remarks
Width 4
Not Null Yes
Description Identification Page | 36
IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM Heightcm
Varchar
20
Yes
Height in Centimeter
Heightft
Varchar
20
Yes
Height in foot
13. Registration Constraint Name
Type
Reference Table(If any)
RegId
Primary Key
ReligionId
Foreign Key
Religion
CasteId
Foreign Key
Caste
CountryId
Foreign Key
Country
StateId
Foreign Key
State
CityId
Foreign Key
City
CitizenId
Foreign Key
Citizenship
EduId
Foreign Key
Education_Category
BloodId
Foreign Key
Blood_Group
LangId
Foreign Key
Mother_Tongue
OccupId
Foreign Key
Occupation
StarId
Foreign Key
Star
HeightId
Foreign Key
Height
Column Name
Remarks Unique
Data Type
Width
Not Null
Description
RegId
Int
4
Yes
Identification
Name
Varchar
50
Yes
Name
Age
Int
4
Yes
Age
Gender
Varchar
10
Yes
Gender
Marital_Status
Varchar
20
Yes
MaritalStatus
NoOfChildren
Int
4
Yes
NoOfChildren
LivingStatus
Varchar
20
Yes
LivingStatus
Page | 37 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM ReligionId
Int
4
Yes
ReligionId
CasteId
Int
4
Yes
Caste Id
CountryId
Int
4
Yes
CountryId
StateId
Int
4
Yes
State Id
CityId
Int
4
Yes
City Id
CitizenId
Int
4
Yes
Citizenship
EduId
Int
4
Yes
EduId
BloodId
Int
4
Yes
BloodId
LangId
Int
4
Yes
LangId
OccupId
Int
4
Yes
OccupId
StarId
Int
4
Yes
StarId
HeightId
Int
4
Yes
HeightId
Resid_Status
Varchar
20
Yes
Residential Status
Employ
Bit
1
Yes
Employment
Email
Varchar
50
Yes
Email
name
Varchar
20
Yes
name
Varchar
20
Yes
BodyType
Varchar
20
Yes
BodyType
Weight
Varchar
20
Yes
Weight
Complexion
Varchar
20
Yes
Complexion
Physical_Status
Varchar
20
Yes
Physical_Status
Eating_habits
Varchar
20
Yes
Eating_habits
CasteNobar
Bit
1
Yes
CasteNobar Page | 38
IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM Subcaste
Varchar
50
Yes
Subcaste
Horos_match
Varchar
20
Yes
Horoscopematch
Chovva
Varchar
20
Yes
ChovvaDosham
Adderss
Varchar
50
Yes
Adderss
Phone
Bigint
8
Yes
Phone
Mobile
Bigint
8
Yes
Mobile
Aboutme
Varchar
100
Yes
Aboutme
Profilefor
Varchar
25
Profileby
Varchar
20
Yes
Profileby
Familyvalue
Varchar
50
Yes
Familyvalue
Familytype
Varchar
50
Yes
Familytype
FamilyStatus
Varchar
50
Yes
FamilyStatus
NoOfbrothers
Varchar
20
Yes
NoOfbrothers
NoOfsisters
Int
4
Yes
NoOfsisters
AboutFamily
Varchar
100
Yes
AboutFamily
RegDate
Date
8
Yes
Registration Date
VisitCount
Int
4
Yes
Visit count
Int_sent
Int
4
Yes
Total Interest Sent
Int_Rec
Int
4
Yes
Total Interest
Profile for
Received Status
Varchar
20
Yes
Registration Status
14. _summary
Page | 39 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM Constraint Name RegId
Type Foreign Key
Column Name
Reference Table(If any)
Remarks
Registration
Data Type
Width
Not Null
Description
RegId
Int
4
Yes
Identification
_Date
Date
8
Yes
Date
_Time
Varchar
10
Yes
Time
Status
Varchar
10
Yes
Status
15. Photos Constraint Name
Type
Reference Table(If any)
PhotoId
Primary Key
RegId
Foreign Key
Registration
Data Type
Width
Column Name
Remarks Unique
Not Null
Description
PhotoId
Int
4
Yes
PhotoId
Photo
Varchar
50
Yes
Photo
PhotoDescr
Varchar
25
Yes
PhotoDescription
RegId
Int
4
Yes
RegId
16. Favourites
Constraint Name
Type
Reference Table(If any)
FavId
Primary Key
RegId
Foreign Key
Registration
FavRegId
Foreign Key
Registration
Data Type
Width
Column Name
Remarks Unique
Not Null
Description Page | 40
IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM FavId
Int
4
Yes
RegId
Int
4
Yes
FavRegId
Int
4
Yes
Add_date
Date
8
Yes
17. Interest_Received
Constraint Name
Type
Reference Table(If any)
RecId
Primary Key
RegId
Foreign Key
Registration
FromRegId
Foreign Key
Registration
Data Type
Width
Column Name
Remarks Unique
Not Null
Description
RecId
Int
4
Yes
RecId
RegId
Int
4
Yes
RegId
FromRegId
Int
4
Yes
From RegId
Message
Varchar
50
Yes
Message
Rec_Date
Date
8
Yes
Received Date
18. InterestSent
Constraint Name
Type
Reference Table(If any)
SentId
Primary Key
RegId
Foreign Key
Registration
ToRegId
Foreign Key
Registration
Data Type
Width
Column Name
Remarks Unique
Not Null
Description Page | 41
IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM SentId
Int
4
Yes
Sent Id
RegId
Int
4
Yes
RegId
ToRegId
Int
4
Yes
To RegId
Message
Varchar
50
Yes
Message
Sent_Date
Date
8
Yes
Sent Date
19.
Constraint Name name
Type
Reference Table(If any)
Primary Key
Column Name
Remarks Unique
Data Type
Width
Not Null
Description
name
Varchar
20
Yes
name
Varchar
20
Yes
Name
Varchar
30
Yes
Name
Status
Varchar
10
Yes
Status
20. Success_Stories
Constraint Name
Type
Reference Table(If any)
StoryId Column Name
Remarks Unique
Data Type
Width
Not Null
Description
StoryId
Int
4
Yes
StoryId
Title
Varchar
30
Yes
Title
From
Varchar
30
Yes
From Page | 42
IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM Story
Varchar
30
Yes
Story
SDate
Date
8
Yes
Submit Date
21. News Constraint Name
Type
News_ID
Primary
Reference Table (If Any)
Remarks Unique id to this table
Key Column Name
Data Type
Length
Not Null
Description
News_ID
Int
4
Yes
News ID
News_title
Varchar
20
Yes
News title
News
Varchar
20
Yes
News
News_Date
Date
8
Yes
News Date
Status
Varchar
20
Yes
Status
9.3 PROCESS LOGIC FOR ALL MODULES
Module Create new registration Enter name and Check name, and roles are valid or not. If valid , allow access to the authenticated pages otherwise display error messages.
Add /Edit Religion Page | 43 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM Add /Edit Caste Add /Edit Education Category Add /Edit Occupation Add /Edit Country Add /Edit State Add /Edit City Add /Edit Citizenship Add /Edit Blood Group Add /Edit Mother Tongue Add /Edit Star Add /Edit Height View and activate registration View 's summary View interest received View interest sent View and publish success Stories Manage News View and send mails Module Create new registration Enter name and Check name, and roles are valid or not. If valid , allow access to the authenticated pages otherwise display error messages. Post profile. Update profile. Delete profile. Know the profile statistics View and send message Search profile Add to favorites Page | 44 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM View interest received Send interest View success stories View news Searching Module Advanced search Regular Search Search by Profile Number. Search by Religion Search by Country Search by Caste Search by Education
9.4 IMPLEMENTATION METHODOLOGY A methodology is not a series of templates. It is a process that needs to be adapted to suit each situation. There needs to be someone who teams can talk with - someone who will mentor the teams in the use of the methodology. It all starts with providing a single point of for all issues from order entry through field acceptance. The project manager will hold a kickoff meeting with the identify the project plan, review the sold project scope, develop correspondence and communications practices for the project and set commitment dates. The sold specification and the notes from the kick-off meeting make up a project's scope of supply definition. A performance based project schedule is developed using Microsoft Project that identifies milestones from the scope of supply. This schedule is the basis for internal monthly project review meetings and status reports. Realizing that communication is critical for success, these review meetings identify status of the project definition, hardware design,
Page | 45 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM software design, manufacturing, system test and shipment. The project manager uses this forum to highlight any issues and assess resources as necessary to ensure a successful implementation
9.5 LIST OF REPORTS Reports are the outputs of database application. Reports are used to retrieve and present data in formatted way. The information on reports is arranged in different ways. A report may also contain graphs, charts, table’s etc.The can generate different types of reports by manipulating database. Some reports are simple a list of the record in database. There are five reports in this project are as follow: Daily, Weekly, Monthly, Yearly Registration Report Profile Statistics Report Graphical Report of Visitors Interest Received Report Interest Sent Report
10. IMPLEMENTATION OF SECURITY MECHANISMS Security mechanism comes at two levels: One at the operating System level and the other at the Database System Level. The Operating System Level Security is implemented at several levels, ranging from s for access to the system to the isolation of concurrent process running within the system. The OS denies access to the system if the and name is invalid. Database Security
As with securing a network, securing a database by looking at the various layers that are involved is an effective approach. Security of databases can be defined as preventing Page | 46 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM unauthorized or accidental disclosure, alteration, or destruction of data. In addition, the confidentiality of data that exists in the database must be considered, as should the availability of that data. The following section will discuss a secure database design; while not all-inclusive, it should provide a good, basic starting point.For SQL Server Express, one of our goals is to provide secure defaults for the different components. For instance, the networking protocols such as T/IP and Named Pipes are turned off. SQL Browser service is not started unless the explicitly asks for this in the setup command line. The SA or System is disabled by default if Windows Authentication is used. Normal s on the machine have almost no privileges on the SQL Server Express instance. A Local on the server must explicitly grant relevant permissions for normal s so that they can use SQL functionality.
Performance SQL Server Express has abandoned the concept of a "governor". Frankly, I've rarely seen the governor slow any MSDE system down, but by dropping the governor, Microsoft has removed a point of confusion about the scalability of the SQL Server engine. SQL Server Express has ways to limit scalability. As configured in the Beta, SQL Server Express can only address 1GB of system RAM in the buffer pool. This limits the number of data pages and procedures in the RAM cache. Roles SQL provides for easy and controlled privilege management through roles. Roles are named groups of related privileges that are granted to s or other roles.
11. FUTURE SCOPE & ENCHANCEMENT OF THE PROJECT The Online Matrimonial System is designed for s to find out his/her best soul mate. Each task in this site is divided into modules. Hence modification and enhancement can be made Page | 47 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM easily without affecting any other part of the program. This siteis not providing any facility for direct interaction between s. This system can be further enhanced by including a chat application, which will facilitate direct communication between s. The current system provides free service for all kinds of s. It can be enhanced to a commercial site. Since the design of the system allows high level of feasibility for expansion and development, all the above said improvements can be performed hassle free and without hampering the basic functionalities of the system.
12. BIBLIOGRAPHY 1. System Analysis and Design, M Awad Elias., GalgotiaBooksource, 1997 Second Edition 2. Software Engineering A Practitioner’s Approach, S Pressman Roger, McGraw-Hill International Edition, 2001 Fifth Edition 3. Analysis and Design of Information Systems, James A Senn
Page | 48 IGNOU MCA PROJECT 2015
SYNOPSIS 1. TITLE OF THE PROJECT
ONLINE MATRIMONIAL SYSTEM The project entitled Online Matrimonial Systemis web-based software developed to aid the activities of marriage bureau. Online Matrimonial System is a virtual marriage bureau, providing free service to bride and grooms world-wide.
2. INTRODUCTION & OBJECTIVES
2.1 INTRODUCTION Online Matrimonial System is a virtual marriage bureau, providing free service to bride and grooms world-wide. One can place his / her profile with photograph without any charge. Here Men or women can with or without their photos. There are umpteen -friendly search options for men to choose from to help them land at the best. A member can post their profile, add their photo to it, and receive mails of matching profiles and Use "Express Interest" to send an automated message expressing your interest to a member.
The Online Matrimonial System is designed for s to find out their best matching pair. This site includes two main modules such as side and side. Any can search the website without registration but only the ed can express his/her interest to another . The has whole power in this site such as approving registration, editing and deleting of details. The can
Page | 1 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM their photo into the site after approving his/her registration. The ed can into the site and also can change their profile.
2.2 OBJECTIVES Online Matrimonial System is a real time project to create efficient software for online marriage. This software module is designed to provide detailed information about marriage bureau. This project has a communication between different modules and a common database is created.
Online Matrimonial System provides the efficient matrimonial website, a provision for viewing the latest status of the service. The web service provides you the maximum benefit by providing the information about various s located at various places, there by managing them effectively.
3. PROJECT CATEGORY The project entitled “Online Matrimonial System” can be categorized as RDBMS(Relational Database Management System). RDBMS is a type of database management system (DBMS) that stores data in the form of related tables. Relational databases are powerful because they require few assumptions about how data is related or how it will be extracted from the database. As a result, the same database can be viewed in many different ways. One of the most outstanding systems is Microsoft SQL Server 2008. Microsoft SQL Server is a relational database server, developed by Microsoft: it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet). There are at least a dozen
Page | 2 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM different editions of Microsoft SQL Server aimed at different audiences and for different workloads.
4. TOOLS/PLATFORM, HARDWARE AND SOFTWARE REQUIREMENT SPECIFICATIONS. 4.1 TOOLS/PLATFORM Online Matrimonial System uses .NET platform for design and Microsoft SQL Server as
RDBMS. .NET allows applying common skills across a variety of devices, application types, and programming tasks. It enables integration with other tools and technologies to build the right solution with less effort and time. Microsoft SQL Server is a computer application used to create desktop, enterprise, and web-based database systems. It is used at different levels and with various goals. Frond End: ASP.Net 4.0 with C# ASP.NET is a Web application framework developed and marketed by Microsoft to allow programmers to build dynamic web sites, web applications and web services. In this project, asp.net application could be written in C# language. Back End: SQL SERVER 2008 Express Edition Microsoft SQL Server 2008 Express is a powerful and reliable data management system that delivers a rich set of features, data protection, and performance for embedded application clients, light Web applications, and local data stores. Web Server: Internet Information Services (IIS) IIS formerly called Internet Information Server – is a web server application and set of feature extension modules created by Microsoft for use with Microsoft Windows.
Page | 3 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM
4.2 SOFTWARE SPECIFICATONS
Operating System
:
Windows XP Server
Front End
:
ASP.Net 4.0 with C#
Back End
:
SQL Server 2008
Web Server
:
IIS 7.0
Web Browser
:
Internet Explorer 7.0
Internet Technologies
:
JavaScript
4.3 HARDWARE SPECIFICATONS
Processor
:
Pentium 2 GHz
RAM
:
1GB
Hard disk
:
80 GB
Monitor
:
VGA
Keyboard
:
Standard Keyboard
Mouse
:
Standard Mouse
Page | 4 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM
4.4 SOFTWARE REQUIREMENT SPECIFICATION
A software requirements specification is a document which is used as a communication medium between the customer and the supplier. When the software requirement specification is completed and is accepted by all parties, the end of the requirements engineering phase has been reached. This is not to say, that after the acceptance phase, any of the requirements cannot be changed, but the changes must be tightly controlled.
Benefits of SRS
Forces the s to consider their specific requirements carefully.
Enhances communication between the Purchaser and System developers.
Provides a firm foundation for the system design phase.
Enables planning of validation, verification, and acceptance procedures.
Enables project planning e.g. Estimates of cost and time, resource scheduling.
Usable during maintenance phase.
Introduction In this Project basically focus on all the world of people who want to find their life partner. This system is made for connect the all these from all over the world and can provide facilities for all age of member.To provide suitable match for brides and grooms for Kerala across the world. No payments to be made by anyone for use of application. Providing these facilities for people and they can find easily information & news related the different religions. Purpose The purpose of this document is to present a detailed description of the Online Matrimonial System. It will explain the purpose and features of the system, the interfaces of the system, what the system will do, the constraints under which it must operate and how the system will react to external stimuli. The purpose of this project is
Page | 5 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM providing a platform to people for connecting from worldwide.Still there is no any platform for connect on internet through the website. Scope Online Matrimonial System provides matrimonial services to all people. In this system provide matrimonialsection where people can him/her profile and easily find life partners.The software will facilitate communication between and s.
Background This Website is based on ASP.NET with C# include 4.0 .NET framework with the securities of managing the s and the resources. The SQL Server is used as database.
5. PROBLEM DEFINITION, REQUIREMENT SPECIFICATIONS, PROJECT PLANNING AND SCHEDULING 5.1PROBLEM DEFINITION 5.1.1 EXISTING SYSTEM Now a day a lot of Matrimonial consultancies are listed. Most of these companies are working manually without the help of a system. Checking of existing records, editing and other reporting are done manually. It is a time consuming process. Natural behaviors of these companies are o Profiles can himself in a particular Matrimony company o He or she can submit their biodata and Photo there o Staff of the company should identify each Profiles area and make a manual search for suitable requirements o If they find a matched Profile they have to inform him or her about this
Profile
o They search more about this Profile
Limitations of the Existing System
Page | 6 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM Main limitation is time consuming. Here all works are done manually. If there are a lot of applicants, it is very difficult to staff to check the profile, sort the profile and delete all expired profiles. So it will take more time and it is uncomfortable. And also company must manually keep files and maintain it manually. It is not applicable in the case of this System and it is not friendly. Another limitation is in the field of biodata submission. If a Profile wants to modify his/her biodata, it will be a Herculean task. There is no centralized control over all operations. So the existing system doesn’t work properly. So an automated service system is needed.
5.1.2 PROPOSED SYSTEM The proposed system is fully web enabled and builds with the help of Microsoft’s latest web technologies. The main objective is to provide matrimonial for Groom and Brides. Everyone can access the service through a web browser from anywhere in the world because the service is totally centralizes.
Main advantages of the proposed system The proposed system is fully web based. So it can provide centralized control over the criteria. It is fast, friendly and comfortable. The objectives of this system are: -
-
1. To save time. 2. To provide accurate information about the s. 3. Ease of use. 4. Reduce money and very less effort to take.
5.2 REQUIREMENTS SPECIFICATION A detailed statement of the exact results we or the customer want to get from a project. Page | 7 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM A condition or capability that must be met or possessed by a system, product, service, result or component to satisfy a contract, standard, specification or other formally imposed documents. Requirements include the quantified and documented needs, wants and expectations of the sponsor, customer and other stakeholders. A requirements specification is a defined goal that details the desired end result of a project. This helps project managers to ensure that they are delivering exactly what their customers want, because it is specified and communicated clearly to those involved in the project.
FUNCTIONAL REQUIREMENTS Functional requirements capture the intended behavior of the system. This behavior may be expressed as services, tasks or functions the system is required to perform. This white paper lays out important concepts and discusses capturing functional requirements in such a way that they can drive architectural decisions and be used to validate the architecture.
The following is a running list of possible Online Matrimonial System Requirements: 1. s the activation of s 2. s the search and views profile 3. the interesting profile send mail 4. the Know the profileStatistics.
TECHNICAL SPECIFICATION Technical specifications are typically written by the developers and coders, and describe how they will implement the project. The developers work from the functional specifications, and translate the functions into their actual coding practices and methodologies.
Page | 8 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM 5.3
PROJECT PLANNING & SCHEDULING
The key to a successful project is in the planning. Creating a project plan is the first thing you should do when undertaking any kind of project.Often project planning is ignored in favor of getting on with the work. However, many people fail to realize the value of a project plan in saving time, money and many problems. Project scheduling looks at which tasks need to be performed for a project and assigns deadlines for their completion. The project scheduler sets these deadlines by calculating how long each task should take to perform. Scheduling requires a comprehensive understanding of which action steps need to get done and when.
To provide a brief introduction to project planning and scheduling.The critical area where project management meets system development.
Steps in the Planning Process
1) Identify the tasks. 2) Clearly state the objective of each task. 3) Estimate the Personnel, Time and Resources to meet objectives. 4) Develop a task sequence. 5) Estimate the product development costs.
5.3.1
GANTT CHART
The bar or Gantt chart is a widely used simple project scheduling technique.Gantt chart is a type of bar-chart that shows both the scheduled and completed work over a period. A time-scale is given on the chart's horizontal axis and each activity is shown as a
Page | 9 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM separate horizontal rectangle whose length is proportional to the time required for the activity's completion. o
Advantages include:
Direct correlation with time.
Straight forward relationship with projects involving a limited number of tasks.
Straight forward integration of subtasks having separate scheduling charts.
Time schedule is flexible and is expanded to show tasks of shorter nature.
Progress against the plan is easily reflected
Following table illustrates the various project tasks and time (in Weeks and Days) required, for the synopsis development of “Online Matrimonial System”. Sl. No
ACTIVITIES
DAYS
Sl.No
Activities
Days
1
Requirement Study
5
2
System Study
5
3
System Analysis
5
4
System Design
7
6
Testing
6
5
Documentation
5
Page | 10 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM
ID
Task Name
Start
Finish
Duration
1 Requirement Study
5/25/2017
5/29/2017
5d
2 System Study
5/30/2017
6/3/2017
5d
3 System Analysis
6/4/2017
6/8/2017
5d
4 System Design
6/9/2017
6/15/2017
7d
5 Testing
6/16/2017
6/21/2017
6d
6 Doumentation
6/22/2017
6/26/2017
5d
May 2017
Jun 2017
25 26 27 28 29 30 31 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
Gantt Chart
5.3.2 PERT CHART A project management tool that provides a graphical representation of a project’s timeline. PERT, or Program Evaluation Review Technique, was developed by the United States Navy for the Polaris submarine missile program in the 1950s. PERT charts allow the tasks in a particular project to be analyzed, with particular attention to the time required to complete each task, and the minimum time required to finish the entire project.
Page | 11 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM Requiremet Study
5/30/2017
Testing
5/25/2017
5/29/2017
5/30/2017
6/3/2017
6/4/2017
6/8/2017
5/25/207
5/29/2017
5/30/2017
6/3/2017
6/4/2017
6/8/2017
System Design
System Design
Documentation
6/9/217
6/15/2017
6/16/207
6/21/2017
6/22/2017
6/26/2017
6/9/2017
6/15/207
6/16/207
6/21/2017
6/22/2017
6/26/2017
Figure: PERT CHART
6. SCOPE OF THE SOLUTION This system will provide the leadership and necessary to sustain long-term growth and customer satisfaction for our world-class customers and ionately promote quality and service at all levels while enhancing company’s competitive advantage. Requirement Analysis encomes the tasks that go into determining the requirements of the new system, taking of the possibly conflicting and requirements of the various s. In the flexibility of the uses, the interface has been developed a graphics concept in mind, associated through a browsers interface.
1. Scope determines the boundary within which the system works. 2. s of the system are and s. Page | 12 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM
7. ANALYSIS System development is having two major components: System analysis and System design. System analysis is the process of collecting and interpreting facts, understanding problems and using the information to suggest improvements on the system. This will help to understand the existing system and determine how computers make its operation more effective. System design is a process through which requirements are translated into a representation of the software. It is the activity of decision-making. The system design is concerned with in the transformation of requirements into data and software architecture. Then it focuses on the refinements for the architectural representations that lead to detailed data structures and algorithmic representation of software. Depending on the applications and project requirements, a good design is one, which allows efficient code to be produced, and whose implementation is as compact as possible.
7.1 DATA FLOW DIAGRAM Data flow diagram represents one of the most ingenious tools for structured analysis. A DFD has the purpose of clarifying system requirements and identifying major transformations that will become programs in system design. It is the major starting point in the design phase that functionally decomposes the requirement specifications down to the lowest level of detail. A DFD consists of a series of bubbles ed by lines. The bubble represents the data transformation and lines represent data flow in the system. In the normal conventional DFD have 5 major symbols. o Square which defines source or destination of data o An arrow identifies dataflow- data in motion. It is a pipeline through which information flows. Page | 13 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM o A circle or bubble represents a process that transforms incoming data flow(s) into outgoing data flow(s). o An open rectangle is a data store- data at rest or a temporary Repository of data. o An open rectangle with a bar represents a data store (file), which is repeatedly referenced Symbols used in DFD
It defines a source or destination of system data.
It represents a process that transforms incoming data flow into outgoing data flow.
It defines data flow. It is a pipeline through which information flows It is used to store data or a temporary repository of data.
Page | 14 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM
LEVEL 0 DFD
Reports
Profile
Online Matrimonial System
Manage System
Search Results
Page | 15 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM
LEVEL 1 DFD ()
Registration Details
D er
ils eta
ils eta D gin Lo
Registration
Re gis De tratio tail n s
Us
1.0 Registration
Check name & Request
2.0
alid If V
in
If Valid
ails h Det Searc
hD arc Se
If inv alid l og
2.1 View Profile
Profile Details
ils eta
Registration 3.0 Search
Us
file D
eta ils
Detai ls
er D
eta ils
Interest_Received
InterestSent
Profile Details
3.1 Express Interest
Pro
3.2 Mailing
Page | 16 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM LEVEL 2 DFD ( REGISTRATION)
Education_Category
Mother_ Tongue
Occupation
To ngu e
Height Weight Weig ht
State
He igh t
Blood group
Citizenship BloodGroup
State
City
ls tai De
nship Citize ils Deta
ion lig Re
Ca ste
Country
City
Caste
ry unt Co
tion uca Ed
Religion
O
Star
n tio a up cc
Star Details 1.0 Registration
etails tion D a r t s i Reg
Re gis tr
Details
Request
ati on D
2.0
eta ils
Profile Details Invalid Registration
Valid 3.0 View Profile
3.1.1 Photo
ew Vi
U De ser tai ls
3.1.3 Delete Profile
Up dat e De Prof tail ile s
est to Requ ad Uplo
Photo Details
Photo
3.1.2 Edit Profile
Page | 17 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM
LEVEL 2 DFD ( SEARCHING)
Details
Religion Religion
ls Detai
2.1 Search by Religion
1.0
Profile Details
Valid
Search Details
Caste Caste 2.0 Search
2.2 Search by Caste
Profile Details
Education 2.3 Search by Education
Education_Category
Profile Details
2.4 Search by ProfileId
Registration
Profile Details
2.5 Search by City
Profile Details
City
City
Page | 18 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM
U Request
Failure
Response
1.
e nam r e s sw Pas
ord
Success
2. Online Matrimonial System
Page | 19 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM FIRST LEVEL DFD FOR
Mother_tongue
Request to Manage
Response
1.0 Mother Tongue
Request to Add Religion
2.0 Religion
Request to Enter
n
Response
Caste
3.0 Cast
Request to Manage
io lig Re
s tail De
4.0 Education Category
Response
ti Educa
on De
tails
Education_Category
Response Request to Manage
Request to
5.0 Citizenship
6.0 Activate/ Reject
Citzenship
Response
Response Request to View
7.0 View Express Interst
Response
Success_stories Request to Publish
7.0 Success Story
Response
Page | 20 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM SECOND LEVEL DFD FOR ACTIVATION 6.0 Requst to
6.1. New Registration
Details Registration
Approval Response
Approval Request Approval Response
6.2 Activate or Reject
Update Status
Activated
name , 6.3 Invalid
Valid
Response
6.4 Online Matrimonial System
Page | 21 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM SECOND LEVEL DFD FOR EXPRESS INTEREST 7.0 Interest_Received
7.1 Interest Received
st re te In ved w i ie e V Rec
Interest Received Profiles Response
Interest Sent Profiles
InterestSent
View Interest Sent Request to View
7.1 Interest Sent
7.1 Express Interest
Response
Re que st t oV
Favourite Profiles
iew
Favourites 7.1 Faviourites Response
7.2ER DIAGRAM An Entity Relationship model (ER model for short) 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. Diagrams created by this process are called Entity Relationship diagrams or ER diagrams. A conceptual ER model may be used as the foundation for one or more logical data models. The purpose of the conceptual ER model is then to establish structural metadata commonality for the master data entities between the set of logical ER models. The conceptual data model may be used to form commonality relationships Page | 22 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM between ER models as a basis for data model integration. The following are some DFD symbols used in the project
Rectangles represent entity sets.
Diamonds represent relationship sets. Lines link attributes to entity sets and entity sets to relationship sets.
_________
Underline indicates primary key attributes.
Page | 23 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM
HeightId Photo
Heightcm
Heightft _Date
RegId Star_id
Height
PhotoId
StarName
_Time RegId
OccupId
Status
Has
Photos
Occupation
Star Include
Occupation LangId
BloodId
Name
Marital_Status
Age
Language RegId
Add_date FavId
NoOfChildren
ReligionId
Blood_Group
Religion CasteId
Has
Mother_Tongue
_summary
BloodGroup
Has
Registration
Caste ReligionId
Religion Caste
RegId FavRegId Favourites
From
Title
Education
EduId
CountryId
Country
Add
SDate
StoryId Has
Education_Category
IS A
Country
Message Sent_Date SentId
View
CountryId
CitizenId
Citizen
Name
State RegId
RegId
Success_Stories
StateId
ToRegId
Story
Cityzenship
State
name Status
Rec_Date FromRegId
InterestSent CityId
CityName
CountryId
d RecI
StateId
Interest_Received IS A
City
Activate
Hitdate
View
Manage
News_Date
HitNo
Hit
Mail_From News_title
News
_ID News News
Subject
_Id Mail
Mail Mail
Page | 24 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM 7.3 USE CASE DIAGRAMS ONLINE MATRIMONIAL SYSTEM Manage Religion Manage Caste Manage Education category Manage Country
Manage State
Manage City Manage Citizenship
Manage Blood_Group
Manage Mother_Tongue
Manage Occupation
Manage star Manage Height
View and activate registration View 's summary View interest received
View interest sent View and publish success
View Stories
Page | 25 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM
ONLINE MATRIMONIAL SYSTEM New Registration
Update Profile
Search profile
Add to favourites
View interest received
Send interest
View success stories
Generate hit
Page | 26 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM 7.4
STRUCTURE OF THE MODULES ONLINE MATRIMONIAL SYSTEM
Manage Religion
New Registration
Manage Caste
Update Profile
Manage Education_Category
Search profile
Manage Country
Add to favourites
Manage State
View interest received
Manage City
Send interest
Manage Cityzenship
View success stories
Manage Blood_Group
Generate hit
Manage Mother_Tongue Manage Occupation Manage Star Manage Height View and activate registration View 's summary View interest received View interest sent View and publish success View stories View hit
Page | 27 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM 7.5CLASS DIAGRAM
Page | 28 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM 8. COMPLETE DATABASE DESIGN
Registration
Religion PK
PK
ReligionId Religion
City
Caste
PK
CityId
FK1 FK2
CityName CountryId StateId
Country PK
PK
CasteId
FK1
Caste ReligionId
CountryId Country
State PK
StateId
FK1
State CountryId
_summary Star PK FK1
StarId
RegId _Date _Time Status
Star Name
Height Mail PK
PK
HeightId
Mail_ID
Heightcm Heightft
InterestSent Mail_From Mail_To Subject Mail Mail_Date Mail_Time
PK
SentId
FK1
RegId ToRegId Message Sent_Date
News PK
News_ID News_title News News_Date Status
Photos PK
PhotoId
FK1
Photo PhotoDescr RegId
PK
name Name Status
Success_Stories PK
StoryId
Cityzenship
RegId
Name Age Gender Marital_Status NoOfChildren LivingStatus Resid_Status Employ Email name BodyType Weight Complexion Physical_Status Eating_habits CasteNobar Subcaste Horos_match Chovva Adderss Phone Mobile Aboutme Profilefor Profileby Familyvalue Familytype FamilyStatus NoOfbrothers NoOfsisters AboutFamily RegDate VisitCount Int_sent Int_Rec Status ReligionId FK1 CasteId FK2 CountryId FK3 StateId FK4 CityId FK5 CitizenId FK6 EduId FK7 BloodId FK8 LangId FK9 FK10 OccupId FK11 StarId FK12 HeightId
PK
Citizen
Education_Category PK
EduId Education Blood_Group
PK
BloodId BloodGroup
Mother_Tongue PK
LangId Language
Occupation PK
OccupId Occupation
Favourites PK
FavId
FK1
RegId FavRegId Add_date
Interest_Received PK
RecId
FK1
RegId FromRegId Message Rec_Date Hit
PK Title From Story SDate
CitizenId
Hitdate HitNo
9. COMPLETE STRUCTURE Page | 29 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM This software module is designed to provide detailed information about the activities of and s.
9.1 MODULES AND DESCRIPTIONS A module is a bounded contiguous group of statements having a single name and that can be treated as a unit. In other words, a single block in a pile of blocks.
The Online Matrimonial System includes two main modules.
1. ISTRATIOR istration module consist of three sub-modules
1.1. Add Details This sub module of enables to add new items to the database. Details Such as Religion, Education category, caste, occupation etc
1.2. Edit Details At each entry into the matrimonial data base, the has got the power to edit the details before adding to its original list of items. And it is being performed within a specified time stamp. Validation of profiles is done manually. meticulously validates each and every profile carefully on specific criterion before it is added to our database. Hence, it takes 24 hrs to validate all the profiles that are being added on one particular day. Almost every word counts. categorically ignores profiles that are submitted by underage persons, and profiles that contain abusive content. reject profiles that contain invalid data such as added for fun/ looking for friendship / not related to marriage. We try and maintain the highest quality in the database we serve.
Page | 30 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM 1.3. Delete Details As of the power to edit the details, has also got the power to delete an added Item from the list.
2. module consist of three sub-modules
1.1 Registration A Member at Online Matrimonial System can
Post Profile.
Update Profile.
Delete Profile.
Know the ProfileStatistics.
1.1.1 Post Profile (Registration). Here men or women can with or without their photos. The form to add your profile will be displayed. must give all the necessary as well as optional details as possible, including the details in full. This will increase the chances of your profile being displayed when our search for matches. After you submit your information, your profile will be automatically created and you shall be given a "Matrimony ID" generated for future references.
1.1.2 Update Profile s can modify the profile contents that are displayed. 1.1.3, Delete Profile s can delete their profile .Profile once deleted cannot be restored or reactivated. 1.1.4, Know the profileStatistics. In the profile Statistics page can view their details such as name, age, education and occupation details etc. can also view their interest received details and interest sent details Page | 31 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM 1.2 Searching Online Matrimonial System provides s with the following options to search ’s soul mate. o Advanced search o Regular search o Search by Profile Number. o Search by Religion o Search by Country o Search by Caste o Search by Education
1.2.1 Advanced Search :-Advanced Search is designed to cover every aspect of your search criteria delivering such profiles. Advanced Search has additional options of searching for profiles using keywords, caste no bar option, search on the basis of residing state and physical status to further bring profiles closest to expectations.
1.2.2 Regular Search :-This is the regular search that allows you to search for based on age/ language/caste/height etc. 1.2.3 Search by profile number :-Every profile at Online Matrimonial System is identified by a unique profile number.This could be handy in a situation where you have been supplied a profile number by a member and you like to view the complete profile. You can thus skip the hassles of browsing through long pages of search results. It is a convenient way to search for a list of prospective partners based on a few basic fields.
1.2.4 Search by Religion : -It is a convenient way to search for a list of prospective partners based on religion.
1.2.5 Search by Country :-It is a convenient way to search for a list of prospective partners based on country. Page | 32 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM
1.2.6 Search by caste :-It is a convenient way to search for a list of prospective partners based on caste.
2.2.7 Search by Education :-It is a convenient way to search for a list of prospective partners based on education.
1. 3. EXPRESS INTEREST Express Interest is an exclusive feature that enables you to send automated messages to absolutely FREE. can send unlimited Express Interest messages to anyone you choose and can also accept any number of Express interest messages sent to you by other .
9.2 DATA STRUCTURES 1. Religion Constraint Name
Type
Reference Table(If any)
Remarks
ReligionId
Primary Key
Unique
Column Name
Data Type
Width
ReligionId
Int
4
Yes
Identification
Religion
Varchar
30
Yes
Name Of Religion
Not Null
Description
2. Caste Constraint Name
Type
CasteId
Primary Key
ReligionId
Foreign Key
Column Name
Reference Table(If any)
Remarks Unique
Religion
Data Type
Width
Not Null
Description
CasteId
Int
4
Yes
Identification
Caste
Varchar
20
Yes
Name Of Caste Page | 33
IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM ReligionId
Int
4
Yes
ReligionIdentification
3. Education_Category Constraint Name EduId Column Name
Type
Reference Table(If any)
Primary Key
Remarks Unique
Data Type
Width
Not Null
Description
EduId
Int
4
Yes
Identification
Education
Varchar
30
Yes
Name Of Education
4. Country Constraint Name CountryId Column Name
Type
Reference Table(If any)
Primary Key
Remarks Unique
Data Type
Width
Not Null
Description
CountryId
Int
4
Yes
Identification
Country
Varchar
30
Yes
Name Of Country
5. State Constraint Name
Type
StateId
Primary Key
CountryId
Foreign Key
Column Name
Reference Table(If any)
Remarks Unique
Country
Data Type
Width
Not Null
Description
StateId
Int
4
Yes
Identification
CountryId
Int
4
Yes
Country Identification
State
Varchar
30
Yes
Name Of State
Page | 34 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM
6. City Constraint Name
Type
Reference Table(If any)
CityId
Primary Key
CountryId
Foreign Key
Country
StateId
Foreign Key
State
Column Name
Remarks Unique
Data Type
Width
Not Null
Description
CityId
Int
4
Yes
Identification
CityName
Varchar
30
Yes
Name Of City
CountryId
Int
4
Yes
Country Identification
StateId
Int
4
Yes
State Identification
7. Cityzenship Constraint Name CitizenId
Type
Reference Table(If any)
Primary Key
Column Name
Remarks Unique
Data Type
Width
Not Null
Description
CitizenId
Int
4
Yes
Identification
Citizen
Varchar
30
Yes
Name Of Cityzenship
8. Blood_Group Constraint Name BloodId Column Name
Type
Reference Table(If any)
Primary Key
Remarks Unique
Data Type
Width
Not Null
Description
BloodId
Int
4
Yes
Identification
BloodGroup
Varchar
20
Yes
Name Of Blood group
9. Mother_Tongue Page | 35 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM Constraint Name LangId
Type
Reference Table(If any)
Primary Key
Column Name
Remarks Unique
Data Type
Width
Not Null
Description
LangId
Int
4
Yes
Identification
Language
Varchar
30
Yes
Name Of Language
10. Occupation Constraint Name OccupId Column Name
Type
Reference Table(If any)
Primary Key
Remarks Unique
Data Type
Width
Not Null
Description
OccupId
Int
4
Yes
Identification
Occupation
Varchar
30
Yes
Name Of Occupation
11. Star Constraint Name Star Id Column Name
Type
Reference Table(If any)
Primary Key
Remarks Unique
Data Type
Width
Not Null
Description
StarId
Int
4
Yes
Identification
StarName
Varchar
20
Yes
Name Of Language
12. Height
Constraint Name HeightId Column Name HeightId
Type
Reference Table(If any)
Primary Key
Unique
Data Type Int
Remarks
Width 4
Not Null Yes
Description Identification Page | 36
IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM Heightcm
Varchar
20
Yes
Height in Centimeter
Heightft
Varchar
20
Yes
Height in foot
13. Registration Constraint Name
Type
Reference Table(If any)
RegId
Primary Key
ReligionId
Foreign Key
Religion
CasteId
Foreign Key
Caste
CountryId
Foreign Key
Country
StateId
Foreign Key
State
CityId
Foreign Key
City
CitizenId
Foreign Key
Citizenship
EduId
Foreign Key
Education_Category
BloodId
Foreign Key
Blood_Group
LangId
Foreign Key
Mother_Tongue
OccupId
Foreign Key
Occupation
StarId
Foreign Key
Star
HeightId
Foreign Key
Height
Column Name
Remarks Unique
Data Type
Width
Not Null
Description
RegId
Int
4
Yes
Identification
Name
Varchar
50
Yes
Name
Age
Int
4
Yes
Age
Gender
Varchar
10
Yes
Gender
Marital_Status
Varchar
20
Yes
MaritalStatus
NoOfChildren
Int
4
Yes
NoOfChildren
LivingStatus
Varchar
20
Yes
LivingStatus
Page | 37 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM ReligionId
Int
4
Yes
ReligionId
CasteId
Int
4
Yes
Caste Id
CountryId
Int
4
Yes
CountryId
StateId
Int
4
Yes
State Id
CityId
Int
4
Yes
City Id
CitizenId
Int
4
Yes
Citizenship
EduId
Int
4
Yes
EduId
BloodId
Int
4
Yes
BloodId
LangId
Int
4
Yes
LangId
OccupId
Int
4
Yes
OccupId
StarId
Int
4
Yes
StarId
HeightId
Int
4
Yes
HeightId
Resid_Status
Varchar
20
Yes
Residential Status
Employ
Bit
1
Yes
Employment
Varchar
50
Yes
name
Varchar
20
Yes
name
Varchar
20
Yes
BodyType
Varchar
20
Yes
BodyType
Weight
Varchar
20
Yes
Weight
Complexion
Varchar
20
Yes
Complexion
Physical_Status
Varchar
20
Yes
Physical_Status
Eating_habits
Varchar
20
Yes
Eating_habits
CasteNobar
Bit
1
Yes
CasteNobar Page | 38
IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM Subcaste
Varchar
50
Yes
Subcaste
Horos_match
Varchar
20
Yes
Horoscopematch
Chovva
Varchar
20
Yes
ChovvaDosham
Adderss
Varchar
50
Yes
Adderss
Phone
Bigint
8
Yes
Phone
Mobile
Bigint
8
Yes
Mobile
Aboutme
Varchar
100
Yes
Aboutme
Profilefor
Varchar
25
Profileby
Varchar
20
Yes
Profileby
Familyvalue
Varchar
50
Yes
Familyvalue
Familytype
Varchar
50
Yes
Familytype
FamilyStatus
Varchar
50
Yes
FamilyStatus
NoOfbrothers
Varchar
20
Yes
NoOfbrothers
NoOfsisters
Int
4
Yes
NoOfsisters
AboutFamily
Varchar
100
Yes
AboutFamily
RegDate
Date
8
Yes
Registration Date
VisitCount
Int
4
Yes
Visit count
Int_sent
Int
4
Yes
Total Interest Sent
Int_Rec
Int
4
Yes
Total Interest
Profile for
Received Status
Varchar
20
Yes
Registration Status
14. _summary
Page | 39 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM Constraint Name RegId
Type Foreign Key
Column Name
Reference Table(If any)
Remarks
Registration
Data Type
Width
Not Null
Description
RegId
Int
4
Yes
Identification
_Date
Date
8
Yes
Date
_Time
Varchar
10
Yes
Time
Status
Varchar
10
Yes
Status
15. Photos Constraint Name
Type
Reference Table(If any)
PhotoId
Primary Key
RegId
Foreign Key
Registration
Data Type
Width
Column Name
Remarks Unique
Not Null
Description
PhotoId
Int
4
Yes
PhotoId
Photo
Varchar
50
Yes
Photo
PhotoDescr
Varchar
25
Yes
PhotoDescription
RegId
Int
4
Yes
RegId
16. Favourites
Constraint Name
Type
Reference Table(If any)
FavId
Primary Key
RegId
Foreign Key
Registration
FavRegId
Foreign Key
Registration
Data Type
Width
Column Name
Remarks Unique
Not Null
Description Page | 40
IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM FavId
Int
4
Yes
RegId
Int
4
Yes
FavRegId
Int
4
Yes
Add_date
Date
8
Yes
17. Interest_Received
Constraint Name
Type
Reference Table(If any)
RecId
Primary Key
RegId
Foreign Key
Registration
FromRegId
Foreign Key
Registration
Data Type
Width
Column Name
Remarks Unique
Not Null
Description
RecId
Int
4
Yes
RecId
RegId
Int
4
Yes
RegId
FromRegId
Int
4
Yes
From RegId
Message
Varchar
50
Yes
Message
Rec_Date
Date
8
Yes
Received Date
18. InterestSent
Constraint Name
Type
Reference Table(If any)
SentId
Primary Key
RegId
Foreign Key
Registration
ToRegId
Foreign Key
Registration
Data Type
Width
Column Name
Remarks Unique
Not Null
Description Page | 41
IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM SentId
Int
4
Yes
Sent Id
RegId
Int
4
Yes
RegId
ToRegId
Int
4
Yes
To RegId
Message
Varchar
50
Yes
Message
Sent_Date
Date
8
Yes
Sent Date
19.
Constraint Name name
Type
Reference Table(If any)
Primary Key
Column Name
Remarks Unique
Data Type
Width
Not Null
Description
name
Varchar
20
Yes
name
Varchar
20
Yes
Name
Varchar
30
Yes
Name
Status
Varchar
10
Yes
Status
20. Success_Stories
Constraint Name
Type
Reference Table(If any)
StoryId Column Name
Remarks Unique
Data Type
Width
Not Null
Description
StoryId
Int
4
Yes
StoryId
Title
Varchar
30
Yes
Title
From
Varchar
30
Yes
From Page | 42
IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM Story
Varchar
30
Yes
Story
SDate
Date
8
Yes
Submit Date
21. News Constraint Name
Type
News_ID
Primary
Reference Table (If Any)
Remarks Unique id to this table
Key Column Name
Data Type
Length
Not Null
Description
News_ID
Int
4
Yes
News ID
News_title
Varchar
20
Yes
News title
News
Varchar
20
Yes
News
News_Date
Date
8
Yes
News Date
Status
Varchar
20
Yes
Status
9.3 PROCESS LOGIC FOR ALL MODULES
Module Create new registration Enter name and Check name, and roles are valid or not. If valid , allow access to the authenticated pages otherwise display error messages.
Add /Edit Religion Page | 43 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM Add /Edit Caste Add /Edit Education Category Add /Edit Occupation Add /Edit Country Add /Edit State Add /Edit City Add /Edit Citizenship Add /Edit Blood Group Add /Edit Mother Tongue Add /Edit Star Add /Edit Height View and activate registration View 's summary View interest received View interest sent View and publish success Stories Manage News View and send mails Module Create new registration Enter name and Check name, and roles are valid or not. If valid , allow access to the authenticated pages otherwise display error messages. Post profile. Update profile. Delete profile. Know the profile statistics View and send message Search profile Add to favorites Page | 44 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM View interest received Send interest View success stories View news Searching Module Advanced search Regular Search Search by Profile Number. Search by Religion Search by Country Search by Caste Search by Education
9.4 IMPLEMENTATION METHODOLOGY A methodology is not a series of templates. It is a process that needs to be adapted to suit each situation. There needs to be someone who teams can talk with - someone who will mentor the teams in the use of the methodology. It all starts with providing a single point of for all issues from order entry through field acceptance. The project manager will hold a kickoff meeting with the identify the project plan, review the sold project scope, develop correspondence and communications practices for the project and set commitment dates. The sold specification and the notes from the kick-off meeting make up a project's scope of supply definition. A performance based project schedule is developed using Microsoft Project that identifies milestones from the scope of supply. This schedule is the basis for internal monthly project review meetings and status reports. Realizing that communication is critical for success, these review meetings identify status of the project definition, hardware design,
Page | 45 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM software design, manufacturing, system test and shipment. The project manager uses this forum to highlight any issues and assess resources as necessary to ensure a successful implementation
9.5 LIST OF REPORTS Reports are the outputs of database application. Reports are used to retrieve and present data in formatted way. The information on reports is arranged in different ways. A report may also contain graphs, charts, table’s etc.The can generate different types of reports by manipulating database. Some reports are simple a list of the record in database. There are five reports in this project are as follow: Daily, Weekly, Monthly, Yearly Registration Report Profile Statistics Report Graphical Report of Visitors Interest Received Report Interest Sent Report
10. IMPLEMENTATION OF SECURITY MECHANISMS Security mechanism comes at two levels: One at the operating System level and the other at the Database System Level. The Operating System Level Security is implemented at several levels, ranging from s for access to the system to the isolation of concurrent process running within the system. The OS denies access to the system if the and name is invalid. Database Security
As with securing a network, securing a database by looking at the various layers that are involved is an effective approach. Security of databases can be defined as preventing Page | 46 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM unauthorized or accidental disclosure, alteration, or destruction of data. In addition, the confidentiality of data that exists in the database must be considered, as should the availability of that data. The following section will discuss a secure database design; while not all-inclusive, it should provide a good, basic starting point.For SQL Server Express, one of our goals is to provide secure defaults for the different components. For instance, the networking protocols such as T/IP and Named Pipes are turned off. SQL Browser service is not started unless the explicitly asks for this in the setup command line. The SA or System is disabled by default if Windows Authentication is used. Normal s on the machine have almost no privileges on the SQL Server Express instance. A Local on the server must explicitly grant relevant permissions for normal s so that they can use SQL functionality.
Performance SQL Server Express has abandoned the concept of a "governor". Frankly, I've rarely seen the governor slow any MSDE system down, but by dropping the governor, Microsoft has removed a point of confusion about the scalability of the SQL Server engine. SQL Server Express has ways to limit scalability. As configured in the Beta, SQL Server Express can only address 1GB of system RAM in the buffer pool. This limits the number of data pages and procedures in the RAM cache. Roles SQL provides for easy and controlled privilege management through roles. Roles are named groups of related privileges that are granted to s or other roles.
11. FUTURE SCOPE & ENCHANCEMENT OF THE PROJECT The Online Matrimonial System is designed for s to find out his/her best soul mate. Each task in this site is divided into modules. Hence modification and enhancement can be made Page | 47 IGNOU MCA PROJECT 2015
ONLINE MATRIMONIAL SYSTEM easily without affecting any other part of the program. This siteis not providing any facility for direct interaction between s. This system can be further enhanced by including a chat application, which will facilitate direct communication between s. The current system provides free service for all kinds of s. It can be enhanced to a commercial site. Since the design of the system allows high level of feasibility for expansion and development, all the above said improvements can be performed hassle free and without hampering the basic functionalities of the system.
12. BIBLIOGRAPHY 1. System Analysis and Design, M Awad Elias., GalgotiaBooksource, 1997 Second Edition 2. Software Engineering A Practitioner’s Approach, S Pressman Roger, McGraw-Hill International Edition, 2001 Fifth Edition 3. Analysis and Design of Information Systems, James A Senn
Page | 48 IGNOU MCA PROJECT 2015
Related Documents 3m3m1z
Synopsis Matrimony 4gw6m
November 2021 0
Bharath Matrimony 495i1v
August 2021 0
Nesco Matrimony 2p3841
December 2019 39
Matrimony Srs 511b19
October 2019 58
Synopsis 39532a
October 2019 92