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 Book Review Management System

INTRODUCTION

PROJECT DESCRIPTION

The online book review management system project is to implement a computer-based online book review system and alerts will be given to the user with the help of mobile Sms when new books are updated.

This system objective is to the system design Book Review Management system, and to develop a customer web-based Review Management system. The publisher will upload the Reviews on the website. The reader can give the ratings and feedback to the reviews. Based on the feedback and the ratings given by the user, the publisher can publish the books.

Problem Definition

Existing System

In the existing system, the publisher will publish the book without considering the views of the user.

Problems with the Current System

  • It is more time-consuming.
  • It includes wastage of manpower.

It includes wastage of money.

Proposed System

The proposed system is globalized-website which contains the reviews of new books which are uploaded by the publisher before publishing the book. It will also help the user to know the latest books of their interests being introduced into the market like fiction, science, technology etc.

Stakeholders are:

1. Publishers
2. Readers
3. Administrator

Requirements Specification (RS):

No. Module Requirement/ Functionality Essential or Desirable Description of the Requirement
RS1 User Management Users.

 

 Essential Maintain the details of users.
RS1 Book Management Books Essential Maintaining the details of books.
RS1 Search Management Books Essential Searching the details of books.
RS1 Feedback Books. Essential Feedback on books.
RS1 Rating Engine. Books . Essential Rating on books.
RS1 Review Management Books. Essential Reviewing the book management.
RS1 Forum Books. Essential Generating the forum.
RS1 Analysis Management. Books. Essential Analysing the details of the book.

Diagram:

Use case Diagrams:

Use Case for Admin:

Use Case for User:

Use Case for Publisher:

Activity Diagrams:

Activity Diagram for Admin:

Activity Diagram for User:

Activity Diagram for Publisher:

Class Diagrams:

Class Diagram for Admin:

Class Diagram for user:

Class diagram for Publisher:

Sequence Diagrams:

Sequence Diagram for Admin

Sequence Diagram for User

Sequence Diagram for Publisher

HARDWARE AND SOFTWARE REQUIREMENTS

Hardware Requirements

Processor: Pentium-III (or) Higher

Ram: 64MB (or) Higher

Cache: 512MB

Hard disk: 10GB 

Software Requirements 

Technology: Java 2 Standard Edition, JDBC

Web Server: Tomcat 6.0

Client Side Technologies: HTML, CSS, JavaScript

Server Side Technologies: Servlets, JSP

Data Base Server:  MySQL

Operating System: Microsoft Windows, Linux or Mac any version

MODULE DESIGN:

The major modules of the project are

  • Administrator Module
  • Publisher Department Module
  • User Department Module

Test Cases:

TEST CASE 1 :

Test case for Login form:

When a user tries to login by submitting an incorrect ID or an incorrect Password then it displays an error message “NOT A VALID USERNAME”.

TEST CASE  2:

Test case for User Registration form:

When a user enters user id to register and ID already exists, then this result in displaying error message “USER ID ALREADY EXISTS”.

TEST CASE 3 :

Test case for Change Password:

When the old password does not match with the new password, then this results in displaying an error message as “ OLD PASSWORD DOES NOT MATCH WITH THE NEW PASSWORD”.

TEST CASE 4 :

Test case for Forget Password:

When a user forgets his password he is asked to enter a Login name, ZIP code, Mobile number. If these are matched with the already stored ones then the user will get his Original password.

OUTPUT SCREENS

Home Page:

Admin Home Page:

User Home Page:

User Registration Page:

User Details Page:

Publisher Registration Page:

Publisher Details Page:

Book Store Page:

Upload Book Page:

Search Page:

View Feed Back Page:

CONCLUSION

The Online Book Review Management System project has been successfully completed. The goal of the system is achieved and the problems are solved.This project is developed in this manner that is user-friendly and required help is provided at different levels.

The primary objective is to provide the interactive service to all the students. Different types of services are provided to both the students and staff. The student can avail this service anytime.

This system certainly doesn’t reduces the manpower but helps the development of the available manpower and optimizes the manpower.

LIMITATIONS

The present system is developed for offline communication only.
As the memory capacity is limited to server’s memory we can’t accommodate an infinite number of users.
An unauthorized candidate can take the exam instead of an authorized candidate if he knows his user ID and password.
The images or pictures, which are drawn by the Drawing Tool Bar, can’t be saved.

FUTURE ENHANCEMENTS

To make that only authorized candidates taking the exam their fingerprints, can be taken and compared with stored ones.

Examination centers can be set up at various places and candidates can be asked to take the exam in those centers only. Invigilators should be asked to invigilate at those centers. This eliminates copying and any malpractices by the candidates.

Voice can be provided to all the students by using VOIP (voice over internet protocol).

Posted on

Online Seminar Hall and Auditorium Booking System

The Online Seminar Hall and Auditorium Booking System is divided into four main modules. Each and every module performs a particular work. Those 4 modules are

  1. Maintenance of user and seminar hall
  2. Booking the seminar hall
  3. Approval and Rejection by In-charge
  4. Role of Principal

Maintenance of user and seminar hall

It consists of Signup, Login and update details of the seminar halls, users. The Administrator creates a separate account for each Department, Seminar hall in-charges, other cells like placement and training, EMDC etc., and Principal.

Booking the seminar hall

Each department has the username and password to book the seminar hall for their requirement. Through this they can view the available dates of particular seminar hall and also the facilities in the hall like capacity, mic’s, projector, marker board etc., This provides user-friendly environment while booking the seminar hall it gives suggestion regarding the selection of seminar hall based on the capacity and availability. The concern department head can view the list of the request. The acceptance and rejection can be viewed by the user through that log in or even by the email id.

Approval and Rejemailon by In-charge

The role of seminar hall in-charge is to check the request came to the seminar hall. When in-charges login into their account the list of new requests are displayed in their page as shown. The request can be either accepted or rejected based on the priority of the request. If more than one request is made for the same seminar hall on the same date after granting approval to a particular request by seminar hall in-charge, the remaining requests are automatically rejected and the email is sent to the bookie and also it is notified on their page.

Module – IV: Role of Principal

The Principal can view the entire process which is happening on the website and can fetch the data from the past to present who all are used the seminar hall. In an emergency case, he can reject the accepted request and the email will be sent to the booker as well as the seminar hall in-charge by suggesting alternate seminar halls.

User Registration Form

This form contains new user Registration Fields. Admin will take the role of this process to register user details. Here all the fields are validated using JavaScript Validation.


Signup Form

Login Form
The user can enter username and password. These Fields are mandatory. Both fields are validated using PHP. Login option given separated for four types of users.

Checking Availability

To check the availability of the seminar hall by Booker

Checking the availability
Availability Details
Seminar hall Booking FormIt contains all required fields for booking seminar halls like booking date, session, Booker name, dept, etc., Here all the fields are validated using JavaScript validation. For date picker, we are using ‘jQuery Date Picker’.

It contains all required fields for booking seminar halls like booking date, session, booker name, dept, etc., Here all the fields are validated using JavaScript validation. For date picker, we are using ‘jQuery Date Picker’.

Booking Form

Booking suggestion form

OUTPUT DESIGN

It contains a list of users on this system.

Administrator portal

Seminar hall Incharge Portal

It lists out the request came for the seminar hall with Booker details.In-charges approve the request based on the priority based on First Come First Serve order based on booking id or booking date and time.

Seminar hall in-charge portal

Usage details
It is Users availability checking page. On this user can check the availability of particular seminar halls.

Usage details

User page-Request details

It contains a list of requests have been sent to the seminar halls, viewed by the Head of the Departments.

Rejection of Acceptance

Notification of Approval Rejection

Usage details –principal portal

From this page, Principal can view the entire process which is happening on the website and can fetch the data from the past to present who all are used the seminar hall.

Acceptance rejection page

It shows the acceptance rejection page details, it can be viewed by principal

Admin portal

Principal portal

SYSTEM IMPLEMENTATION

The project is developed and hosted in our Engineering College web server. It is going to use by our college. Users can access this website by using the intranet. It helps users by reducing manual works. It will be a User-friendly website.

CONCLUSION

The project entitled “Seminar Hall and Auditorium Booking System” was successfully executed.  This system replaces the existing system with more features.  The system provides security to user documents.

However, the possibilities for innovation are infinite and scope for development is innumerable. The future extension can be made to provide more option in this application.

FUTURE ENHANCEMENT

Good amount of user friendliness has been incorporated in this system. It is possible to exploit these features to get the details of not only seminar hall but also the total number of blocks and which contains the total list of the hall in a block wise.  The process is suitable to extend the kind of task and the number of more process.

Download Seminar Hall booking System PHP project.

Posted on

Easy Resource Utilization System

This Easy Resource Utilization System project aims to development of booking seminar halls and auditoriums in our college through online. It reduces the traditional/manual maintenance system. It creates a user-friendly website for users.

Here, four types of users are available like Principal, Administrator, Seminar hall in-charge and Head of Departments or Booker. Booker can check seminar hall availability, booking and viewing the status through online. Any faculty can reserve the seminar hall and auditorium based on the availability.

In this system, the seminar hall in-charges can view the requests and accept the request(s) according to the priority and also view the usage reports and status for a particular period. Administrator plays a vital role to maintain complete details of all the users, hall details and he/she is the only authorized person to update all details.

The principal can view all user details and usage details of seminar halls. Other users can only view the details of the seminar halls. Each event like seminar hall booking, cancellation of seminar hall will be intimated to the concern seminar hall in-charge, bookie, and Heads of the department through E-mail. Ultimately this project helps to utilize the seminar hall in an easy way.

PROJECT OVERVIEW

The project is developed for the requirement of our Kongu Engineering College. It is used to book the seminar hall through the online. Four roles are available for this project i.e., Principal, Administrator, Seminar hall In-charge and Hod. Booker can reserve the conference/seminar halls and auditorium easily.

Hall in-charges can accept and reject request came for the seminar hall. The principal can view the entire user, in-charge and usage details and he can reject the approval of hall in-charge. The administrator is responsible for users and hall details maintenance.

The project is developed and hosted in our Kongu Engineering College web server and linked to www.kongu.edu.

In the first step, the administrator has to provide the user id, password for the principal, seminar hall in-charges, Hod’s in order to avoid unwanted users to access the file, the second step Booker can book the seminar hall which is required, third step is hall in-charge can approve/reject the request of Booker. The final step is principal can view the usage details of the hall and also he has the rights to cancel the approval of hall in-charge which is accepted.

OBJECTIVES

• It is mainly to implement for departments to book seminar hall through online instead of carrying out documents and maintaining it.
• To reduce the effort of maintaining documents of seminar hall usage.
• It is the effective way of using the college resources properly.

SYSTEM ANALYSIS

EXISTING SYSTEM

This seminar hall booking is done only through the process on paper which means the process done through manual maintenance system.

Drawbacks

• Checking availability of seminar halls.
• Checking the capacity of seminar halls.
• Viewing the detail of the seminar halls.
• Phone conversations with seminar hall in-charges.
• Time wastage for the Booker.
• Mental stress to the booker.
• Non-availability of the technician.
• Booking form maintenance by the in-charge.

PROPOSED SYSTEM

This application entirely based on the online process as we can view the status of all seminar halls. It mainly reduces the effort and time of the Booker and hall in-charge. Based on the priority of request hall in-charges can easily accept or reject the request.

FEASIBILITY STUDY

This application is proposed by our principal as it is a valid one, which is a must for Kongu Engineering College as for the seminar hall booking process. This is efficiently done and helpful for all the faculty and HOD of the entire department. The drawbacks mentioned above in the current/ existing system will not reflect the proposed system.

SYSTEM SPECIFICATIONS

HARDWARE REQUIREMENTS

Processor: Intel Pentium i3 1.3 GHz
RAM: 4 GB
Hard Disk: 320 GB
Monitor: 17inch color display
Key Board: standard 104 Keys
Mouse: 4Button Scroll

SOFTWARE REQUIREMENTS

Operation System: Windows 7
Front End : HTML, PHP
Back End: MySQL
Scripting Languages: JavaScript and jQuery, PHP
Web server: XAMPP server 1.8.1

DATABASE DESIGN

Posted on

Sentimental Analysis Opinion Mining for Mobile Networks

Abstract:

Sentimental Analysis and Opinion Mining for Mobile Networks is a project mainly focuses on sharing posts in the application more effectively and easily. In this application, users can share their posts whether they may be images any others.

This application provides a special feature i.e.., when one user shares a post in the application, all the registered user can see the post and leave a comment to the post. By this, all users can easily find the comments for their post very easily.

Existing System:

In the existing system, it takes time for users to find the comment for their post. All the details of the comments should be verified to see whether it is positive or negative which takes a lot of time. All the work in the existing system is done manually which requires a lot of time and effort.

Proposed System:

In the proposed system users can easily find the status of the comment for their post by a user. The user can save a lot of time. The user can easily find the status of their comment on the post with in no time and with less effort.

Modules:

User:

The user should fill all the details in the registration form to get login details. The user should enter unique username and password to get a login to the application. The user can view his profile, add images, view his uploaded images and can change the password. The user can see the positive comments and negative comments of the post and also user has an option to see the graph.

Admin:

Admin can get login by entering a valid username and password. Admin can view all the activities of the users and can view all the posts uploaded by users.

Software Requirement:

Operating System – Windows
Application Server – Tomcat.
Front End – HTML, Java, Jsp
Scripts – Java Script.
Server side Script – Java Server Pages.
Database – My SQL
Database Connectivity – JDBC

Conclusion:

Out project “Sentimental Analysis and Opinion Mining for Mobile Networks” provides easy and fast opinion on the comments made on the post uploaded by the user in the application. Our application saves a lot of time and effort for users in searching the status of the post.

Posted on

Student Friendly College Management System

Abstract:

Student Friendly College Management System is a web application which provides a very easy way for students to pay the fee and check the results online. This application maintains the complete information about the students their fee details and their results.

We developed a web application where students can pay the fee online and check the results. This application provides a service to students to check their fee dues and pay it online and students can even check the results online.

Introduction: –

The main objective of our project is to develop a GUI (Graphical User Interface) which is user friendly. It is fast in operation and databases will be up to date. Every user will have their own profile, where they can know about their fee dues, make fee payment online and check the results in .xls format.

Literature Survey: –

We know the difficulty of paying the college fees, exam fees, etc, in college because there are so many students in the college who want to pay the fee. (Students who can’t pay the fee immediately and has to pay on the last day, due to which long queue is seen everywhere and it is a time taking process.

Students, who appear in the exams, eagerly wait for the results, but the university servers are so busy in the time of the results when they are released and lots of time is being consumed in awaiting of the results for coming days. So, we are developing a system in which a student can pay his/her fee from their profile and even check their results.

Problem with our Existing System: –

The main problem with our existing College Management system are:

  • No software for online fee payment system.
  • Busy university servers while the results are released.
  • User login profiles are not user friendly.
  • No online enquiry for fee dues.
  • There is no predefined classification of fee categories.
  • Students fee payment data searching is not available, it is not user friendly.
  • Existing system is total manual process. It is time taking process.

Proposed System: –

To overcome all the problems in the existing College Management System, we have proposed a new system with the following actions.

  • A web page has been created with separate logins and profiles with good security for students and accountant.
  • Student can search his/her results as soon as results are announced in their own profiles and they can check their fee dues and can pay that online from their own logins.
  • Student can choose the fee structure in the way they want to pay and can pay that separately by providing the details based on the method payment they choose.
  • Student can pay college fee, university fee, exam fee, transport fee, CRT fee, etc,.
  • Payment is done only for those who has any fee dues. The transaction gets cancelled if the payment is done beyond the fee dues.
  • An accountant can check status of students who paid the fee and how much. He can insert the fee details from his login which reflects into students fee dues.

Modules of the system: –

  • Administrator
  • Student
  • Accountant

Functionality of the project: –

  • 1) Administrator
    1. Add student
    2. Add accountant
    3. Upload results
  • 2) Student
    1. Updates student details
    2. Check fee dues
    3. Check results
    4. Make online payment
  • 3) Accountant
    1. Insert student fee dues
    2. Check student dues
    3. Check student online transactions
Posted on

A Project Report on Online Score System

Team Information

The administrator Can Add/Update the teams With the details and the user can view the overall information of the

  • the team detail module allows the user to browser The details of the team profile and management.
  • Team module allows user to browse different teams
  • where only one team can be selected at a time and get the detail
  • when selected on a particular team.

This module gives the detail of team such as team logo, team name, team information, team captain, address, contact no show match details

Player Details

this will come under team information which gives the basic details about the players.

  • allow the user to have a glimpse of the player’s profile.
  • it give the personal details of a player with their batting style, bowling style and his position in the team along with their achievements

Batting Performance

  • It gives the batsman profile, statistic, and summary of his batting performance in his current and previous matches that he had played.

Bowling Performance

  • It gives the bowling profile, statistics, and summary of his bowling performance in his current and previous matches that he had played.

Results

  • This module gives the summary that was played.
  • It also gives the overall detailed result of that particular match that was played.
  • Detail such as scores scored by both the teams Over’s completed, loss of wickets.

Gallery

it shows the best captured moments, pictures, video etc… That was taken during the course of the matches.

  • It will dynamic.
  • Here the photo is uploaded which was clicked/recorded by the fans during the matches.
  • The user cannot upload the image here due to censorship issues.
  • Instead, the user is supposed to e-mail the image to admin and then admin uploads it to the website.

Administrator

The administrator is allowed to access all the services in the system. The main objective of the administrator is to add/update the summary of the matches and also to add/update the schedules of the matches.

Users/Visitors

These users will get the full access of the website but they cannot do any changes on the Online Score System website, they can enjoy the services provides by the administrator.

Data Dictionary

ADMIN

No FieldsName DataType Size Constraint
1. id int 3 PK
2. username Varchar 20 Null
3. password Varchar 20 Null

TEAMLIST

No FieldsName DataType Size Constraint
1. id int 3 PK
2. team_name Varchar 20 Null
3. team_logo Varchar 30 Null
4. captain_name Varchar 20 Null
5. Captain_photo Varchar 30 Null
6. Villege Varchar 20 Null
7. Contact Varchar 10 Null

PLAYERLIST

No FieldsName DataType Size Constraint
1. id int 3 PK
2. Player_name Varchar 20 Null
3. Player_photo Varchar 30 Null
4. taem_name Varchar 20 Null
5. age int 2 Null
6. dob date Null
7. Contact Varchar 10 Null

BATSMAN

No FieldsName DataType Size Constraint
1. id int 3 PK
2. match_no Varchar 20 Null
3. Player_name Varchar 20 Null
4. Team_logo Varchar 30 Null
5. Innings Varchar 10 null
6. run Int 3 Null
7. Ball Int 3 null
8. four Int 3 Null
9. six Int 3 Null
10. Wide_run Int 3 Null
11. No_run Int 3 Null
12. lage Int 3 Null
13. By_run Int 3 Null
14. St float Null
15. out_detail Varchar 30 Null
16. Bowler_name Varchar 20 Null
17. Vs_team Varchar 30 null

MATCHLIST

No FieldsName DataType Size Constraint
1. Id int 3 PK
2. Team_name(a) Varchar 20 Null
3. Team_logo(a) Varchar 30 Null
4. Villege(a) Varchar 15 null
5. Team_name(b) Varchar 20 Null
6. Team_logo(b) Varchar 30 null
7. Villege(b) Varchar 15 Null
8. umpire varchar 20 Null
9. Tos Varchar 10 Null
10. Date Date Null

ELEVENPLAYER

No FieldsName DataType Size Constraint
1. id int 3 PK
2. Player_name Varchar 20 Null
3. Team_name Varchar 20 Null
4. Match_no int 3 Null

UMPIRELIST

No FieldsName DataType Size Constraint
1. id int 3 PK
2. umpire_name Varchar 20 Null
3. villege Varchar 20 Null
4. contact int 10 Null

GALLERY

No FieldsName DataType Size Constraint
1. id int 3 PK
2. photo Varchar 100 Null

BOWLER_LIST

No FieldsName DataType Size Constraint
1. id int 3 PK
2. Match_no int 20 Null
3. Team_name Varchar 20 Null
4. Bowler_name Varchar 20 Null
5. Innings Varchar 10 Null
6. Over Float Null
7. Run Int 3 Null
8. Wide_run Int 3 Null
9. No_ballrun Int 3 Null
10. Wicket Int 3 Null
11. Run_out int 3 Null
12. Echonomics Float Null
13. Vs_team Varchar 20 Null
14. Bowler_statas Varchar 20 null

Data Flow Diagrams

Level 1

Snapshot


Live Score Page


Team Page
Schedule Page
Result Page
About Us
Admin side Snapshot

Admin Login
Add Team Page
Add Player Page
Add Match Page
Live Update Batsmanside Page
Live Update Bowler Side Page
Add Umpire Page
Gallery Page

Posted on

A Project Report On Online Certified Course

 Preface

  • This Online Certified Course Website is Provide to you to learn and get the certificate.
  • This Website Can be Also Provide Information about different types of courses.
  • The User can learn online and get the certificate.
  • This is a static and dynamic website designed
  • The User can registration first and then login and start the course.

Acknowledgement

We are very grateful and thankful to professors of my college. Who give me a good guidance and gives suggestion about each and every topic which we study and research? They give me guidance about my current Online Certified Course project.

We also thankful to my friends. Who give me support to helpful to complete this project? And solve my all difficulties.

We are taking this opportunity to express out gratefulness to the principle and All staff.

We also express our heartily thankfulness to all out friendly classmate and those entire person who have directly helped us in the preparation of this project.

Thank you to all person involve in this Online Certified Course project.

Project Profile

Project Name : Online Certified Courses
Front – end – tool : PHP Version 5.2.6
Back – end – tool : Mysql
Operating System : Windows-7.
Team Size : 2 Students
Project Duration : 3 Months

Software Requirement:-

  • Operating Systems : Microsoft Windows XP (or more)
  • Front End Tool : PHP
  • Back End Tool : Mysql
  • Browser : Chrome, IE, Firefox

Drawback of Existing System

  • As Current System is Window base. So it’s Very Difficult.
  • Time consuming Problem.
  • Only One Person is work at a time.
  • Difficult to Work for learning courses Time Duration.

Need for new System

  • To online certified Process Work Is Fastly?
  • Reduce The Time Period for learning courses.
  • Paper work to be Removing.
  • Information stored in database, which provides data security.

Data Flow Diagram

Context Level Diagram

0’Level DFD for User

O’Level DFD for Admin

DATA Dictionary

REGISTRATION TABLE

SR.NO Field Name Data Type Constraints Description
1 Id Int(5) Auto/Inc Use For id
2 Cust_name Varchar(25) Not Null Use For Name
3 Cust_address Varchar(50) Not Null Use For Address
4 Cust_city Varchar(50) Not Null Use For City
5 Cust_state Varchar(12) Not Null Use For State
6 Cust_country Varchar(10) Not Null Use For Country
7 Cust_email Varchar(50) Not Null Use For Email
8 Cust_password Varchar(15) Not Null Use For Password
9 Cust_dob Date Not Null Use For Birth Date
10 Cust_gender Varchar(6) Not Null Use For Gender
11 Cust_Pincode Int(6) Not Null Use For Pincode
12 Cust_mobile Decimal(10,0) Not Null Use For Mobile

ADMIN LOGIN TABLE

SR.NO Field Name Data Type Constraints Description
1 id Int(11) Auto/Inc Use For id
2 Username Varchar(25) Not Null Use For Username
3 Password Varchar(25) Not Null Use For Password

NEWS TABLE

SR.NO Field Name Data Type Constraints Description
1 id Int(11) Auto/Inc Use For id
2 News Text Not Null Use For News

FEEDBACK TABLE

SR.NO Field Name Data Type Constraints Description
1 Id Int(11) Auto/Inc Use For id
2 Name Varchar(20) Not Null Use For Name
3 Email Varchar(30) Not Null Use For Email Id
4 Mobile Decimal(10,0) Not Null Use For Mobile No
5 Message Varchar(500) Not Null Use For Message

COURSE TABLE

SR.NO Field Name Data Type Constraints Description
1 C_id Int(5) Auto/Inc Use For id
2 Course_Name Varchar(50) Not Null Use For Name
3 Course_category Varchar(50) Not Null Use For Category
4 Course_cont Text Not Null Use For Content
5 Img_Name Varchar(50) Not Null Use For Image Name
6 Image Blob Not Null Use For Image
7 Pdf_name Varchar(100) Not Null Use For Pdf

Form Layout

Home Page
About Us Page
Contact Us Page
Registration Page
Login Page
Business Course Page
Admin Login Page


Admin Home Page


Add Course Page


Update News Page


Admin Change Password


Feedback Suggession Page
Feedback Report
Registration Page

 

Posted on

A PHP Project Report & Source Code on E-Shop

Acknowledgement

We are very grateful and thankful to professors of our college. Who give us a good guidance and gives suggestion about each and every topic which we have study and research. They give us guidance about our current project.

We also thankful to our friends. Who give us support to helpful to complete this project? And solve our all difficulties. We are taking this opportunity to express out gratefulness to the HOD sir
We also express our heartily thankfulness to all out friendly classmate and those entire person who have directly helped us in the preparation of this project. Thank you to all person involve in this project.

Project Profile

Project Title: Online Shopping System

Hardware Requirement:- 

Dual core , 2.5 GHz, 512 MB RAM, 40 GB HDD

Software Requirement:- 

Operating Systems : Microsoft Windows XP (or more)
Front End Tool : PHP
Back End Tool: : Mysql
Browser : Chrome,IE,Firefox

Need For New System

With the help of new system a members of shopping mart has easy to handle whole process. With the help of online shopping system it’s easy to sell a product in a better price rate and easy way to keep customer demands satisfaction.

Online system has a one more special feature is shopkeeper can easily find customer and customer finds desired products in comparing low rate than manually purchasing. Online shopping system contains some other decent feature like as under.

Data Dictionary:

  • Money (e.g travelling cost, courier cost)
  • Save Time (e.g at home delivery)
  • Multiple Choices (better Availability)
  • Cash on Delivery (remove money risk)
  • Know Festival Offers (better Discount on offer)

HOME PAGE


USER LOGIN


Advertise Form


CUSTOMER REGISTRATION


CUSTOMER ORDER


ABOUT US
CONTACT US
ADMIN LOGIN
ADMIN FORM
CUSTOMER ORDER REPORT

 

Posted on

Virtual Learning Environment Java Project

Abstract:

Virtual learning environment is a project which is developed to provide support in the  academic administration, teaching and research using the internet, particularly in the world wide web. Visual  learning is a  form of e-learning that allows the interaction between teachers and students. This project provides various kinds of activities to students by introducing tutors and learners.

This project allows students to get information of the courses in a very easy and quick way. This project also maintains good interaction between parents and teachers. This project allows the potential for new ways of learning and teaching such as active and independent learning which make use of online communication, online assessment and collaborative learning such independent learning still needs to be guided and supported.

Modules:

Admin:

Admin gets login with valid username and password. Admin will upload all the details in the application like course details, syllabus details, fee details, parents and students queries ,professor details and payment details.

Student:

Students should register and can login by entering a valid username and password. Student can view all the college information details, fee details, course details and can post queries and feedback.

Professor:

Professor gets login with valid username and password. Professor can view all the details of the students and their queries. Professor can give reply to the students queries.

Software Requirements:

  • Language : Java
  • Web technologies : JEE (Servlets/JSP)
  • Front-end Design : Html, CSS, JSP, Bootstrap
  • Database : MYSQL
  • Scripting : JavaScript
  • Browser : IE 6.0/ Mozilla
  • Operating System : Windows/Linux

Conclusion:

Our project visual learning environment has been successful in making a good interaction between parents and teachers.

Posted on

Net Banking Project Synopsis

Net banking project does banking online. This aims in functioning always as in Banking

The Net banking project constitutes of modules like

  1. Savings Account
  2. Demat Account
  3. Trading Account & Share Trading
  4. Customer Service
  5. Administration &  Communication
  6. Human Relation

Savings Account

This module contains  of normal Bank transaction such as deposit and withdrawal of funds by Bank employee and transaction by customers directly using net banking, Viewing account details  by  customers, Viewing accounts by bank employee  for any customers Bank employee are allowed to add customers. etc.,. are done here.

Demat Account

In this module  Customers can be  updated from Savings Account to Demat account, Their shares can be de materialized  and be converted to electronic format, The account maintenance charges  are collected . Demat customers can view their account of demat account. 

Share Trading and Trading Account

By this module  customers are allowed to view their trading account details, transfer amount from or to  Savings account , Trade ie.,. to buy any new shares available based on amount available in trading account and sell  the holding shares on prevailing rates.  Share rates are now manually updated by admin part based on prevailing rates.

Customer Service

Customers are provided with variety of  service  like Change of address online, Change of  password, registering cheque book request, Bill Payements etc.,. In Bill payment the customer  can pay any bill  enabled online. Customers request of their password are served by mail

Administration

Admin  are enabled to  view the accounts of bank income, view the status of customer service, like the status of cheque book request  etc.,. Almost all activity related to customers are made known to customer by mail like new entry are welcomed, cheque book registration Bill Payments  and more.

Human Relation

In this module Admin is enabled to add Branches  add and  delete employee in a  branch and to transfer  employee from one branch to  another  etc.

Software Requirements:

  • Operating System Windows XP
  • Internet Information Service – (IIS) and above
  • Bean, Servlet
  • JSP
  • MS SQL Server