Sms Based Result Checking System For Faculty Of Science

CHAPTER FOUR
SYSTEM DESIGN AND IMPLEMENTATION
4.1    Objective of Design
To demonstrate and prove that the 3rd generation access techniques result in equal and better end-user access experiences as compared to the existing 2nd generation approaches.
4.2    Database Design
The developed system has two databases; OzomaSMS and Examination result.
OzomaSMS database records all messages that are received and sent by the OzomaSMS software. It has one table, inbox to store all incoming messages. If SMS message is received, OzomaSMS will interact with the SQL script that has been defined in the system application program. The message and the sender’s mobile number are extracted from the SMS. This is the information that will be inserted into the inbox table. The SMS is inserted into the hp field. This information will then be passed to the system application programs for further processes.

Fig. 4.1 shows the OzomaSMS database design. On the other hand, another database namely: Examination Result, stores the student’s exams result. It is used by the system in information validation and retrieval processes. There are three tables in this database; course, student id (matric number), exam id(course code), semester and name.
The data extracted from the SMS sent by users are compared to the students’ data in the student table in order to retrieve the matched results.
The course table on the other hand stores data for each course offered by the Faculty of Science; details for each course are stored in this table such as course code, description and credit hour.
Finally, the Result table stores each student’s examination result. Each student’s examination result comprises of the following information: student’s id, course taken for the respective semester, course description, grade of each course, credit hours, etc.
This table is correlated with the course and student tables since it contains the courses taken by each student and the student’s ids as its primary key