Category: MySQL Projects

MySQL is the backend database system, We have developed projects with MySQL DB. Students and Projects Lovers can Download Projects with MySQL Database and enjoy executing.

Posted on

Online Survey System Java Project

Abstract:

The main aim of developing this online survey system is to conduct an online survey on different topics to the users. In this Java Application, the user can take part in various online polls. Admin in this application will add the polls regarding different questions and different topics and he can see the results of each poll in the pie chart.

Existing System:

In Existing System user can poll the votes more than once. Then We cannot get the results of the exact poll that results in manipulation of results.

Proposed System:

In the Proposed system user can vote only once and after that, he tries to vote it says you are already voted.

UML Diagrams:

Online Survey System Use Case Diagram:

Online Survey System Sequence Diagram:

Online Survey System Activity Diagram:

Online Survey System Class Diagram:

Software Requirements:

 NetBeans 8.0.1, JDK 1.8, MySQL 5.5, SQLYog, HTML, JavaScript and CSS

Output Screens:

Fig: Home Page

This is basic View of how the application looks and shows the list of modules used

Fig: Admin Login

In This Page, Admin can log in with the username and password

Fig: Admin Home

After Successful Login, it welcomes with admin home page and shows the basic Functionalities of admin.

Fig: Add Poll

In this page, the admin will add the polls by posting questions and multiple answers.

Fig: Select Question Id

In this admin will see the poll details by giving the question number.

Fig: View Results

After Giving the question number the poll results are showed in Pie Chart Representation.

Fig: User Login

In Thi Page User will login with the username and password.

Fig: User Home

After Successful Login it show the user home page with the basic Functionalities of admin

Fig: View Poll

In this Page user can see the polls Posted By admin and can participated by voting to that question.

Fig: Submit Answer

In this Page User need Select the answer for any particular type question.

Fig: Poll Results via Chart

Posted on

Alumni Event Management Portal Android App

Abstract:

The Main Objective of the Event Management Portal is to maintain communication between passed-out students and students of university or college to know about each other’s current activities. The students can also post and read various articles, thus promoting literary insight. Articles can be seen by anybody who is registered. Based on the requests from the students, passed-out students can conduct webinars on trending topics.

Introduction:

Nowadays, it is very difficult to communicate with our seniors without knowing any details about them, and the only way is to contact the college for their activities, to avoid this we are creating an app where the current students and passed-out students have to register and update their details, through which we can establish a connection between them. They can have a friendly environment by posting their thoughts and ideas which helps in developing their future plans.

Existing System:

The Existing system provides less memory usage for the users. It also has less security for storing data and some data may be lost due to mismanagement. Every time students need to take help from the college in case they want to communicate with the passed-out students. The system does not provide users to post the articles. The system does not provide a facility to track all the activities of the students.

UML & DFD Diagrams:

Use case Diagram:

Sequence Diagram:

Class Diagram:

Activity Diagram:

Data Flow Diagrams:

Modules:

Administrator: The admin is responsible for maintaining information about students When the user submits the registration form administrator will complete the verification process and if successful, the student details are added to the database. The admin maintains the passwords of the event manager and of himself

Student: The student has to register and then log in, Students can view the notification, post a query, and give a reply to the given post, They can stay connected with college alumni

Faculty: The administrator can register the faculty, Then they can log in, add articles, and question papers from the previous year, and they can also answer the query posted by students.

Download Online Event Management System Academic Project, which is developed in PHP, And MySQL database with HMTL, CSS, PHP, and Javascript.

Output Screens:

App Home Page:

Admin Login Page:


Posted on

Secure Web Application on Travel Rating and Exploring Java Project

Abstract:

Travel Rating is a web application developed in java. This Travel Rating and Exploring application enable users to view the information of various places. Admin will add all the information about the various places. The user can search the place details with a category like international and national. Users can view all the details of the places and they can give the description and rating to the place. All the details of places which include the description and ratings can be viewed by guest users.

Existing System:

In the existing Travel Rating system, no proper information is provided. All the information of the location is stored in records which is very difficult to search or make any modification .if the data is once lost can be retrieved. Users need to spend much time in getting the information about places and its details. A lot of time and physical effort is required to get the details of the place.

Proposed System:

The proposed Travel Rating system provides details information about places and enables users to give ration and description. Users can get information about places just in one click by selecting the category which saves a lot of time and physical effort. All the data will be stored in the database without any data loss and can be easily viewed and modified.

UML Diagrams:

Use Case Diagram:

Sequence Diagrams:

Activity Diagram:

Class Diagram:

Modules:

Admin:

Admin needs to enter valid credentials to get a login. Admin can view all the details of registered users and need to activate every user. Admin can add all the details of the places.

User:

The user needs to get registered with the application and need to be authorized by admin. The user can get login by entering unique username and password. The user can view all the details of the places by selecting the category. The user can give description and rating to the selected place.

Guest User:

Guest users can search the details of the places by selecting the category. The guest user can view all the details of the place including description and rating has given by registered users.

Softwares used to develop this wedding Event application below:

Netbeans 8.0.1, JDK 1.7, MySQL 5.5, SQLYog, HTML, JavaScript and CSS.

Project Output Screens Description:

  • Home Page

  • Admin Login Page

  • Admin Home Page

  • User Details Page

  • Add Places Page

  • User Registration Page

  • User Login Page

  • Select Category page

  • Travel Rating Page

  • My Places Page

  • Guest user page

  • Place Details Page

Posted on

Wedding Event Planner Java Project

Abstract:

The wedding planner is a java web application which helps to organize successful wedding events for users. This application provides an easy way to plan their special events. The user can add all the details of the event and can get the service. The user can select the type of event, type of food to be served, type of decoration and estimated budget. All the details given by users will be verified by admin. Admin will add all the details of the planner based on the requirement of the user and send the user’s event details to the planner. The planner will verify and send his response with a confirmation mail. The user needs to complete the payment process to confirm the order

Existing System:

In the existing Wedding Event Planner system, users need to waste a lot of time and physical effort in finding the place for the event and no proper information is provided to the user regarding the event details like food, decoration, and budget. All the information is maintained in records which are difficult to view or modify.

Proposed System:

 The proposed Wedding Event Planner system provides a smart way to users in booking the venue for the event. The user can book the venue from anywhere and at any time which saves a lot of time and not the physical effort is required. All the details given users are stored in the database with high-level security which can be checked frequently and can be modified at any time by authorized members of the application.
UML Diagrams:
Use Case Diagram:
Sequence Diagram:
Activity Diagram:
Class Diagram:

Modules:

Admin:

Admin needs to get logged in by entering valid credentials. Admin can view all the details of the registered users and can authorize them. Admin can add planners. Admin can view users request and will send to the planner. Admin can view planner response and will confirm users request for a venue with a confirmation mail to users.

Planner:

The planner will be added by admin and will get his/her credentials to their mail id. The planner needs to give valid username and password. The planner can view request sent by admin and can give a response to admin.

User:

The user needs to get registered with the applicant by entering all the details in the registration form. Every registered user should be activated by the admin. The user can get login by entering unique username and password. The user can add all the details in the application regarding the event like the type of event, decoration, and budget. Users will get a confirmation mail to his mail id. Users order will be booked after completing the payment process.

Softwares used to develop this wedding Event application below:

Netbeans 8.0.1, JDK 1.7, MySQL 5.5, SQLYog, HTML, JavaScript and CSS.

Project Output Screens Description:

  • Wedding Planner Home Page

  • Admin Login Page

  • Admin Home Page

  • Admin View User Details

  • Admin Add Planner

  • Admin View User Request

  • Admin View Planner Response Page

  • User Login Page

  • User Registration Page

  • User Add Event Page

  • User payment Page

Posted on

Student Performance with Graph & Academic Project Work Reporting System

Abstract:

Student Performance with Graph & Academic Project Work Reporting System is a web-based application developed using Java, HTML, and MySQL Database. This application provides an easy waa y to student in searching the details of projects and details of their academic attendance and marks percentage details the with graph. Students can search the projects with project title or with guide name or with the year. All the details of the projects and details of student’s attendance and marks percentages are added by admin.

Existing System:

In the existing system, all the student information is added manually and the data is stored in the records. Takes a lot of time and physical effort in searching and adding the information. In the existing system, there is a possibility of losing data and no proper maintenance of data.

Proposed System:

The proposed system provides the student an easy and accurate data about projects and academic percentages. Students can view all the information in just one click which saves a lot of time and effort. The proposed system maintains a database to store all the information. In this system, there is no chance of losing data. Adding and searching the information is very easy which does not take much time and physical effort.

Modules:

Admin:

Admin can get login by entering valid username and password. Admin can view all the details of the users and need to authorize them. Admin can upload projects by giving all the details of the project. Admin can add all the details of student’s attendance and marks. Admin can view added students and the progress in a graph.

Student:

The student needs to enter all the details in the registration form. The student should be authorized by admin to get login into the application. A student can search projects based on the title, year and Guide name. Students can view all the details of his/her attendance and marks. Students can view graph for his attendance and marks.

Conclusion:

“Student Performance with Graph & Academic Project Work Reporting System” Java project satisfies all the requirements of students in searching the projects and finding details about his\her attendance and marks. This project also satisfies the requirement of admin in adding all the details of the project and he can easily find the progress of student’s attendance and marks.

Softwares used to develop this project below:

Netbeans 8.0.1, JDK 1.7, MySQL 5.5, SQLYog, HTML, JavaScript and CSS.

Project Outputs Description:

  • Home Page

  • Student Login Page

  • Student Registration Page

  • Student Home Page

  • Search Projects Page

  • Project Details Page

  • Attendance Page

  • Marks Page

  • Graph Page

  • Attendance Graph Page

  • Marks Graph Page

  • Admin Login Page

  • Admin Home

  • View Users Page

  • Upload Project Page

  • View Projects Page

  • Add Attendance Page

  • Add Marks page

  • Attendance Graph

Posted on

Career Analysis Java Project

Abstract:

“Career Analysis” is a web application developed in java & MySQL Database. This project enables users to search information about colleges and college location. The user can get all the detailed information about colleges and course details. Users can select their interested category and branch. Users can get the information of colleges just in one click. Users need to give their rank to know the suitable college for their rank. This application provides required information of the engineering and medicine colleges and the location of the college.

Existing System:

In the existing Career Analysis system, physical effort is needed and proper information is not provided within time. The user needs to go physically to the college and give his rank to know the suitable and available college’s. Complete information of the colleges and course is not provided to users. This system takes a lot of physical effort and time.

Proposed System:

The proposed Career Analysis system provides an easy and accurate way to search colleges. The User can get all the details of colleges and course details in just one click. The user needs to give their rank and find the details which do not require any physical effort and time loss.

Modules:

Admin:

Admin needs to get logged in by entering valid credentials. Admin can view all the details of users. Admin can activate and deactivate users. Admin can add engineering and medicine college details.

User:

The user needs to give all the required information in the registration form to get a unique username and password. The user can select the category branch and need to enter their rank. The user can get the result with the suitable college and its information after entering rank.

Software Requirements to develop this application below:

Netbeans 8.0.1, JDK 1.7, MySQL 5.5, SQLYog, HTML, JavaScript and CSS.

Project Outputs Description:

  • Home Page of Career Analysis Project

  • Admin Login Page

  • Admin Home Page

  • View Users Page

  • Add Engineering Details Page

  • Add Medicine Details Page

  • User Registration Page

  • User Login Page

  • User Home

  • Course Details Page

  • Branch Details Page

  • Search College Page

  • Search Result Page

Posted on

Basic MySQL Command-line Operations Project

Abstract:

“Basic MySQL Command line Operations” is an application developed in using MYSQL.This application has the only module which plays a key role which is an admin

Admin can get logged into the application by entering valid credentials.ADmin can add all the details of the employee like employee name, id, salary, email,

address, mobile no.Admin can update and delete all employee details.

In MYSQL command prompt we need to enter MySQL password to get access.Create a database by entering the database name.

After creating the database we can execute the query.We need to create employee table.After creating Employee table all the details of the table can be

inserted into the table.We can update all the details in the employee table by using an update query.: We can delete the details in the employee table by using delete query.

Modules:

admin:

* Admin login with valid username and password

* Admin can add employee details like employee name, id, salary, email, address, mobile no.

* Admin can update and delete all employee details.

Output Screens with Explanation:

Fig: enter mysql password: To Connect Mysql(Database) here user need to enter password, which we enter at the time of installation.

Fig: create Database : Here we need to create database using SQL Query

Fig: execute query: After executing the given query database will be created

Fig: create employee table: Here we will create a table by giving all the required column names using data types and length with a specific table name.

Fig: insert Employee Details: After creating Employee table all the details of the table can be inserted into the table

Fig: Update employee details: We can update all the details in the employee table by using update query.

Fig: Delete Employee Details: We can delete the details in the employee table by using delete query.

 

Posted on

Vehicle Management System Java Project

Abstract:

Vehicle Management System is web application developed in Java and it is implemented by using windows appliance. This application provides an easy and simple way to sell or purchase vehicles online. Customers can vie wall the details of the vehicles and can purchase the vehicle. Customers can view all the details of the vehicle and send a request if he wants to purchase the vehicle.

Existing System:

In the existing Vehicle system, all the work is done manually which takes a lot of time and effort. It is very difficult to users to view the details of the vehicle and to purchase the vehicle.

Proposed System:

The proposed Vehicle system provides an easy way to find the information of the vehicle. This is an automated system which enables users to view and purchase a vehicle from anywhere and at any time. All the data will be stored in the database in which there will have not the scope of losing the stored information.

Modules:

Dealer:

The dealer needs to register with the application to get unique username and password. The dealer can enter into the application with valid username and password. The dealer can upload vehicle information such as vehicle name, manufacture year, model color and cost.

Admin:

Admin can get log in with valid username and password. Admin can view all registered dealer details. Admin can upload vehicle information like Vehicle name, Manufacture Year, Model Color, Cost.

Vehicle:

A vehicle needs to register with the application to get unique username and password. The vehicle can get log in with valid username and password. The vehicle can view vehicle information like Vehicle name, Manufacture Year, Model Color, Cost.

Customer:

Customer needs to register with the application to get unique username and password. The customer can get log in with valid username and password. Customer views Vehicles and sends a request to sales manager for cost and delivery date. The customer can view sales manager response

Sales Manager:

Sales manager need to register with the application to get unique username and password. A sales manager can get log in with valid username and password. Sales Manager can view customer requests and send vehicle cost and delivery date.

Conclusion:

Vehicle Management System Java web application satisfies all the needs of admin, customer, sales manager, and vehicle by providing fast and accurate information about vehicles.

Posted on

Smart Voting System PHP Website & Android App Synopsis PPT

The main goal and objective of this Smart Voting System application are to help the organization in automating the entire manual process of the existing voting system.

The voting system must be compatible with the multiuser environment.

The Smart Voting System should be able to follow the entire detailed description of candidates and voters.

Development & Working Procedure: 

  1. Create a website
  2. Develop an Android application
  3. Create MySQL database
  4. Authentication and verification through OTP
  5. Prepare hardware

Website:

1) New User Registration via web portal
2) Generate OTP to confirm the valid user
3)Can login to the Website
4) Should fill the Voter Registration form to Vote
5) Upload necessary documents Like ID & Address Proofs
6) Get confirmation mail for participating in the voting process.

Android App:

The Process of Voting is below:

First, the user has to download the android app then log in with their credentials then the user has to register for the voting, where the user getting verification mail / OTP to vote.

Creating database in MySQL:

1.Installation: two Apache webserver software programs with PHP and MySQL database server.

2. Save the voter information in the database. Now tell PHP to search the database for a list of voters and their information that you would like to appear on your site.

3. There are advantages to using this approach:

Instead of writing an HTML page for each voter, he would write a single PHP script designed to look up information in the database and display it.

Benefits

  • Voters can vote from anywhere at any time in India.
  • Save time.
  • Reduced workload.
  • Information available on time.
  • The number of votes will increase.
Posted on

Health Prediction Management System

ABSTRACT

“Health Prediction Management System” is a project which is developed to provide an easy and simple way to both users and doctors communicate with each other directly. In this application, users can search the symptoms of the diseases to the doctor from anywhere and at any time.

The user can also ask queries about their problems online directly with the doctor. Doctors can see all the details of the users and give the answers to their queries anytime.

IMPLEMENTATION

Modules:

Admin:

Admin gets logged into the application with a valid username and password. Admin can view all the details of the user and doctor.

User:

The user should give all the details in the registration form to get registered in the application. The user will be given username and password after registration. The user can consult a doctor by selecting the symptoms of the disease. The user can send a query directly to doctor. The user can get the response in view feedback field.

Doctor:

The doctor should give all the details in the registration form to get registered in the application. The doctor will be given username and password after registration. The doctor can view users query and send them to reply.

SCREENSHOTS

HOME PAGE

Application main page displays main modules like Admin, User and Doctor.

ADMIN LOGIN PAGE

Admin login page in which admin can get logged in by entering valid username and password.

ADMIN MAIN PAGE

Admin main page displays modules like view users and view doctors.

VIEW USERS PAGE

Admin view all details of users in user details page.

VIEW DOCTORS PAGE

Admin view all details of doctors in doctor’s details page.

USER REGISTRATION PAGE

Users need to fill all the details in the registration page to get username and password.

USER LOGIN PAGE

User can get login by entering unique username and password

USER MAIN PAGE

User main page displays modules like search and doctor feedback.

USER SEARCH PAGE

Users search page enables users to select options and find the result.

USER SEARCH RESULT PAGE

USER VIEW DOCTOR INFORMATION PAGE

USER VIEW DOCTORS FEEDBACK PAGE

DOCTOR REGISTRATION PAGE

Doctors need to fill all the details in the registration page to get username and password.

DOCTOR LOGIN PAGE

The doctor can get login by entering unique username and password.

DOCTOR MAIN PAGE

Doctor main page displays modules like view feedback.

DOCTOR VIEW FEEDBACK PAGE

The doctor can view the details of users query in view feedback page.

DOCTOR REPLY TO USER PAGE

The doctor sends a reply to the user.

CONCLUSION

Our project “Health Prediction Management System” provides an easy and simple way to users and doctors to communicate with each other. Our project also saves lot of time and effort to both users and doctors.