Design And Implementation Of An Academic Information System Using Relational Database And HTTP Server

Project and Seminar Material for Computer Science and Computer Engineering

Project and Seminar Material for Computer Science and Computer Engineering


Abstract


In our today activities, most people have some kind of “database” collections of CDs, students’ academic entries, a phonebook of phone numbers and name entries, vehicles parts, records to be processed by a program. With a bit more precision, the term database means a logically coherent collection of related data with inherent meaning, built for a certain application and representing a “mini-word”. A database management system (DBMS) is the software that allows database to be defined, constructed, and manipulated. Developing HTTP and RDBMS information service for federal polytechnic Nekede, owerri was the core of this project work. The integration which implemented, project the strength of the institution, provided most level of functionality and reduced the hitherto duplication of data so often the case with student particulars and the resultant stressful situation which the academic staff face in record manipulation.

In considering the design of a web driven relational database management system; it is obvious that RDBMS succeed to a very large extent which depends on the level of data structure while structure itself depends on the level of reliability, which can be achieved through the kind of tables and web interface to be rendered, and the requirements needed. It is my convictions that a closer look at this project work give insight and vital information to any interested person who wish to know the requirement for developing a HTTP and a relational database management system server to effectively implement an academic information system. The design has demonstrated its HTML web pages integration via ASP.NET programming by demystifying and defining what it takes to implement an Internet information service, HTTP server, a MsSQL relational database management system and a ASP.NET web pages.


Table of Contents


Preliminary Page(s)

  • Title Page
  • Declaration
  • Approval
  • Dedication
  • Acknowledgement
  • Abstract
  • Table of Content

Chapter One

  • 1.1 Introduction
  • 1.2 Background of study
  • 1.3 Statement of the problem
  • 1.4 Objective of the study
  • 1.5 Significance of the study
  • 1.6 Scope and limitation of the study
  • 1.7 Definition of terms

Chapter Two

  • 2.1 Review of related literature
  • 2.2 Data and information
  • 2.3 Database model
  • 2.4 Data relation and keys
  • 2.5 Entity and integrity constraints
  • 2.6 Data normalization
  • 2.7 Local network and internet

Chapter Three

  • 3.1 Brief description and analysis of the existing
  • 3.2 Data collection method
  • 3.3 Input process output form analysis
  • 3.4 Problems of the exist system
  • 3.5 Justification for the new system
  • 3.6 System design
  • 3.7 File design
  • 3.8 Database implementation
  • 3.8.1 Software requirement
  • 3.8.2 Hardware requirement
  • 3.9 Education and training

Chapter Four

  • 4.1 Implementation
  • 4.1.1 Coding
  • 4.2 Program testing and debugging
  • 4.3 Changeover procedure
  • 4.4 Documentation

Chapter Five

  • 5.1 Recommendation
  • 5.1.1 Areas of further improvement
  • 5.2 Conclusion
  • References
  • Appendix I
  • Appendix II

Chapter One


1.1 Introduction

There is an outgrowing need for electronic accessories in a world where there is great necessity for speed, efficiency and perfection of work. Information factors efficiency, access to electronic device and relevant information is usually considered in the setting up of a relational database for a local network intranet. The internet has revolutionized the computer and communications world like nothing before. The invention of the telegraph, telephone radio and computer, set the stage for unprecedented integration of capabilities. The intranet is at once a location-based broadcasting capability, a mechanism for information disseminating and a medium for collaboration and interaction between individuals and their computers without regard for extensive location.

Presently, the internet represents one of the most successful examples of the benefits of sustained investment and commitment to research and development of information infrastructure. Starting with the early research in pocket switching, the government, industry and academic have been partners in evolving and developing this existing new technology. Terms like “http:www.yahoo.com” and “Uktehamum Edu” trip off the lounge of the random person on the street.

The aim of this project is to give an introduction to database and its integration with HTTP server. Before the specifics and theoretical, lets focus on some of the more generic aspects of this study.


1.2 Background of the Study

Information handling has gone beyond papers and is now at the discretion of the PC. Thus, this project is a conceivable effort to ameliorate the pressing need for a more web centric environment. Although its primary focus is not on web site design, yet it is inevitable. Since the emergence of the internet and its accompanying protocols, web use has intensified and so developing web applications is a promising way of reaching greater audience. Web use is not limited to the internet, but to virtually any application that can interface and communicate via web protocols. Intranet with the proposed design, staff, students and any authorized person can get all the available information from the polytechnic intranet integrated database. They can get their syllabus, academic calendars and results, register course, to mention just a few.


1.3 Statement of the Problem

Invariably, the problem that gave rise to this system study is from the continuous use of manual methods of dispensing academic details in the institution. The core is information management. As they say if you are not informed, you are deformed and he who is deformed cannot perform”. It would not be an exaggerated statement if I say that graduates from Nigerian institutions are deformed because they are not being well informed due to inadequate information acquisition facilities. It can be seen that information is not only important in this age but also the method of accessibility. No wonder it is termed as power, without it there is no headway. According to the U.S. Gen. Collins Powell (1995) “Lack of information breeds analysis paralysis” without adequate information on any subject matter, it would be difficult to handle. However, the enatic nature of power supply, especially in third world countries has tremendously affected online information systems and remote access to queries, information down time and data corruption is inevitable.

In Federal Polytechnic, Owerri the method of information processing and sharing is done manually and therefore slows down the speed at which information is stored, processed and shared. To eradicate this to its optimum a robust database and web server should be implemented where the information no longer have to reside in man’s brain or on his desk but on the network and can be accessed by anyone who is privileged.


1.4 Objective of the Study

The new system will bring about efficient and effective academic information system. The concise documentation of students and staff details will tremendously improve its timely decision support.

The project would also go a long way in fostering good perception of the information age in our various institutions and individual organization thereby breaking the ugly bone of continuous use of manual and archaic systems. It fosters on the in depth principles, rules and protocols of coding, scripting and hosting of database driven web pages. It will also help in making the processing of information as well as on the sport feedback faster and provide spring board for our young database developer. It also stirs and gives focus to our institutions of higher learning on the facilities obtained in the use of modern system of communication.

In order to produce a more classified knowledge of the subject matter, the researcher intends to describe the tools required to design and implement a functional Internet information service server, HTTP web server and a MsSQL relational database server for the institution through HTML encoded ASP.NET web interface. The objective of developing the system and procedure for the polytechnic is to ensure that end users are provided with requisite tolls and data that are cost effective and easily accessible.


1.5 Significance of the Study

These research works critically explores the possible ways of demystifying the mystery behind database and related technologies, web hosting services, protocols and of course design, and encourage young programmers to joint the race without feeling interns to their counterparts in the development parts of the world.

Without shifting this focus to web site design, we might still be in darkness for the next twenty years and by then a new inventions might be made which can sentence us unto another one thousand years of Dark Age. The study will go a long way to cutting down on time wastage, inefficient use of statistical data, manual errors and duplication of efforts by both staff and academic personnel. It will also enhance efficient query and enquiring ensure security of records and assist the polytechnic in copying with the daily work load.


1.6 Scope and Limitation of the Study

Data not withstanding of its size cannot be too large to process. However, a guided approach is adopted to stay within limits for easy comprehension. To this end, the study will only focus on the students together with its accompanying web interface, students’ registration details and academic results.

In its most common form, the wide application of computers in accessing remote files paved way for adopting of more superior ways of making information available to the millions of users. And it also exposes the researcher to the core about the intricacies of database programming for web, an all round technology.

Although economic constraints did not stop this project room completion, yet adequate funds would have aided the provision of industrial standard hardware and software. The limitations encountered in this case are mainly based on the fact that the institution, Federal Polytechnic Nekede, Owerri does not have the necessary software and extended network of computers, that is, it lack the projected operational hardware. Nevertheless, the researcher simulated typical sceneries. Now, the last and not the least, the time to develop, test and implement the complete scenario was without unbearable sleepless night and frustration from public power supply.


1.7 Definition of Terms

API

A term used to denote Application Programming Interface. An interface that is defined in terms of a set of functions and procedures, and enables a program to gain access to facilities within an application.

Byte

It is a fixed number of bits that can be treated as a unit by the computer hardware. It is a unit of storage capable of holding a single character equal to 8 bits, large amount of memory are referred in terms of kilobytes (1,024 bytes), megabytes (1,048,576 bytes), and gigabytes (1,073,741,824 bytes).

Bandwidth

The amount of data or signal that can be transmitted in a transmission medium or media in a given time. It is measured in bits per second (bps) for digital devices and Hertz (HZ) for analog devices.

Counter

Keeps track of how many times a web page is visited.

Download Time

The time it takes foe a web page to be completely visible on the computer screen.

File Size

How large the file containing the data is usually measured in kilobytes or megabytes. File size is used when referring to pages, HTML documents and any other type of file.

Frames

Formatting a page so that more than one HTML document is visible on the screen at the same time.

Home Page

The main and first page of a website, containing introductory information about the facility that has been accessed, together with links to the actual details of services or information.

HTML

An abbreviation for Hypertext Mark-Up Language. A form of SGML (standard generalized mark up language) intended for use on the World Wide Web. It is used to create documents for the World Wide Web.

HTTP

Hypertext transfer protocol. An application level protocol with the lightness and speed, necessary for distributed collaborative hypermedia information systems. It transfers hypertext requests and information between servers and browsers.

Internet

The global information network that now links a very substantial fraction of the world’s computer networks.

Intranet

A private network setup by an organization or company that resembles the World Wide Web, but which is inaccessible by external users.

JAVA

A language for object-oriented programming on the internet, especially applicable to the World Wide Web.

JAVA SCRIPT

A scripting language designed to add features to web pages.

Operating System

The set of software products that jointly controls the system resources and the processes using these resources on a computer system


Chapter Five


5.0 Recommendation

Designing a database driven website for an educational institution entails more of data collection than traditional programming. Nevertheless the outcomes and benefits of a well planned website cannot be over emphasized. Although many factors contribute to an effective website, yet there are so many that one could not but think of them all. The internet with all its functionality has indeed changed the way people live and interact politically, socially, economically and otherwise. The internet as with database combines audio, video and textual contents while eliminating time and space of traditional media.

This has enabled website, an interactive media when integrated with a database making it a cost effective one on one educational tool. Thus, if federal polytechnic Nekede and its contemporaries should utilize this honey comb, literacy in African as a whole would wear a glorious crown.

To this end, the researcher suggests the following recommendations:

  1. Implementing a database local website for federal polytechnic Nekede will not only enhance management communication but also accomplish effective resource utilization in terms of information sharing and decision making. It is therefore recommended that educational institution, federal polytechnic Nekede inclusive adopt an interactive system. This proposal is 70% achievable considering the already existing equipment, which only requires little manpower.
  2. This implementation will also allow for staff, student and management interaction through live survey, chats, forms and emails, while helping to improve the knowledge and understanding of the institutional needs and interests.
  3. Undoubtedly, a well incorporated webbed database for federal polytechnic Nekede, owerri would improve the customer support service by saving money and time while expanding on its educational distribution.

5.0.1 Areas of Further Improvement

  1. The polytechnic should provide an efficient internet network by incorporating its existing computers into an enterprise local network. Staff and students should be sensitized to leverage its resources such as chart and voice messaging, classroom conferencing, catalogues, library and other academic information ranging from registration, lectures to result enquires.
  2. In addition to the above network infrastructural enhancement, it is suggested that the polytechnic acquires its own VSAT (satellite communication). This will ensure internet connection with its counterparts in the World Wide Web.
  3. A major drawback to these proposals would be unreliable power supply system. Therefore, the institution is urged to complement this with industrial uninterruptible power supply systems (UPS) that can ensure round the clock power supply for the network.
  4. Develop an intensive in house training for academic and non academic staff. This will help reduce the dependence on manual processing and also increase staff competence on world class office automation.
    Once, the database is fully integrated with www. Federal polytechnic Nekede will not only register the institution’s presence, but also boast its academic as a citadel of technological excellence students and individuals of academic interest will include those with mobility constraints, will find the universal access very comforting. It will also create avenue for online research and development, which in turn will create more revenue for the site.

5.1 Conclusion

The need for available, secure and reliable information solution is heightened by the increasing dependence on web like systems and database technologies to provide core educational services, develop efficient academic products, administer daily activities and perform both short, long term management functions. Using federal polytechnic Nekede, owerri as a case study this project has elaborated on the technical and operational requirement of developing an academic information system. Issue like web and database concept and technologies: analysis and design tools, security and content maintenance were adequately explained.

Initially, HTML was used to convey contents like text, graphic images, video, audio and hyperlinks in static form. But today, database and dynamic web page scripting are the communication means to live information content. These technologies have come to stay no doubt that every organization, institution and government parastatal wants to join the e-race. Designing a functional academic information website for federal polytechnic Nekede is indeed a giant step in the right direction.


How To Get The Complete Material For Design And Implementation Of An Academic Information System Using Relational Database And HTTP Server


Project Material Download


The complete material will be sent to your email address after payment
( Quick & Simple)

FOR CLIENTS IN NIGERIA:
CLICK HERE to make purchase (₦3,000)

FOR CLIENTS OUTSIDE NIGERIA:
CLICK HERE to make purchase ($15)

  Contact Our Help Desk


⚠️ Need a different topic? Perform a quick search



Get A Complete Business Plan For Any Business In Nigeria

Business Plan for Businesses in Nigeria

  Business Plans in Nigeria


Disclaimer


This research material “Design And Implementation Of An Academic Information System Using Relational Database And HTTP Server” is for research purposes and should be used as a guide in developing your research project / seminar work. For no reason should you copy word for word (verbatim) as samphina.com.ng will not be liable for any who copied the material.

The aim of providing this material is to reduce the stress of moving from one school library to another all in the name of searching for research materials. This service is legal because, all institutions permit their students to read previous projects, books, articles or papers while developing their own works. According to Austin Kleon “All creative work builds on what came before”.

samphina.com.ng is only providing this material “Design And Implementation Of An Academic Information System Using Relational Database And HTTP Server” as a reference for your research. The paper should be used as a guide or framework for your own paper. The contents of this paper should be able to help you in generating new ideas and thoughts for your own research. Use it as a guidance purpose only.

Samphina Academy

Samphina Academy is an Online Educational Resource Center that is aimed at providing students with quality information and materials to aid them in succeeding in their academic pursuit.