Alumni Information System

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of Alumni Information System

Alumni Information System is a web based application which has been developed over PHP and MySQL and runs on WAMP, XAMP or Apache2 server.. The main modules of the project is Alumni,College,Social Network,Opportunity,College News. Admin user can manage all the operations of Opportunity,College News,Alumni,College Mates,College and their details. Admin can create different type of reports of Alumni,College,Social Network,Opportunity,College News according to their choise and filters. You can Download PHP and MySQL Project Alumni Information System with source code and database from this site. We also provide Project Report of Alumni Information System.

Functionalities and their descriptions of Alumni Information System are as follows:

  • You can search records on various criterias. Such as Alumni, Social Network, Opportunity, College News
  • Create, read, update and delete (CRUD) application has been implemented on Alumni,College,Social Network,Opportunity,College News
  • Keep the track logs of College, College Mates, Opportunity ect
  • Advance search has been implemented on College,College Mates, Opportunity
  • You can see all the details of the Alumni, Social Network, College Mates, Opportunity
  • All the modules College Mates, Opportunity, College,College News, Alumni are inter related and tightly coupled
  • It deals with monitoring the information and transactions of Opportunity.
  • All the College,College Mates, Opportunity modules has their unique record ID for fast transactions and searching
  • Editing, adding and updating of Records is improved which results in proper resource management of Alumni data.

Modules of Alumni Information System and their descriptions:

  • Alumni Module : Manage all the operations of Alumni
  • College Module : Manage all the operations of College
  • College Mates Module : Manage all the operations of College Mates
  • Social Network Module : Manage all the operations of Social Network
  • Opportunity Module : Manage all the operations of Opportunity
  • College News Module : Manage all the operations of College News

Classes and their methods of Alumni Information System:

  • Alumni Methods : addAlumni(), editAlumni(), deleteAlumni(), updateAlumni(), saveAlumni(), searchAlumni()
  • College Methods : addCollege(), editCollege(), deleteCollege(), updateCollege(), saveCollege(), searchCollege()
  • College Mates Methods : addCollege Mates(), editCollege Mates(), deleteCollege Mates(), updateCollege Mates(), saveCollege Mates(), searchCollege Mates()
  • Social Network Methods : addSocial Network(), editSocial Network(), deleteSocial Network(), updateSocial Network(), saveSocial Network(), searchSocial Network()
  • Opportunity Methods : addOpportunity(), editOpportunity(), deleteOpportunity(), updateOpportunity(), saveOpportunity(), searchOpportunity()
  • College News Methods : addCollege News(), editCollege News(), deleteCollege News(), updateCollege News(), saveCollege News(), searchCollege News()

Database tables and attributes of the Alumni Information System:

  • Alumni Entity : Attributes of Alumni are alumni_id, alumni_title, alumni_type, alumni_date, alumni_description
  • College Entity : Attributes of College are college_id, college_name, college_description
  • College Mates Entity : Attributes of College Mates are college mates_id, college mates_name, college mates_mobile, college mates_email, college mates_username, college mates_password, college mates_address
  • Social Network Entity : Attributes of Social Network are social_network_id, social_network_name, social_network_type, social_network_description
  • Opportunity Entity : Attributes of Opportunity are opportunity_id, opportunity_type, opportunity_description
  • College News Entity : Attributes of College News are college news_id, college news_title, college news_type, college news_description

Database definition of Alumni Information System:

  • The details of Alumni is store into the Alumni tables respective with all tables
  • Each entity (College News, College Mates, Opportunity, College, Alumni) contains primary key and unique keys.
  • The entity College Mates, Opportunity has binded with Alumni, College entities with foreign key
  • There is one-to-one and one-to-many relationships available between Opportunity, Social Network, College News, Alumni
  • All the entities Alumni, Opportunity, College Mates, College News are normalized and reduce duplicacy of records
  • We have implemented indexing on each tables of Alumni Information System tables for fast query execution.

Super admin functionality of Alumni Information System:

  • Admin can add, edit, delete and view the records of Alumni, Opportunity, College Mates, College News
  • Admin can manage all the details of College, College Mates, Social Network, Opportunity
  • Admin can also generate reports of Alumni, College, College Mates, Social Network
  • Admin can search the details of Alumni, Opportunity, College Mates, College News
  • Admin can apply different level of filters on report of Alumni, College Mates, College News
  • Admin can tracks the detailed information of Opportunity, College News, Alumni, College

Report of Alumni Information System:

  • Generates the report on College Mates,Social Network,Alumni,College,Opportunity,College News,
  • Social Network,Opportunity,College News has been integrated with the dynamic filter. So you can filter the records run time
  • You can also import the report data into PDF of Social Network,Opportunity,College News
  • Excel Sheet report has also been integrated for College,Social Network,College News
  • You can create the CSV reports for Alumni,Opportunity,College Mates

Limitation of Alumni Information System

  • Run time report generation is not available in Alumni Information System.
  • We have not implemented the dynamic report for Alumni,Social Network,Opportunity,College,College Mates,College News
  • This project Alumni Information System has not been developed on Model View Controller architecture, so its very complex to manage
  • Batch mode execution for Off-line reports of Alumni, Social Network, College News cannot be generated.
  • Crystel report has not been integrated

Input Data and Validation of Alumni Information System

  • We have added all the validations for input value on the modules Alumni,College,College Mates
  • Social Network,Opportunity,College News can not be submited without filling all the inout fields
  • Duplicate values testing has been implemented on Alumni,College Mates,College News
  • CSRF token has also been implemented on Social Network,College,Alumni, Opportunity,College News
  • All the Alumni,Social Network,Opportunity,College,College Mates,College News has integrated with captcha for spam protections
  • Access level validation has been implemented on College News,Opportunity,Social Network
  • Number and character validation has also been implemented on College Mates,Opportunity,Alumni

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database