.

Wednesday, March 2, 2011

ONLINE UNIVERSITY - HOW TO DEPLOY AND RUN

User Maintenance Manual

This project titled ‘On-Line University’ has been built using JSP, which is a server side program. So to run this program on a personal computer, a web server such as Java Web Server2.0 or Apache Tomcat 4.0’, is needed. Here ‘Tomcat’ is used.

In this CD, there is a folder named ‘University’ and inside this folder there are another three folder named ‘htmls’, ‘jsps’ and ‘database’. The ‘htmls’ contains html codes, the ‘jsps’ contains jsp codes and ‘database’ contains databases created on MS Access.

Procedures for Apache Tomcat 4.0 web server

The folder ‘University’ should be included inside the ‘Tomcat’ as follows:

Note:

Copy University Folder and paste it under

C:\Program Files\Apache Tomcat 4.0\webapps\examples\jsp


ONLINE UNIVERSITY DATABASE CREATION

Working with MS Access

To create a new Database, open the MS Access and select ‘Blank Access Database’ and click at OK. This is shown below:



Then another window will be opened as shown below. In this window we can select the Drive where we want to save this database file.




After selecting the Drive, assign a name to the Database file, which we are going to create and click at the button. Then another window will be opened as shown below:





In the above figure, we can see that three ways to create a database. Among this, select the second one (as shown in the picture) and double click on it. Then another window will be selected as shown below:




Here we can select the subject for the ‘Sample Tables’ by choosing ‘Business or Personal’. Here I chose ‘Book’ as the subject for the Sample Tables. If we choose a


Subject for the Sample Tables, its possible attributes will be appeared on the ‘Sample Fields’. From this field we can choose the fields that we would like to have. Here I selected ‘BookID, Title and Copyright Year’. This can be done by clicking the button while keeping a sample field is selected. After this, click next and another window will be opened as shown below:





Here also click ‘Next’ and the next window is shown below:



Here click at ‘Finish. Then another window will be opened as shown below

In this window, we can enter the values for the attributes such as ‘Book ID, ‘Title and Copyright Year’. After entering all the values to the fields, press ‘Ctrl + W’ for saving the file




Introduction









Preface





  1. SYSTEM ANALYSIS



1.1  Analysis Report


1.2  Requirement Specification


    


  1. PROJECT PLAN






2.1  Project plan




2.4  Minutes of Group Meetings





  1. SYSTEM DESIGN









3.4  Testing Methods



3.6  Programming Language Used


   


  1. Implementations and Future Enhancements


ONLINE UNIVERSITY-Table and View Structure

Login Table




UserName stores students user name for login
Password stores password, the user can login only if the correct password is
Entred.


For each person user name and password is different or unique.


Registration Table for the New User.




UserName -> stores the name of the user

Prefer1 -> stores the code of the Subject to which the user gives 1st preference

Prefer2 -> stores the code of the Subject to which the user gives 2nd preference

Prefer3 -> stores the code of the Subject to which the user gives 3rd preference

Qmarks ->stores the Qualification marks

CollegeCode à stores the code number of the college



Table for Subject Details







SubjectName -> stores the name of the Subject.
SubjectCode -> stores the code number of the Subject.


Table for Allotment of Seats for different Courses in different Colleges



CollegeCode --> stores the code number of the College
CourseCode --> stores the code number of the Course
AllottedGeneral --> stores the number of seats allotted generally.
AllottedRes --> stores the number of seats reserved
AllottedManage --> stores the number of seats reserved by the Management of the College

Table for College and Course details


Table for College Details


Duration --> stores the Duration of Course in Years/Semester
SORY --> stores ‘S’ for Semester and ‘Y’ for Years.
Fees --> stores the Fees for completing the specified Course.

Table for Result Details



RollNumber --> stores the roll number of the candidate

Table for Result



Marks --> stores the marks secured in the specified subject


















Introduction









Preface





  1. SYSTEM ANALYSIS



1.1  Analysis Report


1.2  Requirement Specification


    


  1. PROJECT PLAN






2.1  Project plan




2.4  Minutes of Group Meetings





  1. SYSTEM DESIGN









3.4  Testing Methods



3.6  Programming Language Used


   


  1. Implementations and Future Enhancements


ONLINE UNIVERSITY Data Flow Diagrams

CONTEXT DIAGRAM














Introduction









Preface





  1. SYSTEM ANALYSIS



1.1  Analysis Report


1.2  Requirement Specification


    


  1. PROJECT PLAN






2.1  Project plan




2.4  Minutes of Group Meetings





  1. SYSTEM DESIGN









3.4  Testing Methods



3.6  Programming Language Used


   


  1. Implementations and Future Enhancements


ONLINE UNIVERSITY Technical Feasibility

Technical Feasibility OF ONLINE UNIVERSITY USING JAVA ACADEMIC PROJECT
The application will be implemented in the Windows NT Server. MS Access is used as the Database, the application interface is programmed using HTML and the code is programmed using Java Server Page.


Economic Feasibility


Coding Cost

Productivity = 2500 LOC/Person-Month cost of System

Development Cost = Rs. 1000.00

Person-Month = Productivity/Lines of Code
= 2500/10000
= 0.25

Cost of Software = 10000*0.25
= Rs. 2500

Cost/LOC = 2500 /10000
= 0.25

ONLINE UNIVERSITY Technical Feasibility

Technical Feasibility OF ONLINE UNIVERSITY USING JAVA ACADEMIC PROJECT
The application will be implemented in the Windows NT Server. MS Access is used as the Database, the application interface is programmed using HTML and the code is programmed using Java Server Page.


Economic Feasibility


Coding Cost

Productivity = 2500 LOC/Person-Month cost of System

Development Cost = Rs. 1000.00

Person-Month = Productivity/Lines of Code
= 2500/10000
= 0.25

Cost of Software = 10000*0.25
= Rs. 2500

Cost/LOC = 2500 /10000
= 0.25



Introduction









Preface





  1. SYSTEM ANALYSIS



1.1  Analysis Report


1.2  Requirement Specification


    


  1. PROJECT PLAN






2.1  Project plan




2.4  Minutes of Group Meetings





  1. SYSTEM DESIGN









3.4  Testing Methods



3.6  Programming Language Used


   


  1. Implementations and Future Enhancements



THE “ON – LINE UNIVERSITY” PROJECT SPECIFICATION

This project work is really meant for the students who are studying under a specific University. So in this project, the students should have the opportunity to do the things almost like when they are in a University for an admission procedure, searching for their result, enquiring about a college/course etc. So the provision for all these purposes should be included in this software.

A screen layout of this shown below:





So the students can search the exam result by entering their “ Roll Number”, they can see the college and course details, the students can register for a new course in a college (Admission) and register for the examinations. While doing the registration for admission, the students have to specify the following details:

1) Name of the College the student want to study
2) The students have to specify the name of the Courses with preference.
3) The marks awarded in the Qualifying Exam

Also doing the registration for examination, the students have to specify the following details:

1) Specify the Course
2) Specify the subjects that the student is going to register for the examination
3) Specify the number of the Fees receipt (DD/Chelan)

For the new user (student) to sign up, the following details of the student have to be entered.

1) Member Name
2) Password
3) First Name
4) Last Name
5) Street Address
6) City
7) Country
8) Zip code
9) Birth Day
10) E-mail Address
11) Education
12) Phone Number

The editing of all the details concerning the University is done by the Administrator. The Administrator has the provision to see the details entered by the user. The screen layout of this shown below:


So the Administrator can view the details of the students who are registered for the examination and admission. The Administrator can Add new college and course details, edit the college details, entering the results of the exam in the site etc. For all editing and adding processes, the Administrator has to specify the relevant details.


System Specifications


Hardware Requirements (Minimum):

1. Pentium Celeron 1.2 GHz Processor
2. Intel 810E Chipset Motherboard
3. 128 MB DDR RAM
4. 20 GB HDD
5. 1.44 MB FDD
6. 58 X Samsung CD ROM Drive
7. Keyboard
8. Mouse
9. Monitor
10. UPS

Software Requirements:

1. Web Server (Apache Tomcat 4.0 Recommended)
2. Java Development Kit (Any Higher Version than 1.2.2)
3. Windows 98 or Windows 2000 Professional



Introduction









Preface





  1. SYSTEM ANALYSIS



1.1  Analysis Report


1.2  Requirement Specification


    


  1. PROJECT PLAN






2.1  Project plan




2.4  Minutes of Group Meetings





  1. SYSTEM DESIGN









3.4  Testing Methods



3.6  Programming Language Used


   


  1. Implementations and Future Enhancements


ONLINE UNIVERSITY Operations of Different Levels in the Project

The Aim of the Project “On-Line University”

This project entitled “On – Line University” is meant for students those who are studying under a University. This University provides so many courses through different colleges, which are affiliated, to this University. One cannot find all the courses in one college. But these courses are distributed to different colleges after considering the facilities available in those colleges. Suppose that, this University is going to introduce a new course, which is related to Software Development. So the college that has the permission to conduct this course must have a computer lab. The University also puts some restrictions in number of seats for different courses.

If any student wants to study “Astro-Physics” in Degree level, have to search for the college, which conducts this course. And the admission form should be submitted to that college before the date. The college checks all the eligibility criteria and the rank list for the Degree program will be prepared on the basis of mark awarded in the last course the student had appeared. For this process, it takes time to prepare a rank list of hundreds of students who had applied for the college admission.

The “On – Line University” facilitates all these problems to some extends. That means this University is starting an Internet based service for the students. With the help of this on-line service, students can register for a course through on-line, students can view a particular course available in any one the colleges under this University, they can search their exam result, the students can register for the exam etc so that they can save time.




Administrator Level:

Administrator can perform some operations like ‘Adding and Editing College Details, Viewing the Applicants, Entering the Exam Results, Course Seat Allotment, Verifying Exam Applications . . . etc’. The Login of the Administrator is protected through the authorized password.




User Level:

Here user refers to students. The new student has to sign up as new user and those students have to fill up their personnel details in a form that will be displayed when they log on to the website of the University. In that form, the new student has to specify a user name and a password and this user name and password can be used for further references whenever they log on to the this site.

The students those who already registered with this site, can directly log on the site by typing the user name and password in the appropriate columns. When they get into the site, they can search their exam result, view the details of the colleges; they can notice the number of seats available for each course, they can register for a new course, they can register for the exam etc.






The overall structure will be given as shown below:








Introduction









Preface





  1. SYSTEM ANALYSIS



1.1  Analysis Report


1.2  Requirement Specification


    


  1. PROJECT PLAN






2.1  Project plan




2.4  Minutes of Group Meetings





  1. SYSTEM DESIGN









3.4  Testing Methods



3.6  Programming Language Used


   


  1. Implementations and Future Enhancements



ONLINE UNIVERSITY - SYSTEM ANALYSIS

Operations in the Existing System


Registration

The students those who are looking for pursuing a course at any college under the ABCD University has to pass the qualifying examination or any other examination, recognized by this University as equivalent to it, with a minimum of 55% marks. Relaxation of marks will be allowed to SC/ST students. Even if the student has passed the qualifying course he/she must also have attained the minimum age prescribed for admission to the course.


Apart from this at the time of admission the students are required to present their transfer certificate (T.C) and a conduct certificate from the institution they have last studied. If student is an over aged private S.S.L.C holder then that student is exempted from producing the Transfer Certificate at the time of admission in the affiliated colleges and also for Private Registrations. If the student had studied in an institution outside the territorial jurisdiction of this University and presently he/she wish to seek admission to a College/Institution or any of the University’s Departments of Study and Research in this University, in addition to the above said requirements they should also produce a Migration Certificate.

The students shall also produce an Eligibility Certificate that can be had from the Registrar by submitting an application form with a prescribed fee. Candidates who migrate from other Universities should register as matriculates of this University at the time of admission by paying the prescribed fee. If one fails to produce the Migration Certificate as requested by the University, then he/she will not be allowed to take any examination of this University. Admission to colleges or other institutions under the University will not be permitted after two months from the date of reopening of the college or University Department concerned, except with the previous permission of this University. However, he/she may be permitted to join the certain part-time courses conducted by the University or by a college affiliated to this University or by a Center for study and research of this University. No Candidate who has passed an examination from this University or from any other University shall be permitted to take an examination of this University or to join the course leading to that Examination or part or parts thereof which is considered lower than the one he has passed



Draw backs of the Existing System

The main problem with the existing system is that it takes so long for completing the registration process. Also there may cause the problem of losing application or registration forms while sending the forms to and fro. Besides all that, all the databases of these students have to be entered in to the computer by the data entry operator and it is a tedious as well as a time consuming process. Here also errors-like unfilled columns in the forms, losing data, etc may occur while creating the databases for the students. If anyone’s form is not filled completely, his or her registration or application form will not be taken into consideration.

In the case of admission, students are not aware of the number of seats available in each college for a certain course. Difficulty arises when the student came to know that the college to which he/she applied for a certain course does not have sufficient number of seats. In such cases, again, the student has to submit another admission form, for which he/she has to follow all the rules and formalities that the student had done when applied for the first time. As far as a student is concerned, it is all time consuming processes and they have to wait till for a replay from the University/College authorities.

While applying for an exam, students have to submit all the examination forms and the exam fee receipt before the date. This is very difficult for the students those who are coming from very long distance and from outside state.



Proposed System and its Advantages

If the University has On-Line services, the above-mentioned problems will be solved to some extend. Students can register for a course through on-line thereby they can avoid the missing of forms, waiting so long for the replay, etc. Through on-line, students can fill up the registration form and it can be send within a fraction of a second. While doing on-line registration, students cannot leave any columns as blank, as the system reminds them of that. So the students can avoid such mistakes that might be leading to the cancellation of their registration. As soon as the students registered for the course, they will get the further information from the University at once.

With the help of On-Line registration, the students need not wait for days or weeks for the result. While doing On-Line registration, the students will be informed of their college, their course, their admission number, their registration number etc. Also when students are registering through On-Line, they have to fill up their academic details, personal details, mark lists, etc in the registration form. So the details in the forms are directly going to the server of the University so that the university needn’t have to create a separate database for the student.

The proposed system offers on - line facilities like viewing the Course details, College details, Exam results, Registration for both Admission and Examinations etc. In the administration side, the administrator can enter new details such as adding new colleges, allotting seats, entering new course details, entering exam results etc.







Introduction









Preface





  1. SYSTEM ANALYSIS



1.1  Analysis Report


1.2  Requirement Specification


    


  1. PROJECT PLAN






2.1  Project plan




2.4  Minutes of Group Meetings





  1. SYSTEM DESIGN









3.4  Testing Methods



3.6  Programming Language Used


   


  1. Implementations and Future Enhancements



Google Ads