Student Information Management System Report.docx

PROJECT REPORT ON

“STUDENT INFORMATION MANAGEMENT SYSTEM” Submitted as a part of course curriculum for

DIPLOMA IN COMPUTER SCIENCE & ENGINEERING As prescribed by

DEPARTMENT OF TECHNICAL EDUCATION, KARNATAKA Submitted by

FAIZAN KHAN FAZAL UR REHAMAN RAHUL J.P SAGAR.V

578CS16010 578CS16011 578CS16027 578CS16029

Under the guidance of

Mrs. GAYATHRI M (Asst. Prof., Dept. of CSE) Mrs. PRIYA V K (Asst. Prof., Dept. of CSE)

BRINDAVAN COLLEGE OF ENGINEERINGPOLYTECHNIC Yelahanka, Bengaluru-560063

A Project Report on

“STUDENT INFORMATION MANAGEMENT SYSTEM” Submitted for partial fulfillment of the requirements for the award of DIPLOMA IN COMPUTER SCIENCE & ENGINEERING As prescribed by

DEPARTMENT OF TECHNICAL EDUCATION, KARNATAKA BY BATCH

Mr. FAIZAN KHAN (578CS16010) Mr. FAZAL UR REHAMAN (578CS16011) Mr. RAHUL J.P (578CS16027) Mr. SAGAR.V (578CS16029) Under the guidance of

Mrs. GAYATHRI M (Asst. Prof., Dept. of CSE) Mrs. PRIYA V K (Asst. Prof., Dept. of CSE) DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING

BRINDAVAN COLLEGE OF ENGINEERINGPOLYTECHNIC Yelahanka, Bengaluru - 560063

CANDIDATE’S DECLARATION

We,

the students of

DIPLOMA

IN COMPUTER

SCENCE &

ENGINEERING Department bearing Register Number 578CS16010, 578CS16011, 578CS16027, 578CS16029 of BRINDAVAN COLLEGE OF ENGINEERING- POLYTECHNIC, hereby declare that, we owe full responsibility for the information, results and conclusions provided in this project work titled “STUDENT INFORMATION MANAGEMENT SYSTEM” submitted to Board of Technical Examinations, Government of Karnataka for the award of Diploma in Computer Science & Engineering. To the best of my knowledge, this project work has not been submitted in part or full elsewhere in any other institution/organization for the award of any certificate/diploma/degree. We have completely taken care in acknowledging the contribution of others in this academic work. We further declare that in case of any violation of intellectual property rights and particulars declared, found at any stage, we, as the candidate will be solely responsible for the same. Date: candidates Place:

Signature of

FAIZAN KHAN (578CS16010)

FAZAL UR REHAMAN (578CS16011)

RAHUL J.P (578CS16027)

SAGAR.V (578CS16029)

BRINDAVAN COLLEGE OF ENGINEERINGPOLYTECHNIC DIPLOMA IN COMPUTER SCIENCE & ENGINEERING

BONAFIDE CERTIFICATE

Certified that this project report “STUDENT INFORMATION MANAGEMENT SYSTEM” is the bonafide work of FAIZAN KHAN (578CS16010), FAZAL UR REHAMAN (578CS16011), RAHUL J.P (578CS16027), SAGAR.V (578CS16029) of this institution who carried out the project work under my supervision.

SIGNATURE OF GUIDES HOD 1. Gayathri M (Asst. Prof.) 2. Priya V K (Asst. Prof.) Department of CSE, CSE, BrCE-Polytechnic, Yelahanka, Bengaluru - 560063

SIGNATURE OF Gayathri M Assistant Professor, Department of BrCE-Polytechnic, Yelahanka, Bengaluru - 560063

SIGNATURE OF DEAN Mr. Suresh Raj Jain

DEPARTMENT OF TECHNICAL EDUCATION

BRINDAVAN COLLEGE OF ENGINEERINGPOLYTECHNIC Dwarkanagar, Yelahanka, Bengaluru-560063 DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING

CERTIFICATE Certified that this project report entitled “HOSPITAL MANAGEMENT SYSTEM” which is being submitted by Mr. FAIZAN KHAN (578CS16010), Mr. FAZAL UR EHAMAN (578CS16011), Mr. RAHUL J.P (578CS16027), Mr. SAGAR (578CS16029), bonafide students of Brindavan College Of Engineering – Polytechnic, in partial fulfilment for the award of Diploma in Computer Science & Engineering during the year 2018-19, is record of students’ own work carried out under our guidance. It is certified that all corrections/suggestions indicated for internal assessment have been incorporated in the Report and one copy of it being deposited in the polytechnic library. The project report has been approved as it satisfies the academic requirement in respect of Project Work prescribed for the said diploma. It is further understood that by this certificate the undersigned do not endorse or approve any statement made, opinion expressed or conclusion drawn therein but approve the project only for the purpose for which it is submitted.

1. Gayathri M (Asst. Prof.) 2. Priya V K (Asst. Prof.) Guide(s)

Dr. Suresh Raj Jain Dean

Dr. B R Niranjan Principal

Name and Signature of Examiners: 1. Name:

Signature:

2. Name:

Signature:

ACKNOWLEDGEMENT The stratification that accompanies the successful completion of any activity would be incomplete without mentioning the people who made it possible whose content guideline and encouragement crowned our effort with success. We are deeply indebted to the following persons for their valuable cooperation which has resulted in a better script. We would like to express our sincere gratitude to our principal Dr. B. R. Niranjan, Brindavan college of Engineering for the encouragement and support extended by him. We wish to express our gratitude to Dr. Suresh Raj Jain, Dean, Brindavan College of Engineering-Polytechnic for his suggestion and guidance. We would like to thank our guide Mrs. Gayathri M, Assistant Professor, Department of CSE and Mrs. Priya V K, Assistant Professor, Department of CSE for the help and guidance given to the successful completion of our project work. We also thank our teaching and non-teaching staff of Computer Science & Engineering who have steered us on the pure path to success directly and indirectly.

FAIZAN KHAN FAZAL UR REHAMAN RAHUL J.P SAGAR.V

DATABASE DESIGN Table Name: t_user_data Fields s_id s_pwd s_dob s_name s_email s_mob s_signupdate

Data Type Varchar (PRIMARY KEY) varchar date varchar varchar Bigint datetime

Description Student ID Student’s login Password Date of Birth Student Name Student Email Student Mobile No. Signup Date and Time

Table Name: t_user Fields s_id s_phn1 f_name f_occ f_phn m_name m_occ m_phn s_sex s_cadr s_cst s_cmob s_padr s_natn s_relg s_catg s_pcm s_pct s_moi s_pay

Data Type Varchar (PRIMARY KEY) Bigint varchar varchar Bigint Bigint datetime Bigint varchar varchar varchar Bigint varchar varchar varchar varchar varchar Int varchar varchar

Description Student ID Student’s Phone No. Father’s Name Father’s Occupation Father’s Phone No. Mother’s Name Mother’s Occupation Mother’s Phone No. Gender Current Address State Name Home Telephone No. Permanent Address Nationality Religion Category (GEN,OBC,SC,ST) Previous Course Completed Aggregate Percentage Medium of Instruction (Lang) Payment Mode

Table Name: t_admin Fields ad_id ad_name ad_pswd ad_eml ad_mob

Data Type Varchar (PRIMARY KEY) varchar varchar varchar Bigint

Description Admin ID Admin Name Admin Login Password Admin’s Email Admin’s Mobile No.

Table Name: t_usermark Fields

Data Type

s_id Varchar (PRIMARY KEY) s_sem Int s_mark Int s_mark2 Int s_mark3 Int s_mark4 Int s_mark5 Int UNIQUE KEY `msem` (`s_id` , `s_sem`)

Description Student ID Student’s Semister Subject-1 Marks Subject-2 Marks Subject-3 Marks Subject-4 Marks Subject-5 Marks

Table Name: t_attndns Fields

Data Type

s_id Varchar (PRIMARY KEY) s_asem Int s_year Int s_attnded Int s_total Int UNIQUE KEY `asem` (`s_id`,`s_asem`)

Description Student ID Student’s Semister Academic Year Classes Attended Total Classes

Table Name: t_fees Fields

Data Type

s_id Varchar (PRIMARY KEY) s_acyr Int s_year Int s_paid Double s_total Double UNIQUE KEY `ayr` (`s_id`,`s_acyr`)

Description Student ID Academic Year Year Fee Paid Total Fee

ABSTRACT

Student Information Management System (SIMS) provides a simple interface for maintenance of student information. It can be used by educational institutes or colleges to maintain the records of students easily. The creation and management of accurate, up-to-date information regarding a students’ academic career is critically important in the university as well as colleges. Student information system deals with all kind of student details, attendance, I.A marks, Fee details, and other resource related details too. It tracks all the details of a student from the day one to the end of the course which can be used for all reporting purpose, tracking of attendance, progress in the course, completed semesters, years, I.A marks, Fee details, online interface embedded in the college’s website. It enables student to login and access the necessary details. It also provides an admin login where admin can add, delete or update the student details.