Online Enrollment and Administration System

1. Introduction

The need for powerful and flexible data management systems is increasing in science,

engineering, business and the personnel fields. The success of an organization depends on

its ability to acquire accurate and timely data about its operation, to manage this data

effectively, and to use it to analyze its own activities. In our final year project, a web-based

course enrollment system for The Chinese YMCA of Hong Kong will be implemented to

manage a vast amount of data, and to answer a given query with the relevant information in

as little time as possible. The system is built by applying the techniques of Internet

programming, database design and database management.

The objective and purpose of the Course Enrollment System is to provide real-time

registration for the members and relevant reports for staff. It helps the staff in the YMCA to

input and retrieve data in a more efficient way and the members can do registration of any

course or programme in the nearest YMCA centre. The system is also flexible because the

user only needs to make a connection with the Internet and use the web browser to access

the system server to use the Course Enrollment System.

We studied some materials during the summer vacation to prepare for this project. We

mainly searched for web sites that provided the syntax of the programming languages

including ASP (Active Server Page), JSP (Java Server Page), DHTML (Dynamic HyperText

Markup Language) and PHP (Personal Homepage Programming, Hypertext Preprocessor).

One of the web sites is www.php.net. This web site provides the functions and syntax of

PHP for reference. Another web site is www.mysql.com, which provides the usage of the

MySQL Server. We also found some books for reference. The Core PHP Programming by

Leon Atkinson presents the techniques and issues in using PHP. Database Management

Systems by Raghu Ramkrishnan and Johannes Gehrke presents the database management

skill and design to produce...