College Management System

(1)

PROJECT REPORT ON

COLLEGE MANAGEMENT SYSTEM

Submitted In Partial Fulfillment of the Requirement Of Bachelor of Business Administration

BATCH-(2009-2012)

PROJECT SUPERVISOR: SUBMITTED BY: MISS.NEHA SABHARWAL ASHISH KHEMKA

E.NO – 01912401709

Delhi institute of rural development, Nangli Poona (Affiliated to Guru Gobind Singh Indraprastha University)

(2)

DECLARATION

I hereby declare that this Project Report titled “COLLEGE MANAGEMENT

SYSTEM” submitted by me to Delhi Institute Of Rural Development,

NANGLI POONA is a Bonafide work undertaken by me and has not been submitted to any other University or Institution for the award of any degree diploma / certificate or published any time before.

……… Ashish Khemka 01912401709 Date: / / 2010

(3)

ACKNOWLEDGEMENT

First of all I will thank to our director sir “Dr. NARENDER MOHAN”, who give me the valuable suggestion for my minor project.

The success of this final report is the outcome of Guidance and Valuable suggestions provided by the all concerned without which the report could not fide on the right back.

I express my sense of deep gratitude to Faculty Coordinator “Ms. NEHA

SABHARWAL” for inclusions and timely suggestions in the preparation of

this final report.

Name: Ashish khemka BBA 01912401709

(4)

TABLE OF CONTENTS

S.NO TABLE OF CONTENTS

Declaration Acknowledgement (1) Introduction (2) Objectives (3) Implementation details (4) Format SRS (5) Hardware/software configuration (6) SDLC • MODEL (7) FEASIBILITY STUDY (8) ANALYSIS-DATA GATHERING (9) SYSTEM DESIGN • MODULE (10) ER-DIAGRAM & DFD

(11) SCREENS LAYOUT & CODING (12) TESTING

(13) MAINTENANCE (14) FUTURE SCOPE (15) BIBLIOGRAPHY

(5)

(6)

INTRODUCTION

The project “COLLEGE MANAGEMENT” is made to use that management working in dird. This Project is helpful to Registration of New records into the “COLLEGE”. This Project Contain mainly following section:-

1. VIEW SECTION. 2. ALTER SECTION

3. STAFF INFORMATION. 4. STUDENT INFORMATION. 5. TIME-TABLE INFORMATION.

6. STAFF RECORDS(ADD / MODIFY / DELETE) 7. STUDENT RECORDS(ADD / MODIFY / DELETE) 8. ATTENDENCE RECORDS(ADD / MODIFY / DELETE).

The upper “EIGHT” Forms are mainly used in this project. View Section is used to view the information of staff and student and Alter Section is used to modify the records. In staff information we undertakes the general and salary of staff member. In student information we are able to see his/her records about their performance , fee and attendance. In “TIME TABLE” Section we can see the lecture of all Lecturer. IF a new lecturer is appointed to college we can add its general information by using alter section. IF a new Student is admitted to college we can add its general information by using alter section. By using the attendance section we can see the monthly attendance of the student and also prepare monthly attendance percentage.

The Software VISUAL BASIC 6.0 is used as front end for the designing and programming and to create user friendly GUI forms. Oracle is used as backend to create the data tables required to store the information. At present there is no such system which helps in addition, ensure, alteration and demonstration of information to the client. So this system facilitates us to perform all these

(7)

functions rather straightforwardly with no supplementary specialization required.

Platform :

This project has been developed in one of the most popular and user friendly Microsoft Windows’ environment. The following components are also used for a successful user friendly effective development of this project:

1. FRONT END:- VISUAL BASIC . 2. BACK END:- ORACLE.

COLLEGE

MANAGEMENT:-This project (College Management) is made into the VISUAL BASIC 6.0 .It is used to modify / add / delete .The data into the project after submission is store into the Oracle.

This Project Contain mainly following forms: 1.VIEW SECTION.

2 ALTER SECTION

3 STAFF INFORMATION. 4 STUDENT INFORMATION. 5 TIME-TABLE INFORMATION.

6 STAFF RECORDS(ADD / MODIFY / DELETE) 7 STUDENT RECORDS(ADD / MODIFY / DELETE) 8 ATTENDENCE RECORDS(ADD / MODIFY / DELETE

(8)

1. VIEW SECTION:-.

View Section is used to view the student and staff information their salary information, general information, attendance information of student. We can check the semester wise information of student. We can also find the student who have not deposit their fees at time. . This form is fill by the user in alter section and user can see its data in view section..On this form there is a

commend button by which we can select an id to see information . In this form there is some text boxes, command buttons, labels , combo box .

TEXT BOX:-A text box is use to receive the information from the user by typing into it. A text box generally used in conjunction with a label

LABEL :-A label is a control used to display text on the form. The value of label button will be given on design time or can be change on the run time. COMMAND BUTTON:-A command button is used to initiate an action,

when user clicks on it. The code for the action to be performed is provide by the programmer

COMBO BOX:-It is Similar to the list box. Most of what you know about list box will apply to combo boxes. Item are added, Remove and clear with the add item, remove item and clear

method.

The user can fill following Fields 1. Name 2. Address 3. Phone No 4. Sem. 5. Branch 6. F.Name 7. Roll No 8. Sex etc.

(9)

2. ALTER SECTION

Alter Section is used to add the genral, fees, attendances, result information according to their needs. Management can add, modify, delete the information about their staff. Lecturs can add monthly attendance .

1. E-id 2. Name 3. Depdt. NAme. 4. Desgnation 5. Salary 6. Date of joining 7. Qualification 8. Sex 9. Age 10.Add.

(10)

PROJECT CATEGORY TOOLS AND ENVIRONMENT

PROJECT CATEGORY:

The programming language used for this project is Visual Basic (VB) which is the third-generation event-driven programming language and integrated development environment (IDE) from Microsoft. VB is considered a relatively easy to learn and use programming language, because of its graphical development features.

Visual Basic enables the rapid application development (RAD) of graphical user interface (GUI) applications, access to databases using Data Access Objects, Remote Data Objects, or ActiveX Data Objects, and creation of ActiveX controls and objects.

Keywords:

Event-Driven Programming: In computer programming, event-driven programming or event-based programming is a programming paradigm in which the flow of the program is determined by events²i.e., sensor

outputs or user actions (mouse clicks, key presses) or messages from other programs or threads.

Event-driven programming can also be defined as an application

architecture technique in which the application has a main loop which is clearly divided down to two sections: the first is event selection (or event detection), and the second is event handling.

Integrated Development Environment (IDE): An integrated development

environment (IDE) also known as integrated design environment or

integrated debugging environment is a software application that provides comprehensive facilities to computer programmers for software

(11)

• A source code editor

* A compiler and/or an interpreter * Build automation tools

CHARACTERSTICS:

1. The project stores all the information about the staff and students.

2. The management must be able to get details of all their information after storing.

3. It is simple to use and it is Graphical user interface.

4. The management can also be able to modify the information.

5. It has self explanatory form.

6. Management can check all the information of any staff member and student.

7. It is user friendly.

(12)

OBJECTIVE

The new College Management System is built to provide a better facility to the operator. This system makes the use of oracle as the back-end to tackle the problem of inconsistency of data.

✔ The project being developed in visual basic provides as integrated

development and debugging environment for debugging of the application.

✔ To gives a better user interface by providing the user with menus for the

various operations.

✔ To generates report in the required format correctly and within few

seconds by receiving the command from user. It allows multiple tasks to execute simultaneously.

Hence the project provides a better solution to the problem domain by providing not only faster operation but also by better utilization of system resources. Therefore, it provides data integrity and consistency, better user interfaces, support for multitasking.

(13)

IMPLEMENTATION DETAILS

TECHNOLOGY USED:- .NET  VBSCRIPT FRONT-END:- VISUAL BASIS BACK-END:- ORACLE

(14)

FORMAT for the SRS

• Introduction: The introduction of the Software Requirement Specification

states the goals and objectives of the software, describing it in context of the computer based system.

• Information Description: It provides detailed description of the problem

that the software must solve. Information content, flow and structure are documented. Hardware, Software and human interfaces are described for external system elements and internal software functions.

• Functional Description: A processing narrative is provided for each

function, design constraints are stated and justified, performance characteristics are stated, and one or more diagrams are included to graphically represent the overall structure of the software and interplay among software and other system elements.

• Behavioral Description: This section of the SRS examines the operation

of software as a consequence of external events and internally generated control characteristics.

• Validation Criteria: It is probably the most important and ironically the

most often neglected section of the Software Requirement Specification. The section is neglected because completing it demands a thorough understanding of the software requirements. Specification of validation

(15)

criteria acts as an implicit review of all other requirements, so it is essential that time and attention is given to this section.

• Bibliography and references: It is also important to put all the important

references at the end of the document so that any other programmer or user can refer to them in case of any confusions or problems.

(16)

HARDWARE/ SOFTWARE CONFIG

U

RATION

HARDWARE CONFIGURATION:  Microprocessor -- Pentium IV  Mother Board -- 845 GVPS  Hard Disk -- 80 GB  RAM -- 128 X 128 MB  Keyboard -- Multimedia

 ROM -- COMBO “SONY”

 UPS -- 500 WATT.

SOFTWARE CONFIGURATION:

 Operating System -- Windows Xp

 Language -- VISUAL BASIC 6.0

(17)

SDLC

System Development Life Cycle (SDLC) is the overall process of developing information systems through a multi-step process from investigation of initial requirements through analysis, design, implementation and maintenance.

✔ Correcting errors that were not discovered during the product

development phase. This is called corrective maintenance.

✔ Improving the implementation of the system, and enhance the

functionalities of the system according to the customer’s requirements. This is called perceptive maintenance.

✔ Porting the software to work in a new environment. This is called

adoptive testing.

MODEL

THE RAD MODEL (Rapid application development)

1. Rapid application development (RAD) is an incremental software

development lifecycle process model that emphasizes an extremely short development lifecycle.

2. The RAD model is a “high-speed” adaptation of linear sequential model in which rapid development is achieved by using component based construction.

(18)

3. If the requirements are well understood and project scope is constrained,

the RAD process enables a development team to create a “fully functional system” within short time periods (e.g, 60 to 90 days).

THE RAD MODEL

Business Modeling :- The information flow among business function is

modeled in a way that answer the following question. What information drives the business process? What information is generated? Who generates it?

Data Modeling :- The information flow defined as a part of the business

(19)

business. The characteristics (called attributes) of each object are identified and relationship between these objects defined.

Process Modeling: - The data objects defined in the data modeling phase are

transformed to achieve the information flow necessary to implement a business function. Processing descriptions are created for adding, deleting, modifying, or retrieving a data object.

Application Generation :- RAD assumes the use of fourth generation

techniques. Rather than creating software using conventional third generation programming languages the RAD process work to reuse existing program components. In all cases, automated tools are used to facilitate construction of the software.

Testing And Turnover :- Since the RAD process emphasizes reuse, many of

the program components have already been tested. This reduces overall testing time. However new components must be tested and all interfaces must be fully exercised.

DISADVANTAGES:-• For large but scalable projects, RAD requires sufficient human

resources to create the right number of teams.

• If commitment fails, projects will fail.

(20)

FEASIBILITY STUDY

Feasibility Study is a step towards identification of the candidate system as a feasible product. First the studies often pre-suppose that when the feasibility document is being prepared, the analyst is in a position to evaluate solutions. Second, most studies tend to overlook the confusion inherent in system development – the constraints and the assumed attitudes.

If the feasibility study is to serve as a decision document, it must answer three questions:

• Is there a new and better way to do a job that will benefit the user?

• What are the costs and savings of the alternatives?

• What is recommended?

Feasibility Considerations:

There are three key considerations to the feasibility study: 1) Economic

2) Technical 3) Behavioral

(21)

FEASIBILITY ANALYSIS OF THE SYSTEM

Economic Feasibility:

The project was considered to be economically feasible

because-• The cost involved in developing the candidate system well under the

budget of the organization.

• The Cost-Benefit Analysis tells us that the value of the benefits offered

by the proposed system is much higher than the cost.

Technical Feasibility:

The proposed system is technically feasible because all the necessary hardware and software required for developing and installing the system is available with the organization.

Behavioral

Feasibility:-The proposed system is also behaviorally feasible as it is very user friendly. Extensive training of the users is not required. The users can easily learn to use the system and can adapt themselves according to the system.

(22)

ANALYSIS

Analysis is the first technical step in the process of any software development. A careful analysis can help the software designer and programmer to have a better insight of the product to be created. A careless analysis can result into incomplete or dysfunctional software. To avoid such a situation it is very important to properly identify the required software’s features and create an effective design for it.

It is also important to analyze and find out whether the application being developed suits the current hardware and software platform available or not. The application should be developed well within time and should meet the specified requirements. If the application is being developed for commercial purposes then a cost-benefit analysis becomes must to find out the real value of the software product.

TECHNIQUES USED FOR ANALYSIS

Interviews and Questionnaires:

Interviews:

The interview is the face-to-face interpersonal meeting designed to identify relations and capture information as it exists. It is flexible tool, offering a better opportunity than the questionnaire to evaluate the validity of the information gathered.

(23)

This tool is used because it is a superior technique for capturing information as it exists and it is also an exploratory device to identify or verify information.

Guidelines for interviews:

• Who will be interviewed?

• In what order will they be interviewed?

• What specific questions will be asked in each interview?

Besides these, individual, group discussions can also be conducted, which can lead to some frank expression of opinions and ideas.

During interviews it should be kept in mind that there is a proper coordination between the interviewer and the interviewee so that the purpose of the interviews id fruitfully fulfilled.

Questionnaires:-The questionnaire is a self-administrated tool that is more economical and requires less skill to administer than the other methods. It examines a large number of respondents at the same time, provides standardized wording and instructions, and places less pressure on subjects for immediate responses.

(24)

SYSTEM DESIGN

The main part of designing a client/server application is to map the requirements identified into the features provided by the environment.

DESIGN PHASE

The design phase focuses on the detailed implementation of the system recommended in the feasibility study. Emphasis is on translating performance specifications into design specifications. The design phase is a transition from a user-oriented document (system proposal) to a document oriented to the programmers or database personnel.

The design process is a set of iterative steps that allow the designer to describe all the aspects of the software to be built, based on the user specification.

System design goes through two phases:

The requirements analysis phase defines WHAT a system must do and the design phase states HOW to do it.

(25)

The term design is used in two ways. When used as a verb, it represents the process of design & when used as a noun, it represents the result of the design process, which is the design for the system. The goal of the design process is to provide a model or representation of a system, which can be used later to build that system. The produced model is called the design of the system. The design process is essentially a blue print of a solution for the system. The input to the design phase is the specifications for the system to be designed.

DATABASE DESIGN

Database design activity deals with the design of the physical database. A key to this is how the access paths are to be implemented. A physical path is derived from a logical path. It may be implemented through pointers, chains or some other mechanisms.

A database is a collection of information that’s related to a particular subject or purpose, such as details of a bank and the users that use it. If your database isn’t stored on a computer, or only parts of it are, you may be tracking information from a variety of sources that you will need to coordinate and organize yourself.

Field:

A field is the smallest entity in the database. It is a particular characteristic or property of a specific person or subject.

(26)

Record:

A record is a collection of related fields.

Table:

A table is a collection of related records. Usually a separate table is made for different types of subjects or purposes. The tables can be related to obtain a working relationship in the database.

Module

The complete functions of this project are based on the fowling module.

 Attendance Maintenance Module:

In this module we deal with different activities associated with college like regular attendance, short attendance report, every day attendance, checking of short list, replacement of staff, Appointing new lecturer according to the requirement, maintaining total staff(teacher & non teacher), and many more term associated with college management by this module. To handle these entire tasks it takes help of following forms, which are as follows:

✔ Access student information form

✔ Attendance form.

✔ Short list check form

✔ Total attendance by date

(27)

 Quick Search module:

This module contains a strong search mechanism, which search for different ways as per the requirement of the user. It can search:

• Attendance list present in the database

• Different student present in different class provides a full detail of all

student.

• It also provides facility to check the list of short attendance of the student

• It also searches for the total student present in class for any required

date.

(28)

(29)

(30)

(31)

CONTEXT LEVEL DIAGRAMRepresents External Entity Represents the Process Represents the flow of Control/Data

Represents Close Database

(32)

SYST EM INPUT OUTPUT

DATA FLOW DIAGRAM

0-level DFD:

(33)

LOGIN PROC ESS TEACHER ENTRY STUDENT ENTRY ATTENDENC E ENTRY REPORT GENRATION

2-level DFD:

2.1:

(34)

ADMINISTRATOR_LOGI N PROC ESS TEACHER ENTRY ADMINISTRATOR STUDENT ENTRY

2.2:

TEACHER STUDENT LOGIN AFTER LOGIN AFTER LOGIN DATA ENTRY DATA ENTRY DATA STORED DATA STORED

(35)

LOGI N PROC ESS ADMINISTRATOR REPORT GENERATION ATTENDENCE ENTRY USER

SCREEN LAYOUT AND CODINGS

Form 1

Program Picture Form

LOGIN ATTENDENCE ATTENDENCEREPOR T DATA STORE D DAT A ENTR Y AFTE R LOGI N AFTE R LOGI N

(36)

CODING

Private Sub Form_Load() ProgressBar1.Max = 500

(37)

ProgressBar1.Min = 0 End Sub

Private Sub Timer1_Timer() Static i As Integer 'i = 1 i = i + 1 ProgressBar1.Value = i If (i Mod 2 = 0) Then Label1.Visible = True Else Label1.Visible = False End If If (i > 498) Then Unload Me PASSWORD.Show End If End Sub

Form-2

LOGIN FORM

(38)

(39)

Private Sub Form_Load() T_PASS.PasswordChar = "*" End Sub

Private Sub CMDCONT_Click() If T_PASS.Text = "" Then

MsgBox ("PLEASE ENTER A PASSWORD") Else

If T_PASS.Text = "college" Then WELCOME_SCREEN.Show Else

MsgBox ("YOUR PASSWORD IS INVALD") End If

End If End Sub

Private Sub CMDEXIT_Click() End

End Sub

(40)

(41)

CODING

Private Sub Form_Load() If Time$ < "12:00:00" Then MsgBox ("GOOD MORNING") Else

If Time$ = "12:00:00" Then MsgBox ("GOOD NOON") Else

If Time$ > "12:00:00" And Time$ < "16:00:00" Then MsgBox ("GOOD AFTERNOON")

Else

If Time$ >= "16:00:00" And Time$ < "20:00:00" Then MsgBox ("GOOD EVENING")

Else

If Time$ > "20:00:00" Then MsgBox ("GOOD NIGHT") End If End If End If End If End If End Sub

Private Sub Timer1_Timer() Unload Me

MM.Show End Sub

(42)

F

orm

-4

(43)

CODING

Private Sub Form_Load()

Unload PIC End Sub

Private Sub HELP_Check4_Click() MM_HELP.Show

MM.Hide

HELP_Check4.Value = Unchecked End Sub

Private Sub SM_Check1_Click() SM.Show

MM.Hide

SM_Check1.Value = Unchecked End Sub

Private Sub TM_Check2_Click() TM.Show

MM.Hide

TM_Check2.Value = Unchecked End Sub

Private Sub NTM_Check3_Click() NTM.Show

MM.Hide

NTM_Check3.Value = Unchecked End Sub

(44)

End End Sub

Form

-5

(45)

CODING

Private Sub GEN_Check1_Click()

STUDENTS_GENERAL_INFORMATION.Show GEN_Check1.Value = Unchecked

SM.Hide End Sub

Private Sub EXAM_Check2_Click() STUDENTS_EXAMS.Show

EXAM_Check2.Value = Unchecked SM.Hide

End Sub

Private Sub ATTEN_Check3_Click() STUDENTS_ATTENDANCE.Show ATTEN_Check3.Value = Unchecked SM.Hide

End Sub

Private Sub FEES_Check4_Click() STUDENTS_FEES.Show

FEES_Check4.Value = Unchecked SM.Hide

End Sub

Private Sub LIB_Check5_Click() STUDENTS_LIBRARY.Show LIB_Check5.Value = Unchecked

(46)

SM.Hide End Sub

Private Sub HELP_Check6_Click() STUDENTS_HELP.Show

HELP_Check6.Value = Unchecked SM.Hide

End Sub

Private Sub MM_Check7_Click() MM.Show

MM_Check7.Value = Unchecked SM.Hide

(47)

F

orm

-6

Student_General

Information

Database

Create table STUDENT_GEN(ID NUMBER(10) NOT

NULL,

S_NAME VARCHAR2(15) NOT NULL,

DOB DATE NOT NULL,

SEX VARCHAR2(3) NOT NULL,

F_NAME VARCHAR2(15) NOT NULL,

M_NAME VARCHAR2(15) NOT NULL,

F_OCCU VARCHAR2(25) NOT NULL,

M_OCCU VARCHAR2(25) NOT NULL,

ADDRESS VARCHAR2(25) NOT NULL,

PHONE NUMBER(25) NOT NULL,

CLASS VARCHAR2(10) NOT NULL,

SECTION VARCHAR2(8) NOT NULL,

ROLL_NO VARCHAR2(15) NOT NULL,

YEAR VARCHAR2(5) NOT NULL,

HOBBIES VARCHAR2(40) NOT NULL,

REMARKS VARCHAR2(40) NOT NULL)/

(48)

(49)

CODING

MsgBox ("TO MAKE OR VIEW RECORDS FIRST CLICK COMMAND BUTTON")

T_DATE.Text = Date$ T_TIME.Text = Time$ End Sub

Private Sub CMDNEW_Click() Adodc1.Recordset.AddNew End Sub

Private Sub CMDDEL_Click() Adodc1.Recordset.Delete

MsgBox ("DELETED") End Sub

Private Sub CMDMF_Click() Adodc1.Recordset.MoveFirst

MsgBox ("YOU ARE NOW ON FIRST RECORD") End Sub

Private Sub CMDML_Click() Adodc1.Recordset.MoveLast

MsgBox ("YOU ARE NOW ON LAST RECORD") End Sub

Private Sub CMDMN_Click() Adodc1.Recordset.MoveNext If Adodc1.Recordset.EOF Then

MsgBox ("NO NEXT RECORD IS PRESENT") Adodc1.Recordset.MoveLast

(50)

End If End Sub

Private Sub CMDMP_Click() Adodc1.Recordset.MovePrevious If Adodc1.Recordset.BOF Then

MsgBox ("NO PREVIOUS RECORD IS PRESENT") Adodc1.Recordset.MoveFirst

End If End Sub

Private Sub CMDFIND_Click() Dim A As Integer

Dim STRCRITERIA As String Adodc1.Recordset.MoveFirst

A = InputBox("ENTER ID TO BE SEARCHED") STRCRITERIA = "ID = " & A

Adodc1.Recordset.Find STRCRITERIA If Adodc1.Recordset.EOF = False Then

T_ADD = Adodc1.Recordset.Fields("ADDRESSS").Value T_DOB = Adodc1.Recordset.Fields("DOB").Value T_F_NAME = Adodc1.Recordset.Fields("F_NAME").Value T_M_NAME = Adodc1.Recordset.Fields("M_NAME").Value T_F_OCCU = Adodc1.Recordset.Fields("F_OCCU").Value T_M_OCCU = Adodc1.Recordset.Fields("M_OCCU").Value T_S_NAME = Adodc1.Recordset.Fields("S_NAME").Value T_PHNO = Adodc1.Recordset.Fields("PHONE").Value T_ROLL = Adodc1.Recordset.Fields("ROLL_NO").Value T_REM = Adodc1.Recordset.Fields("REMARKS").Value T_HOBB = Adodc1.Recordset.Fields("HOBBIES").Value L_STREAM = Adodc1.Recordset.Fields("STREAM").Value L_SEX = Adodc1.Recordset.Fields("SEX").Value L_SEC = Adodc1.Recordset.Fields("SECTION").Value L_YEAR = Adodc1.Recordset.Fields("YEAR").Value End If

(51)

End Sub

Private Sub CMDUPD_Click() Dim A As Integer

Dim STRCRITERIA As String A = Val(TextID.Text)

Adodc1.Recordset.MoveFirst STRCRITERIA = "ID <> " & A

Adodc1.Recordset.Find STRCRITERIA If Adodc1.Recordset.EOF = False Then Adodc1.Recordset.Update

MsgBox ("YOUR RECORD IS UPDATED") Else

MsgBox ("YOUR RECORD CANNOT BE UPDATED AS SAME ID EXIST")

End If

CMDMOD.Enabled = True End Sub

Private Sub CMDSM_Click() SM.Show

STUDENTS_GENERAL_INFORMATION.Hide End Sub

Private Sub CMDMOD_Click() CMDMOD.Enabled = False CMDUPD.Enabled = True End Sub

Private Sub TEXTID_LostFocus() TextID.Text = Trim(TextID.Text) End Sub

(52)

Form

-7

Student Examination Information

Database

CREATE TABLE S_EXAM(ID NUMBER(15) NOT NULL,

S_NAME VARCHAR2(15) NOT NULL,

STREAM VARCHAR2(10) NOT NULL,

SECTION VARCHAR2(10) NOT NULL,

ROLL_NO NUMBER(15) NOT NULL,

EXAM VARCHAR2(15) NOT NULL,

YEAR VARCHAR2(5) NOT NULL,

T_SUBJECTS VARCHAR2(50) NOT NULL,

MAX_MARKS NUMBER(10) NOT NULL,

MIN_MARKS NUMBER(10) NOT NULL,

MARKS_OBT NUMBER(10) NOT NULL,

PERCENTAGE NUMBER(10) NOT NULL,

RESULT VARCHAR2(25) NOT NULL,

ENTRY_DATE DATE NOT NULL,

ATTENDANCE NUMBER(10) NOT NULL,

REMARKS VARCHAR2(40) NOT NULL)

/

(53)

CODING

(54)

End If End Sub

(55)

Dim A As Integer

T_S_NAME = Adodc1.Recordset.Fields("S_NAME").Value T_ROLL = Adodc1.Recordset.Fields("ROLL_NO").Value T_SUB = Adodc1.Recordset.Fields("T_SUBJECTS").Value T_MAXM = Adodc1.Recordset.Fields("MAX_MARKS").Value T_MINM = Adodc1.Recordset.Fields("MIN_MARKS").Value T_MOBT = Adodc1.Recordset.Fields("MARKS_OBT").Value T_PERC = Adodc1.Recordset.Fields("PERCENTAGE").Value T_RESULT = Adodc1.Recordset.Fields("RESULT").Value T_ENTRYDATE = Adodc1.Recordset.Fields("ENTRY_DATE").Value T_REM = Adodc1.Recordset.Fields("REMARKS").Value L_EXAM = Adodc1.Recordset.Fields("EXAM").Value L_YEAR = Adodc1.Recordset.Fields("YEAR").Value L_MONTH = Adodc1.Recordset.Fields("MONTH").Value T_STREAM = Adodc1.Recordset.Fields("STREAM").Value T_SEC = Adodc1.Recordset.Fields("SECTION").Value End If End Sub

(56)

Adodc1.Recordset.Update

End If

STUDENTS_EXAMS.Hide End Sub

Private Sub T_SUB_LostFocus()

If L_EXAM.ListIndex = 0 And T_SUB.Text = "6" Then T_MAXM.Text = "90"

T_MINM.Text = "54" End If

(57)

End If End Sub

Private Sub T_MOBT_LostFocus() Dim A, B As Integer A = Val(T_SUB.Text) B = Val(T_MOBT.Text) If L_EXAM.ListIndex = 0 Then T_PERC.Text = (B * 10 / 9) Else If L_EXAM.ListIndex = 1 Then T_PERC.Text = (B * 10 / 9) Else If L_EXAM.ListIndex = 2 Then T_PERC.Text = (B * 1 / 9) End If End If End If If T_PERC.Text < 40 Then T_RESULT.Text = "FAIL" Else

If T_PERC.Text >= 40 And T_PERC.Text < 60 Then T_RESULT.Text = "PASS PROMOTED"

Else

If T_PERC.Text >= 60 And T_PERC.Text < 80 Then T_RESULT.Text = "GOOD"

Else

If T_PERC.Text >= 80 And T_PERC.Text < 100 Then T_RESULT.Text = "EXCELLENT" End If End If End If End If T_ENTRYDATE = Now() End Sub

(58)

Form

-8

S

tudent

A

ttendence

Database

CREATE TABLE S_ATTENDANCE(ID NUMBER(15)

NOT NULL,

YEAR number(4) NOT NULL,

MONTH VARCHAR2(15) NOT NULL,

S_NAME VARCHAR2(15) NOT NULL,

STREAM VARCHAR2(10) NOT NULL,

SECTION VARCHAR2(8) NOT NULL,

ROLL_NO NUMBER(15) NOT NULL,

HALF_DAYS NUMBER(10) NOT NULL,

FULL_DAYS NUMBER(10) NOT NULL,

T_PRESENCE NUMBER(10) NOT NULL,

FINE NUMBER(4) NOT NULL)

(59)

CO

DING

(60)

End If End Sub

(61)

Adodc1.Recordset.MoveFirst End If

End Sub

T_S_NAME = Adodc1.Recordset.Fields("S_NAME").Value T_ROLL = Adodc1.Recordset.Fields("ROLL_NO").Value T_FULLD = Adodc1.Recordset.Fields("FULL_DAYS").Value T_HALFD = Adodc1.Recordset.Fields("HALF_DAYS").Value T_FINE = Adodc1.Recordset.Fields("FINE").Value T_ATTEN = Adodc1.Recordset.Fields("T_PRESENCE").Value T_DOJ = Adodc1.Recordset.Fields("DOJ").Value L_STREAM = Adodc1.Recordset.Fields("STREM").Value L_SEC = Adodc1.Recordset.Fields("SECTION").Value End If End Sub

(62)

End If

STUDENTS_ATTENDANCE.Hide End Sub

Private Sub T_FULLD_LostFocus() Dim B, C As Integer B = Val(T_HALFD.Text) C = Val(T_FULLD.Text) T_ATTEN.Text = (1 / 2 * B + C) T_FINE.Text = (B + 2 * C) End Sub

(63)

Form

-9

S

tudent

F

ees

Database

CREATE TABLE S_FEES(ID NUMBER(15) NOT NULL,

S_NAME VARCHAR2(15) NOT NULL,

STREM VARCHAR2(10) NOT NULL,

SECTION VARCHAR2(10) NOT NULL,

ROLL_NO NUMBER(15) NOT NULL,

YEAR VARCHAR2(5) NOT NULL,

FEES_SUBMIT NUMBER(15) NOT NULL,

FINES NUMBER(10) NOT NULL,)

(64)

CODING

(65)

End If End Sub

(66)

Adodc1.Recordset.MoveFirst End If

End Sub

T_S_NAME = Adodc1.Recordset.Fields("S_NAME").Value T_ROLL = Adodc1.Recordset.Fields("ROLL_NO").Value T_FEES = Adodc1.Recordset.Fields("FEES_SUBMIT").Value T_FINE = Adodc1.Recordset.Fields("FINES").Value L_STREAM = Adodc1.Recordset.Fields("STREAM").Value L_SEC = Adodc1.Recordset.Fields("SECTION").Value End If End Sub

(67)

STUDENTS_FEES.Hide End Sub

Form

-10

Student Library Record

Database

CREATE TABLE S_LIB( ID NUMBER(15) NOT NULL,

S_NAME VARCHAR2(15) NOT NULL,

STREAM VARCHAR2(10) NOT NULL,

SECTION VARCHAR2(10) NOT NULL,

YEAR VARCHAR2(5) NOT NULL,

BOOKS NUMBER(5) NOT NULL,

BORROWER_NO NUMBER(15) NOT NULL,

FINE NUMBER(10) NOT NULL)

(68)

(69)

CODING

(70)

End Sub

End If End Sub

(71)

T_FINE = Adodc1.Recordset.Fields("FINE").Value T_BOOKS = Adodc1.Recordset.Fields("BOOKS").Value T_BNO = Adodc1.Recordset.Fields("BORROWER_NO").Value T_S_NAME = Adodc1.Recordset.Fields("S_NAME").Value L_STREAM = Adodc1.Recordset.Fields("STREAM").Value L_SEC = Adodc1.Recordset.Fields("SECTION").Value L_YEAR = Adodc1.Recordset.Fields("YEAR").Value End If End Sub

End If

STUDENTS_LIBRARY.Hide End Sub

Private Sub CMDMOD_Click() CMDMOD.Enabled = False CMDUPD.Enabled = True

(72)

End Sub

Form-11

Student Help Desk

CODING

Private Sub CMDSM_Click()

SM.Show

STUDENTS_HELP.Hide End Sub

(73)

F

orm

-12

Teacher Help Desk

CODING

(74)

TEACHERS_GENERAL.Show GEN_Check1.Value = Unchecked TM.Hide

End Sub

Private Sub ATTEN_Check2_Click() TEACHERS_ATTENDANCE.Show ATTEN_Check2.Value = Unchecked TM.Hide

End Sub

Private Sub SAL_Check3_Click() TEACHERS_SALARY.Show SAL_Check3.Value = Unchecked TM.Hide

End Sub

Private Sub HELP_Check4_Click() TEACHERS_HELP.Show

HELP_Check4.Value = Unchecked TM.Hide

End Sub

MM_Check5.Value = Unchecked TM.Hide

(75)

Form-13

Teacher General Information

Database

CREATE TABLE TEACHER_GEN(ID NUMBER(15) NOT

NULL,

T_NAME VARCHAR2(15) NOT NULL,

DOB DATE NOT NULL,

YEAR VARCHAR2(5) NOT NULL,

SEX VARCHAR2(3) NOT NULL,

F_NAME VARCHAR2(15) NOT NULL,

M_NAME VARCHAR2(15) NOT NULL,

F_OCCU VARCHAR2(25) NOT NULL,

M_OCCU VARCHAR2(25) NOT NULL,

ADDRESS VARCHAR2(40) NOT NULL,

PHONE NUMBER(25) NOT NULL,

CLASS VARCHAR2(10) NOT NULL,

SECTION VARCHAR2(8) NOT NULL,

REMARKS VARCHAR2(40) NOT NULL,

DOJ DATE NOT NULL)

(76)

CODING

T_DATE.Text = Date$ T_TIME.Text = Time$

(77)

End Sub

MsgBox ("NOW YOU ARE ON FIRST RECORD") End Sub

MsgBox ("NOW YOU ARE ON LAST RECORD") End Sub

End If End Sub

(78)

T_ADD = Adodc1.Recordset.Fields("ADDRESSS").Value T_DOB = Adodc1.Recordset.Fields("DOB").Value T_F_NAME = Adodc1.Recordset.Fields("F_NAME").Value T_M_NAME = Adodc1.Recordset.Fields("M_NAME").Value T_F_OCCU = Adodc1.Recordset.Fields("F_OCCU").Value T_M_OCCU = Adodc1.Recordset.Fields("M_OCCU").Value T_T_NAME = Adodc1.Recordset.Fields("T_NAME").Value T_PHNO = Adodc1.Recordset.Fields("PHONE").Value T_DOJ = Adodc1.Recordset.Fields("DOJ").Value T_REM = Adodc1.Recordset.Fields("REMARKS").Value L_CLASS = Adodc1.Recordset.Fields("CLASS").Value L_SEX = Adodc1.Recordset.Fields("SEX").Value L_SEC = Adodc1.Recordset.Fields("SECTION").Value L_YEAR = Adodc1.Recordset.Fields("YEAR").Value End If End Sub

(79)

End If

Private Sub CMDTM_Click() TM.Show

TEACHERS_GENERAL.Hide End Sub

(80)

Form-14

T

eacher

A

ttendence

Database

CREATE TABLE T_ATTENDANCE(ID NUMBER(15)

NOT NULL,

YEAR NUMBER(4) NOT NULL,

MONTH VARCHAR2(10) NOT NULL,

T_NAME VARCHAR2(15) NOT NULL,

STREAM VARCHAR2(10) NOT NULL,

SECTION VARCHAR2(8) NOT NULL,

HALF_DAYS NUMBER(10) NOT NULL,

FULL_DAYS NUMBER(10) NOT NULL,

T_PRESENCE NUMBER(10) NOT NULL,

FINE NUMBER(10) NOT NULL)

(81)

CO

DING

(82)

End If End Sub

Private Sub CMDMP_Click() Adodc1.Recordset.MovePrevious

(83)

If Adodc1.Recordset.BOF Then

End If End Sub

T_T_NAME = Adodc1.Recordset.Fields("T_NAME").Value T_FINE = Adodc1.Recordset.Fields("FINE").Value T_FULLD = Adodc1.Recordset.Fields("FULL_DAYS").Value T_HALFD = Adodc1.Recordset.Fields("HALF_DAYS").Value L_YEAR = Adodc1.Recordset.Fields("YEAR").Value T_ATTEN = Adodc1.Recordset.Fields("T_PRESENCE").Value L_MONTH = Adodc1.Recordset.Fields("MONTH").Value L_SEC = Adodc1.Recordset.Fields("SECTION").Value L_STREAM = Adodc1.Recordset.Fields("STREAM").Value End If End Sub

(84)

End If

TEACHERS_ATTENDANCE.Hide End Sub

Private Sub T_FULLD_LostFocus() Dim B, C As Integer B = Val(T_HALFD.Text) C = Val(T_FULLD.Text) T_ATTEN.Text = (1 / 2 * B + C) T_FINE.Text = (B + 2 * C) End Sub

(85)

Form

- 15

T

eacher

S

alary

Database

CREATE TABLE T_SALARY(ID NUMBER(15) NOT

NULL,

T_NAME VARCHAR2(15) NOT NULL,

STREAM VARCHAR2(10) NOT NULL,

SECTION VARCHAR2(8) NOT NULL,

YEAR NUMBER(5) NOT NULL,

GRADE VARCHAR2(8) NOT NULL,

SALARY NUMBER(15) NOT NULL,

DOJ DATE NOT NULL)

(86)

(87)

CODING

(88)

End If End Sub

(89)

If Adodc1.Recordset.EOF = False Then

T_T_NAME = Adodc1.Recordset.Fields("T_NAME").Value T_DOJ = Adodc1.Recordset.Fields("DOJ").Value T_SAL = Adodc1.Recordset.Fields("SALARY").Value L_YEAR = Adodc1.Recordset.Fields("YEAR").Value L_GRADE = Adodc1.Recordset.Fields("GRADE").Value L_STREAM = Adodc1.Recordset.Fields("STREAM").Value L_SEC = Adodc1.Recordset.Fields("SECTION").Value End If End Sub

End If

TEACHERS_SALARY.Hide End Sub

Private Sub CMDMOD_Click() CMDMOD.Enabled = False

(90)

CMDUPD.Enabled = True End Sub

Private Sub L_GRADE_LostFocus()

If L_CATEG.ListIndex = 0 And L_GRADE.ListIndex = 0 Then T_SAL.Text = "9000"

End If

End If End Sub

(91)

Form

-16

Teacher Help Desk

CO

DING

(92)

TEACHERS_HELP.Hide End Sub

Form

-17

N

on

-T

eacher

M

enu

D

atabase

create table NON_TEACHERS_GEN(ID NUMBER(15)

NOT NULL,

NT_NAME VARCHAR2(15) NOT NULL,

DOB DATE NOT NULL,

SEX VARCHAR2(3) NOT NULL,

F_NAME VARCHAR2(15) NOT NULL,

M_NAME VARCHAR2(15) NOT NULL,

F_OCCU VARCHAR2(25) NOT NULL,

M_OCCU VARCHAR2(25) NOT NULL,

ADDRESSS VARCHAR2(40) NOT NULL,

PHONE NUMBER(25) NOT NULL,

REMARKS VARCHAR2(40) NOT NULL,

DOJ DATE NOT NULL)

(93)

CODING

NON_TEACHERS_GENERAL.Show GEN_Check1.Value = Unchecked NTM.Hide

End Sub

Private Sub ATTEN_Check2_Click()

NON_TEACHERS_ATTENDANCE.Show ATTEN_Check2.Value = Unchecked

NTM.Hide End Sub

(94)

NON_TEACHERS_SALARY.Show SAL_Check3.Value = Unchecked NTM.Hide

End Sub

Private Sub HELP_Check4_Click() NON_TEACHERS_HELP.Show HELP_Check4.Value = Unchecked NTM.Hide

End Sub

MM_Check5.Value = Unchecked NTM.Hide

(95)

Form

-18

General Information Menu

CO

DING

(96)

T_TIME.Text = Time$ End Sub

End If End Sub

(97)

End If End Sub

T_ADD = Adodc1.Recordset.Fields("ADDRESS").Value T_DOB = Adodc1.Recordset.Fields("DOB").Value T_F_NAME = Adodc1.Recordset.Fields("F_NAME").Value T_M_NAME = Adodc1.Recordset.Fields("M_NAME").Value T_F_OCCU = Adodc1.Recordset.Fields("F_OCCU").Value T_M_OCCU = Adodc1.Recordset.Fields("M_OCCU").Value T_NT_NAME = Adodc1.Recordset.Fields("NT_NAME").Value T_PHNO = Adodc1.Recordset.Fields("PHONE").Value T_DOJ = Adodc1.Recordset.Fields("DOJ").Value L_SEX = Adodc1.Recordset.Fields("SEX").Value End If End Sub

(98)

End If

Private Sub CMDNTM_Click() NTM.Show

NON_TEACHERS_GENERAL.Hide End Sub

(99)

Form

-19

G

eneral

A

ttendence

Database

Create table NT_ATTENDANCE(ID NUMBER(15) NOT

NULL,

YEAR NUMBER(4) NOT NULL,

MONTH VARCHAR2(15) NOT NULL,

NT_NAME VARCHAR2(25) NOT NULL,

HALF_DAYS NUMBER(10) NOT NULL,

FULL_DAYS NUMBER(10) NOT NULL,

T_PRESENCE NUMBER(10) NOT NULL,

FINE NUMBER(4) NOT NULL)

(100)

CODING

T_DATE.Text = Date$ T_TIME.Text = Time$

(101)

End Sub

MsgBox ("YOU ARE NOW LAST RECORD") End Sub

End If End Sub

(102)

End Sub

T_NT_NAME = Adodc1.Recordset.Fields("NT_NAME").Value T_FINE = Adodc1.Recordset.Fields("FINE").Value T_FULLD = Adodc1.Recordset.Fields("FULL_DAYS").Value T_HALFD = Adodc1.Recordset.Fields("HALF_DAYS").Value T_PRES = Adodc1.Recordset.Fields("T_PRESENCE").Value L_MONTH = Adodc1.Recordset.Fields("MONTH").Value L_YEAR = Adodc1.Recordset.Fields("YEAR").Value End If End Sub

Adodc1.Recordset.MoveFirst STRCRITERIA = "ID = " & A

Adodc1.Recordset.Find STRCRITERIA If Adodc1.Recordset.EOF = True Then Adodc1.Recordset.Update

End If

(103)

End Sub

Private Sub CMDNTM_Click() NTM.Show

NON_TEACHERS_ATTENDANCE.Hide End Sub

Private Sub T_FULLD_LostFocus() Dim A, B As Integer A = Val(T_HALFD.Text) B = Val(T_FULLD.Text) T_PRES.Text = (1 / 2 * A + B) T_FINE.Text = (A + 2 * B) End Sub

(104)

Form

-20

N

on

-T

eacher

S

alary

D

atabase

Create table NT_SALARY(ID NUMBER(15) NOT NULL,

NT_NAME VARCHAR2(20) NOT NULL,

CATEGORY VARCHAR2(15) NOT NULL,

GRADE VARCHAR2(8) NOT NULL,

SALARY NUMBER(6) NOT NULL,

DOJ DATE NOT NULL)

(105)

(106)

End If End Sub

(107)

End If End Sub

T_NT_NAME = Adodc1.Recordset.Fields("NT_NAME").Value T_DOJ = Adodc1.Recordset.Fields("DOJ").Value T_SAL = Adodc1.Recordset.Fields("SALARY").Value L_CATEG = Adodc1.Recordset.Fields("CATEGORY").Value L_GRADE = Adodc1.Recordset.Fields("GRADE").Value End If End Sub