Answer to Question #257754 in HTML/JavaScript Web Application for Saksham

Question

Create a database for a Student management system consisting of the following two tables: Student (SID, name, highest qualification, Pcode) Programme (Pcode, ProgrammeName, Duration, Fee) Develop and deploy a web based “Programme Information System” using JSP, any database backend and any web server. Your system should use JDBC for input of information to both the tables. In addition, this system should output Programme wise list of students on the screen. Submit the JSP program, screens and database for the system. You must demonstrate this system at the time of viva voce. Make and state suitable assumptions, if any.

Answer 1

CREATE TABLE Student 
(SID INTEGER,
name CHAR(20),
highest qualification CHAR(15),
Pcode INTEGER)

CREATE TABLE Programme
(Pcode INTEGER,
ProgrammeName CHAR(20),
Duration INTEGER
Fee CHAR(15),
)