Study On Creating A School Information System Computer Science Essay

Published: Last Edited:

This essay has been submitted by a student. This is not an example of the work written by our professional essay writers.

Al Bayan International School is using a manual system in registering new students, the registration department is still using the traditional method in documentation such as papers and files and stores it in shelves, but regarding to the important information they use Microsoft offices programs to store it, and that way is totally reduce human effort and time. There is a basic disadvantage in that way; any one can enter the files and document because there is no secure system.

Also the main method for storing the information about teachers and students is by written documents without the use of computer and also its stored in files put in shelves, that if there is any change in there records like the phone number, address or anything they must take them all out, that will take a lot of time and will take a big place in storing it.

The project allows users to save almost all of their school's information electronically, including information on employees, teachers and students that make it easy to manage the information with saving the time.

Chapter One: _


1.7 Introduction

At present time most of the schools does not have an electronic database, which means that it is very difficult to access information for students, teachers and the administration, and for that reason was the school information system to facilitate the search for the required information, especially in schools that contain a large number of students and therefore teachers and administrators.

Al Bayan International School (B.I.S) was established in 1977 by a group of dedicated people. Their aim was to provide fasters an environment for students to develop the intellectual qualities, ethical values, and positive attitudes required for effective participation and leadership in the overall development of Kuwait and the rapidly changing world, by creating awareness and understanding of their own Islamic culture and the values as well as those of others.

The school provides educational levels from Nursery through to High School that follows a balanced educational program in both Arabic and English Subjects. B.I.S is recognized by the Ministry of Education of Kuwait. These programs are implemented by specialist teachers in different areas of learning education.

1.8 School's Current Situation

Al Bayan international school is currently using a manual system, such as in registering new students they apply it using some forms that is written in papers, file them, put them in shelves, if there is any thing wrong they must take all the registering forms out, and find the form they wanted to correct.

Also the main method for storing the information about teachers and students is by written documents without the use of computer and also its stored in files put in shelves, that if there is any change in there records like the phone number, address or any thing they must take them all out, that will take a lot of time and will take a big place in storing it.

1.9 Aim of the Project

Al Bayan International School is using a manual system in registering new students, the registration department is still using the traditional method in documentation such as papers and files and stores it in shelves, but regarding to the important information they use Microsoft offices programs to store it, and that way is totally reduce human effort and time. There is a basic disadvantage in that way; any one can enter the files and document because there is no secure system.

1.10 Objectives of the Study

There are two objectives , general Objective and specific Objective as shown in the following sections

1.10.1 General Objective

The aim of the project is to create an information system for Al Bayan International School with special features that matches with the global educational development.

1.10.2 Specific Objective

Specifically the project aims to establish an interesting, comfortable system which includes:

a. Develop a system that will provide fast access to student information and provide privacy and security for all student and teacher information.

b. Provide a user ' friendly and easily navigable system by determine the problems encountered with the current system.

Most importantly, this information can be easily shared with authorized users, records can be easily searched, and reports can be easily generated.

1.11 Scope and Delimitation

Al Bayan International School system will cover many registration processes (Applying for Admission Form), these processes include:

1. Admission registration processes "Admission Form" which helps to record the useful information which refers to administration employs.

2. Teachers registration processes "Teachers form" which manage the employee records like name, contact details, and education information for teachers.

3. Students processes "Students form" this includes student's name, birth date, contact number, email, parents numbers, class, grades.

The project system will computerized some of the manual processes in the register department.

1.12 Project layout

In this project we are divided the report into 5 chapters:

In chapter one, we provide a brief introduction about the project, and al Bayan School the project applied to.

In chapter two, we provide a brief introduction to describe the meaning of the database, and some database models, and ending with some database applications.

In chapter three we will focus on the design of the project included the software and method used in our system.

Chapter Four the gives a full description of the system implementation

Chapter five is the conclusion and future works.

Chapter two: _

Database Models and Applications

2.1 Introduction

Most of us are fully aware of term data. The fact that we use this term on a daily basis, such as the person's age, prices of products, the number of staff in the company, and the postal code of the city, etc. are some examples of data. In our life we have to remember a lot of data but it is easier for us to remember all the information on a small number of individuals. It is very difficult for us to remember a lot of information when the number is greater. The database is an important aspect of all aspects of life and especially business, where we need database more than others for keeping the records. In the information society that we have, is dedicating a lot of computing power in the world to maintain and use databases.

Databases include all types of businesses, where are stored all types of data, like e-mail messages and contact information, financial data and sales records in the form of a database.

2.2 Database Management System (DBMS)

Database management system (DBMS) is a class of software which is used for making, organizes, and picks up, analyses and of the computer information in the databases to sort. Frequently become such program's has been meant for in an informal manner such as the 'database software." Database and database management are distinguishing systems, just like the text from the document differs from a text processing program uses for making and adapting.

Companies use the databases in many applications to the rules of accurate and comprehensive data, and usually to maintain databases of clients and suppliers, employees, inventory, supplies, products and orders, and service requests, and many other things. Database system can deal with all aspects of the data on the differences, and provide the desired methods required for data analysis. It is an essential tool for the management of all businesses.

2.3 Database & (DBMS) Structures

Data units are called usually within the database "records". Each record is unique and is divided into more limited numbers of "Fields", which describes the nature of the record. For example, in the database of employees, there is a unique number for each employee, and the fields in each record specifies the name of each employee, title, salary, date of appointment, phone number, the name of the supervisor, and many of the data to be stored in the system, and so forth. Fields may have fixed or variable information, and May or may not be unique in the record, but at least one must be unique for the record. Fields may contain text or numbers.

Figures in value- and date-type fields can be used for computations when the DBMS is used to analyze the data.

Fields can contain images, video clips, and audio, if the database management systems and computer hardware compatible to deal with multimedia data. Usually, the records- containing the same set of field classifications- kept within single file. For example, in the business database, groups of record exist in many cases, both for tangible objects, such as customers or vendors, or in the form of activities, such as orders, payments, and production statistics.

While many database management systems are designed specifically for applications of many specific industries, and can be customized only by the programmer, often database management systems users have the ability to design at least some of the characteristics of the fields or records and determine how the fields, records, and files relate to each other. To maintain complex databases in companies or institutions, a database designer or database administrator position is typically created specifically for this task. Database design is also the main activity of the Computer Consulting Services.

When a database containing the records is designed, it is include data entry, whether through human input or by computer, such as the barcode scanning. The adding, deleting and modifying processes for the records, it will be possible, almost in the real time for that entry If there lots are possible record which modifications require, them by updated, or processes, by a computer which in batch vogue on a certain time after several computer users the requests for modifications have introduced. Such as batch-mode processing generally take place after the working day beyond are with a view to the day sale or take consignments.

Relational DBMS, on the other hand are possible analyzing data from several files with complete flexibility of the relation between the records of the superior files.

Other types DBMS models which are possible data are related to more than one file, but only in restricted hierarchical proportions DBMS, which relate records from different files in a one-way, many-to-one tree structure. In such a relation there a number of levels of the functioning exists in those each 'child" record is only 'parent" and variables are consequently limited.

Another type of, network DBMS, is possible specific relation record. The possibility for record is related reduces the redundancy of data and makes it unnecessary for update several record when data a record changes related in.

A typical scenario of the relation between the data in two files the link of a record in an order resistant to the customer resistant on the basis of a single unique area, such as customer identification number.

The newest model is object-oriented database, in which entities the data are treated as abstract objects. Thus, the activities and functions are not on the database application dependent.

A database management system (DBMS) is a set of computer program's that creation, the maintenance controls, and the use of a database. It puts organizations able for the control of database development place in the hands of database administrators (DBA) and other specialists.

DBMS are a system software parcel which the use of incorporated collection of data confessed as databases helps documents and files. It leaves several user application programs' s for simple access to the same database. DBMS can use each a mixture database models, such as network model or relational model. In large systems, DBMS can users and other software for storing and picking up in a structured manner.

Instead of to the computer program's to write to obtain information, simple in query-talk can ask the user. Therefore many DBMS parcels offer program to fourth generation (4GL' s) and other application development functions. It helps the logical organization for a database and to give entrance and the information in a database. It offers facilities for regulating access to the data, the maintaining of the integrity of data, managing concurrency, and the convalescence of the database of backups. DBMS offer also to the possibility database information logically present to users.

2.4 Database Models:

A database model or database diagram is the structure or the format of a database, described in a formal language which is supported by database management system, in other words, 'database model 'the application of a data model is at use in combination with a database management system' ,

2.4.1 Network Model

The popularity of the network data model coincided with the popularity of the hierarchical data model. Some data were more naturally modeled with more than one parent per child. So, the network model permitted the modeling of many-to-many relationships in data. In 1971, the Conference on Data Systems Languages (CODASYL) formally defined the network model. The basic data modeling construct in the network model is the set construct. A set consists of an owner record type, a set name, and a member record type. A member record type can have that role in more than one set; hence the multi parent concept is supported. An owner record type can also be a member or owner in another set.

The data model is a simple network, and link and intersection record types (called junction records by (IDMS) may exist, as well as sets between them . Thus, the complete network of relationships is represented by several pairwise sets; in each set some (one) record type is owner (at the tail of the network arrow) and one or more record types are members (at the head of the relationship arrow). Usually, a set defines a 1:M relationship, although 1:1 is permitted. The CODASYL network model is based on mathematical set theory.

2.4.2 Relational Model

(RDBMS - relational database management system) A database based on the relational model developed by E.F. Codd. A relational database allows the definition of data structures, storage and retrieval operations and integrity constraints. In such a database the data and relations between them are organized in tables. A table is a collection of records and each record in a table contains the same fields.

There are some properties of Relational Tables: [3]

1) Values Are Atomic

2) Each Row is Unique

3) Column Values Are of the Same Kind

4) The Sequence of Columns is Insignificant

5) The Sequence of Rows is Insignificant

6) Each Column Has a Unique Name.

Certain fields may be designated as keys, which mean that searches for specific values of that field will use indexing to speed them up. Where fields in two different tables take values from the same set, a join operation can be performed to select related records in the two tables by matching values in those fields.

Often, but not always, the fields will have the same name in both tables. For example, an "orders" table might contain (customer-ID, product-code) pairs and a "products" table might contain (product-code, price) pairs so to calculate a given customer's bill you would sum the prices of all products ordered by that customer by joining on the product-code fields of the two tables. This can be extended to joining multiple tables on multiple fields. Because these relationships are only specified at retrieval time, relational databases are classed as dynamic database management system. The RELATIONAL database model is based on the Relational Algebra.

The relational model uses the basis concept of a relation or table. The columns or fields in the table identify of the attributes, such as name, age, and therefore. Tuple or row contains all data of a single copy of the table, such as a person Doug called. In the relational model, must each tuple have an unique identification number or key on the basis of the data. In this character, the social security account number (SSAN) the key is which identifies unique each tuple in the relation. Frequently its keys used to exclude identification data two or more relations on the basis of matching. The relational model contains also terms such as foreign keys, which loved in a relation which again in another link primary keys to keep with the accession the data. If an example of foreign keys is storing your mother and father SSAN in the tuple who you represent. Your parents SSANs are keys for the tuples which represent them and they are keys referring in the tuple that you represent. Figure 2.2 shows an example of the relational model

Figure 2.1: relational model

2.4.3 Object/Relational Mode

Object-relation the model has been devised a relational database management system that allows developers databases incorporate with their data types and methods give. It is really a relational model which users' permits object-oriented functions incorporate in.[4]

Advantage, Feature for Object/relational model:

' Extensibility - users are able the capacity of the database extend server, this can be done by defining patterns defined of new types data, as well as by the user. Because of this is possible the user to store and managing data. Complex types - users can define of new data types which one or more of the data at present existing to type to combine. [4]

' Complex types - support is more flexibility at organizing the data on a structure which exists from columns and tables.

' Inheritance - Users are able objects or type and tables which buy the properties of other objects to determine, as well as adding new properties which are specific for the object which is defined.

' A field is possible also an object with attributes and operations.

' Complex objects can be stored in relational tables.


2.4.4 Object-Oriented Model

Object DBMSs add database functionality to object programming languages. They bring much more than persistent storage of programming language objects. Object DBMSs extend the semantics of the C++, Smalltalk and Java object programming languages to provide full-featured database programming capability, while retaining native language compatibility. A major benefit of this approach is the unification of the application and database development into a seamless data model and language environment. As a result, applications require less code, use more natural data modeling, and code bases are easier to maintain. Object developers can write complete database applications with a modest amount of additional effort.[4]

According to Rao (1994), "The object-oriented database (OODB) paradigm is the combination of object-oriented programming language (OOPL) systems and persistent systems. The power of the OODB comes from the seamless treatment of both persistent data, as found in databases, and transient data, as found in executing programs."

In contrast to a relational DBMS where a complex data structure must be flattened out to fit into tables or joined together from those tables to form the in-memory structure, object DBMSs have no performance overhead to store or retrieve a web or hierarchy of interrelated objects. This one-to-one mapping of object programming language objects to database objects has two benefits over other storage approaches: it provides higher performance management of objects, and it enables better management of the complex interrelationships between objects. This makes object DBMSs better suited to support applications such as financial portfolio risk analysis systems, telecommunications service applications, World Wide Web document structures, design and manufacturing systems, and hospital patient record systems, which have complex relationships between data. [3]

2 Database Applications:

As soon as a database has been made, the DBMS can be used record which requires select the user on the basis of the information to that (yes or no taken) in their fields. For example at the use of an inventory database, the user can the availability of a product which to certain criteria? Uch meet this way style, color, and extra functions? Ach that is has been defined in the fields. An automated request can be done for a single, specific record or for several records. An example of a request foret several records in a customer file for all those customers whose invoices to have been expired.

The user, in this case, request record where the difference between the date of today and the date on which the invoice became is taken is sent, say more than 30 days, and in which the "date of payment receipt 'field empty is. Several DBMS offer several methods of introducing tasks or 'queries" to pick up information. The most attentive query commando format is Structured Query Language (SQL), for a large part because it makes possible with several users on a network with a database simultaneous access. Some DBMS offer commando to the choice of the query, by menu's, or for example forms. Besides picking up data, DBMS the user can sort data in the fields on all criteria. This can imply that all record in a database or, more practical, which meets certain selection criteria. For example, record can be selected from sale database of all salesmen which sold during a certain total amount in dollars, and that list can be sorted to the salesmen rank of the sold quantity. [2]

DBMS make software for generating several pressed or electronic reports of the selected data. Of the most going formats of a database a report is a table record with the shown selected fields, sorted on the basis of a list of. Data from individual files can be added also automatically to stencil key sets or empty fields of specific forms or attributes.

Moreover address labels can be made by printing the data of name and address fields. Some DBMS contain also extra software functions, such as spreadsheet and communication functions, as a result of which further manipulative of information picked up from the database.

Databases and DBMS are used on all types of computer systems, of which permitted for several users to a database simultaneously access a lot of. On mainframe and minicomputers/midrange systems, users access to the database by means of several terminals. DBMS are also always more often used for client server computer networks of personal computers or work stations, including by means of intranets using a web-browser interface. The database and the DBMS server software itself on a computer which acts as a server and the other copies of DBMS-software are on each of the client computers which are linked with the server. Finally databases distributed there, are, in which a database physical stored in two or more computers succeeded on several locations not yet in by a single DBMS by copies of the software on every location. [2]

Chapter Three: _

Design School Information System

3.1 Introduction:

To meet our needs in the project, some applications and approaches have been used in project design.

In the following topics we provided brief introduction about these applications and approaches, which may help to understand what has been implemented in the project.

3.2 Visual Basic

Using Visual Basic is the Quickest and easiest way to create powerful, full-featured applications that take advantage of the graphical user interface in Microsoft Windows. For companies developing custom applications Visual Basic reduces development time and cost intuitive interface makes Visual Basic an excellent tool for programmers. [6]

New users benefit from mouse operations and a consistent look and feel more advanced users benefit from ease-of-use features, such as drop-down list boxes and multiple-windows applications.

Visual Basic supports a number of features that make it an excellent language for quickly creating full-featured solutions, including the following:

3.2.1 Data access features

Data access features allow you to create databases, front-end applications, and scalable server-side components for most database formats, including Microsoft SQL Server and other enterprise-level databases.

3.2.2ActiveX technologies

ActiveX technologies allow you to use the functionality provided by other applications like Microsoft Word Processor, Microsoft Excel spreadsheet, and other Windows applications. You can even automate applications and objects created using the professional or enterprise edition of Visual Basic.

3.3 ER for School Information System

Figure 3.1 shows the school information system ER diagram. This is an entity relationship diagram (ERD) School Information System. An ERD is a model that identifies the concepts or entities that exist in a system and the relationships between those entities. It is neither a complete data model depicting every necessary relational database table, nor is it meant to be a proscriptive design for implementations of ERM systems.

Figure 3.1: ER diagram for School information system

3.4 Context Diagram:

Figure 3.2 shows the context diagram for the manual existing system used by al Bayan School.

Figure 3.2: the existing system used by al Bayan School

The context diagram for the proposed system is shown in figure 3.3

Figure 3.3: the proposed system for al Bayan School

3.5 System database schema:

The following figure shown the school information system database Schema which contains of 9 tables to store the data as described later. The names for the tables are Credentials, Department, Enrolment, school, Section, Staff, Student, Subject and User.

Figure 3.4: School Information System Database Schema

3.6 Al Bayan information system Database tables:

1. Student table:

Table 3.1 shown the student table attributes and the data type for each attribute

Table 3.1 student table

Attribute Type

Student ID Int

Name varchar

Credentials varchar

Remark varchar

Creation date decimal

Created by varchar

A description for each attribute is given below:

1. Student ID : Identification key for the student data and used as primary key for the table.

2. Name: Description the name for each student.

3. Credentials: Description the whole student mark.

4. Remark : any note in student Credential

5. Creation date: the date for when the data entry

6. Created by : name for who entry the data in this table

2. Department table:

Table 3.2 shown the department table attribute and the data type for each attribute

Table 3.2 department table

Attribute Type

Department ID Int

Department title varchar

A description for each attribute is given below:

1. Department ID: Identification Key For The department Data And Used As Primary Key For The Table

2. Department title

3. Enrolment table:

Table 3.3 shown the enrolment table attribute and the data type for each attribute

Table 3.3 enrolment table

Attribute Type

Enrolment ID Int

School Year varchar

Student ID Int

Student Name varchar

Sex decimal

Department ID Int

Department Title varchar

Sections decimal

Date Enrolled decimal

Creation Date varchar

Created By Varchar

A description for each attribute is given below:

1. Enrolment ID: Identification Key For The registration Data And Used As Primary Key For The Table

2. School Year

3. Student ID: Identification for each student.

4. Student Name:

5. Sex: type of student sex, male or female

6. Department ID: Identification key for the department

7. Department Title

8. Sections

9. Date Enrolled

10. Creation Date: the date for when the data entry

11. Created By: name for who entry the data in this table

4. Section table:

Table 3.4 shown the section table attributes and the data type for each attribute

Table 3.4 section table

Attribute Type

Section ID Int

Section Title varchar

Description varchar

Department ID Int

Department Title varchar

Year level decimal

Creation Date decimal

Created By varchar

A description for each attribute is given below:

1. Section ID: Identification Key For The section Data And Used As Primary Key For The Table

2. Section Title: the name for the section

3. Description: describe the section type

4. Department ID: Identification key for the department

5. Department Title

6. Year level : the level year for the section

7. Creation Date: : the date for when the data entry

8. Created By: name for who entry the data in this table

5. Staff table:

Table 3.5 shown the staff table attribute and the data type for each attribute

Table 3.5 staff table

Attribute Type

Staff ID Int

Name varcher

Sex varcher

Age Int

Address varchar

Phone varchar

Qualification Int

NOKName1 Int

Address1 varchar

phone1 decimal

NOKName2 int

Address2 Int

Phone2 varchar

Creation Date varchar

Created By decimal

A description for each attribute is given below:

1. Staff ID: Identification Key For The staff Data And Used As Primary Key For The Table

2. Name: description name for each staff member

3. Sex: type of staff sex, male or female

4. Age: description for the staff age

5. Address: address of the staff

6. Phone : telephone number for each school

7. Qualification: describe the level for the Qualification range for the staff member

8. NOKName

9. Address1

10. phone1

11. NOKName2

12. Address2

13. Phone2

14. Creation Date: : the date for when the data entry

15. Created By: name for who entry the data in this table

6. Username table:

Table 3.6 shown the username table attributes and the data type for each attribute

Table 3.6 Username table

Attribute Type

User Name Int

Password Decimal

Full Name Varchar

User Type Varchar

Creation Date Decimal

Created By varchar

A description for each attribute is given below:

1. User Name: Identification Key For The username Data And Used As Primary Key For The Table

2. Password : the username password to allowance for entry the system

3. Full Name : the actual name for the owner for the username

4. User Type : the type of user if student, administrator or staff member.

5. Creation Date: : the date for when the data entry

6. Created By: name for who entry the data in this table

7. User table:

Table 3.7 shown the user table attribute and the data type for each attribute

Table 3.7 user table

Attribute Type

School Year Int

ID Int

First name varchar

Middle name varchar

Last name varchar

Home address varchar

City varchar

State varchar

Gender decimal

Stats decimal

Religion decimal

Nationality decimal

Birth Date varchar

Birth Place varchar

Last SchName varchar

Old Ave Grade varchar

Transferee decimal

Ransfereelevel varchar

Guardian Name varchar

Creation Date decimal

Created By varchar

A description for each attribute is given below:

1. School Year: the year level for the school

2. ID: Identification Key For The school user Data And Used As Primary Key For The Table

3. First name: first user name for each one.

4. Middle name: middle user name for each one.

5. Last name: last user name for each one.

6. Home address : user address for each one.

7. City

8. State

9. Gender : type of staff sex, male or female

10. Stats: The social situation of each user

11. Religion: Type of religion espoused for each user

12. Nationality:

13. Birth Date: the date for birth for each user

14. Birth Place: the birth place for each user

15. Last SchName: identify the last school name for the user.

16. Old Ave Grade: the last average grade for each student for what they got during the school day.

17. Transferee:

18. Ransfereelevel

19. Guardian Name: the Responsible for each student

20. Creation Date: : the date for when the data entry

21. Created By: name for who entry the data in this table

8. Subject table

Table 3.8 shown the subject table attribute and the data type for each attribute

Table 3.8 subject table

Attribute Type

Subject ID Int

Subject Title varchar

Department ID Int

Department Title varchar

Year level varchar

Section varchar

Creation Date decimal

Created By varchar

A description for each attribute is given below:

1. Subject ID: Identification Key For The subject Data And Used As Primary Key For The Table

2. Subject Title: identification the subject title

3. Department ID: identification department key for which subject refer to

4. Department Title: the name for the department where the subject refer to

5. Year level: Grade level to which it belong topic.

6. Section :identify the section name for where the subject refer to

7. Creation Date: : the date for when the data entry

8. Created By: name for who entry the data in this table

3.7 Use Case diagram

The use case diagram is used to identify the primary elements and processes that form the system. The primary elements are termed as "actors" and the processes are called "use cases." The use case diagram shows which actors interact with each use case. Use case diagrams of School Information system are used to view a system from this perspective as a set of discrete activities or transactions.

Figure 3.5 Use Case Diagram

As shown in Figure 3.5 There is one system user (actor); administrator, and there are many functions can be applied by him.

Chapter Four: _

System Implementation

4.3 Introduction

4.4 Al Bayan International School System Interfaces:

It made the user interface easier to handle, and clear for them. In the next Figures we will explain most of project interface and usage methods.

? In Figure 4.1, when open the system the security check window will appear.

The user must fill username and password and click login, Then the system will show the time, to inform the user about the time of entry to the system, If any mistake when entry the information, an error massage will appear to inform the user about the error.

Figure 4.1: The user interface

? In Figure 4.2, the screen shows two major bars:

A. Side bar: include two parts :

1. Shortcut menu refer to the most application usage in toolbar menu.

2. Explorer menu which have some applications related to the computer operating system like calculator.

The staff management only shown in side bar.

B. Toolbar menu: includes all applications usage in system. as show in figure 4.3.

Figure 4.2: Side bar menu

Figure 4.3: Toolbar menu

? In next figures we will describe the Toolbar application and how to use it.The toolbar menu contains 5 options :

1. Main

2. User

3. Admission

4. School

5. Settings

1. In main option there is only the Exit function used to go out from the system as show in Figure 4.4 :

Figure 4.4: main application and Exit function

2. In user option as show in (Figure 4.5) there are two functions:

? Add New Entry as shown in (Figure 4.6) this function used by the teachers.

? View All Users as shown in (Figure 4.7) this function only used by the teachers

Figure 4.5: User application

Figure 4.6: Add New Entry Function in User application

Figure 4.7: View All User Record Function in User menu

3. Admission application as show in (Figure 4.8)

Figure 4.8: Admission application

There are three functions in admission application:

a. Student Information with three subtitle:

? Add new student, with automatic ID generation. As shown in Figure 4.9 and Figure 4.10.

Figure 4.9: Automatic ID generation

Figure 4.10: Add new student.

All information to fill it by administration user, and then when complete the entry by the administration user, they have to press the second button to save the data.

? Edit student entries function by choosing the ID from the criteria option, then all data it will show in the screen. After edit the needed information, click update as shown in Figure 4.11.

Figure 4.11: Edit student entries

On the same way for entry new data we can edit what we fill it before by using the edit student entry, this option can used by the admission only

? Delete student entries: to delete any entry data only we can choose the student ID.

Figure 4.12: Delete Student Record

b. Search function, for rapid ID or name searching as show in (Figure 4.13):

This search option can be used in many ways, by select the student Id or his first, middle, or last name.

Figure 4.13: Search Function

c. Student Credentials with two subtitle as show in (Figure 4.14)

? Add Credentials. As show in (Figure 4.15)

? View Credentials. As show in (Figure 4.16)

Figure 4.14: Student Credentials

Figure 4.15: Add Credentials Function

To add any student credit we can select the credentials option, then choose the student ID who we want to add any subject marks for him.

Figure 4.16: View Credentials Function

Some time we want the whole credits for one student, we can do that by choosing the View Credentials Function. By select the student ID then press the show icon.

4. School options as show in (Figure 4.17) with 3 main functions:

a. school information as show in (Figure 4.18)

Al-Bayan school information can get by choosing the school information, only the

edit option can use by the admission

b. Department with 3 subtitles:

? Add Department as show in (Figure 4.19)

? Delete Department as show in (Figure 4.20)

? View Department as show in (Figure 4.21)

Figure 4.17: School application

Figure 4.18: School information

Figure 4.19: Add Department

If we need to add new department, we can use add departments option, then fill the ID and Title for new department.

Figure 4.20: Delete Department

To delete any department we can select from the toolbar >school> Department> delete department.

Figure 4.21: View Department

View departments option allows seeing all departments which the system saves before.

c. Subject with Add subject Function as shown in (Figure 4.22)

Figure 4.22: Subject application

5. Setting Application with 3 main function as show in (Figure 4.23):

a. Backup Database: to save exist data in one file as backup, if any loss of data suddenly happened.

Figure 4.23: Setting application

b. Change Password as show in (Figure 4.24)

Figure 4.24: change password function

Change password option very useful for all users, this password can change by entry the username > old password> entry new password > re-enter the new password > ok,

To save the entry data.

c. Log Off function: to log out from the system as show in (Figure 4.25)

Figure 4.25: Log off function

Finally if the user to come out from the system and keep the system running for another coming user, by select the Log off option. The option is not like the exit option because the exit means shutdown the whole system.

Chapter Five: _


5.3 Conclusion

The need to develop a system is a must for any school in today's technologically driven world, where everything is done over the computer ' whether to buy products or to check company profiles. There for the proposed system was designed and develop, the entire software was found to be technically, operationally and economically feasible.

Due to the use of simple Microsoft technologies such as visual basic 6.0, the programmer can modify or update the contents of site with ease in the future. The designed system has a touch of creativity with simple navigation process, where users can easily view they require. The contents of the page were kept simple, as this system will be used to enhance AlBaian school capabilities in terms of computer technology.

5.4 Future work