ABSTRACT
This project title is written to help universities, polytechnics especially Ken Saro-Wiwa Polytechnic, Bori to improve in their information system. Also to make sure that customer/Students receive a personal attention, the front-office officer calling Student day by day to remind them of their registration and payment regularly. This routine was done by phone, called Maintenance Reminder system (MRS) but this process is considered costly and takes much time. In this paper, I will propose new model to remind student/customer the opportunity of utilizing short message service. By using the proposed model, the service provider company gained cost effectiveness and increase time efficiency. According to the result, using short message service (SMS) system can remind 5-10 Student/customers to check or maintain their record within a minute more efficient compared to calling the student one-by-one.
In this work I used Microsoft Access for Database, Visual Basic and MS Front-page for registration of students.
TABLE OF CONTENTS
COVER PAGE —————————————————————————- i
TITLE PAGE —————————————————————————— ii
DECLARATION ————————————————————————– iii
CERTIFICATION ————————————————————————- iv
DEDICATION —————————————————————————– v
ACKNOWLEDGEMENT —————————————————————- vi
ABSTRACT ——————————————————————————– vii
TABLE OF CONTENTS —————————————————————– viii-ix
LIST OF FIGURES ———————————————————————–x
CHAPTER ONE
INTRODUCTION
- Introduction ———————————————————————- 1-2
- Background of the study ——————————————————- 2-3
- Purpose of the study ———————————————————— 3-4
- The significance of the study ————————————————– 4-5
- Scope of the study ————————————————————— 5
- Aim/objectives of the study —————————————————- 6
- Limitations of Short Message Service ————————————— 6
- Definition of terms —————————————————————7-8
CHAPTER TWO
LITERATURE REVIEW
2.1 Introduction ———————————————————————- 9
2.2 Studies of existing system —————————————————– 9-11
2.2.1 UKLM mail delivery system ———————————————— 9-11
2.2.2 Library SMS notification service, Monash University ——————11
2.3 SRRUS technique and tools —————————————————-12-13
2.3.1 Microsoft Visual Basic 6.0 —————————————————12
2.3.2 Microsoft Access 2000 ——————————————————-12
2.3.3 Global System Mobile (GSM) modem ————————————-13
CHAPTER THREE
METHODOLOGY
3.1 Introduction ———————————————————————14-16 3.2.0 Requirement planning phase ————————————————– 16-17
3.2.1 System analysis and design phase ——————————————-17-18
3.2.2 Implementation phase ———————————————————-18
3.3 Project requirement ————————————————————— 19-21
3.4 Testing phase ———————————————————————- 22-23
CHAPTER FOUR
SYSTEM IMPLEMENTATION, TESTING AND INTEGRATION
4.1 Introduction —————————————————————————24
4.2 Development of interface —————————————————— 24-26
4.3 Database Architecture ———————————————————– 27
4.4 Development of system ———————————————————28-29
4.5 Program source codes ———————————————————– 30-34
4.5.1 GPA calculator code ———————————————————- 30-34
4.5.2 Registration form1 code —————————————————— 34
4.5.3 Registration form2 code —————————————————— 34-35
4.5.4 SRRUS interface code ——————————————————– 35
4.5.5 SRRUS portal interface code ———————————————— 35-41
4.6 Flowchart ————————————————————————-42
CHAPTER FIVE
CONCLUSION AND RECOMMENDATION
5.1 Conclusion ———————————————————————– 43
5.2 Recommendation ————————————————————— 45
REFERENCE ——————————————————————- 45-46
LIST OF FIGURES
Figure2.1 Mail delivery system in UKLM ————————————————— 10
Figure3.0 System process modes ————————————————————– 14
Figure3.1 Incremental models —————————————————————– 15
Figure3.2 System module ———————————————————————- 21
Figure3.3 Increment development cycle —————————————————–22
Figure4.1 Homepage interface —————————————————————–24
Figure4.2 GPA Calculator ———————————————————————- 25
Figure4.3 Registration portal ——————————————————————-25
Figure4.3.1 Registration form1 —————————————————————-26
Figure4.3.2 Registration form2 —————————————————————-26
Figure4.4.1 The Database ———————————————————————-27
Figure4.4.2 The Database ———————————————————————-27
Figure4.4.3 The Database ———————————————————————-27
Figure4.5 SRRUS portal ————————————————————————28
Figure4.6 SRRUS interface form ————————————————————-28
Figure4.7 Database foe SRRUS —————————————————————29
Figure4.8Flowchart ————————————————————————–51
CHAPTER ONE
1.0 INTRODUCTION
Since the earlier stages of using technology, the inventors and scientist were always trying to create method and develop techniques in order to achieve the most flexible and easiest way of life for humanity. People always want to be in control. They need real time information whenever they need. With the advance of technology, mobile phone was introduced with the ability of notifying someone via SMS.
SMS appeared on the wireless scene in 1991 in Europe, where digital wireless technology first took hold. The European standard for digital Wireless, now known as the global standard for mobiles (GSM), included short messaging services from the outset.
In North America, SMS was initially made available on digital wireless networks, built by early pioneers such as BellSouth Mobility and Nextel. In 1998, as the build out of PCS networks based on GSM, code division multiple access (CDMA), and time division multiple access (TDMA) methods is completed, SMS is expected to enjoy full-fledged deployment.
The point-to-point SMS provides a mechanism for transmitting “short” messages to and from wireless handsets. The service makes use of a short message service center (SMSC) which acts as a store and forward system for short messages. The wireless network provides for the transport of short messages between the SMSCs and wireless handsets. In contrast to existing text message transmission services, such as alphanumeric paging, the service elements are designed to provide guaranteed delivery of text messages to the destination.
A distinguishing characteristic of the service is that an active mobile handset is able to receive or submit a short message at any time, independent of whether or not a voice or data call is in progress. SMS also guarantees delivery of the short message by the network. Temporary failures are identified, and the short message is stored in the network until the destination becomes available. SMS is characterized by out-of-band packet delivery and low-bandwidth message transfer. Initial applications of SMS focused on eliminating alphanumeric pagers by permitting two way general purpose messaging and notification services, primarily for voice mail. As technology and networks matured, a variety of services were introduced, including electronic mail and fax integration, paging integration, interactive banking, and information services such as stock quotes.
