Аннотация
INTRODUCTION 7
1. THE ANALYSIS OF THE SUBJECT AREA 10
1.1. The problem domain 10
1.2. The best current web development technologies 10
1.3. Technology used to develop the project (software requirement) 12
1.4. My SQL 12
1.5. PHP 13
1.6. HTML 14
1.7. Database management system 15
1.8. Cost Effectiveness for develop the application 17
2. DESIGN OF MANAGEMENT INFORMATION SYSTEM FOR
UNIVERSITY OF BASRAH 18
2.1. Functional requirements 18
2.2. Non-functional requirements 19
2.3. Use case diagram for design system functions requirement 19
2.4. Database scheme design 21
2.5. Interface design 26
3. IMPLEMENTATION OF MANAGEMENT SYSTEM FOR
REGISTRATION DEPARTMENT OF UNIVERSITY OF BASRAH 36
3.1. Several fragments of PHP-code for implementing the basic functionality . 36
3.2. Deployment diagram for web application 40
4. TESTING OF THE WEB APPLICATION 42
REFERENCES 48
Actuality
Education system forms the backbone of every nation. It is important to provide a strong educational foundation to the young generation to ensure the development of open-minded global citizens securing the future for everyone. Advanced technology available today can play a crucial role in streamlining education related processes to promote solidarity among students, Professors and the university staff.
Automation is the utilization of technology to replace human with a machine that can perform more quickly and more continuously. By automating documents that took up many large storage rooms can be stored on few disks. Transcript images can be annotated. It reduces the time to retrieve old transcripts from hours to seconds [17], and it reduce the waste of money and effort in this area, And thus we get more accurate results, to manage our educational institutions.
Databases form the common component of many software systems, including mission critical transaction processing systems and multitier Internet applications [14].
Databases (DB) are used to store collections of related data. Database management Systems (DBMS) are the underlying runtime environment for a database. A DBMS Provides a high-level language to define the structure of the data; known as the data definition language (DDL). In addition, DBMS have high-level languages to access and modify data in the database; this is the data manipulation language (DML). The Standard DML is the Structured Query Language (SQL), which is based on relational calculus [16]. Database access entails either: a request for data, i.e. a SQL SELECT statement or a modification of the data, i.e. SQL INSERT, UPDATE or DELETE statements. Programs that access the database are called transactions and are written in a data manipulation language such as SQL or in a procedural language with SQL extensions. Transactions are executed by the DBMS as one atomic unit.
Database designers are assigned the task of transforming an enterprise’s data from its external representation in the real world to a representation that can be stored in the database. The first step in this transformation is the conceptual data model of the database. The conceptual data model represents real-world data using the entity relationship (E-R) model or UML class diagrams, [14].
At this stage, the data is represented as entities with attributes. In addition, relations between the different entities are represented
At the beginning of development of this system, I used PHP with My SQL server to manage the database of the University of Basra.
At this report, we will create application by PHP programming.
PHP is that it can interact with many different database languages including MySQL. We work with MySQL so it makes sense to use PHP. Both PHP and MySQL are compatible with an App server which is also free to license.
PHP is an "HTML-embedded scripting language" primarily used for dynamic Web applications PHP was written in the C programming language by Rasmus Lerdorf in 1994 for use in monitoring his online resume and related personal information. For this reason, PHP originally stood for "Personal Home Page", [12].
Research goal and objectives
The goal of the research is create an application to manage student's information in the registration department of University of Basra.
In order to attain the general objective, the following list of specific objectives is set.
1. Install and use PHP and MY SQL Server.
2. Analyze the subject area.
3. Analyze of modern tools that used for development web application and choose tools for project development.
4. Design the system functional requirement by using usecase diagram.
5. Design database scheme.
6. Implement the system (code).
7. Perform the testing of the system.
The practical significance
This project is beneficial to university of Basra because intended to help the registration department in order to obtain effective information about the university.
1. Each user register has the ability to view the information both according to their location.
2. Easily dealing with the site for its friendly user Interface design that characterized by simplicity, consistency and use common elements.
3. Unlimited number of users could access the application.
4. Ensuring that there is no repetition when display grades in the sense (of the same subject and same course).
5. Ability for the following development of the web application.
Structure of the thesis
The thesis comprises of four chapters, introduction, conclusion and reference list.
In chapter, one, the problem domain, the best current web development technology, technology used to develop project (software requirement), database management system, and cost effectiveness for develop the application.
In chapter, two, there is a description of functional requirements, use case diagram, database scheme and the design the application interfaces.
In chapter, Three, we show the project solution, several fragments of PHP-code for implementing the basic functionality and deployment diagram for the system.
Chapter Four is devoted to the functional testing of the application.
For the management of large database of university you must use application has a high potential in the management of these data to provide precise management and high secrecy of these data. I think MY SQL server currently owns better specifications, because it has a large capacity and services are very good in data security and data management.
I offer an application that provides a help to the University of Basra because it has a high capacity to manage student data by using MY SQL server, where stored the data in server, through six tables and linked those tables by relationships. The application is used by four levels for user, for each level has authorities Specific.
At the end of this project, I have some recommendations. University of Basra play an important role in the development of society. Using of modern technology at the University of Basra, it affects positively on the performance of the university administration. Therefore, I recommend linking all the administrative units working at the University of Basra with SQL server. It will reduce the time spent on the completion of administrative transactions, and improve productivity of administrative work.
