Alumni Portal

CHAPTER 1

AIMS IHE, 2020-21 Department of IT & Sciences Page 1

Alumni Portal

INTRODUCTION

1.1 SUMMARY:

The greatest asset any Institution can have is the Alumni system. Alumni are
the people who represent the Institution in the real world.Alumni website is created for
the students that have graduated from the Institution. This is a web based application that
allows former students to take advantage of the benefits and services that a Institution
offers after graduation. The alumni network is becoming important in the development of
the institution because of their vast potential that benefits both the Institution and the
students. There are many benefits for being an alumni member of a college or Institution,
some of these benefits are: keeping a person inform on the events that are organized by
the Institution, and when some important events will be holding in the Institution.
Another benefit is that information concerning a former student can easily be received
and other members of the alumni community can be located without much stress. The
student and alumni can communicate each other.

1.2 PURPOSE: GOALS and OBJECTIVES

• This project acts as mode of communication between College and Alumni.

• The aim of this project is to build an Online Alumni Dashboard.
• The main intension is to bring all Alumni of College to in contact together in one
platform.
• The project mange to collect old students’ information like their name, course and
their respective field of jobs.
• This project also helps alumni who are in search of job.
• Alumni can get to know information or events in college very fast.

AIMS IHE, 2020-21 Department of IT & Sciences Page 2

Alumni Portal

1.3 SCOPE

• Alumni portal helps to students who have passed out from an Institution.

• Alumnus can easily contact their friends.

• Alumnus can also get to know about the events of the College.

• They can know about the jobs.

• They can know about public forums.

• College can also communicate old students easily and maintain their records.

1.4 TECHNOLOGY and LITERATURE REVIEW

This project is aimed at developing a Repository and each Engine for alumni of the
college, which is of importance to a college. The Alumni Information Database is a web
based application that can be accessed throughout the World. Anyone can access the search
Engine to know about any Alumni of that college

This project is aimed at developing a Repository and each Engine for alumni of the
college, which is of importance to a college. The Alumni Information Database is a web
based application that can be accessed throughout the World. Anyone can access the search
Engine to know about any Alumni of that college but can’t able to add.

We introduce a literature review on the problem and how people solved it. The problem
of the search is extensively studded and summarized.

Referendum of students about the project, and hence, an Explanation for the powers of
administration with alumni and representation for the used UML’S with the system
interfaces and database ERD.

We expected that by applying and implementing the project on the web server, a great
benefit for both the students and the college and university administrations.

AIMS IHE, 2020-21 Department of IT & Sciences Page 3

Alumni Portal

TOOLS and TECHNOLOGIES

HTML:
 HTML stands for Hyper Text Mark Up Language
 HTML elements are the building blocks of HTML
 It is a standard language for creating webpages
 Browser that does not show the tags in web page but it will display the content which
is written in tags
 Elements of the html are also called tags these are very use full to design the web
pages
 Now html 5 is the stable version
 Anchor tag is used to link the web pages
 Tables and division tag are mostly used tags in the html
 Some of the tags like paragraph, headings, ordered list, unordered list and input tag
so on

CSS:
 It depicts hoe HTML components are to be shown on screen, paper, or in other media
 CSS spares the ton of work
 It can control the design of numerous site pages at the same time
 In three types we can write the CSS for the web pages they are: inline, internal,
external
 Selectors are used to selects the particular one for the styling purpose
 We have to write the CSS in the separate file it will helps to separate the html and
CSS Code
 Selectors of three types: class, Id, Pseudo-class

AIMS IHE, 2020-21 Department of IT & Sciences Page 4

Alumni Portal

 Some of the properties of CSS as follows: Background, Border, margin, and Padding
so on

PHP:

 Php is a serve side scripting language

 The most significant feature of the php is mainly supports the wide range of the
databases
 It can Add or Delete or Modify the data which is present in our database
 A variable is starts with $ Sign and followed by the name of the variable
 In php there are two basic output they are Echo and Print
 $_GET and $_POST are the two global variables to collect the form data
 Php also use to validate the forms

MYSQL:
 It is very fast and easy to use.
 We can send a request through query.
 We can insert the data into it multiple times.
 We can create database so that we can create tables in it.
 It increases the value when we add new data into it by auto increment.
 Each table has primary key and unique values.

JAVASCRIPT:
 It is the client-side scripting language.
 It is used in the forms to validate them.
 It is also very use-full in building the responsive websites.

AIMS IHE, 2020-21 Department of IT & Sciences Page 5

Alumni Portal

 By writing the java-script externally we can partition the html and js code for neat
coding in the WebPages.
 It will load to the page when page loads to the browser.
 We can change the html content with the java-script.
 The java-script also can be written in the header section or in the body.

AIMS IHE, 2020-21 Department of IT & Sciences Page 6

Alumni Portal

CHAPTER 2

PROJECT MANAGEMENT
AIMS IHE, 2020-21 Department of IT & Sciences Page 7
Alumni Portal

2.1 Project Planning and Scheduling

We scheduled our project in such a way that all activities need to be complete with specific
order and within time slot assigned to each task. We have distributed predicted effort across the
project duration by assigning the effort to specific tasks.

2.1.1 Schedule Representation

This project schedule representation of plan is about all activities, sequencing,

dependencies and efforts. The representation is in such a way that all activities need to finish
with order and time allocated to each task. Not only by allocating time but also by allocating the
effort to specific tasks. And also these activities are going to carry out in sequence.

We scheduled our project from the month of June to September of 2021. And further we stared
project by breaking down project into smaller manageable form also seeking out different tasks
and correlate them. And further estimating time frame required for every task involved that is the
time which fills or bridges the gap between objective and goal. Finally, calculating total time
required from start of the project to end.

2.1.2 Risk Management

No one would disagree that managing risk within a project is not a good idea. Risk
Management is an essential part of any program or project and can vastly contribute to
successful delivery. Where it can and does go wrong is when there is an over-reliance on the risk
aspects of the project and them in themselves start driving the way project moves forward. The
management of risk is part and parcel of project management is not the be all and end all of it as
it sometimes become is more risk adverse organizational cultures.

To understand how risk within projects can be better managed it is a worth considering a
number of aspects of the risk identification and mitigation processes involved.

AIMS IHE, 2020-21 Department of IT & Sciences Page 8

Alumni Portal

2.1.3 Risk Identification

 To choose a good database to store data.

 Maintaining records of alumni on paper is inefficient.
 Time consuming.
 Difficult to keep track of all records.
 Records may have lost due to error prone.
 Not easy to recover these data.

AIMS IHE, 2020-21 Department of IT & Sciences Page 9

Alumni Portal

CHAPTER 3

AIMS IHE, 2020-21 Department of IT & Sciences Page 10

Alumni Portal

SYSTEM REQUIREMENTS STUDY

Having a clear picture of the requirements gathered is most important but at the same
time, knowing the system requirements are equally necessary to reach the objective as desired.
Majorly the system requires the study of the hierarchy of authorities involved in resolving the
grievances that have been registered against the organization.

3.1 USER CHARACTERISTICS

Users are the people who interact with the system in one way or other way.

There are mainly two kinds:

1. Admin
2. Users

3.2 HARDWARE and SOFTWARE REQUIREMENTS

Hardware Requirements

• Processor : processor i3
• Hard disk: 500GB
• RAM: 4GB
• System Type: 64-bit operating system

Software Requirements

• Operating system : windows10

• Frontend : Html, CSS
• Backend : Php , MySQL, Xampp

AIMS IHE, 2020-21 Department of IT & Sciences Page 11

Alumni Portal

CHAPTER 4

AIMS IHE, 2020-21 Department of IT & Sciences Page 12

Alumni Portal

SYSTEM ANALYSIS

System analysis is the process of observing system for development purposes looking at end
user implementation of software product.

4.1 STUDY OF CURRENT SYSTEM

Existing system is a manual one in which users are maintaining documents paper
work to store the information like colleges details, student details. It is very difficult to maintain
historical data. It is difficult to maintain important information in documents paper work. More
manual hours need to generate required reports. It is tedious to manage historical data which
needs much space to keep all the previous years, ledgers, documents paper work.

Limitations in Existing System

 System will enter students, staff data and handling it. There is no centralized database
maintenance
 There is no easy access to the particular students record.
 The student cannot easily navigate through the database.

4.2 PROBLEMS OF CURRENT SYSTEM

• After the graduation there will be no contact between colleges and alumni.
• Even some of the students will not be in contact with their old friends.
• Some Colleges don’t maintain information about alumni.
• Alumni also don’t get updates about their college.
• Colleges face difficulty to inform their old students about placement drives.
• Thus it causes lack of communication between Colleges and Alumni.

AIMS IHE, 2020-21 Department of IT & Sciences Page 13

Alumni Portal

4.3 REQUIREMENTS OF NEW SYSTEM

FUNCTIONAL REQUIREMENTS:

 Track and manage all alumni from graduation class till present.
 Add/Remove alumni as needed in the system.
 Provide the KSU alumni options to opt out and be added to mailing lists sent by the
system.
 Allow the alumni association to communicate back and forth with KSU alumni from
graduation class till present.

NON FUNCTIONAL REQUIREMENTS:

 Host the alumni database server on the Cloud Management Portal to allow for large
storage capacity.
 Create the system so that it may be accessible through all internet browsers rather than
just one type of browser.

4.4 REQUIREMENTS VALIDATION

 All fields such as Email, Name, Password and Contact number are validated and does not
invalid values for Email and cannot accept empty or blank values to Email and password
fields.
 Avoiding errors in data.
 Users can view their details.
 The system needs to store data in an organized way.

AIMS IHE, 2020-21 Department of IT & Sciences Page 14

Alumni Portal

4.5 FUNCTIONS OF SYSTEM

 System can act as a interactive medium between the old student and the School, College,
University or institution..
 At the same time it helps the alumni to communicate with the institution, may be a
school, or college or a university and with the old batch mates.
 The system stores alumni information that is recorded for future reference.
 The system enhances retrieval of needed information by admin

4.6.DATA MODELING

4.6.1 USE CASE DIAGRAM

A Use case is a description of set of sequence of actions. Graphically it is rendered as
an ellipse with solid line including only its name. Use case diagram is a behavioral diagram
that shows a set of use cases and actors and their relationship. It is an association between
the use cases and actors. An actor represents a real-world object. Primary Actor – Sender,
Secondary Actor Receiver.
Use case diagrams model behavior within a system and helps the developers understand
of what the user require. The stick man represents what’s called an actor.

Use case diagram can be useful for getting an overall view of the system and clarifying
that can do and more importantly what they can’t do.

Use case diagram consists of use cases and actors and shows the interaction between the
use case and actors.

 The purpose is to show the interactions between the use case and actor.
 To represent the system requirements from user’s perspective.
 An actor could be the end-user of the system or an external system.

AIMS IHE, 2020-21 Department of IT & Sciences Page 15

Alumni Portal

USE CASE DIAGRAM OF ADMIN

Supervisor has the following tasks

 Add a new account
 login
 view Feedback
 Change password
 Add college
 Add college Information
 logout

AIMS IHE, 2020-21 Department of IT & Sciences Page 16

Alumni Portal

USE CASE DIAGRAM OF ALUMNI

Student has powers

 login
 Registration
 Give Feedback
 Change password
 Search college
 logout

AIMS IHE, 2020-21 Department of IT & Sciences Page 17

Alumni Portal

4.6.2 ACTIVITY DIAGRAM

AIMS IHE, 2020-21 Department of IT & Sciences Page 18

Alumni Portal

4.6.2 DATA DICTIONARY

 Refocus senior class giving campaigns. The class gift is often a staple of senior year.
 Establish online alumni affinity communities. ...
 Audit the campus newspaper. ...
 Cross search relevant local boards.

4.7FUNCTIONAL AND BEHAVIOURAL MODELLING

4.7.1 DATA FLOW DIAGRAM

The DFD takes an input-process-output view of a system i.e. data objects flow into the
software, are transformed by processing elements, and resultant data objects flow out of the
software.

Data objects represented by labelled arrows and transformation are represented by

circles also called as bubbles. DFD is presented in a hierarchical fashion i.e. the first data flow
model represents the system as a whole. Subsequent DFD refine the context diagram (level 0
DFD), providing increasing details with each subsequent level.

The DFD enables the software engineer to develop models of the information domain &
functional domain at the same time. As the DFD is refined into greater levels of details, the
analysts perform an implicit functional decomposition of the system. At the same time, the DFD
refinement results in a corresponding refinement of the data as it moves through the process that
embodies the applications.

AIMS IHE, 2020-21 Department of IT & Sciences Page 19

Alumni Portal

DFD DIAGRAM OF ALUMNI

AIMS IHE, 2020-21 Department of IT & Sciences Page 20

Alumni Portal

4.8 MODULES OF NEW SYSTEM

Admin Side 

 Login Page
 The page where system admin will submit their system credential to access and
manage the system data.
 Home Page
 The page where the admin user will be redirected by default after logging into the
alumni management system admin side. This page displays the summary or total
counts of alumni, posted jobs, forum topics, and upcoming events.
 Gallery Page
 The page where the admin user will manage the gallery images and data for the
website.
 Course List
 The page where the admin will populate and manage the university or college
school's courses.
 Alumni List
 The page where the alumni list in the system are listed and this the page where
can the admin verify the alumnus/alumna's account.
 Jobs Page
 The page where all posted jobs are listed and can be managed by the admin.
 Events Page
 The page where an admin manages or posts an upcoming event of the school
where can alumni can participate.
 Forum Page
 The page where all forum topics are listed along with the count of comments if
this topic is being shown.
 User Page
 The page where an admin user manages the system users.

AIMS IHE, 2020-21 Department of IT & Sciences Page 21

Alumni Portal

 System Settings Page

 The page where an admin setup or manages the school information to be shown
on the website.

Alumni Side

 Home Page
 The default page where the user will be redirected when browsing the website and
after logging in. This page shows the list of upcoming events.

Signup Page

 The page where the unregistered alumnus/alumni submit their credentials.

 About Page
 The page where the page about content is being shown.
 Job Page
 The page where all posted job opportunities is listed.
 Forum Page
 The page where those forum topics are listed and the user can join or read the
comments by selecting and viewing a topic.
 Account Management Page
 The page where can the user update his/her system credentials and information.

AIMS IHE, 2020-21 Department of IT & Sciences Page 22

Alumni Portal

4.9 SELECTION OF HARDWARE AND SOFTWARE JUSTIFICATION

 MYSQL

 As MYSQL is one of the few open source relational DBMS and an essential
component in web development
 MYSQL is another main language like PHP and when combined together for
a web development they can create websites amazingly
 The good thing about PHP and MYSQL is its integrity, open source and ease
properties
 It makes everything transparent

 OPERATING SYSTEM

We are familiar with the use of windows 10. And also the enhanced Windows 10
security features allow businesses to keep their data, devices and users protected
24x7. The OS makes it easier than over for a small or mid-sized business to get the
Windows 10 benefits of enterprise-grade security and control without complexity or
unrealistic costs.

AIMS IHE, 2020-21 Department of IT & Sciences Page 23

Alumni Portal

CHAPTER 5

AIMS IHE, 2020-21 Department of IT & Sciences Page 24

Alumni Portal

SYSTEM DESIGN

The design of a database starts with finding and organizing the information required and
dividing the information into tables and turning information items into columns, defining
primary keys and setting up the relationships of tables. The data in the system has to be stored
and retrieved from database. Designing the database is part of system design. Data elements and
data structures to be stored have been identified at analysis stage. They are structured and put
together to design the data storage and retrieval system. A database is a collection of interrelated
data stored with minimum redundancy to serve many users quickly and efficiently. The general
objective is to make database access easy, quick, inexpensive and flexible for the user.
Relationships are established between the data items and unnecessary data items are removed.
Normalization is done to get an internal consistency of data and to have minimum redundancy
and maximum stability. This ensures minimizing data storage required, minimizing chances of
data inconsistencies and optimizing for updates. The MYSQL database has been chosen for
developing the relevant databases.

Relationships
One to many relationship:
One to many relationship is the common relationship. In this type of relationship one table can
have many matching rows in other table

AIMS IHE, 2020-21 Department of IT & Sciences Page 25

Alumni Portal

5.1 DATABASE STRUCTURE DESIGN

Table 5.2 Registration of user page
Field Name Datatype Constraints
Email Varchar(50) Not Null
Password Varchar(50) Not Null

Table 5.2 Alumni Account Creation

Field Name Datatype Constraints

First Name Varchar(50) Not Null
Last Name Varchar Not Null
Middle Name Varchar(50) Not Null
Currently connected to Varchar(50) Not Null
Email Varchar(50) Not Null
Password Varchar(50) Not Null

Table 5.3 Login of user:

Field Name Datatype Constraints
Email Varchar(50) Not Null
Password Varchar(50) Not Null

5.4 SYSTEM ARCHITECURE DESSIGN

AIMS IHE, 2020-21 Department of IT & Sciences Page 26

Alumni Portal

AIMS IHE, 2020-21 Department of IT & Sciences Page 27

Alumni Portal

CHAPTER 6

IMPLEMENTATION and PLANNING DETAILS

XAMPP server (about backend)

AIMS IHE, 2020-21 Department of IT & Sciences Page 28

Alumni Portal

XAMPP is a free and open source cross-platform web server solution stack package, consisting
mainly of the Apache HTTP server, MYSQL database, and interpreters for script written in PHP.

APACHE server

MySQL

MySQL is the world’s second most Relational Database Management System(DBMS) and most
widely used open-source RDBMS. It is named after co-founder Michael Widenius’s daughter
MySQL acronym stands for Structured Query Language.

The MySQL development project has made its source code available under the terms of the GPL
(General Public License), as well as under a variety of proprietary agreements. MySQL was
owned and sponsored by a single for-profit firm,the Swedish company MySQL Ab, now owned
by Oracle Corporations.

MySQL is a popular choice of database for use in web applications, and is a central component
of the widely used LAMP open source web application software stack (and other “AMP” stacks).
LAMP is an acronym for “Linux, Apache, MySQL, Perl/PHP/”. Free software open source
projects that requires a full-featured database management system often use MySQL.

AIMS IHE, 2020-21 Department of IT & Sciences Page 29

Alumni Portal

6.1 MODULES SPECIFICATION

ADMIN MODULE

• Login page: Admin will login using this page.

• Home page: Admin can view all menu’s like alumni list, events and jobs etc.

• Gallery: Admin can add images to gallery.

• Alumni list: Admin will verify this list.

• Jobs page: Admin can post jobs.

• Events: Admin can add events and manages the events.

• Forum page: Contains list of all forum topics.

• User page: The page where an admin manages the system users.

• System settings page: The page where admin manages the information to be shown on
website.

ALUMNI SIDE / USER SIDE

• Home page: This page shows upcoming events.

• Signup page: Unregistered alumni submit their information and create account.

• Login page: The user will login using this page.

• Gallery page: Will contain images.

• About page: Contains about details.

• Job page: Here user can view/post jobs.

• Forum Page: Here user can view/post forum topics.

• Account management page: Here user can update their account details.

AIMS IHE, 2020-21 Department of IT & Sciences Page 30

Alumni Portal

CHAPTER 7

AIMS IHE, 2020-21 Department of IT & Sciences Page 31

Alumni Portal

TESTING

Testing is the third phase of our development. It plays a vital role in understanding the
system expectations and results by one or more different attempts on working with the system. It
is more than just error detection.

In testing phase we used manual testing in our project, where manual testing is a type of software
testing in which test cases are executed manually by a tester without using any automated tools.
The purpose of Manual Testing is to identify bugs, issues, and defects in the software
application. Manual software testing is the most primitive technique of all testing types and it
helps to find all critical bugs in the software application.

7.1 TETSING PLAN

Our documentation as described in above points that the scope, approach, resources, and
schedule representation, it identifies the test activities that suite for the particular approach, what
to test? Who will do each task? The test environment these are to be taken while doing and kind
of test strategies.

7.2 TESTING STRATEGY

In this section, we usually define the following:

 Test levels: In this section will test the level of testing such as white box testing and
black box testing were in our project we test for the functional/behavioural, non-
functional tests.

 Test types: In this section we usually check our QA (Quality Assurance). Testing as we
are not using any type of Automation testing, we will not consider this content in our
topic.

AIMS IHE, 2020-21 Department of IT & Sciences Page 32

Alumni Portal

 Roles and Responsibilities: In section we describe the roles and responsibilities of

project team members, where we both shared our work like front-end and back-end part
which resulted us the good shape of project.

 Environment Required: As we are not using any automation testing, we don’t need any
environment or IDE’s.

7.3 TESTING METHODS

In this section, we usually define the following:

As we have followed grey box testing, we have the done the following methods:

 Matrix Testing: In matrix testing we tested about defining variables that exist in
programs.

 Orthogonal Array Testing (OAT): Orthogonal array testing made us relieve as it covers
maximum code with minimum test cases.

Steps that will be perform in grey box testing:

 Identifying inputs
 Identifying outputs
 Identifying major paths
 Identifying sub functions
 Developing inputs for sub functions
 Developing outputs for sub functions
 Executing test case for sub functions
 Verifying correct results for sub functions

AIMS IHE, 2020-21 Department of IT & Sciences Page 33

Alumni Portal

7.4 TEST CASES

AIMS IHE, 2020-21 Department of IT & Sciences Page 34

Alumni Portal

AIMS IHE, 2020-21 Department of IT & Sciences Page 35

Alumni Portal

CHAPTER 8

AIMS IHE, 2020-21 Department of IT & Sciences Page 36

Alumni Portal

SCREEN SHOTS

ADMIN HOME PAGE:

JOB LIST:

ALUMINI LIST:

AIMS IHE, 2020-21 Department of IT & Sciences Page 37

Alumni Portal

ALUMINI LIST:

ALUMNI ACCOUNT CREATION:

LOGIN OF ALUMNI:

AIMS IHE, 2020-21 Department of IT & Sciences Page 38

Alumni Portal

JOBS Posting by Admin:

ALUMNI DISCUSSION FORUM :

AIMS IHE, 2020-21 Department of IT & Sciences Page 39

Alumni Portal

ALUMNI PROFILE:

AIMS IHE, 2020-21 Department of IT & Sciences Page 40

Alumni Portal

CHAPTER 9

LIMITATION AND FUTURE ENHANCEMENT

AIMS IHE, 2020-21 Department of IT & Sciences Page 41
Alumni Portal

Though we have improved the way of best features to include in the specific terminology
and to make our project with the best efforts and the great implementations. The result of the
project will make a great enhancement in the running of each module in simple, better and
flexible ways.

Though we have tried our best efforts to make the software flexible and feasible to operate
still them are limitations. They are so many efforts from us to make it easy to operate but it be
bit problematic to:

 To improve security wise

 If user data is more

FUTURE ENHANCEMENT

• This project can be made as Android Application.

• Verification message can be sent to user after registration.
• At the time of login, users will enter their respective email-id , and password.
Instead of entering password, we can make user to enter OTP sent to the email-id
and then login to the website.

• Event Invitation can be sent to the alumni who are committed to participate in the
event.

AIMS IHE, 2020-21 Department of IT & Sciences Page 42

Alumni Portal

CHAPTER 10

AIMS IHE, 2020-21 Department of IT & Sciences Page 43

Alumni Portal

CONCLUSION

This system will be available for general public use through the web interface. A
non-registered visitor can look at the list of graduates according to year of graduation or
a field of study.

He can also look at graduates profiles. The level of profile details shown to the public
is limited. By default, a public visitor can only see name and surname of a graduate, year
of graduation and a field of study. The faculty endeavors to propagate its graduates.

Therefore graduates can also add some information about themselves into the system
during the study such as working experience, knowledge. Graduates can enable to
display this information in their profiles for public visitors. Inserted information can be
used as an input for generating graduate’s curriculum vitae in pdf format, which is
provided automatically. It is in a graduate’s competence, which information will be
searching pages with their crawlers. A graduate can use it for the building of his virtual
web identity on the internet.
Our Alumni system solves the problem concerned with graduate’s feedback to the
faculty with an inquiry module. In this module the faculty can define questions with
answers which active graduates can respond. This module should be used for collecting
data which are not included in graduate’s profiles and have high information value for
the faculty

AIMS IHE, 2020-21 Department of IT & Sciences Page 44

Alumni Portal

CHAPTER 11

REFERENCES

AIMS IHE, 2020-21 Department of IT & Sciences Page 45

Alumni Portal

 https://www.youtube.com/
 https://www.tutorialspoint.com/php/php_and_mysql.htm
 https://www.w3schools.com/php
 www.codementor.com
 www.stackover.com

AIMS IHE, 2020-21 Department of IT & Sciences Page 46