Course Registration Project \"Simple Scenario \" • At the beginning of each seme
ID: 3802330 • Letter: C
Question
Course Registration Project "Simple Scenario
" • At the beginning of each semester, students get a course catalogue containing a list of course offerings for the semester. Information about each course, such as professor, department, and prerequisites will be included to help students make informed decisions.
• The system will allow students to select four course offerings for the coming semester. In addition, each student will indicate two alternative choices in case the student cannot be assigned to a primary selection.
• Course offerings will have a maximum of ten students and a minimum of three students. A course offering with fewer than three students will be cancelled. Once the registration process is completed for a student, the registration system sends information to the billing system so the student can be billed.
• Professors must be able to access the online system to indicate which courses they will be teaching. They will also need to see which students signed up for their course offerings. • For each semester, there is a period of time that students can change their schedule. Students must be able to access the system during this time to add or drop courses.
• In addition to the routine treatments, the hospital also provides emergency care. For an emergency care, patients do not need to make appointments. Emergency patients are seen by emergency specialized doctors, and later patients may be handed over to an appropriate doctor for further treatments.
1. Briefly describe the objective of the project?
2. Identify all the stakeholders?
3. List the main functions that the project provides?
4. Identify the conditions/constrains that the project scenario may has?
Explanation / Answer
Online Examination - Administration & Student Modules
It is consisting of two applications.
Exam Administration
Allows administrator to add course, batch, student and questions. Uses a filter to ensure only authenticated user can access JSP pages.
Major Operations
The following are the major operations of this application.
Technologies and Products used
The following table lists operations and associated objects and files.
Operation
Files
Associated Objects
Login
login.jsp , mainpage.html,header.html
AdminBean JavaBean, DBUtil class
Home page
menu.html
Adding new course
addcourse.jsp
CourseBean javabean, DBUtil class
Adding new batch
addbatch.jsp
CourseBean javabean, BatchBean JavaBean, CourseTag custom tag, DBUtil class
Adding new students
addstudents.jsp
StudentBean javabean, BatchTag custom tag, DBUtil class
Adding new questions
addquestion.jsp
QuestionBean JavaBean , CourseTag custom tag, DBUtil class
Changing password (Not done)
changepassword.jsp
List Courses
listcourses.jsp
DBUtil class
List Batches
listbatches.jsp
DBUtil class
List Students
liststudents.jsp
DBUtil class
List Questions
listquestions.jsp
DBUtil class
List Exams
previousexams.jsp
DBUtil class
Student Examination
Allows student to login with batch code, rollno and password and take exam.
Major Operations
The following are the major operations of this application.
Technologies and Products used
The following table lists operations and associated objects and files.
Operation
Files
Associated Objects
Login
login.jsp
StudentBean JavaBean, DBUtil class
Home page
startexam.jsp
StudentBean JavaBean
Taking Exam
takeexam.jsp
StudentBean Javabean, ExamBean Javabean
Finsing Exam
Finish exam
finishexam.jsp, StudentBean JavaBean, ExamBean JavaBean and ExamEJB EJB
List Of Previous Exams
previousexams.jsp
StudentBean JavaBean, DBUtil class
<html>
<link rel="stylesheet" href="style.css">
<body>
<center>
<h2>Add New Course</h2>
<form action="addcourse.jsp" method=post>
<table cellpadding=3>
<tr>
<td>
Course Code
<td>
<input type=text name=ccode size=10>
</tr>
<tr>
<td>
Course Name
<td>
<input type=text name=cname size=20>
</tr>
</table>
<p>
<input type=submit value="Add Course">
<input type=submit value="Clear All">
<p>
<a href="menu.html">Back To Menu </a>
<%
if ( request.getParameter("ccode") == null) return;
%>
<jsp:useBean id="course" class="exam.CourseBean" scope="page" />
<jsp:setProperty name="course" property="*"/>
<h4>
<%
if ( course.add() )
out.println("Course Has Been Added Successfully.");
else
out.println("An Error Occured While Adding Course!");
%>
</h4>
</center>
</body>
</html>
<html>
<%@ taglib uri="/WEB-INF/tld/exam.tld" prefix="exam"%>
<link rel="stylesheet" href="style.css">
<body>
<center>
<h2>Add New Batch</h2>
<form action="addbatch.jsp" method=post>
<table cellpadding=3>
<tr>
<td>
Course Code
<td>
<exam:courses />
</tr>
<tr>
<td>
Staring Date :
<td>
<input type=text name=stdate size=10> (dd-mon-yy)
</tr>
</table>
<p>
<input type=submit value="Add Batch">
<input type=submit value="Clear All">
<p>
<a href="menu.html">Back To Menu </a>
<%
if ( request.getParameter("ccode") == null) return;
%>
<jsp:useBean id="batch" class="exam.BatchBean" scope="page" />
<jsp:setProperty name="batch" property="*"/>
<h4>
<%
if ( batch.add() )
out.println("Batch Has Been Added Successfully.");
else
out.println("An Error Occured While Adding Batch!");
%>
</h4>
</center>
</body>
</html>
<%@page import="java.sql.*,exam.*"%>
<link rel="stylesheet" href="style.css">
<%
String ccode = request.getParameter("ccode");
Connection con = DBUtil.getConnection();
PreparedStatement ps = con.prepareStatement("select bcode, stdate from batches where ccode = ?");
ps.setString(1,ccode);
ResultSet rs = ps.executeQuery();
%>
<center>
<h2>Batches For Course [ <%=ccode%> ] </h2>
<table border=1 cellpadding=2>
<tr>
<th>Batch Code</th>
<th>Starting Date
<th>
</tr>
<%
while(rs.next())
{
%>
<tr>
<td><%= rs.getString("bcode")%>
<td><%= rs.getString("stdate")%>
<td>
<a href=liststudents.jsp?bcode=<%=rs.getString("bcode")%>>Students</a>
</tr>
<%
}
rs.close();
ps.close();
con.close();
%>
</table>
<a href="#">Back </a> <a href="menu.html">Main Menu</a>
</body>
<%@page import="java.sql.*,exam.*"%>
<link rel="stylesheet" href="style.css">
<%
Connection con = DBUtil.getConnection();
PreparedStatement ps = con.prepareStatement("select ccode, cname from courses");
ResultSet rs = ps.executeQuery();
%>
<center>
<h2>Course Details </h2>
<table border=1 cellpadding=2>
<tr>
<th>Course Code</th>
<th>Course Name
<th>
</tr>
<%
while(rs.next())
{
%>
<tr>
<td><%= rs.getString("ccode")%>
<td><%= rs.getString("cname")%>
<td>
<a href=listbatches.jsp?ccode=<%=rs.getString("ccode")%>>Batches </a>
<a href=listquestions.jsp?ccode=<%=rs.getString("ccode")%>>Questions </a>
</tr>
<%
}
rs.close();
ps.close();
con.close();
%>
</table>
<p>
<a href="#">Back </a> <a href="menu.html">Main Menu</a>
</body>
create table courses
( ccode varchar(5) primary key,
cname varchar(30)
);
create table batches
( bcode number(3) primary key,
ccode varchar(5) references courses (ccode),
stdate date
);
create table students
( bcode number(3) references batches(bcode),
rollno number(3),
sname varchar(20),
pwd varchar(10),
primary key(bcode,rollno)
);
create table questions
( qid number(5) primary key,
ccode varchar(5) references courses(ccode),
question varchar(1000),
ans1 varchar(1000),
ans2 varchar(1000),
ans3 varchar(1000),
cans char(1)
);
create table exams
( examid number(5) primary key,
bcode number(3),
rollno number(3),
marks number(2),
dexam date,
foreign key (bcode,rollno) references students(bcode,rollno)
);
create table password
( pwd varchar(10) );
insert into password values('abc');
Design some other pages code i have it but server not support.i will send throw mail
Operation
Files
Associated Objects
Login
login.jsp , mainpage.html,header.html
AdminBean JavaBean, DBUtil class
Home page
menu.html
Adding new course
addcourse.jsp
CourseBean javabean, DBUtil class
Adding new batch
addbatch.jsp
CourseBean javabean, BatchBean JavaBean, CourseTag custom tag, DBUtil class
Adding new students
addstudents.jsp
StudentBean javabean, BatchTag custom tag, DBUtil class
Adding new questions
addquestion.jsp
QuestionBean JavaBean , CourseTag custom tag, DBUtil class
Changing password (Not done)
changepassword.jsp
List Courses
listcourses.jsp
DBUtil class
List Batches
listbatches.jsp
DBUtil class
List Students
liststudents.jsp
DBUtil class
List Questions
listquestions.jsp
DBUtil class
List Exams
previousexams.jsp
DBUtil class