22-06-2012, 01:58 PM
Student Management System
Student Management System.docx (Size: 29.99 KB / Downloads: 105)
Abstract :
The Student management system is a project module designed using MySQL database server. This provides the back-end for managing the student details in any institution . This project is developed for iPrimed company. It will manage the details of student, their course details, Batch details, marks details and Attendance details. This module is designed only by considering the back-end.
Requirement Analysis :
1) The records for the student with the details should be maintained and can be updated for new entry.
2) The details of courses offered , Batch details and Assessment details should be maintained separately.
3) The attendance and marks details of each student should be maintained .
4) Views should be created individually for Admission, Progress_report,HR_view etc. by using data from different tables as per the requirement.
5) Some procedures should be created for making data retrieval and updation easly.
6) Triggers should be created for the back_up purpose.
Design :
E-R Diagram :
Finding Entities –
The System has following entities –
1) Student
2) Course
3) Batch
4) Test
5) Attendance
Finding Attributes-
The Entities have following attributes-
1)Student(student_ID,Student_name,Student_phonenumber,Student_email,Student address,Student course,Student batch no.,Student grade,Attendance percentage)
2)Course (course_ID,course_name,Course_duration)
3)Test(subject,total marks,percentage,grade)
4) Batch(Batch_id,Batch_start_date,Batch_EndDate,No. of student)
Student Management System.docx (Size: 29.99 KB / Downloads: 105)
Abstract :
The Student management system is a project module designed using MySQL database server. This provides the back-end for managing the student details in any institution . This project is developed for iPrimed company. It will manage the details of student, their course details, Batch details, marks details and Attendance details. This module is designed only by considering the back-end.
Requirement Analysis :
1) The records for the student with the details should be maintained and can be updated for new entry.
2) The details of courses offered , Batch details and Assessment details should be maintained separately.
3) The attendance and marks details of each student should be maintained .
4) Views should be created individually for Admission, Progress_report,HR_view etc. by using data from different tables as per the requirement.
5) Some procedures should be created for making data retrieval and updation easly.
6) Triggers should be created for the back_up purpose.
Design :
E-R Diagram :
Finding Entities –
The System has following entities –
1) Student
2) Course
3) Batch
4) Test
5) Attendance
Finding Attributes-
The Entities have following attributes-
1)Student(student_ID,Student_name,Student_phonenumber,Student_email,Student address,Student course,Student batch no.,Student grade,Attendance percentage)
2)Course (course_ID,course_name,Course_duration)
3)Test(subject,total marks,percentage,grade)
4) Batch(Batch_id,Batch_start_date,Batch_EndDate,No. of student)