STUDENT'S INFORMATION SYSTEM

STUDENT’S INFORMATION SYSTEM

STUDENT’S INFORMATION SYSTEM

INTRODUCTION:

GOAL:

Software development process involves four modules analysis,designing,coding and testing of the software.Our goal is to develop software for storing student’s information,which we have named as student’s information system.

OBJECTIVE:

Our objective is to first understand the software to be developed,analyze the process and finally implement the concepts to develop software along with the considerations for various user levels,to provide a secured and a reliable software to store the details of the student’s studying in our institution.

INFORMATION DESCRIPTION:

DETAILED DESCRIPTION:

In this project development,we will have a database as a back end to store the details of the student’s,which will include,

1.Student name

2.Register number

3.Department

4.Year

5.Address & ph.no

6.Marks

We will have three different user:administrators,staff and student’s.They will be provided with different access levels.

The administrator will be allowed to ADD,EDIT AND VIEW the student’s information.The staff members will be allowed to EDIT AND

VIEW student’s records.The students will be allowed only to VIEW the records.

HARDWARE DESCRIPTION:

1. Intel Motherboard with Pentium Processor

2. RAM 256MB(minimum)

3. Hard disk 40GB(minimum)

SOFTWARE DESCRIPTION:

Microsoft VisualBasic6.0

Microsoft Access

Rational Rose

FUNCTIONAL DESCRIPTION:

PERFORMANCE CHARACTERISTICS:

In this project,the users will be students,staff members and administrators.The operations involved will be

Ø Addition of records

Ø Edition of records

Ø Deletion of records

Ø Viewing of records

The supreme access will be provided to the administrator who will be allowed to perform all the operations.

DATABASE REQUIREMENTS:

We will use MS Access as a back end to store our information.The database will be linked in the forms created using VB.

NON-FUNCTIONAL DESCRIPTION:

RELIABILITY:

The software is designed considering the reliability of ATM system.

AVAILABILITY:

This software will be available to all the users inside the campus.

SECURITY:

This software will provide a good security by providing authentication.The users are allowed to access the database after their user id and password gets authenticated.

MAINTAINABILITY:

Easier to maintain and update the database.

STUDENT MARK ANALYSIS SYSTEM

USECASE DIAGRAM:

CLASS DIAGRAM:

SEQUENCE DIAGRAM:

COLLABORATION DIAGRAM:

VB SOURCE CODE

Login : (Form1.frm)

Private Sub Command1_Click()

If Trim(Text1.Text) = "admin" And Trim(Text2.Text) = "sec" Then

Form2.Show

Unload Me

Else

If Trim(Text1.Text) = "staff" And Trim(Text2.Text) = "sec" Then

Form3.Show

Unload Me

Else

If Trim(Text1.Text) = "student" And Trim(Text2.Text) = "cse" Then

Form4.Show

Unload Me

Else

MsgBox "Check username & password"

End If

End If

End If

End Sub

Private Sub Command2_Click()

End

End Sub

Details : (Form2.frm)

Private Sub Command1_Click()

Data1.Recordset.AddNew

Data1.Recordset.Fields(0) = Text1.Text

Data1.Recordset.Fields(1) = Text2.Text

Data1.Recordset.Fields(2) = Text3.Text

Data1.Recordset.Fields(3) = Text4.Text

Data1.Recordset.Fields(4) = Text5.Text

Data1.Recordset.Fields(5) = Text6.Text

Data1.Recordset.Update

MsgBox "RECORD ADDED"

End Sub

Private Sub Command2_Click()

Dim b As String

Data1.Recordset.MoveFirst

a = False

Do While Not Data1.Recordset.EOF

If Data1.Recordset.Fields(0) = Trim(Text1.Text) Then

MsgBox "RECORD FOUND"

a = True

MsgBox "Are you sure want to delete", vbOKCancel

If vbOK Then

Data1.Recordset.Delete

MsgBox "RECORD DELETED"

Form2.Show

ElseIf vbCancel Then

Form2.Show

End If

Exit Do

End If

Data1.Recordset.MoveNext

Loop

If Not a Then

MsgBox "RECORD NOT FOUND"

End If

End Sub

Private Sub Command3_Click()

Form4.Show

Unload Me

End Sub

Private Sub Command4_Click()

End

End Sub

Private Sub Form_Load()

Dim a As Boolean

End Sub

Search : (Form4.frm)

Private Sub Command1_Click()

Data1.Refresh

fnd = False

Data1.Recordset.MoveFirst

Do While Not Data1.Recordset.EOF

fnd = True

If Data1.Recordset.Fields(0) = Trim(Text1) Then

Frame2.Visible = True

Text3.Text = Data1.Recordset.Fields(2)

Text4.Text = Data1.Recordset.Fields(3)

Text5.Text = Data1.Recordset.Fields(4)

Text6.Text = Data1.Recordset.Fields(5)

End If

Data1.Recordset.MoveNext

Loop

If Not fnd Then

MsgBox "CHECK NAME AND NO"

End If

End Sub

Private Sub Command2_Click()

End

End Sub

OUTPUT FORMS

Login : (Form1.frm)

Details : (Form2.frm)

Search : (Form4.frm)

RESULT:

Thus the Student information system was developed by using visual basic in front end and MS-Access in back end.