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

Advertising Management PHP Project

In The Existing System The Advertising Management System Project is going by Manuals keeping all the information in books or records no data base is used at all so no security to data.

The objective and scope of my project:

Is to record all the details of various activities of users. It will simply reduce the paper work and simplifies the task. For implementation every user will be requires some basic training to suit their specific needs. Within academic calendar specific support can be provide. This Project has been made keeping in mind the point that it will be use by academics, students and administrators and applicants. So it is very user friendly for everyone

Proposed System:

Some more Advantages of Advertising Management project can be found below:
1) Enhancement: The main objective of Advertising Management is to enhance the existing system by increasing effectiveness and efficiency. This project will generate a new thought in public and replace user manual system with the computer-based system.
2) Accuracy: Advertising Management provides all accurate information regarding the users etc. There is very less chance of being mistake. If any mistake taken place then it will be due to manual mistake not by the system.
3) Automation: Advertising Management automates every activities of the manual system thus it increase its output. In this way response time is very less and it also works very fast.
4) Fully User Friendly: Advertising Management is fully user friendly ,so user feel very happy to work on it. User never complaint any problem that is why it is being used by many peoples.
5) The transactions reports of the system can be generate and retrieve as and when required. There is no delay in availability of information.
6) Maintenance cost: Maintenance cost of Advertising Management is very low it is approximately equal to Zero.

Modules

Login

  • The Login screen is required to allow only validated users to use the application.
  • The Login screen, allows the user to enter his/her User Id and Password. On validating the user he/she is redirected to the next page depending on whether he’s staff or manager.
  • In case the User forgets his password by clicking on the forgot password link, he’s directed to another page which displays a message stating ‘password has been sent to his mail id’. This is done only when the User enters a valid user id.

Staff

Manager Report

SYSTEM REQUIREMENT SPECIFICATION:

HARDWARE SPECIFICATION
• Processor : Intel Pentium IV 1GHz
• RAM : 256MB (Min)
• Hard Drive : 5GB free space
• Monitor : 1024 * 768, High Color inch
• Mouse : Scroll Mouse(Logitech)
• Keyboard : 104 keys

SOFTWARE SPECIFICATION
• WAMP — Web Application Server
• PHP — Server Side Scripting Language
• MySQL — Database
• XHTML — Extendible Hypertext Markup Language

Posted on

Web Traffic Analyzer Tool PHP Project

ABSTARCT

It is a web traffic analyzer tool which helps you to keep track on website traffic. You can monitor the website traffic. You can measure your website Popularity around the world. You can find how much peoples have visited on your website, which is coming to your website, from which country, from which operating system, through which keyword.

Existing System:

In The Existing System We Dot have any tool to trace the information about the website like how much people have visited that web site or from where its open all that is not stored any where

Draw Backs:-

  • No Security
  • No Tracking of users
  • No Data Storage

Proposed System & Features

  • Which pages did the visitors click on while visiting the site.
  • How much time was spent on each page?
  • Search Engine Optimized (SEO).
  • Through which keyword almost the visitors are coming to your website.
  • Which source Did the peoples who are visiting to your website.
  • How many visitors are on online on website i.e. at Real Time.
  • What Is the Bounce rate og webpage on website.
  • How many times a particular page has been viewed by visitors
  • How many visitors from which country have visited your website.
  • Works in all Browser i.e Firefox,Opera,IE
  • 24/7 email & technical support

SOFTWARE SPECIFICATION

  • WAMP — Web Application Server
  • PHP — Server Side Scripting Language
  • MySQL — Database
  • XHTML — Extendible Hypertext Markup Language

IMPLEMENTATION 

Modules:-

  • Login: – By using this module the users can login in to the website by giving the user name & Password. for security we are using this module
  • Registration: – This module is for taking the data of all the users who are using our website tool and will save all the information about the users who are using our application.
  • Intuitive interface
    Managing website by admin requires no any special skills or programming skill. You have to just know how to use a browser. All the functionality is inbuilt in the Website Analysis Tool  It was built to be simple and readily usable!
  • Security
    Website Analysis Tool provides full security to your details. It is protected by Username and password. You should change password after some time for security purpose.
Posted on

Bug Repository Java Project

OBJECTIVE:

Identifying and storing the bug in Data Base and also giving relevant information about the bug

ABSTRACT

Bug Repository is the system which enable to store and detect the bugs. It not merely stores the bugs but provides the complete information regarding bugs detected.Using this no bug will be unfixed in the developed application.

EXISTING SYSTEM

In the existing system, the developer has to manually record the occurrence of each bug. This might lead to some errors as he might not record the minute or negligible bugs.

PROPOSED SYSTEM

The project that is going to be built will have a Data Base which keeps a record of commonly occurring software bugs. It will have details about the type, occurrence, severity of the bug. Once the bug is detected, it automatically gets stored in our records.

TECHNOLOGIES USED

• Language:Java
• DataBase:MYSQL

Posted on

Online Form Requesting System Java Project

ONLINE FORM REQUESTING SYSTEM

Abstract:

Online form requesting system is a project which is used to request a form from our personal mobile instead of going to the administration offices and filling up all the details and waiting to receive for the forms .BY using this online form requesting system users  can apply  for the form from anywhere. This is controlled by admin. Admin will accept the requests and sends an sms to the user to receive the form needed.

Existing System:

Traditionally, online form request is not existed this form request existed manually in the collage. All the form requesting is done manually which takes lots of time. To apply any form students need to submit application by hand.

Proposed System:

In the proposed system we can implement an android app of requesting for forms(Example: custodian, bonafide and transfer certificate) . In this application a list of passed out students is maintained and students can also apply for transfer certificate online. As soon as they receive sms from the admin they can come and collect the form .

Online_Form_Request

Modules:

Admin:

Admin can get login. Admin can add or change the options in the application. Admin can check and approve or cancel users requirements. Admin will add new questions and new topics. Admin can view the application.

Student:

Student can get login by filling the registration form. Student can apply for any application online. Student can fill the application form, update profile and view status.

Software Requirements:

Operating System                   : Microsoft Windows 2007/XP

Languages                               : Java Programming Language.

Database System                    : MYSQL

Conclusion:

Our project online form requesting system has successful in receiving any type of certificates/forms from the college, we have to do lots of stuff like submitting letters , filling forms etc., but our project has introduced online submission process which saves lot of time.  Our application can help students/users to avoid all these things by implementing an application. Our application has successfully implemented in sending a request to receive any type of forms from the collage.

 

 

Posted on

Online Project Management System in Educational Institutes

ABSTRACT
“Online Project management system in educational institutes” can act as a bridge between the students and faculty members. Students do number of projects in their academic year to which a lot of faculty support is required. By using web based application, students can know information about their faculty and their area of interest and based on that information students can get registered to the respective faculty members.

Here in this project students can communicate with their faculty at any time through chat communication barriers. Transparency about student project can be obtained by using project management system. All the projects which are performed can be viewed through project management system. Project coordinator acts as admin. Admin has authority over student distribution in project groups.

Online Project Management System

OVERVIEW
“Online project management system” is an education based website, which helps the students and faculty to get all the resources about the projects available online. Students can access this website anytime and from anywhere. It is reliable & time efficient approach compared to all links of the website provided by any search engine while searching for course materials.

EXISTING SYSTEM

In manual system, students can get information about the projects provided by other students manually or through online resources such as Free Engineering Study Materials and Youth4work. But in this system, students may not get the related and sufficient information according to our syllabus. The above resources do not provide discussion forums between student and professor to clarify their doubts. There is no proper guidance to the students.

PROPOSED SYSTEM

The main aim of this system is to provide sufficient resources regarding to our college students projects according to our syllabus from which students can easily download study materials of their relevant course. The first step is to register in order to access this website.

In this system, we are providing discussion forums between student and professor where students can easily clarify their doubts about their projects. Students can upload their report regarding their project where the faculty can have all the detailed information about the project. Modules of this website are Admin, professor, student, mentor, publisher, discussion forum, security and authentications, reports.

 ADVANTAGES

• This creates a user-friendly environment and encourages active learning.
• It provides simple study materials which a student can easily understand.
• This is a student-centered learning.
• Provides quick responses to students in clarifying their doubts.
• Being available to students on an extended basis electronically

Software requirements:-

Operating System : Windows XP/7/8 Programming Language : JAVA Technology : J2EE (Servlets& JSP) Front End : HTML, CSS and JavaScript Data Base : MYSQL 6.0. Web Server : Tomcat 7.0

Posted on

E Tuitions Java Project

Abstract:

E-Tuitions  is a collaborative teaching tool to assist the students to learn in an interactive manner. The main aim of the E Tuitions Java Project is to complement the efforts of teachers to integrate technology and link the students to the Internet in educationally productive ways. This E Tuitions Java application  also provides students a stimulating, positive and enjoyable environment to study. E-tuitions provides a friendly interactive environment.

E Tuitions Java ProjectExisting System:

In the existing system students cant post their questions or find answers in less time. There is lot of communication gap between student and faculty. Student cant retrieve the information about missed classes. All the data or records are maintained manually which takes lot of time in searching. Information in the ppt’s or video classes can’t be updated or edited. Need special focus on maintaining the records. Misuse or loss of data may cause sometime.

Proposed System:

The proposed system maintains all student information in the database. Information can be entered online. Faculty can post answers online where student can see the answers within no time. Student can save video classes and learn anytime and anywhere. Time can be saved and don’t need any special maintenance. Information once stored can be updated, edited and deleted.

Modules:

Student Login Module:

This module enables students to get logged in or sign up if he/she is not registered . Student can edit their profile. Student can view the details, list, ppt’s  and interactive video lessons categorized by subjects which are posted by faculty. Student can ask questions and find answers for their questions.

Faculty Login Module:

Faculty module  enables a person to login as a faculty member or sign up if he/she has not registered. Faculty can edit their profile. Post  or remove details of the study materials and video lectures.

Administrator Login Module:

Administrator is the ultimate controller of the application with the highest authority. Student/Faculty registration details can be viewed by the admin. Admin will Add or delete the requests send by students/faculty.

Software Requirements:

Language                                :           Java

Web technologies                   :           JEE (Servlets/JSP)

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

Database                                 :           MYSQL

Conclusion:

From the above discussion we conclude that Implementation of E Tuitions Java Project has been satisfactorily performed the tack of educating students online. Using this application students can experience online learning effectively. The flexibility and global nature of e-tuition has led an increasing number of e-tuition enrollment. With the progressive form of technology e-tuition has grown tremendously. E-tuition application has some disadvantages as we discussed above. Inspite of certain  defects, e-tuitions is very useful application to students.

Posted on

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.                  

Posted on

Credit Card Approval System Project in Java

Abstract:

Credit Card Approval System is developed to record the details of various activities of the user. This Credit Card Approval System is used to overcome the entire problem which they are facing currently, and making complete atomization of manual system to computerized system.

Proposed System:

The proposed system the application is updated with more advantages and flexibility. The Credit Card Approval System eliminates most of the limitations of the existing software. It has the following objectives: enhancement, automation, accuracy, user-friendly,  availability and maintains cost.

Modules:

Customer Application:

The customer can fill all the details of the credit card and the customer personal details. The customer can give the billing address details in the customer application module and save his details.

Transactions:

The customer can give all the transaction details done through his credit card. The customer can select the name to who money has to transfer and can view total purchase cost in the transaction module. The customer can select the process of the payment in the transaction module.

Search/View And Modify:

The customer can search/view and modify the details of the transaction made. The customer can view the credit card number, cardholder details, type of payment and the status of the payment.

Software Requirements:

Operating System: Microsoft Windows 2007/XP

Languages: Java Programming Language.

Database System: MYSQL

Download Credit Card Approval System Project in Java

Posted on

Car Pooling System Java Project

Abstract:

Car pooling System is a Java web project which reduces the misery of travelers and make them find cars in short period of time. Car pooling, is an application of finding car in which drivers who are traveling to work alone can ask for fellow passengers through our application. For those who use public-transport system to go to work daily can use this application to find drivers who are traveling to the same destination in a short path.

Existing System:

In the existing system there is no good communication between administration and the car drivers. The older system is not user friendly. Administrator not able to view the requests of the users. Security is less compared to existing system. Details of the routes are not given online.

Proposed System:

The proposed system is user friendly. Good communication is maintained between admin and driver. All the users requests can be viewed by the administrator immediately. Details of the driver and car are maintained in the database. High level security is assigned in the proposed system.

Modules:

Admin:

Admin gets login with a valid username and password. Admin can assign the services to the employees with details. Admin  can view the details of the employee.

Employee:

Employee should get registered with the site by giving all his personal details. Employee can get login with unique username and password. Employee can view all the services provided by the administrator.

Software Requirements:

Operating System                   : Microsoft Windows 2007/XP

Languages                               : Java Programming Language.

Database System                    : MYSQL

Browser                                   : ANY WEB BROWSER

Hardware requirements:

Processor                                : Standard processor with a speed of 1.8 GHz

RAM                                        : 512 MB RAM

Hard Disk                                : 80 GB

Monitor                                   : Standard color monitor

Conclusion:

Car pooling system is an effort to reduce consumption of fuel, our most important non-renewable resource and traffic congestion on roads by encouraging people to use cars haring. So it is an environment-friendly social application and also helps people to reduce their journey time.

Posted on

Video Library System in Java

SYNOPSIS

  1. This Final Project (Assignment 2) is worth 25% of the total unit assessment.
  2. Students are to complete their project in groups of no more than two people. It is each group member’s responsibility to maintain their group activities. In the rare case of one group member becoming seriously ill or uncontactable or not responding, the other member should consider forming a different group or working on his or her own for the project. As in real life, everyone should have a contingency plan, or Plan B.
  3. It is each student’s own responsibility to form a group of no more than 2 people for their assignment 2, that is, for this final project. Should any student not yet able to find a project partner, he or she should advertise their availability on the student communication board. Students not putting up a request for partnership on this Student Communication Board will be considered as either having already found a project partner, or not looking for a project partner at all. Students must complete the matter of project partnership, or have their partnership requests placed on the above mentioned student communication board.
  4. The development and delivery of a major project in a timely manner is an important indicator on the success of the project. As such, the deadlines for this final project need to be observed, and any late submissions need to be approved before the corresponding due dates.
  5. Let the unit coordinator know if you have any comments on this project so that he can have this document amended before its finalization on the date specified in the above title section.

PROJECT REQUIREMENTS

  1. For this final project, you are required to develop a Video Library System in Java for a video library, so that the system can be used to facilitate the borrowing and the management of the videos the library keeps. A video record should contain at least a video number and its corresponding video title, a flag indicating if the video is currently available for borrowing, and a borrower number and the corresponding borrower name if the video is currently being borrowed. Although the functionalities of the video library system are open to the students’ individual design, the system should be mainly menu-driven with the main menu options somewhat similar to, but not limited to,
    • Add new video to the system
    • Borrow video
    • Modify video record
    • Delete video record
    • Search video
    • Report of available videos
    • Exit

and the navigation among the video records should also be possible, perhaps through additional options on the main menu, or on a submenu, somewhat similar to

    • Current video
    • Next video
    • Previous video
  1. This project is semi-open in that students are expected to have their own design and/or additional capacity to enrich their final software product. External file or files are also expected to be utilised for the storing the video records. In particular, when the video library system starts, it should first load the existing videos from the data file/s which should also contain at least 3 video records.
  2. It is up to each student group to decide how to design and implement their Video Library System. However, the project will be evaluted according to the functionalities, user interface, robustness, and how much object-oriented programming is being utilised.
  3. The final Project Report must be written to include, among all the other relevant matters, the following aspects.
    • The main functionalities, along with the demonstrating examples and screen shots if pertinent.
    • How and where you made use of the paradigm of object-oriented programming, if any.
    • Brief conclusion and reflection on your experience in completing this project.

We note that your project should aim at top quality as much as possible. Your end-product, the Video Library System, will be judged on the achieved functionalities, the look and feel, the design methodology (e.g. ad hoc versus systematic), and the use of advanced features such as object orientation and exception handling. You should cite your design and technical evidence in your Final Report on the quality of your developed software system.

DELIVERABLES

  • Final project report and all the Java programs
  • Class presentation: 10 minutes – during the normal class time of the final teaching week, week 14. The presentation slides, if any, must also be uploaded on the same day as the presentation.

SUBMISSION

  • A pre-submission of all the work must be made 3 days ahead of the due date. This submission should contain all the work you have up to the submission time, and should follow the usual submission procedure. Although this pre-submission will not be given any marks per se, as its purpose is to allow marker/s better prepared for marking the final presentation, fail to complete the pre-submission may however lead to a loss of up to 20% of the total marks of this project.
  • The submission should contain the Final Project Report and all the relevant Java source code.
  • The submitted Java programs should be directly compilable and runable without the use of any Java IDE (such as Netbeans or Eclipse), although students are free to develop their project system with any Java IDE they may choose. That is, your submitted Java code should be directly compilable and runnable under the JDK installed on the same lab/s to which this unit is scheduled.
  • Zip (don’t use the rar compression format) all the relevant files into a single zip file, and then upload it via the submit button on the unit website. it’s each student’s responsibility to keep the submission receipt which will be automatically generated after each submission.