Online College Portal using HTML & SQL (Computer Project)

Get this Project:

Fields with * are mandatory

ABSTRACT

Online College Portal (OCP) provides a simple interface for maintenance of student–faculty information. It can be used by educational institutes or colleges to maintain the records of students easily. The creation and management of accurate, update information regarding a students’ academic career is critically important in the university as well as colleges. Student information system deals with all kind of student details, academic related reports, college details, course details, curriculum, batch details, placement details and other resource related details too.

It tracks all the details of a student from the day one to the end of the course which can be used for all reporting, tracking of attendance, progress in the course, completed semesters, upcoming semester year curriculum details, exam details, project or any other assignment details, final exam result and all these will be available through a secure, online interface embedded in the college’s site. It will also have faculty details, batch execution details, students’ details in all aspects, the various academic notifications to the staff and students updated by the college administration. It also facilitate us explore all the activities taking place in the college, different reports and queries are generated based on vast options related to students, batch, course, faculty, exams, semesters, certification and even for the entire college.

SYSTEM DESIGN

This deals with data flow diagram, detailed flow graph, requirement analysis, and the design process of the front end and back end design of the student information management system.

Dataflow Diagram

A Data Flow Diagram (DFD) is a graphical representation of the flow of “Online College Portal”. A data Flow diagram can also be used for the visualization of Data Processing. DFD shows the interaction between the system and outside entities. This context-level DFD is then “exploded” to show more detail of the system being modelled. A DFD represents flow of data through a system.

Use Case Diagram

The use case diagram depicts the essential functionality and actors of the application namely admin and student.

Sequence Diagram

The sequence diagram depicts the entities that interact with each other. The diagram shows in detail the sequence of events occurring during the implementation of the proposed System.

ANALYSIS

The basic requirements for the design of the OCP are:

  • Login facility.
  • User can update his/her personal information and can view the notice, results, placement and exam section updates etc.

Faculty/staff, discussion and exam sections can update any of the information.

Functional Requirements

Online College Portal system aims to improve the efficiency of college information management, and the main function is managing and maintaining information. The administrator and students are two major functional requirements in the system. The Administrator will be given more powers (enable/disable/update) than other users. It will be ensured that the information entered is of the correct format.

Non-Functional Requirements

Performance Requirements: The proposed system that we are going to develop will be used as the chief performance system for helping the organization in managing the whole database of the student studying in the organization and having message notifications. Therefore, it is expected that the database would perform functionally all the requirements that are specified.

Safety Requirements: The database may get crashed at any certain time due to virus or operating system failure. Therefore, it is required to take the database backup.

TECHNOLOGY USED

.Net Framework

The .NET Framework is Microsoft’s Managed Code programming model for building applications on Windows clients, servers, and mobile. Microsoft’s .NET Framework is a software technology that is available with several Microsoft Windows operating systems. In the following section it describes, the basics of Microsoft .Net Frame work Technology and its related programming models.

HTML

HTML is a hypertext mark-up language which is in reality a backbone of any website. Every website can’t be structured without the knowledge of html. If we make our web page only with the help of html, than we can’t add many of the effective features in a web page, for making a web page more effective we use various platforms such as CSS.

CSS

CSS Stands for “Cascading Style Sheet.” Cascading style sheets are used to format the layout of Web pages. They can be used to define text styles, table sizes, and other aspects of Web pages that previously could only be defined in a page’s HTML. The basic purpose of CSS is to separate the content of a web document (written in any markup language) from its presentation (that is written using Cascading Style Sheets).

SQL

SQL stands for Structured Query Language. SQL lets us access and manipulate databases. SQL is an ANSI (American National Standards Institute) standard. SQL can execute queries against a database, retrieve data from a database, insert records in a database, update records in a database, delete records from a database, create new databases, create new tables in a database, create stored procedures in a database, create views in a database, set permissions on tables.

CONCLUSION

This paper assists in automating the existing manual system. This is a paperless work. It can be monitored and controlled remotely. It reduces the man power required and provides accurate information. Malpractice can be reduced. All years together gathered information can be saved and can be accessed at any time. Therefore the data stored in the repository helps in taking decision by management. So it is better to have a Web Based system. All the stakeholders, faculty and management can get the required information without delay. This system is essential in the colleges and universities.

Source: International Journal of Current Engineering and Technology
Authors: Tejaswini Chavan | Deb Dutta | Michelle Gomez | Alvino Vaz

Download Project

>> List of Final Year B.E/B.TECH Student DBMS Projects using HTML

Get this Project:

Fields with * are mandatory

Leave a Comment

Your email address will not be published. Required fields are marked *