Alumni Database Management System

Alumni Database Management System

Rugved Shinde, Makarand Kakad, Shital Ghodke, Prajkta Dodake.

Student, Department of Information Technology, Pimpri chinchwad Polytechnic, Pune.

Prof. T. R. Shinde

Lecturer, Department of Information Technology, Pimpri Chinchwad Polytechnic, Pune

Abstract- The main aim of the project is to build an interaction between alumni, admin and the students; a system that will be able to manage alumni data of a college and provide easy access to the same. The alumni will also be interested to maintain relations with their institutions. Alumni can communicate to the students regarding job opportunities and the students can share the department technology activities to the alumni. The alumni and the student can communicate only through the admin permission. A system that will be able to manage alumni data ofa college and provide easy access to the system. Final year students will be initially given a student login ID. Access to the system can help them in building connections to their projects or for placements. The system will automatically list all Alumni information (name, passing year, company currently working in, ) and their status will be transferred from the student module to the alumni module.

Keyword: Database, login, online, web based

1. INTRODUCTION

   The greatest asset any institution can have is the Alumni system. Alumni are the people who represent the institutionin the real world. Alumni website is created for the students that have graduated from the institution. This is an online website that allows former students to take advantage of the benefits and services that an 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 informed on the events that are organized by the institution, and when some important events are going to be held in the institution. Another benefit is that the information concerning a former student can easily be received and other members ofthe alumni community can be located without much stress. The student and alumni can communicate with each other.

2. LITERATURE SURVEY

   1. Existing System

      The Existing system is a computerized system but which is maintained at individual databases i.e in excels sheets, its a time delay process. And maintaining all the records in Excel sheets is difficult. If they want any record , they have to search all the records. It doesnt provide multiple user accessibility and also doesnt have different user privileges.

      So the system is not accessible for all the employees of the organization.

   2. Limitations in Existing System

      The current system is not completely computerized and manual system in entering students and 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.

   3. Proposed System

      The Proposed system is a computerized system but which is maintained at centralized databases i.e. in automated forms its a very fast process. And maintaining all the records in online systems database which makes it very easy to access and retrieve data from the database. If they want any record they can easily search all the records. It provides multipleuser accessibility and also has different user privileges. So the system is accessible for all the employees of the organization.

   4. Advantages Over Existing System

   It is completely automated system in handling the collegedatabase.

   This system provides centralized database maintenance This system provides easy access to the particular alumniaccount or his/her complete details

   This system provides student to easily navigate through theapplication for more information in a most secure manner.

3. ACTIVITY DIAGRAM

   Fig 1: System Architecture

4. APPLICATIONS

   Alumni helps institutes strategically build and manage their alumni network, by facilitating engagement, community- building, networking, communications and giving back.

   With our online website, your Alumni data can be centralized and combined with a host of exciting front-end member modules and timesaving, back-end administration tools.

   It will also be important to the NBA (National Board of Accredition) activities that are going to take place in our college.

5. METHODOLOGY

   As this is a complete online website, there are two technics

   -Frontend & Backend.

   Frontend means the design of the website or the designinginterface of the web application.

   Programing languages coming under Frontend: – HTML, CSS & Java Script.

   Backend means server side programming; it communicatesthe client interface with the database and the logic control. Programing languages coming under Backend: – Php,JavaScript, etc.

   Also Bootstrap and CSS are used for design purpose.

6. CONCLUSION

   • Reduces manual work.

   • It is time saving.

   • Efficient way of managing the Alumni data.

   • No need of paperwork as everything is online.

7. ACKNOWLEDGEMENT

The successful completion of any task would be incomplete, without the mention of people who are foremost, we would like to express our sincere gratitude to our research supervisors who has in the literal sense, guided and supervised us. Their guidance deserves much more than the credit on the successful completion of our project and also for giving us an opportunity to implant our skills and for providing the required help and co- operation to complete the report. We are indebted with a deep sense of gratitude for the constant inspiration and valuable guidance throughout the work.

We are humbly thankful to Prof. T.R.Shinde, H.O.D., Deptof Information Technology for providing us a Proper guidance and high bandwidth round the clock responsible for the completion of this work.

REFERENCES

1. https://www.w3schools.com

2. https://www.wikipedia.org/