Create a database for a Student Registration System consisting of the following two tables: StudentInformation (EnrolmentNo, StudentName, ProgCode) Programme (ProgCode, CourseCode, Credits) Develop and deploy a web based “Student Registration System” using JSP, a database backend and a web server (you may select DBMS and web server, as per your choice). Your system should use JDBC for input of information to both the tables. The system should output list of all the students of BCS053 course on the screen. Submit the JSP program, screens and database of the system. You must demonstrate this system at the time of viva voce. Make and state suitable assumptions, if any.
Creating a full-fledged web-based Student Registration System involves several components, including setting up the database, creating the web application using JSP, and integrating JDBC for database communication. In this response, I'll provide an outline of the steps you need to take to develop the system. Please note that I won't be able to provide a complete working example due to space limitations.
1. Database Setup:
Choose a Database Management System (DBMS) of your choice. For this example, let's use MySQL.
Assumptions:
- You have a MySQL database server installed and running.
- You have a database named "student_registration" created.
Tables:
```sql
CREATE TABLE StudentInformation (
________ ______ __________ _________ ___ ___ __________.
_________ _____ _________ _______ ____ ________ ____ ____ ______ _________ _____.
______ ______ ___ ____ _______ ____ _______.
______ ________ ________ _____ _________ _______ ___ ____ ____ ___ __________.
_________ _____ _________ _______ _______.
____ _____ ______ ____ ___ _______ _________ ___ _______.
___ ________ ____ ______ ______ _______ __________.
________ _________ __________ _______ _________ ______ _____ __________ ___ _________ ___.
__________ ____ ____ ______ ____ ___ _________ _______ ____ _____.
_____ _____ _____ ____ ________ ____ _________ _______ _______.
___ ____ _________ _______ ___ ____ __________ _____ ____ ____ _____.
___ ____ _____ ___ _____.
______ _____ __________ __________ ______ ___ _________ __________.
________ _____ _________ _____ __________ ____ ___.
_________ ___ _______ _________ ______.
_________ _______ ____ _______ ______ ____ __________ ___ ________ ______ __________ _____.
_____ ____ _________ _________ ________ _______ _______ __________.
_______ _________ _____ __________ ______ ____ __________.
_____ ____ ________ __________ _______ ___.
__________ _____ __________ ______ __________ ________ _________ _______ _______ _________ ________ ________.
__________ _________ _____ ____ ______ _____ ________.
___ _____ __________ __________ ______ ______ ________ ______ ________ ___ _________ ___.
_____ ____ _______ __________ ______.
_______ ___ ___ _____ ___ ___ ______ ________ _______ _________ _____.
_______ __________ ___ _______ _________ ____ __________ ________.
______ _____ ___ __________ _____ _____ _______ _________ _____ _____ _______ ________.
_____ __________ _____ _______ __________ ____ _____ _______.
_________ _______ _____ ___ ________ _____ ____ __________ __________.
_______ ____ ____ ______ _________ ___ ___ ____ _________ ____.
____ _______ ___ ______ ______ _______ ___.
________ ______ _______ ______ ______ ______ ___ ________ ______.
___ __________ ______ ________ ___ _____ _________ _______.
____ _____ _____ ___ ___ ______ __________ ______ _______ ___ __________ __________.
_______ _________ _____ ____ ________ _________ _____.
___ ______ _______ ______ ______ _______ ______ ____ ________.
_______ _____ _______ ______ ______ ____.
_________ __________ _________ _____ _____ _______ __________.
_____ _________ _________ _____ ______ _________.
________ ___ ______ ______ _____ _________ _____.
_____ _______ ____ _________ ______ ____ ____ __________ ___ ______.
_____ __________ ________ ________ ______ __________ _________ ______ __________ _______ ____ ______.
___ _____ ___ ___ _________ _______ _____ _________ _____ _____ ________ ______.
______ _________ ______ ________ ___ ___ _______ _____ _____ _________.
________ _____ ____ _______ _____ _____ ________ __________ __________ ___.
___ ____ ________ ___ ___ _______.
______ ______ ____ ___ ____ ________ _________ _______ ___ ______ ________.
_____ _______ _________ ____ __________ ________ ________ _________ _________ _____ ___.
___ __________ ________ ______ ________.
___ ____ ______ ________ __________ ________ _______ _______.
____ _____ ______ _____ ___ _________.
________ _____ _____ __________ ___ _______ ________.
_______ _________ __________ ____ ______.
_____ __________ ____ ____ _____.
_________ ___ ___ _______ ___ ____ _______ ___ ______.
___ _________ _________ ________ _____ ________ ______.
_________ _______ _____ ___ ________ __________ __________ __________ ______.
_________ _______ __________ __________ __________ ____ ___ ________ _______ ________ _______ _________.
______ ____ ______.
Get Full Answer on WhatsApp