E-Students Consultancy .Net Project using C# and SQL Server

The E-Students Consultancy project is a comprehensive web application that is most useful for simplifying the testing process. Its role is more visible in the business environment, as well as in other types of sectors. The system simplifies the testing process by assessing the student’s abilities and fitness. Because the world is a competitive world, it is difficult to examine every individual, and it can also lead to misunderstandings or inaccurate results.

This system is useful for managing the student inspection process; A new user of this system can register his identity to access its features. After successful authentication, this system generates a set of individual questions for users; The user can make their choice to select the correct option from the target test. After filling in the answers to each selection question, the questionnaire ends with an automated process of the system.

This system manipulates the results of the questionnaire, showing the set of skills of each user, creating a survey on the results, and helping the organization or any commercial sector to choose the right person for the ideal job.

existing system

In this modern world the existing online job searching system provides minimum secure authentication for the students that’s why the resulting process takes so much time. Students have to wait for a period to know the result of the attended online tests, even if it may take a month or a while. Each and every student are forced to register their identities on the consultancy site for the job and they have to wait until the respective persons respond to their registration.

So there is a chance to miss the other opportunities from others. Students are required to pay for getting the premium details (like Contact details) of the registered companies. To avoid this type of problem a new method of consultancy portal is required.

Disadvantages

  • Provides minimum security means for individuals
  • The major disadvantages of this system are low efficiency and time consumption. 
  • The maintenance cost of the existing system is high and it should be barred by the students only.
  • Students feel hesitation and there is an opportunity to miss other opportunities.

Proposed System

In this proposed approach individual secured authentication means are provided for each and every student and company, the student can enter into the system with proper identities, so it is easy to find the fraudulent people if any mismatching occurs. The E-Student Consultancy provides a bridge between students and corporate, which leads to attaining job offers and online test scenarios. Free access is provided so the students and companies can attain the details securely without any delay. The online test generation process allows the student to feel free and attend the test to know their individual talent. The result will be delivered immediately once the test is over. This system is used to test the students and their eligibility level.

Advantages

  • Secured login mechanisms are handled.
  • Reducing the workload of the companies and students.
  • Time consumption is comparatively good.
  • Easy access and Online Test Procedures make the students feel free to work.
  • Results will be delivered to students instantly.
  • Implementation and maintenance cost is low.

Modules:

AUTHENTICATION Module

REGISTRATION Module:

The E-Student consultancy provides two types of registration processes on the company side and the student side, in the company side the registration process depends upon the company name, contact details, and vacancy then creates the complete registration process. On the student side, the registration process is based on the personal detail like name, Mail Id, address, etc

COMPANY DETAILS MANIPULATION Module:

The company details manipulation process allows the user to create the company details with proper identities. The following details are required to register the company into the server: company name, contact, and the number of vacancies available in the company. These details are registered into the server, which is useful to the students to find out the company details and the number of vacancies available in the company, and address of the company. This is used to view the job vacancies in the company and reduce the job search time.

ONLINE TEST REGISTRATION Module:

The online test manipulation process is one of the major implementations in this e-student consultancy. That is used to test the student’s ability and fitness for the job. In the online test generation module questions are created by the company individuals and then it will be uploaded into the portal for student access. The students can register and attend the test which is created by the company individuals. The student’s mark will be calculated by the server at the time of completing the test. The student mark denotes whether a particular student is eligible for the job or not.

RESULT ANALYSIS Module:

The result analyzing process is used to generate the result for the test which is attended by the student online and the test generation process creates the result immediately once the student answers their last question. Once the mark is generated then it will immediately be transferred to the respective student mail.

Download E Students Consultancy Project.

Nearby Hotels Python Web Application

This is a simple web application that can be used to search hotels. This application will help in searching nearby hotels and also give weather reports of that place such that they can know the weather details priorly to near that hotel in order to travel. A currency converter is included with which everyone can view hotel prices in their desired currency. Additionally, discount coupons are included, which will help user to access the cheapest hotels nearby.

API’s to be used:

Google maps:

The google maps API fetches the data from google e.g. here Maps API is a server that returns information about a place, an establishment, a geographical location, or a prominent point of interest using an HTTP request. Methods are available for place search, details, and autocomplete queries.

The place API returns in JSON format.

Currency converter:

Planning to use online currency converter API web services. This API allows covering the currency to whatever the users needed.

This API returns data in XML format.

Weather API:

This API forecast the weather near the hotels, which uses information from the Rapid API: this API has all the information like temperature, humidity, wind, etc..

This API returns data in JSON format.

Discount coupon:

Planning develops discount coupon API, which gives what best hotels are available nearby with the best discounts possible.

This API returns data in XML format.

Technologies used:

  • JavaScript
  • HTML
  • CSS
  • Nodejs
  • Python

Restaurant Management System Database Project using PHP, MySQL/MS Access

The aim of this project is to create a Restaurant Management Database (RMD) is an online application for restaurant management. This system wakes to provide service facilities to restaurants and to the customer. The services which are provided are food ordering, reservation of the table by the customer through the system online, menu information management, and report.

The main goal of this project is to make the customers satisfied to get the food from anywhere

  • To develop the online ordering and reservation system in restaurants.
  • To develop a user interface for an online restaurant management system to provide online menu information for customers to order

Project requirement

The basic requirement is to make the customers log in and order their favorite food online. To do so they need to look at the menu. Thus, there must be a menu with quantity and price options. Thus, these basic requirements are addressed for now.

Mission statement

The objective is to help the customer to order food online and get them delivered through an interactive application.

Objectives

  • The application should support customer registration
  • Registered customers should gain access through username and password
  • There must be an interactive menu with all details
  • Customers should be allowed to browse the menu
  • Customers can place an order by adding the menu item to the cart.

Interview Questions

  • What tables are needed for the system?
  • How will we ensure that there are no duplicate records in the database?
  • How will the customer know whether the item is available or not?
  • What navigational options are good for customers?
  • How do secure customer payment information and personal information?

ER Diagram

Tables

Product ID

Product name

Details

Status

Price

Int

char

char

char

Currency

 

user_id

username

password

address

mobileno

email id

int

char

varchar

varchar

number

varchar

 

cart_id

user_id

product details

product_id

quantity

price

int

int

char

int

int

currency

 

delivery_id

user_id

delviery status

duedate & time

int

int

varchar

date  time

 

Reservation_id

User_id

Name

date

table choice

time

int

int

Varchar

date

int

time

Output Results:

Admin Dashboard:

All Orders Details Page:

Restaurant Management Table booking Admin Page:

Popular Dishes Page:

Here you can freely download the complete Restaurant Management System project Source code with both MySQL and MSAccess database code, User Manual Report.

Student School Record Keeping System Application Database Project

Project Background

Efficient management of student-related information becomes challenging for any educational organization when the volume of data and operations over that data increases. Information systems and database systems are the needed tools that help in the efficient management of such large volumes of data. These systems not only manage the data but even help in the easy retrieval and processing of useful information.

Vision

This project work vision is thus to come up with an efficient database management system that is capable of maintaining student records for an educational organization.

Project Objective

The objective of designing and implementing such a database management system is to manage the student records in a proper and organized manner, enable data flow and information flow among various activities related to student information processing, and secure the student data.

The project scope is as follows:

  • To come up with an efficient database management application for student record management.
  • The application shall help to add student records like their personal information, fees-related information, scholarship-related information, course-related information, and marks-related information.
  • the application shall allow to edit or delete any student record based on authorized permission
  • The application shall allow generating reports like marks statistics, feed duellist of students, etc.
  • The application shall have access based on authorization and role-based authorization shall be enabled for read and write processes.
  • The key information like payment, and a password shall be stored in encrypted form for security purposes.

Value proposition

This database application shall help the educational organization to keep track of all the student records and manage them in a more efficient manner. It shall reduce the number of manual errors, do the student record processing task in quick time and thus reduce human effort. It shall enhance the student and teacher experience in generating reports and getting key notifications.

Technical development plan

The existing system makes use of excel based records. These are file-based systems. The biggest challenge in this system is that there are more duplicate records due to the lack of any control mechanisms that control duplicates. Database management system makes use of a primary key that is unique and it is capable of identifying any unique record. Thus, it is a way of eliminating duplicates.

The existing system is not user-friendly to use as they lack user-friendly APIs. With supporting scripting languages like PHP, CSS, and Java Script it is possible to come up with an interactive GUI. Such GUI helps the user to do the tasks in a more efficient manner.

Thus, the proposed system shall make use of the following:

Front end: PHP

Back end: MySQL

Web Server: Wamp server

Operating system: Windows 7 and above.

Development Methodology

The application development shall adopt the Rapid application development methodology and develop the application in a small set of tasks. The objective shall be to come up with a rapid prototype and iterate it as per the testing results. The development process shall begin from starting from system requirements, system design, coding, testing & debugging implementation & maintenance. It shall be an iterative process.

The development tasks shall be small manageable tasks. This shall make project monitoring and management easier.

Requirements Analysis

The first functional requirement of the project is to have an application capable of adding and managing student records.

Thus, the application should allow Admin to do the following

  • Add student: to should allow the admin to add student details like name, enrolment id, contact address, course enrolled, subjects, date of birth, address, gender, and other details.
Activity diagram depicting adding or deleting student
Activity diagram depicting adding or deleting student

Figure 1: Activity diagram depicting adding or deleting student

  • Manage student: to allow the admin to view student records, delete existing student records, and edit or update any existing student records.
  • The application should allow the admin to add marks, manage marks and generate a result
  • The admin can add subject or course details.
  • The application should allow the admin to generate lists of students who have not paid fees and those who have availed of scholarships.
  • Manage user records and change passwords

Students can do the following:

  • The application should allow students to register,
  • view result and download result

Conceptual diagram

Student record system overall architectural diagram

Figure 2: Student record system overall architectural diagram

Tasks of Students and Admin are explained in the figure below:

Figure 3: Task in detail

Interview Questions

With front-end designer:

  • What entries are needed for a student form wherein details can be entered?
  • What entries are needed for the resulting form so that admin can add marks for the students?
  • What entries are needed for the course and subject form?

With back-end designer:

  • What columns should be used for a student table, result-in table, course table, user table, and fees table?
  • Which column should be the primary key to help in unique row identification?
  • How to connect the front end and back end?

Tables

Student table:

Student_id

first name

last name

gender

age

Date of birth

Contact no

address

City

CourseId

email

Password

Primary Key Varchar (10) Unique

Varchar (30)

Varchar (30)

Varchar (30)

int

date

int

Varchar (100)

Varchar (30)

Varchar (30)

Varchar (30)

Varchar (30)

Course table:

Course_id

Course name

Subjects

Primary Key Varchar (10) Unique

Varchar (30)

Varchar (30)

Subject table:

Subject_id

Subject name

Course_id

Primary Key Varchar (10) Unique

Varchar (30)

Varchar (30)

User table:

User_id

username

password

role

Primary Key Varchar (10) Unique

Varchar (30)

Varchar (30)

Varchar (30)

Result table:

Result_id

Student_id

first name

last name

Course_id

Subject_id

Marks obtained

Total marks

Grade

Primary Key Varchar (10) Unique

Varchar (30)

Varchar (30)

 

Varchar (30)

Varchar (30)

Int

int

Int

Student Record System Application Manual

Software required: Wamp Server, MS Access, ODBC driver, and Windows 7 or above operating system

  1. Extract the Zip file as an SRS folder.
  2. Install Wamp server
  3. In the www folder of the Wamp server Copy and paste SRS complete folder
  4. Open the Wamp server and start all the services
  5. The SRS folder has a database file named srms.mdb file.
  6. Open odbc driver by clicking on data sources.
  7. Click Add and select Microsoft Access Driver .mdb and accdb.
  8. Enter the Data source name as srms and select the folder path where the srms.mdb file is i.e. C:wamp/www/SRA/srms.mdb
  9. Click finish and see that the srms.mdb is listed as the new database.
  10. Now open a web browser and type URL localhost/SRS

This shall open the home page

  1. The admin can enter the application through username and password as admin and admin

  1. From the dashboard the admin can navigate to any sections like course, fees, subjects, students, results, etc.

For example Admin wants to add a student

  1. The student form opens wherein the student details can be entered.

In this way results, courses, subjects, etc can be added and updated.

On the student end, the student can enter the application through the Roll number as a password and select the class from the dropdown list.

  1. On entering details if the results are not ready you get

Otherwise

From where the result file can be downloaded.

ER DIAGRAM

Download Student School Record Keeping System Application Database PHP, MySQL, and MSAccess Project Code and Database.

Three Layer Security Login Java Project

Security system authentication application is designed to provide a three-layer login procedure for any application. Most of the login security methods have three procedures which are password-based login, OTP-based login, and login and OTP combined authentication procedure. These methods can provide login security for users to a certain level but some application requires more authenticated methods which are mainly useful for banking and payment methods.

In this project, three-layer login methods are developed which have password login, image selection then OTP login.  In this application when a user registers with the application user fills out the registration form with the image selection option which is stored in a database. Whenever the user logins to the application first user need to give a password if that is correct second stage image selection should be done if the image is correct then OTP is given then the user can log in to the application.

OBJECTIVES:

The main objective of the three-level security system is to provide advanced security to web applications and to prevent unauthorized access.

EXISTING SYSTEM:

Text passwords are the most commonly used technique for authentication and have several drawbacks.

Graphical passwords provide a promising alternative to traditional alphanumeric passwords due to the fact that humans can remember pictures better than text. 

PROPOSED SYSTEM:

A simple graphical password authentication system that consists of a sequence of ‘n’ images and the user has to select the click points associated with the correct image for successful login.

The task of selecting weak passwords is more tedious, discouraging users from making such choices.

We proposed this security system as a building platform to access the system.

SOFTWARE REQUIREMENTS:

  • Operating system:  Windows XP/7.
  • Coding Language:  Java
  • Tool: Netbeans
  • Database:  MYSQL

Platform for Conducting Online Examination through Websites PHP Project

Examinations are part of an education system where every institute is using an online platform for conducting examinations through websites. Existing methods mostly work on manual methods where there is a need for human resources, use of paperwork, and time-consuming process.  

In order to solve this problem and provide an effective platform for institutions and students, an online examination platform provides the best solution. This web Online Examination platform has simple features which cover admin, teachers, and student modules. Admin can view students who are registered with the application and add teachers based on department and view tests and marks of students.

Teachers can log in with a valid username and password and upload test detail with questions and times for each test along with positive and negative marks for answers. Students can register with the application and select a test and take the test. Students can view marks, results, ranking, and history.

PROBLEM STATEMENT:

Conducting online examinations needs a planned process where resources and time are important. It is not possible to conduct exams where students can write exams from any location.

OBJECTIVE:

Developing an online examination system that works on a web-based platform can help in conducting exams from any location in a short span of time and students from any location can write exams.

EXISTING SYSTEM:

Colleges and institutions conduct exams through examination centers where each student is provided with seat allocation and time. Based on that user need to be available at that location and time and take the test.

DISADVANTAGE:

This method needs a user available at that location.

Resources and costs are involved in the examination process.

PROPOSED SYSTEM:

The proposed Online Examination system works on the online web portal where students, admin, and lecturers can be part of this portal by registering with the application.  Admin will add teachers and students can register with the application and view all tests available and take tests and view results and ranks.           

ADVANTAGE:

Students and institutes can save time by conducting exams online.

The entire process is online students from any location can take tests.

SYSTEM REQUIREMENT:

Programming language: PHP

Database: Mysql

Server: Tomcat, xamp server

Front End: Html, CSS, Javascript.

Citizen Card System Java Project

Abstract:

The project ‘Citizen Card system’ provides us the data regarding the citizen of a country. Every citizen has a unique Id to trace the personal data in each and every division or service that he enters. The data can be traced using the unique Id of that particular city.

In case a citizen wishes to use the services or utilities of the Government or private institutions, he ought to go to the various divisions with varied IDs for that specific division. But a citizen card allows the citizen to enjoy all the services and utilities under a single card. The citizen card system assists us in gaining data regarding the services or utilities as well as providing data regarding the conduct of the citizen in credit rating.

UML Diagrams:

Use Case Diagram:

Sequence Diagram:

Activity Diagram:

Class Diagram:

Existing System:

The existing system is a system operated by humans and the citizen requires to reserve his data through excel sheets or disk drives, but there is always a risk of losing the data due to mismanagement.

Proposed System:

The proposed system is more user-friendly and makes the entire project maintenance very uncomplicated and manageable. This system motivates people to get the Citizen Card, which is a multi-purpose card. This is a socially responsible website and functions on the principles of citizen data and strengthening citizen safety in the country.

Output Results:

1. Homepage


2. Admin Login Page

3. Admin Home Page

4. View Users


5. Citizen Registration

6. Citizen Login


7. Citizen Home


8. View Profile

9. Insurance Info

10. Electricity Bill Payment

11. Bank Bill Payment

12. Gas Bill Payment

13. RTO Bill Payment

Software Requirements:

  • Operating System:  Windows
  • Database:  Oracle
  • Technology :  Java/j2ee,JDBC,Servlets,JSP
  • Web Technologies:  Html , CSS, JavaScript
  • Web Server:  Tomcat
  • IDE: Eclipse/ Net beans

Online Job Portal Java Project Report & Source Code

Objectives of the project:

  • Registration
  • Login
  • Authenticating
  • Updating Profile
  • Posting a job and removing or modifying job
  • Searching for a job
  • Taking online exam
  • Feedback

LITERATURE SURVEY

There are many applications developed related to this Online Job Portal, but, however, these systems are very complex for their own purpose. Most of them do not have the centralized database and easy access to users. So in this project, we are implementing this application through a centralized database and easy-to-use access for job seekers and job providers. The administrator is the primary actor to maintain the database, and also accepts comments from job providers and job seekers to improve and develop the application’s graphical user interface. Registered job seekers can also take the company online exam. In addition, qualified applicants can be classified according to this system based on their qualifications and company requirements.

Limitations

• The current Online Job Portal system is not a fully computerized and manual system for entering job candidates and job provider data and managing it.
• There is no centralized database maintenance
• There is no easy access to records of people seeking work in particular
• Job seekers can not easily navigate through the database

Benefits

• It is a fully automated system for managing the Online Job Portal database
• This system provides centralized database maintenance
• This system provides easy access to certain job seekers or their complete details
This system gives job seekers easy to navigate through the application to get more information in the most secure way.

IMPLEMENTATION

5.1. MODULES

The system is divided into three major parts depending upon the requirement they are.

  • 1) Administrator
  • 2) Job Provider
  • 3) Job Seeker

Administrator

All the users are controlled by admin. Administrator services are

  1. view job providers
  2. view job seekers
  3. view feedback

Examination

The job providers prepared questions and update the providers and conduct examinations to the job seekers and also send the particular examination results.

And the job seeker searches the particular job then attends the exam and also views his results after completion of the exam.

Software Requirements: 

Operating System: Windows XP/2003 or Linux/Solaris

User Interface: HTML, CSS

Client-side Scripting: JavaScript

Programming Language: Java

Web Applications: JDBC, JSP

IDE/ Workbench: Eclipse with My Eclipse Plug-in

Database: Oracle

Server Deployment: Apache Tomcat 6.0

Screen Shots:

  • HOME PAGE
  • LOG-IN PAGE
  • ADMIN PAGE
  • JOB PROVIDERS IN DB
  • JOB SEEKERS IN DB
  • FEEDBACK PAGE
  • JOB PROVIDER PAGE
  • UPDATE PROFILE PAGE
  • ADD NEW VACANCY PAGE
  • SEARCH JOB SEEKER PAGE
  • RESULT PAGE FOR SEARCH JOB SEEKERS
  • EXAM MANAGEMENT PAGE
  • PREPARE EXAM PAPER PAGE
  • PREPARING QUESTIONS PAGE
  • ADDING QUESTIONS PAGE
  • RESULT PAGE FOR SEARCH JOBS
  • EXAM MANAGEMENT PAGE
  • TAKING EXAM PAGE

TEST CASE REPORTS 

Name of the page: Admin Login

Sno TEST CASE Expected Result Actual Output Remarks
 1 New Admin logged on without sign in. Should return a message sign in  before log in. Sign in First Success
2. Invalid password Enter correct password Wrong password Success
3. Invalid username Invalid User Enter valid name Success
4. Special character entered in password field. Verify your password You Entered Invalid password Success

Name of the page: Job provider Login 

Sno TEST CASE Expected Result Actual Output Remarks
 1 New provider tried to log on without sign up. Should return a message sign up  before log in.   Failure
2. Invalid password Enter correct password Wrong password Success
3. Invalid username Invalid User Enter valid name Success
4. Special character entered in password field. Verify your password You Entered Invalid password Failure

 Job Seeker Login 

Sno TEST CASE Expected Result Actual Output Remarks
 1 New seeker tried to log on without sign up. Should return a message sign up  before log in.   Failure
2. Invalid password Enter correct password Wrong password Success
3. Invalid username Invalid User Enter valid name Success
4. Special character entered in password field. Verify your password You Entered Invalid password Failure

Name of the page: Exam Management 

Sno TEST CASE Expected Result Actual Output Remarks
 1 Provider tried to add exam paper without scheduling Schedule first NULL Failure
2. Seeker tried to write same exam again exam already taken Can Write Failure
3. Displaying a message after time up in exam Time up Time up Success
4. Selecting exam before scheduling date Invalid test NULL Failure

 

Booking Photography Java Project

Abstract:

Booking photography is a project which will enable customers or clients to book professional photographers online. It is difficult for those who want to book a photography session to request their favorite photographer since the process was done manually. By having this system, it will be easier for them to make their booking.

Booking Photography Java Project

Existing System:

In the existing system process of booking photography sessions was done manually by phone calls or drop-by at their place. It is hard to track the availability of the photographer and to manage all the bookings made by customers.

Booking Photography Gallery Page

Proposed System:

In the proposed system all the data is maintained in the database which is safe and easy to retrieve. Users can book the photographer anytime and anywhere. Users can know the location of the photo shoot.

Modules:

User:

The user module can get register as a new user and login for booking. Users can book their favorite photographer. Users are able to view the status of the booking. Able to check the availability timetable of the photographer

Admin:

Admin can get a login. Admin can add or change the bookings. Admin can check and approve or cancel customer’s booking.

Software Requirements:

Language:           Java

Web technologies:           JEE (Servlets/JSP)

Front-end Design:           Html, CSS, JSP, Bootstrap

Database:           MYSQL

Scripting:           JavaScript

Conclusion:

Booking photography is a system that satisfied the requirement of the user by booking the photographer from their location. This system fulfilled the desire of the users to select the photo shoot at their dream place. Users can know the status of their booking in the system.