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 Music Portal System Java Project

Abstract

The main aim of developing this Online Music Portal System Java based web application, it’s a collection of MP3 songs of different languages in one place where users can get based on the year also play and listen the songs on our website at free of cost only is to provide user friendly tool for music web sites.

This is one type of online music Player. Most of the websites now a day’s Music products through online but download music files with free of cost makes problem with piracy so this is the best place to stop music piracy over the internet. Here the customer should log in through Music store website and play & Lesion selected music files like songs, and private albums by using papal.

Then selected music files can be downloaded directly to the local system of the customer. The main advantage is it is user-friendly, provide us 24 hours customer service, and decrease the manual efforts and Time.

Existing System

We have many websites but we can’t find all languages songs at only one website it’s a time taking the process to find our required languages songs to find by using different websites and so many unwanted pop-ups coming in present websites with are misleading the users from the requirement of songs.

Proposed System

Our Online Music System Java predicated web application it’s an accumulation of audio musical compositions of different languages in one place where users can get predicated on the year withal play and Listen the musical compositions on our website at free of cost only is to provide utilizes cordial implement for music web sites.

This is one type of online music Player. Most of the websites now a day’s Music products through online but download music files with free of cost makes quandary with piracy so this is the best place to stop music piracy over the cyber world.

Here the customer should authenticate through Music store website and play & Lesion culled music files like musical compositions, and private albums by utilizing papal. Then culled music files can be downloaded directly to the local system of the customer. The main advantage of this project is to utilize cordial, provide us 24 hours customer accommodation, and decrements the manual efforts and Time.

Advantages

  • Single Website for Different Languages Songs
  • No Unwanted popup
  • Quick Play & Download
  • Secure & Web application

Modules

  • Admin
  • Existing User
  • New User

Admin: –

Admin will collect all the Data for Our Online Music System like Songs Names, Film Name, Language, Play Link, year of The Song & Store in Our Data Base

Existing User: –

Existing User will login into our website by giving his user name & password into our Online Music System & access all the song as per his/her Requirement based on the language or year…

New User:-

Is the new person who is coming to our Online Music System have to create an account on our website by giving his/her basic information like name first name email id phone no address with will be confident in our data base have to keep a user name & password for next login.

Posted on

Live Chat – Online Chat with Admin PHP Project

Project Title : – Live Chat.
Objective : – Online Chat with Admin.
Platform : – Server Side-Windows XP, Client Side-Any Network Supporting Operating System.
Front End : – HTML, JavaScript, Microsoft Dreamwear, php.
Back End : – MySql.
Technology : – PHP

INTRODUCTION ABOUT PROJECT:

In my project, I have tried to provide online Live chat application. we are being used in creating websites. This is site is very easy to use and gives friendly environment to our users. The user can chat with admin.

In the home page user can see the about college. You can even login from that page. Without login user cannot chat with admin. For new user we have given the facility for sign in.

User can see his/her profile. And if user want to change his/her profile using change profile option.
From admin side, admin can solve a problem of users.

After visiting site you can logout if you have sign in.

Hardware Requirements:

  1. Pentium III Processor
  2. 20 GB HDD
  3. Keyboard & Mouse
  4. 120 MB RAM

Software Requirements:

  1. Windows-xp,7
  2. MY-SQL server
  3. Apache Server
  4. PHP
  5. Internet Explorer
  6. Editor
  7. HTML Toolkit

Dataflow diagram
Level 0,1 st Level

Dataflow diagram Level Zero one two and ER Diagram
Form layout
Home Page
About US
Registration
Login
User Profile
Update Profile
Contact us
Feedback
Admin home page

Home Page About us User Registration Login Details User Profile Update Profile Contact us Feedback Admin Home Page
Limitation and future enhancement

Limitation of Project

No system or software is 100% perfect or reliable in its sense of functionality and performance. There are always small or big bugs in the system.
So our system has also some limitations.

  • The system works only you have PHP.
  • The computer needs continues electricity, in case of power failure.
  • Speed of the program depends on the computer processor and RAM.
  • This system will not be able to run on the network environment.
  • You can’t chat with other user May be in future it is possible to get solution on the spot.

Future Application Of Project

We expect to expand and add some of the features to this System in near future. These features are……

  1. To make system more users friendly.
  2. Configuration features can be changed according to user’s requirements.
  3. To provide more security to its users.
  4. Most Attractive Layout.

Thank You

Posted on

Vehicle Tracker and Speed Notifier Java Project

Purpose: In our daily life, we find many situations where it is necessary to find the vehicle location . This project targets to develop a mobile application in order to provide vehicle location and it also used to send speed notifications to user. It uses internet and can be accessed from anywhere.

Software Requirements-

  • Java
  • XML
  • Eclipse ADT
  • MySQL

Specifications of the project

  • Location tracking.
  • Sending speed notifications.
  • Basically we need two android applications in which one acts as parent app, another one acts as child app.
  • Whenever a parent application needs his respective child application location then we have to provide location and speed.
  • By saving latitude and longitude values in local server ,we can access child location.
  • Speed calculation like after reaching the destination, Distance/time.
  • We have to write an trigger like if speed reaches 50, then push an notification.

Working Of Vehicle Tracking

By using built-in GPS(Global Positioning System) child     application will send the respective Latitude(X) and Longitude(Y) values through a link to guardian/parent application through Notifications, E-Mail and SMS whenever guardian/parent wants to know their respective children.

Here Guardian/Parent can fix some speed limit if respective child cross that speed limit then guardian/parent will get continuous notifications through the application.

https://www.google.co.in/maps/@X,Y,Zz?hl=en

X is the value of Latitude.

Y is the value of Longitude.

Z is the value of Zoom in google maps.

  • If you click on the above link it will show the location of respective child.
Posted on

Master Chef – Easy & Quick Recipes PHP Project

Preface:

Computer technology has proved beneficial in many ways, from visible to invisible, spectacular to routine. In every field computer system occupies special place. Computer makes possible smooth and efficient operation.

Cooking has become passion these days, whether may be a student or a working person or a housewife. Now a day so many web sites are available for that but people like variation in their life. In order to give verity to people, this project has been performed.

Master Chef - Easy & Quick Recipes

In this Master Chef  – Easy & Quick Recipes project we have tried to cover the aspects relating to the accounts of the people. This project unique blend combining the modern technology.

Future Aspects of the Project

Presently our project is based on simple recipe providing system where you can surf recipes and
can give the suggestions.

The future expansion may include information like:

1. How to set a dining table when guests arrive for dinner or lunch.
2. How to make creative things from any fruits of vegetables.
3. How to do the decoration of your dining room.
4. How to garnish the food you serve.
5. Few tips and tricks related to cooking or food.
Project Profile
Operating System : Window XP, Window 7
Front End : HTML, DHTML, PHP, CSS,
DREAMWEAR
Bake End : MySQL
Documentation tools : Microsoft Word

Posted on

Online Matrimonial System Website PHP Project

Project Title: Online matrimonial web site
Platform:
Front End: PHP / HTML / JavaScript / Photoshop/ Flash
Back End: MySQL

Site map
• Site map shows list of mainly used pages in website

Online matrimonial web site
User home
User Home page
• This Page Shows user home page
• And operation that user can carry
• Out once logged in
Registration
• This page indicate user registration form it is firs form among two.
Registration2
• Second registration form Seek for
• More advance detail of user
My account
• My account shows my profile information and allow me to change my profile photo.
• It also allow user to change his/her password, photo album, and who is online.
Full Profile
• Full profile of the user has been
• Presented in this form
Search
• As we all know searching is most useful and crucial feature of any social content base web site
• Hear we have provide six different
• Type of search.
Membership Schemes
• Schemes and detail description of
• Schemes are shown in this page

Success story
• It shows story of couple who find there match from this web site
• You can also post your success story by simply filling form.
Contact Us
• Any query regards to the website will be submitted through contact us page.
• User can also access feed back page to give rating to this site

Update profile
• Update profile page allow you to update your profile in database.
My photo album
• As its name suggest this page allow user to manage there photo album change, delete and add photos


Who is online
• It shows list of user who is online write now.
Admin login
• Ask for admin user name and password


Admin home
• Admin home page from witch admin can carry out further operation
Manage user
• Manage users it display user details allow to change user status, delete user and add user.
Manage column
• This page allow admin to manage all columns that appear when user register them self
• Admin can add update delete and change status of columns
Manage plan
• Admin can change details of plan and apply new plan Site configuration
• Admin is responsible to set site configuration and allowed to change configuration
About us
• This page is use to manage information display on about us page at client side
Success story
• This page is use to add, delete and change status of success story
Privacy policy
• Admin can change privacy policy
Terms & condition
• Admin can decide term & condition of site
Feed back
• Admin get feed back sent from client show it and delete feed back once analyzed deeply


Contact us
• Admin can see message send by client through contact us page and then delete it
Change password
• In this page administrator can change their password

Posted on

Automation of Department Library Java Project

Introduction:

The Automation of Department Library project is aimed at developing an Automated System for the Department library. Department library as the name itself indicates that the library system within a department.

Existing system:

Here faculty will request the book, then the administrator will search for it and if the book is available it will be issued to them.

Collecting books from central library:

Books, journals and other are provided to each and every department. After receiving the books the administrator will send an acknowledge to the library.

Updation of files :

All the updations regarding book issues and returns are done manually.

These files are used for further references.

Demerits of existing system:

  1. More manual work as the number of books increases.
  2. More time consuming for searching and updating the files.
  3. Consumes large volume of paper work and time.

Proposed system

In the proposed system the administrator will do all the updations like issues, returns and any other operations automatically, which reduces the time consumption and increases the efficiency of the system.

Requirement analysis:

Functional requirements

This section describes the functional requirements of the system for those requirements which are expressed in the natural language style.

Administrator will login to the system, and mention the required book details so a list will be generated automatically and he checks the status of the book, he can update, verify the faculty registration details etc.,

Architecture:

Automation Of Department Library Architecture

  • The architecture has central database, which provide the base for the system.
  • In the next layer we have a separate database for each department.
  • Then the middleware which connects user interface to the requested data in database.
  • User interface is top most layers through which the end-user interacts.

Scheduling:

 

Scheduling is an activity that distributes estimated effort across the project planned duration by allocating the effort to specific software engineering task.

The table above shows the schedule that we incorporate into our project to make the project meet all its requirements in time.

Risk management:

“Risk is the potential future harm that may arise from some present action”. Risk Management is a process that is used to minimize or eradicate risk before it can harm the productivity of a software project. With only 28% of software projects finishing on time and on budget, risk and the management of risk play an important role in software development.

Assessing Overall Project Risk

The following table shows some question and answers regarding the analysis of risk.

Question Answer
1. Are requirements fully understood by project team?
2. Do end users have realistic expectations?
3. Are requirements stable?
4. Is number of people on the project team adequate to the job?
5. Does the project team have right mix of skills?
6. Does the project team have experience with the technology to be implemented?

The degree of risk in the project is low.

Cost Risk:

Cost risk is the degree of uncertainty that the budget will be maintained.

Support Risk:

It is the degree of uncertainty that the resultant software will be easy to correct, adapt and enhance.

Performance Risk:

It is the degree of uncertainty that the product will meet its requirement.

Progress:

We are as per the schedule i.e. now we are planning stage. Some of the work regarding planning has been completed and remaining has to be done.

Posted on

Designing a Database System for Tourist Application

PURPOSE OF THE PROJECT:

The purpose of the project is to develop a distributed database system for tourist application by utilizing the knowledge and skills gaining from this subject. This project is chosen to enhance the technical skills that are acquired from lectures and lab exercises; every phase of this project includes implementation of various programming aspects of the subject. Working on this of project gives us a better experience that can be used in developing real time projects in coming future.

This project is nothing but developing a distributed database system for tourism/tourist application. Various phase of this project involves a database with several tables linked and has tourist information and in phase two we will be developing a standard web page that linked to the tourist database to retrieve tourist information. (As the knowledge and time is limited we will be making this project to satisfy the requirements of this subject, any additional features can be added later on).

EXISTING SYSTEM:

In present scenario, a customer has to visit various agencies and offices to plan a tour. The customer has to make reservations for travel and accommodation. The customer may have to collect information from various sources. It takes a lot of time to plan a tour and often the data may not be up to date.

PROPOSED SYSTEM:

The proposed system maintains a centralized repository of all related information such as tour packages, places, hotels and enables one to make reservations for various transportation modes. The system provides all the help and information that a customer generally requires. The system allows one to browse through all the details and information.

MODULES:

The system has been identified to be presented with the following modules:

Tours, Flight Reservation, Hotel Reservation, Local Transportation reservation, Administration

Tours:

Organizing a tour involves many things, which includes flight reservation, accommodation reservation and local transportation booking. As a package of all these things, a tour package will be offered to the customers.

This module deals with managing everything as a package.

Flight Reservation:

This module only deals with flight reservation and it is specific to the users who would want to avail the flight reservation separately.

Hotel Reservation:

This module deals with accommodation reservation. It is specific to the users who would want to avail hotel reservation separately.

Local Transportation reservation:

This module deals with local transportation reservation. It is specific to the users who would want to avail local transportation reservation separately.

Administration:

The administration module centralizes all activities to be done in this application. It automatically allocates the hotel, and does the local transportation reservations if the customers opt for a package. Administrator also can add, delete and edit information related to packages, tours and accommodations.

REQUIREMENTS:

Requirements are listed in terms of use cases

Tour

Tour ID, Tour Name, Place From, Place To, Places To Be, Duration, Fare, Description

Tour Booking

Book ID, Tour ID, Customer Name, Customer Email ID, Place From, Place To, From Date, To Date, Number Of Persons, Amount, Credit Card Number

Cab Booking

Customer Name, Customer Email ID, Cab Location, Cab Type, Travel Name, From Date, To Date, Fare, Credit Card Number, Book ID

Flight Booking

Booking Date, Customer Email ID, Customer Name, Flight Number, Flight From, Flight To, Airline Name, Journey Date, Arrival Time, Departure Time, Number Of Tickets, Fare, Credit Card Number, Amount, Book ID)

Hotel Booking

Customer Name, Customer Email ID, Hotel Name, Hotel Location, From Date, To Date, Number Of Persons, Credit Card Number, Amount, Book Date, Book ID

Package Booking

Book ID, Book Date, Customer ID, Customer Name, Package Name, Journey Date, Number Of Persons, Amount

Customer Registration

User Name, Password, Confirm Password, First Name, Middle Name, Last Name, Address, Age, Phone Number, Email ID

State Details

Country, State Name, City Name, Description, Area Code

Tour Guide

Guide Name, Gender, Languages Known, Amount, Email ID, Phone Number

Do’s And Don’ts: Local Rules and Regulations

Posted on

Organics Management System

ABSTRACT

The project titled “Organics Management System” is a Web-based compensation model for companies which help in managing all the activities in the Organic Farm. Organics is a public limited company engaged in organic farming and having a keen attitude towards establishing a research based agri-business. Organics provides equity and preferential shares, organic products and many services to the public.

The purpose of this application is to have a consistent and reliable system which can track all the activities within the company. It also provides supervisors and directors a tool that manages and estimates the company productivity on a monthly or weekly basis.

The system functional specifications can be used for streamlining activities, provide information flow and manage all the activities effectively. The process of “Organics Management System” is to provide software for the company which helps in tracking the team and individual transactions with the company.

The main objective of the project is to develop and provide an effective management system which can be used for managing shares, products and services. The module is developed based on the requirement gathered from the company. All the shares, products and services are sent to the administrator of the company for his approval before each transaction can be completed.

PROPOSED SYSTEM

The main aim of proposed system is to provide an automated managing system which can track all the daily activities in the Organic Farm. The development of a well-structured, secured and approval based system will allow staff and customers to understand better and will be able to contribute to the growth of the company.

Reduce the manual process flow of discussion and approval from management; promote efficient and scalable products with the company’s growth. It also helps in tracking the profit and quality of the products and also helps establish the company as a major competitor in the field of organic agricultural farming.

BENEFITS OF PROPOSED SYSTEM

The aim of this project is to develop a management system with the following objectives:

  1. To create a management system that can be used to track all the activities within the company.
  2. To reduce the time of management and long discussion process.
  3. System can be implemented on daily or weekly or monthly basis.

SYSTEM REQUIREMENTS

The software requirements for developing the application are Microsoft Visual Studio 2008 to handle front end basically – .NET controls, windows forms and SQL Server to take care of the database part (back end) and Windows 7 as operating system.

Hardware Specification

Processor                        :        Intel Core 2 Duo

RAM                              :         1 GB RAM

Hard disk                        :        2GB

Software Requirements

Operating System                   :            Windows 7

Front-End                   :            Microsoft Visual Studio 2008

Back-End                   :            SQL SERVER 2008

Posted on

Material Management and Stores accounting system

MATERIAL MANAGEMENT

ABSTRACT:

To develop software for Material Management and Stores accounting system to resolve the problems faced by the material managers in the organisation as a solution.

Objectives:

1. To develop the software for transparent procurement of materials/ items and accounting of all the inward goods transactions/items.

2. To improve the material management inventory system by providing quality of service to the stores department to production departments at various levels.

Scope:

It is required to develop a computer-oriented method for MM Department to Stores department activities, right from the purchase request to goods inspection. The decisions, which are taken by the material managers, demands more quality information from the indenter with respective to quantity and time of the items required to meet the organisational production goals.

Solution:

To meet the organisation goal in procurement of items a strong supporting system, by means of stock levels and cost effective. Thus a more flexible, simple user friendly software which can assist all the authorised persons at various levels in making decisions regarding stock of various materials, effective channelling of resources, maintaining important validation data and reduction in the reaction time. Computerization saves a lot of time regarding the maintenance and retrieval of data at crucial time, making the work easier and efficient.

This system covers all the activities of MM right from the raising of Purchase Request (PR) to receipt of materials (inward goods) from the supplier and also issue of materials for production to store credit of finished goods.

System Specifications:

Software Requirements:

• Operating system           :   Windows XP or Windows 7, Windows 8.

• Coding Language            :   Java – AWT, Swings

• Data Base              :   My SQL/ Oracle.

• Documentation               :   MS Office

• Development Kit             :   JDK 1.7

Hardware Requirements:

System                      :   Intel core Pentium IV

Hard Disk                  :   40 GB.

Floppy Drive                        :   1.44 Mb.

Monitor                    :   14’ Colour Monitor.

Mouse                       :   Optical Mouse.

Ram                            :   1 GB. 

System Flow:

 Material Management and Stores accounting system

Posted on

Query Handling System

ABSTRACT

This Query Handling System project is designed for the college students to handle the queries which are frequently asked by the students. In this Query Handling System project we are providing a chance for the student to clarify their doubts by posting the questions. Normally it is very hard to handle all this query clarification process manually. So here we are developing the project which provides automation process for the clarification of doubts by asking the students to post the question and get clarified with their doubts.

There will be many questions that are being posted frequently by the students to various departments in a college.  The College examination branch wants to maintain all the frequently asked questions in the database subject wise.  Time to time they will be updating the questions and the related answers into the database.

The primary goal of the Query Handling System is to provide an environment that is both convenient and efficient for the students and lectures through which the students can get clarified with their doubts and also for the administrators of a particular college to use in retrieving the information from database and also storing the information into database.

Modules: 

  • Super User
  • Administrator
  • Student

Super User:

super user to control the data, appointing the administrators in each department,appointing the administrator  to a particular department for that he register the admin,adding a new departments like computer science, chemistry, physics,    maths, etc.. At the same time he can delete the departments, adding a new topic to particular department. At the same time he delete the added topics also, adding the question with answers and storing the data in database. 

Administrator:

  • Admin can add the question with answers and it will be stored in database for students to retrieve it.
  • Admin will modify the answers.
  • The student post a question in certain department the respective administrator will answer the question and a copy of the answer will be sent to the student. 

Student:

  • Student post a question in certain department.
  • Student check the answer for which he is posted.
  • Student checks the answer for available questions.