Answer to Question #259131 in HTML/JavaScript Web Application for pooja

Question

d) 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 int,
    name varchar(255),
    highest_qualification varchar(255),
    Pcode int
);


CREATE TABLE Programme (
    Pcode int,   
    ProgrammeName varchar(255),
    Duration varchar(255),
    Fee int
);