Online Course Reservation System Project in VB & Oracle

Online Course Reservation System

Aim

To develop a problem statement, SRS document, UML Diagrams, Technical, Domain & Service layers for Online Course Reservation System.

Problem Statement

The Online Course Reservation System helps a student to reserve a course from a college of his or her choice online. If a student is already registered, they can log in. Else, they have to fill up the registration form provided by the administrator. After registering, the student can log in to the system. Then the student selects the college and courses.

Then based on the qualifications of the student the system determines if the student is eligible for the course he has opted for. If the course is available the student can proceed to the payment step, where the course fee can be paid online. After paying the fee, a receipt stating the details of the student and course they selected is provided by the Administrator. Then the student successfully logs out the system.

Welcome to Online Course Reservation System

Result

Thus the problem statement for Course Reservation system is written.

GANTT CHART

AIM:

To develop Gantt chart for Online Course Reservation System.

gantt chart

RESULT:

Thus the Gantt chart for Online Course Reservation System was successfully developed.

Modern Software Requirements Specification

Introduction

This SRS contains the documentation of the requirements used in creating the Online Course Reservation System. It also contains the Use case model hierarchy and the diagrams of the use case model. The software requirement specification is mainly used for requirement elicitation .The users of SRS are the client, the users, the system analysts and the system designers.

Purpose

The main purpose of SRS document is to illustrate the user requirement of the stock maintenance system. This document is developed after a number of consultations with the client. This document will also act as a contract between the client and the developer in case of any dispute during the delivery.

Scope

The scope of the Online Course Reservation System is :

1. A student should be able to

  • Login to the software through the first page of the application
  • Enter the details clearly
  • Enter the courses information clearly

2. The administrator should recognize the personal and account details

3. The course requested by the student should be reserved.

Definitions, Acronyms and Abbreviations

VB Visual Basic, Front end
OCRS Online Course Reservation System

Overview

The Online Course Reservation System helps a student to reserve a course from a college of his or her choice online. Based on the qualifications of the student the system determines if the student is eligible for the course he has opted for. Next, student can proceed to the payment step, where the course fee can be paid online.

Overall Description

This section describes the functions of the project and their aims. It also includes the constraints and the requirements of the project. The Online Course Reservation System is aimed at helping student to reserve a course in a college of their preference. The perspective of project is to efficiently manage reservation of seats online in a simple and convenient manner. The product has a simple and easy user interface.

Use-Case Model Survey

  • Login
  • Registration for new user
  • Enter students details
  • Check student information
  • Select the college
  • Select the course
  • Online fees payment
  • Course reservation

Introduction

It is a graph of actors, a set of use cases enclosed by a system boundary and the association between actors and the use cases. A use case is a special flow of event that occurs in the system. An actor is a user playing a role with respect to the system.

 Survey Description

  • Login- Existing user can enter in to the account
  • Registration for new user- New userto create their account
  • Enter student details- Students will give academic certificates
  • Check student information- Administrator will check eligibility of the student
  • Select college- The user will select the college
  • Select the course- Students will select the course
  • Online fees payment- Online fees payment will be made using credit/debit card or net banking.

Use-Case Model Hierarchy

Following are the actors in the in the system:

   Student– One who wants to Register through online and fill the form for writing the exam

Administrator– One who get the personal details and check the eligibility of the candidate.

Diagrams of the Use-Case Model

Diagrams, primarily use-case diagrams, of the entire use case model are included here

Assumptions and Dependencies

  • The user must have connected to the internet to use the system
  • The user’s computer  must be Windows 98 or later version platform
  • TCP/IP protocol must be installed to communicate  through HTTP message
  • The accuracy of the information of users is the responsibility of all users

Requirements

Online Course Reservation System requires Visual Basic 6.0 and Oracle 10g to be installed in the system. Also there will be a database which will keep all the records done by user while registration and course selection.

Use-Case Specifications

The various use cases are

  • Student details
  • Student Login
  • Course Selection
  • Payment
  • Course reservation
  • Update database

Functionality

The main functionality of system is that we can get from online even at our home itself.

Usability

Online Course Reservation System is very user friendly. Users can easily register and reserve a course of their choice.

Reliability

The system shall operate 95% of the time. The number of defect should not exceed 10 per function. In addition, before the submission of the final release the calendar must be tested in case of the defects over 10 per function.

Performance

  • The system shall accommodate 500 users during the peak usage time  window of  8:00am to 10:00am local time, with estimated average session duration of 45
  • All web pages generated by the system shall be fully downloadable in not more than 10 seconds over a 40KBps modem connection.
  • The system can display confirmation message to users within 4 seconds after the user submits information to the system.

Supportability

The system is supported by Visual Basic for design and Database Management Concepts for backend database storage.

Design Constraints

The design constraints of Hardware and Software

The Hardware:

The various hardware constraints needed are CPU, Processor speed, Coprocessor speed etc.

 The software:

The various software constraints are Front end, Back end and OS.

Online User Documentation and Help System Requirements

None

Purchased Components

None

Interfaces

It describes the various interface needed for the user

User Interfaces

The user interface is Windows XP Operating System.

Hardware Interfaces

The Hardware interfaces are:

CPU                            :           Core 2 Duo

Processor speed           :           2 GHZ

Coprocessor                :           Built in

Total RAM                  :           3 GB

Hard Disk                   :           250 GB

Keyboard                    :           105 Keys

Mouse                         :           Logitech Mouse

Operating system        :           Windows XP/2007/Vista,

The software interfaces are:

Front end                    :           VB

Back end                     :           Oracle

Operating System       :           Windows XP

Hospital Management System Project in Vb.Net

To automate process involved in hospital management this advanced hospital management system project is designed. This project is developed in visual basic using microsoft access as back end.

Hospital Management System Project in Vb.Net

OBJECTIVE TO ACHIEVE :- 

a)     Maintain record of patients. i.e. operation, treatments and other relative processes. 

b)     Maintain record of staff members. 

c)     Maintain all details of different wards and beds. i.e. total occupied beds and total vacant beds. 

d)     Viewing patient’s information securely and rapidly. 

e)     Prepare bill of the patient with total charges. 

f)      Prepare Discharge Card. 

Make the legacy process more efficient and fast.

Existing Working Procedure :- 

a)     The patient contacts for the doctor’s appointment by placing his personal details. Personal information is maintained in the hand-written muster. 

b)     They maintained the hand-written notes for treatment given to each patient for future reference; backup for such notes is not available. 

c)     Every time when patient visits them, the particular folder which contains the patient’s data is searched, this is very time consuming process. 

d)     In old system, all the information of patient such as operation details, admission details, discharge details is kept in register, which is hard to maintain and insecure as any document can be lost during the storage of register. 

e)     On present the authority on the manual bases that took lot of valuable time and possible chances of error or mistake has presented all the bill of material.

Requirement of  Hospital Management System:- 

1)    The time of every activity should reduce considerably. 

2)    Recently unnecessary records are not to be viewed but should remain in system for possible future use. 

3)    System should have provisions for different users with their various rights. 

4)    Records should not be deleted or modified by simple users. Such rights are given to specialized users only. Also read permission should be differing according to the user. 

5)    System should be easy to sue by the user that is it should be user friendly.

Crime Detection Through Facial Features Project in Vb.Net

The aim of Crime Detection Through Facial Features Project  is “Identification of a person in a crime scene by witness descriptions using Image Processing Techniques”.

Crime Detection Through Facial Features Project in Vb.Net

Video fitting, for image reconstruction and person identification, is a well-known technique popularly used in scientific, industrial, medical and forensic applications. There has been a variety of “Application Software” based on Video fitting developed by a number of people.

Biometrics based personal identification provides a promising solution for this kind of problems. Biometrics features include face, speech, handwriting and finger prints etc. Face identification has the advantage of being a passive, non-invasive system for personal identification. The success of face identification depends on the solution of two problems: Representation and matching. Both the algebraic features and geometric features will be used to represent face images.

The work involved in Crime Detection Through Facial Features Project is:

  1. Obtaining the human face images from different video sources such as CCD cameras, Cam coders, Digital cameras, Scanners, stored images etc.
  2. These images are then digitized and stored in a memory for further processing.
  3. Then each video frame is segmented into different parts. For example, the given video frame containing a human face is sliced into three parts of all the images are then stored in a separate data bank. Similar parts of different images are stored in their respective files.

After creating the respective files of forehead, eyes and mouth, these files are used for reconstructing the images in order to get an identifiable image based on various descriptions.

Conclusion:

The project titled FACE RECOGNITION USING IMAGE CROPPING is developed to design a system that supports to find the criminals in less time. A user with valid user_id and password are only allowed to access the developed system. In this project we store the details of the criminals in database and retrieve them when required. 

           Previously it was difficult to find the criminal manually through files. In  the proposed system we can maintain the details of criminals of all regions in a database so that time required for finding the criminals is reduced.

Online Customer Care and Service Center Project

Online customer care and service center project is a web based application which is designed to provide online service for users to get support from computer repair related information. 

Customer Care and Service Center Project

The Present System

In the present system all the activities are carried out either manually or with the help of word processor. While providing services to its customer they keep the record of the products and customers in spreadsheets/word documents or paper register. In which they manages all records illegibly. Resulting is redundancy of data like customer name and address etc. The detail of their account is also kept their. When any customer takes any kind of services, the charge is calculated manually.

Generally problems are faced in allocating duties of employs. In such environment regular and overtime duties are not maintained properly. This lead to improper calculation of employs payroll and if made properly calculation becomes quite complicated for every employee.

Another problem usually faced by the organization is frequent complain by the customers for not getting timely services. This is because improper working schedule of employees and the method for keeping the records. Here owner has to keep a watch on everything all the time. In this case it is nearly impossible to get the details of the services status whenever required. All this makes the owner the key person to handle the whole working system.

In such kind of management there are no facilities to properly handle the Human Recourses, such as staff information, their attendance and monthly salary, customer information and handling its accounts etc.

Production and Resource Planning System Project in Vb.Net

Production and Resource planning system project is management software useful in companies which manufacture goods. Using this application we can manage resource, customers, work, products, cost details, billing..etc.

Production and resource Management Forms work Flow:

Sales Order Work Process:

By default – for each line item, One sub-part is created, and the subpart is the same as the part # in the line item.

The user has the option to add Sub-Parts to each line item. If they click the ‘Add Sub-Part’ button, another Sub-Item is added to the line item. The User must then choose two different Sub-Parts from Inventory (sub-parts CANNOT be the same item as the line-item Part #).

WorkFolw Continued:

For each line item, the user can add Processes. They must select the box below ‘Start’ and click on the ‘Add Process’ button to pop up this window. The user can then click on the process they would like to add, or add a new process if need be:

Work Flow, Cont:

Note that when a Process is added, A ‘Add New process’ button appears before and after the process. This lets the user add process at any point in the process flow.

For each process, A Supplier must be chosen. If an external supplier is chosen, The a corresponding Purchase Order in the system must be linked. This Purchase Order should automatically populate the Due Date.

In ‘In House’ is chosen as the supplier, this means the part will be manufactured locally (NOT with external Supplier).

Extra fields should appear:        

Equipment:  Select from a list of Equipment.

Employee: Employee responsible for the process 

Finished/Received Button:  When clicked – to notify that the process is complete, the Finished Date should be entered automatically in the ‘Date Finished’ Field.

Manufacturing Resource Planning System Project in Vb.Net

Manufacturing resource planning system project is a web based Vb.Net application. This software is developed for production companies where single software can manage employees, products, stock, orders, planning, report generation..etc.

Manufacturing Resource Planning System Project

Manufacturing Resource Planning System Working:

Supplier Manager

  1. Supplier ID Will Be Generated automatically.
  2. Fill the Supplier Company Name, address etc in the provided textboxes.
  3. After this Click on the Save Button it will pop up a message box if you want to save the Filled Supplier entry press on Yes button otherwise press No.
  4. It will save the data And Entry Filled by you will come in the Right grid, you can see the details immediately filled by you on clicking that particular ID whom you want to see.
  5. If there is need of Update some data’s entered by you then Select the Supplier ID to whom you want to Update and Make the Appropriate changes and press Update.
  6. To add the contact’s information of Paticular Supplier select again from the right grid and it will show the filled information about selected supplier into the Below Grid if information is filled otherwise it will show a blank grid. Then fill the info into Grid and press SAVE ADDRESS Button and data will be save into the database.

Customer Manager

  1. Customer ID Will Be Generated automatically.
  2. Fill the Customer Company Name, address etc in the provided textboxes.
  3. After this Click on the Save Button it will pop up a message box if you want to save the Filled Supplier entry press on Yes button otherwise press No.
  4. It will save the data And Entry Filled by you will come in the Right grid, you can see the details immediately filled by you on clicking that particular ID whom you want to see.
  5. If there is need of Update some data’s entered by you then Select the Customer ID to whom you want to Update and Make the Appropriate changes and press Update.
  6. To add the contact’s information of Paticular Customer select again from the right grid and it will show the filled information about selected Customer into the Below Grid if information is filled otherwise it will show a blank grid. Then fill the info into Grid and press SAVE ADDRESS Button and data will be save into the database. 

Equipment Manager

  1. Equipment ID Will Be Generated automatically.
  2. Fill the Equipment Name, Serial No  etc in the provided textboxes.
  3. After this Click on the Save Button it will pop up a message box if you want to save the Filled Supplier entry press on Yes button otherwise press No.
  4. It will save the data And Entry Filled by you will come in the Right grid, you can see the details immediately filled by you on clicking that particular ID whom you want to see.
  5. If there is need of Update some data’s entered by you then Select the Equipment ID to whom you want to Update and Make the Appropriate changes and press Update.

Employee Manager

  1. Employee ID Will Be Generated automatically.
  2. Fill the Employee Name, address etc in the provided textboxes.
  3. After this Click on the Save Button it will pop up a message box if you want to save the Filled Supplier entry press on Yes button otherwise press No.
  4. It will save the data And Entry Filled by you will come in the Right grid, you can see the details immediately filled by you on clicking that particular ID whom you want to see.
  5. If there is need of Update some data’s entered by you then Select the Employee ID to whom you want to Update and Make the Appropriate changes and press Update.

Inventory Manager

  1. Inventory ID will be generated automatically.
  2. Fill the Part’s Name, Serial No. Etc in the provided textboxes.
  3. After this Click on the Save Button it will pop up a message box if you want to save the Filled Supplier entry press on Yes button otherwise press No.
  4. It will save the data And Entry Filled by you will come in the Right grid, you can see the details immediately filled by you on clicking that particular ID whom you want to see.
  5. If there is need of Update some data’s entered by you then Select the Inventory ID to whom you want to Update and Make the Appropriate changes and press Update. 

Calculating average Marks Mini Vb.Net Project

This project titled calculating average marks is a mini vb.net project which is developed by students to understand basics of visual basic programming language with simple form design features. Main objective of this application is to calculate four subject’s marks average and display on screen.

Calculating average Marks

Calculating average Marks Project Overview:

For schools and colleges we need this type of application with more features added to it to calculate results of each student. In this project there is only option to calculate 4 subjects marks average.

Future Scope:

Students can use this application as reference and add more features like generate reports, enter each subject marks for each student, maintain database for each student and search option to find student details.

For related projects on student management system or college management students students can search in this site for full source code, project report, documentation and paper presentation.

Online Survey System Project Source Code in Vb.Net

Online Survey System Project is a plugin like application which is specially developed for websites to take surveys on different topics. Users can update topics to website using this poll survey, at present there are many websites which are using survey plugins for taking surveys.

Project Introduction:

                Main objective of this application is to help websites owners to use this plugin for taking surveys without developing their own plugin. At present there are many website which uses their own plugins but with this application we can add our own poll details and update to website.

Forms List:

Add Poll:     We can add new poll to the system using this module.

Chart Poll:  Results are shownin the form of chart called graphical user interface.

Poll Admin:  Admin can manage all poll results using this poll panel.

Bank Management System Project in Vb.Net

The main objective of Bank Management System Project in Vb.Net is to facilitate the bank employees as well as providing facilities to the customer.

In this application we have implemented Withdrawal, Deposit, Fixed Deposit, Loan, Customer information, Account Information, Employee information, reports, Account Enquiry etc. The general objectives of this system are as follows:-

1) To manipulate the Banking transactions with instant confirmation for the Withdrawal, deposit, loan etc.

2) To save time and make better accounting system.

3) To increase efficiency of employees.

4) For faster access of data and information.

5) For smooth and fair running of the organization.

6) To increase the spreaded area of the organization.

Bank Management System Project Overview:

By studying about some Banks in your area, we find that, in the various Banks which has not using any computer application for their Banking transaction. Therefore there is no any better performance in banking transactions. So these Banks are losing more time for the Banking transactions such as withdrawal, deposit, loan, etc. And it’s also taking more time for calculation of various amounts and taking more time for finding any particular data and information of the customers

So we have an idea for making your bank’s work performance very fast than the human being. For that we have developed application software for your bank. In our application there are various facilities for your bank such as withdrawal, deposit, loans etc can be performed faster than the human beings. We developed a Bank’s database application which keeps your all Banks’ data and information of the customers for future use.

Our application can search any records as your requirement very quickly than the human beings, for which your staff take more time. This application increases your work performance than previous work efficiency. And it calculates any calculation very quickly and provides approximately 100% efficient result.

So, it is better to keep your database application for your Bank to make a better works, calculations, finding records, storing records and other many Banking transactions.

Grade Sheet Project in Vb.Net

Grade Sheet System Project is a software application developed in vb.net programming language for helping different education institution faculty to automatically generate grades for each subject for each student without any manual calculations.

Grade Sheet Project

Existing and proposed System:

In existing system there are no software used by faculty members of any college to generate grades and calculate percentage. Most of them use manual process to generate report and provide for display. This process is a time taking process.

In this proposed system we have developed a automatic grade generation system where we just need to enter basic information of course, student, subject and calculate grade and show results.

Grade Sheet Project Forms Overview:

There are three main features in grade sheet project

Entering Marks

Generating print reports.

Exit.

Project Functionality:

When application is launched a form is displayed with file menu option which consists of enter marks sheet and print marks sheet and exit options.

User should select marks sheet options which will display form with student details and grade points obtained features.

You can easily understand what are the options available and select respective options to display results and calculate grade.

If you want to change subject details, program details ..etc modify database table which is available with download file.

IF you want to print obtained grade details of student you can select print record options from file menu option where you will find two forms which some options and print record.

IMP :  For admin and guest passwords for login to system you can find in database login file.