DESIGN AND IMPLEMENTATION OF COURSE REGISTRATION AND RESULT PROCESSING SYSTEM
TABLE OF CONTENTCover pageTitle pageCertificationApproval pageDedicationAcknowledgementList of TableList of FiguresAbstractChapter One: INTRODUCTION1.1 Background of the Study1.2 Statement of the Problem1.2.1 Solution1.3 Objectives of the Study1.4 Significances of the Study1.5 Scope of the Study1.6 Limitations of the Study1.7 Definition of Terms/VariablesChapter Two: Literature Review2.1 the concept of computer systems2.2 relevance of computer system in data processing2.3 problems associated with data processing2.4 formats of result 2.5 the features of result processing 2.6 computer systems and result processing2.7 types of result processing2.8 the basic features of result processing2.9 factors determining the methods of result processing2.10 result processing stages2.11 modes of result processing 2.12 result transmission2.13 centralised result processing2.14 decentralised result processing2.15 distributed result processing systemChapter Three: Research Methodology and System Analysis3.1 Research Design3.1.1 Sources of Data3.2 Analysis of the Existing System3.3 Advantages and Disadvantages of the Existing System3.3.1 Advantages of the Existing System3.3.2 Disadvantages of the Existing System3.4 Analysis of the New System3.4.1 Online Application Form3.4.2 Form Validation3.4.3 Database3.4.4 Job Advert Page3.4.5 How the Site is Run3.5 Advantages and Disadvantages of the New System3.5.1 Advantages of the New System3.5.2 Disadvantages of the New System3.6 Justification of the New SystemChapter Four: Design, Implementation and Testing of the New System4.1 Object of the Design4.2 Input and Output Specification4.3 Input and Output Format4.4 System Flowchart4.5 Overall Data Flow Diagram4.6 System Implementation4.7 System Documentation4.8 Testing and Integration4.9 User Guide4.10 Choice of Programming Language4.11 Software Testing and Integration4.11.1 The Test Plan4.11.2 System Testing4.11.3 Main System Driven Testing4.11.4 Database Testing4.12 Performance Evaluation/Cost AnalysisChapter Five: Summary, Recommendation and Conclusion5.1 Summary5.2 Problem Encountered and Solutions5.3 Suggestions for further Improvements5.4 Recommendation5.5 ConclusionBibliographyAppendix :Appendix 1; source codeAppendix 2; Application formAppendix 3 ; A Typical report form for the systemAppendix 4; Site definition in DreamweaverCHAPTER ONE1.0 INTRODUCTION1.1 BACKGROUND OF THE STUDYCaritas University, Amorji Nike, Enugu, is a private University approved by the Federal Government of Nigeria on December 16 2004. It was officially opened on January 21, 2005 by the Federal Ministry for Education, Prof. Fabian Osuji. The formal opening was on January 31, 2005. The pioneer students of 250 matriculated on May 28, 2005 in beautiful ceremony that attracted dignitaries both church and state. It is the second Catholic University in Nigeria founded by Rev. Fr. Prof. Emmanuel Paul Mathew EdehCssp, OFR. Although he founded the school, the proprietor of the University is the Congregation of Sisters the Saviour, a religious Congregation of Nuns founded by him.The vision of Caritas University is to rescue some of our wandering and teaming youths from further slide into academic and moral decay, and development and transformation of our society through sound and adulterated education. Its mission is to discover, sanctify and apply the knowledge of science, environmental and engineering for human well-being and sound development of man for better society.Caritas University’s goal is to give efficacy to the University’s motto and to its philosophy of education. We embrace not only sound education for professional skills and competency in various fields; but also maintain strict discipline. We train the mind, body, soul and spirit in the exercise of obedience and self control. The students must not only be intellectually and professionally prepared for different tasks and roles in the world, they must also be morally equipped to face the world itself with all its tensions, conflicts, challenges and contradictions. We achieve this with the help of God Almighty who is with us always.The philosophy is to promote sound education for professional skills and competencies in various fields with strict discipline. By discipline the University meant the training of the mind, body and soul and spirit to obedience and self control. Also to prepare the students to be intellectually and professionally sound for different tasks and roles in the word with its tensions, conflicts, challenges and contradictions.The University operates faculty system. Presently, the University operates six faculties: Education and Arts, Engineering, Environmental Sciences, Management, Social Sciences and Natural Sciences.1.2 DEFINITIONA Computer-Based Result Management Information System (CBRMIS) is a set of software programs that is designed to control the institution’s (practically using CARITAS UNIVERSITY), storage, management, and retrieval of data (RESULT) in a database. CBRMISs are categorized according to their data structures or types. The CBRMIS accepts requests for data from an application program and instructs the operating system to transfer the appropriate data. The queries and responses must be submitted and received according to a format that conforms to one or more applicable protocols. When a CBRMIS is used, information systems can be changed much more easily as the organization's information requirements change. Use of manual imputation of result is discarded and new categories of data can be added to the database so easily without disruption to the existing system.A database management system provides the ability for many different users to share data and process resources. But as there can be many different users, there are many different database needs. The question now is: How can a single, unified database meet the differing requirement of so many users?As this study entails using a different form of database management in connection with organizational result computation and assessment. This brings about the use of computer-based result management information system (CBRMIS).Before the database management approach, the institution relied on the manual method of data processing and storage. Each file was specialized to be used with a specific application. Needless to say, file processing was bulky, costly and nonflexible when it came to supplying needed data accurately and promptly.This study therefore, examines clearly the effect of the computer-based result management information system (CBRMIS) towards the development of CARITAS UNIVERSITY.1.3 OBJECTIVES OF THE STUDYSince this study is specifically to use the physical view to make efficient use of storage and processing resources, therefore, the objective of this study includes the following;1. To help in facilitating generation of ad hoc query.2. To ensure reliability and transparency in the creation and computation of results3. To present a platform for assessment of the performance of the students and workers in other to help develop enabling policy for academic quality and standard.4. To prevent unauthorized access or mutilation of the results of the students thereby maintaining data integrity.5. To help the users of the result database software (RDS) to manage the overall database environment by providing facilities for backup and recovery, security management, query optimization, concurrency control, and change management.1.4 SIGNIFICANCE OF THE STUDYThe significance of this study is to examine closely the advantage of this result application to the benefit of Caritas University and the entire community.1. It will serve as a reference material to those who use this project material.2. It is a contribution to knowledge3. It will provide information to other researchers/developers on how best and beneficial the use of a management information system can be in providing accurate information for an organization’s decision making.4. It will ensure high level quality service development of the management which will ensure that students are not subjected to undue suffering in collection of their transcript or clearance prior to the deployment for youth service.1.5 SCOPE OF THE STUDYThe scope of this study is an integrated study on the use of a Computer-based Result Management Information System (CBRMIS) a case of Caritas University.1.6 LIMITATIONS OF THE STUDYRealizing the financial and time constraints usually associated with students in project of this nature, there is no research carried out that does not experience some difficulties. This work is no exception; the following factors posed serious limitations to the research work.Financial constraints: a study like this nature is expected to be carried out on a broader base but because of lack of funds required, some function and programs could not be applied.Time constraint: in the course of the study, time posed a serious problem in carrying out the test. The duration given for the conduct of this study was short.Non-availability of materials: during the course of this research, there were non-availability of some critical documents and materials which were classified as confidential.Non-availability of Exit: because of the nature of the school as a private university, Permission to go out was not always granted and this posed a serious problem towards the actualization of this goal.1.7 DEFINITION OF TERMS/VARIABLESManagement: Management is a human action, including design, to facilitateThe production of useful outcomes from a system.Processing: To deal with somebody or something according to an established Procedure.System: a set of computer components i.e. in assembly of Computer hardware, Software and peripherals functioning together.Automation: the replacement of human workers by technology; a system in which a workplace or processes has been converted to one that replaced or ministries human labour with electronic or mechanical equipment.Information: Data that has been worked upon and processed.Database: a systematically arranged collection of data, designed so that it can be automatically retrieved or manipulatedeasily by authorized users.Database servers: Database servers are computers that hold the actual databases and run only the DBMS and related software.Data structure:Data structures (fields, records, files and objects) optimized to deal with very large amounts of data stored on a permanentdata storage device (which implies relatively slow access compared to volatile main memory).Data security:Data security prevents unauthorized users from viewing or updating the database by the use of passwords.Data consistency: Data consistency ensures a consistent view of data to every user. Password: this is a secret code that a user must type into a computer to enable He/she access it or its applications. This is made up of numbers, letters, characters or contribution of any of the above categories.PHP: Hypertext Preprocessor (the name is a recursive acronym) This is a Programming language known as a server-side scripting language. It was used in the developing of this software.Query language: A database query language and report writer allows usersto interactively interrogate the database, analyze its data and update it according to the user’s privileges on data. It also controls the security of the database.Software: a software is a collection of written programs which directs the computer on what to do.Querying: Querying is the process of requesting attribute information from various perspectives and combinations of factors.Modules: this is an independent/self- contained program.SQL: Structured Query Language, it is a code used to query or insert records in aDatabase..