Student Managent System

zainadmin

Introduction

       Student Management System is software which is helpful for students as well as the school authorities. In the current system all the activities are done manually. It is very time consuming and costly. Our Student Management System deals with the various activities related to the students.

There are mainly 3 modules in this software

 

  • Teacher Module
  • Student Module
  • Admin Module.

 

 

 

In the Software we can register as a Student and Teacher. Administrator registers both student and teacher and has the power to add new user and can edit and delete a user. A student can register as user and can add edit and delete his profile. The administrator can add edit and delete marks for the student. All the users can see the marks.

Background

Student Management system was introduced because most of  the schools were using manual System to maintain their record, they were using a bundle of files to store data of students, to enroll them they were using files and adding them to different notebook registers. This system was introduced to give a computerized access to the database of students, teacher and other staff members. This System will allow them to find any record of student or teacher within seconds, which was previously saved in the DataBases.

 

The REQUIREMENTS

 

 Hardware Requirements

 

Processor              :       Pentium III 630MHz

RAM                    :       128 MB

Hard Disk             :       20GB

Monitor                :       15” Color monitor

Key Board            :       104 Keys

 

 Software Requirements

 

Operating System       : Windows 7

: Windows XP

Language                    :  C#, M.S Visual Studio

Database                     :   SQL Server

Functional Requirements

 

The functional requirements of the system are to the implement the solution for finding the train details and route information in the large existing rail system.

 

  1. 1.      Input / Output:

 

The user select the type of train and enter the source and destination codes with which finds the trains details and route information.

 

  1. 2.      Processing:

 

The information regarding train details are retrieved from the database.

 

  1. 3.      Storage Requirements:

 

The information will be retrieved from the database.

 

  1. 4.      Control Requirements:

Alerts when any errors are there and when any of the field is not selected.

 

The Design

The Design of School management System is Structured. I have used windows farm in order to make the graphical user interface. As the School management software is intended to be used by administrator of the school, school teachers and as well as by the students of the school so the graphical user interface has been designed in a way that every user of the software can use its corresponding module with ease and comfort. Following the logical and conceptual design of the project are discussed in detail:

The User Interface

As I have explained earlier my project has been divided to 3 different modules. So I have used windows farms an panels to create the graphical user interface for all three modules

The Main Manu:

on the login screen a user can login as an admin teacher   or student depending upon the user type using his user name or password

The Teacher Module

The UI For the teacher module is shown in the following figure:

zainteacher

The Student Module

The UI For the teacher module is shown in the following figure:

zainstudent

 

The Admin Module

The UI For the Admin module is shown in the following figure, u can seethat it is most lengthy and important module of the project as it handlesall the marks management and student registration related tasks

zainadmin

 

 

Logical Design

                        Logical Design derives business objects and their related services directly from these usage scenarios. The logical view of the solution provides a basis for evaluating different physical options. It also formalizes the solution for the project team.

The idea of the application is that the system first emerges in logical design.Its boundaries and business objects and it contains the system definition. Logical design specifies the interfaces between the system and external entities,such as users and other systems. Within a system there may be a number of sub-systems, and these boundaries are also specified.

Logical System Design consists of the following steps:

  • Input/Output Specifications
  • File Specifications
  • Processing Specifications

Logical design should be technologically independent as possible, inorder to separate system behavior issues from system implementation issues.

Conceptual Design:

                       Conceptual Design is the process of acquiring and evaluating, documenting and then validating what the user envisions to be the business relation. It identifies the user and business requirements of the application and leads to a business solution as seen by the user.

To achieve this conceptual design is driven by developing usage scenarios. These scenarios are a direct representation of the user’s view of the solution to a specific business          problem. A conceptual view places the emphasize on solving a business problem and deriving a solution that corresponds to the needs and requirements of the users. It is based on deriving the behavior of the solution with a primary emphasizes on the user. Beginning with a emphasis on the activities of the business rather than aspects of software development, underscores the fact that systems exists to serve the business. A strong focus on the user in the beginning of the project will help in maintaining a proper perspective throughput the development lifecycle.The conceptual design results in the first description of what the system does to solve the business problem articulated in the vision/scope document.

The Code

The coding of the project is very simple to understand. There is main class of student that keeps the record of all students, The teacher class is responsible for the storage the data of all the teachers. Similarly to maintain the all fee transections and handle marks management module I have used the manage class that keeps all the track of all the marks management relating activities and fee record.

protected override void Dispose( bool disposing )

{

if( disposing )

{

if (components != null)

{

components.Dispose();

}

}

base.Dispose( disposing );

}

 

#region Windows Form Designer generated code

/// <summary>

/// Required method for Designer support – do not modify

/// the contents of this method with the code editor.

/// </summary>

private void InitializeComponent()

{

this.panel1 = new System.Windows.Forms.Panel();

this.btnStudent = new System.Windows.Forms.Button();

this.btnClose = new System.Windows.Forms.Button();

this.label1 = new System.Windows.Forms.Label();

this.MainPanel = new System.Windows.Forms.Panel();

this.panel1.SuspendLayout();

this.SuspendLayout();

//

// panel1

//

this.panel1.BackColor = System.Drawing.Color.AliceBlue;

this.panel1.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;

this.panel1.Controls.Add(this.btnStudent);

this.panel1.Controls.Add(this.btnClose);

this.panel1.Dock = System.Windows.Forms.DockStyle.Left;

this.panel1.Location = new System.Drawing.Point(0, 0);

this.panel1.Name = “panel1”;

this.panel1.Size = new System.Drawing.Size(96, 585);

this.panel1.TabIndex = 1;

//

// btnStudent

//

this.btnStudent.FlatStyle = System.Windows.Forms.FlatStyle.Popup;

this.btnStudent.Location = new System.Drawing.Point(8, 16);

this.btnStudent.Name = “btnStudent”;

The Data Base Class

The project is linked with SQL server. All the data is stored in the data base using the database class. Ass Following

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data.SqlClient;

using System.Data;

using System.Windows.Forms;

 

namespace ProjectVP

{

 

 

class DataBase

{

private string connectionString;

public DataBase()

{

MessageBox.Show(“”+connection.State);

dtable = new DataTable();

query = “”;

dtadapter = null;

form3 = new Form3();

total1 = 0;

total2 = 0;

total3 = 0;

total4 = 0;

total5 = 0;

grandTotal = 0;

}

 

 

public void InsertStudentData(string name,string rollNo, string semester,string age,string address)

{

try

{

query = “INSERT INTO tblStudentInfo(Name,RollNo,SemesterID,Age,Adress) VALUES(‘” + name + “‘,'” + rollNo + “‘,'” + semester + “‘,'” + age + “‘,'” + address + “‘)”;

dtadapter = new SqlDataAdapter(query, connection);

dtadapter.Fill(dtable);

MessageBox.Show(“You have successfully added a student in  record”);

}

catch (Exception e)

{

MessageBox.Show(“RollNo already assigned”);

}

}

 

public DataTable Search(string rollNo)

{

query = “SELECT * FROM tblStudentInfo WHERE RollNo = ‘” + rollNo + “‘”;

dtadapter = new SqlDataAdapter(query, connection);

dtadapter.Fill(dtable);

return dtable;

 

}

 

public DataTable FindSubjects(string semester)

{

 

dtadapter.Fill(dtable);

}

catch (Exception e)

{

MessageBox.Show(“Result Already Entered”);

}

}

 

public int getTotal()

{

return grandTotal;

}

 

public DataTable getResult(string roll)

{

query = “SELECT

dtadapter = new SqlDataAdapter(query, connection);

dtadapter.Fill(dtable);

return dtable;

}

 

public string getSemester(string roll)

{

try

{

query = “SELECT SemesterID FROM tblStudentInfo WHERE RollNO = ‘” + roll + “‘”;

dtadapter = new SqlDataAdapter(query, connection);

dtadapter.Fill(dtable);

 

string i = dtable.Rows[0][0].ToString();

dtable.Clear();

}