E-Learning System Web Portal Java Project

Objective:

e-Learning” is an educational-based java web application; this web portal helps college students to get all the resources & study materials of every course available on the online portal. All the students can access this website portal anytime and from anywhere on the internet. E-Learning System is a very good online e-learning portal compared to all web links given by Google, Bing, Yahoo, ChatGPT, or any website while searching for student course materials.

Contents

Existing System:

In Present Educational based E-learning system, students can get information from books or study materials provided by professors manually. But in this system, students may not get the related and sufficient information according to their syllabus. The above resources do not provide discussion forums between students and professors to clarify their doubts. There is no proper guidance for the students.

Proposed System

The main aim of this E-Learning system is to provide sufficient study materials to the academic students according to their 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 students and professors where students can easily clarify their doubts. Modules of this website are Admin, professor, student, and mentor.

Modules:

Admin:

  • Admin can view all member’s details like professors/asst. professors, mentors, and students. Here each user (student/mentor/professor) can upload material.
  • The uploaded material can be verified by the admin. The admin can validate the material if the material is related to the subject. The validated materials are only visible to the students.
  • The admin can view the queries which are sent by the students to the mentors. The admin can also check how many solved queries and unsolved queries.

Student:

  • Each student must and should be registered before login. Here we have user authentication every time. Students can upload material, view material, and send queries. The upload materials first verify by the admin and then visible in the view material tab.
  • The student view uploaded material by all the users which is validated by the admin and he can download materials.
  • The student can send a query to the mentor if he/she has any doubts regarding academic subjects.

Mentor:

  • Mentor registration and login.
  • Mentors can upload material, view material, forward queries, and reply to queries. The upload materials first verify by the admin and then visible in the view material tab.
  • The Mentor view uploaded the material by all the users which is validated by the admin and he can download materials.
  • The Mentor can solve a query if he/she is unable to solve queries forward it to Asst.Professor/Professor.

Professor:

  • Professor registration and login.
  • Professor can upload material, view material, and reply to queries. The upload materials first verify by the admin and then visible in the view material tab.
  • The Professor view uploaded the material by all the users which are validated by an admin.
  • The Professor can solve a query and send it back to the mentors.

Software Requirements:

           Operating System: Windows 10/11

           Web Technologies: HTML, CSS, JavaScript

           Programming Language: Java, JSP, Servlets

           Backend Database: MySQL /Oracle 10G

           IDE / Work Bench: Eclipse/ Netbeans

Hackathon the Code Festival Java Project

Abstract:

Hackathon is a Java web application used for hackathons.  In this web application Project, the Hackathon conducts code fests. The contestants must register to participate in the code fest. The Hackathon announces code festival schedules with desired skill sets. Those eligible for the hackathon can register themselves by using their login credentials. For registered contestants can participate in code fest by using this application. The Hackathon can announce the winner of that particular event and the results also. The contestant can view the results. This Application is very useful for users and the code fests are useful to improve their skills.

Implementation:

This Hackathon the Code Festival project is divided into four implementation modules. Those are

  • Admin
  • Mentor
  • Contestant

Admin:

The admin will maintain all the information about the website and enables contestant to register for a particular hackathon. Then the admin for that particular hackathon enables the contestant to participate in that contest and he is also responsible for displaying the list of contestants for that hackathon. Then the admin is responsible for deciding the winner of that particular hackathon. The admin can give privileges to the contestants to send invites for their friends to participate in the contest.

Mentor:

The mentor is also having the same responsibilities as the admin. The mentor can view the no. of registered contestants and no. of participants. The mentor is responsible for displaying all the contestant’s scores in that hackathon. The mentor can also display the winner of each particular hackathon.

Contestant:

Contestants can choose a particular hackathon in which they are interested from the list of hackathons. To access this application Contestants must and should register. Each every time the contestants should log in by using the given credentials.  Contestants can view the list of Hackathons. The Contestants can participate in hackathons by giving their details about that particular hackathon. The Contests can view the result and winner of the Hackathon.

Software Requirements:

Java, MySQL, HTML, CSS, JavaScript

Campaign Management System Platform for Women PHP Project

Project Problem Statement:

Women all over the world are disadvantaged when it comes to having access to knowledge/capital for starting a business, crowdfunding, political campaigning, and more. 

Women are limited by several factors at different times in their careers, including disadvantaged economic status, discrimination and restrictive gender norms, and lack of access to knowledge on how to start a business or traditional fundraising networks.

Home Page:

The objective of the Task

The main objective of the Campaign Management System project is to build a web-based platform for women so that they can overcome the economic and social barriers that prevent their access to political decision-making through training, mentoring, and technology.

Database Schema:

Pages:

  • Registration page, Login page, welcome page, backend of profile
  • Home page, Dashboard Page
  • Profile page

Technologies used:

1.HTML

2.CSS

3.PHP

4. MYSQL

5. BOOTSTRAP

6. JAVASCRIPT

Download the Project on Campaign Management System Web application using PHP & MySQL.

Portfolio Management System MCA Project using PHP and MySQL

ABSTRACT

The main objective of the portfolio management system is to design and develop a web service that is useful for job seekers and job providers to meet. Create a portfolio website to show off your projects and achievements to prospective employers.

Here, the database is used to collect all the personal information of the candidate for generating their resume profile on the portal. The system admin will generate a report according to the company’s needs and requirements.

INTRODUCTION

Project Description

  • The Portfolio Management system refers to building a strong resume for the candidate who is seeking jobs online.
  • This system introduced a way of hiring employees for the organization that contains all the information of the employees and according to their skill and job requirements, they get selected for the particular post.
  • The purpose of Portfolio management is the selection, prioritization, and control of an organization’s programs and projects, in line with its strategic objectives and capacity to deliver.

The world is growing digitally, and for job seekers, there are more opportunities to seek employment. This system introduced a way of hiring employees for the organization that contains all the information of the employees and according to their skill and job requirements, they get selected for the particular post.

Scope

A Portfolio system is a dynamic and continuous process. The following are the scopes of portfolio management:
1. Monitoring the performance of the portfolio by incorporating the latest conditions.
2. Identifying the objectives, preferences, and constraints.
3. Compare with the latest targets and achievements.
4. There is no need of keeping a physical resume for the candidate.
5. Users have their own login ID and password, with which they can secure their documents.
6. If a wrong password is given three times in succession, that user account will be locked and the user will not be able to use it.
7. Once provided with internet access, users can take part in the system from everywhere.

Purpose

The purpose of Portfolio management is the selection, prioritization, and control of an organization’s programs and projects, in line with its strategic objectives and capacity to deliver. It is a collection of projects and programs used to structure and manage investments at an organizational or functional level to optimize strategic benefits or operational efficiency.

Product function & User classes

User:-

  • Users have to register into the system first.
  • Users can provide their achievements, resumes, and skills in extra detail.
  • Users have to login into the system.
  • Users can view their portfolios according to their details.
  • Users can change their details in the system.
  • Users can provide feedback to the organizations.

Admin:-

  • Admin has to login into the system.
  • Admin can change their details.
  • Admin can view/block the latest registered details.
  • Admin can filter the details.
  • Admin can search the candidate by their skills, name, achievements, and degree.
  • Admin can select appropriate candidates.
  • Admin can send emails to the selected candidates.

Updating the details

  • As we can clarify the profile photo of the user has been updated with the profile and database as well.
  • As follows the update procedure, all the details would be updated with the same result as shown in the image.

Category

Portfolio management is an online web-based application so the main advantage is that there is no more system compatibility requirement problem.

Advantages

  • It improves the candidate selection process.
  • It is used to make smart decisions in the organization.
  • It provides more accurate user performance data.
  • It helps to achieve better productivity in the organization.
  • It also helps to make projects successful.

Design Phase Diagrams:

User Side Activity Diagram:

Admin Side Activity Diagram:

Database Design:

Functional Requirement

Administrator:- Responsible for managing clients of the system, taking system backup, generating reports, and maintaining the organization’s whole details.
Manage Users:- The administrator can manage the user information and the admin can mail and send the details to the appropriate user.
Maintain Details:- The administrator maintains the entire details of the system including details of the users.
Taking System Backup:- The administrator takes a backup of the database in order to prevent loss of the data on system crashes. He takes backup of the entire database in a particular section.
Generate Reports:- Responsible for checking the logs of different system users for auditing and maintaining the whole system.
Use Registration & Login:- The first thing is to register yourself by giving a proper mail id and password then move forward to login into the system.
Filtering as per need:- The administrator can filter the candidate & can view the information related to the filtering.
Non-Functional Requirements
User Interactive:- The response of the website should be high and the website should behave as per the user’s action. Users should be acknowledged in the form of visual changes or feedback on the site to enhance the interaction. The portal should be maintained across all the web pages.
Security:- Secure login option to the users to avoid unauthorized access to the system and the information. 
Reliability:- Portal should provide the users with valid information at all times.
Business Rules:- This requirement contains all the rules and regulations on behalf of the system.

Software tools:-

Front End:- HTML, CSS, Bootstrap, jQuery.
Back End:- MySQL, PHP.
Front End tool:- VS code, Wamp server.

Hardware Specification:-

Hardware platforms support banking transactions. A Portfolio system is effective when the correct software application and hardware configuration are used.
Processor: Intel Pentium 4 or above
RAM: 256 MB OR above
Hard Disk: 160GB or above

System Advantages

  • Building a resume online may save you time which can be utilized in a better way.
  • Candidates may instantly customize their details with one click or add some new details with the same.
  • The site built confidence to boost since you can make your resume professional and you may able to impress the recruiters with your resume.
  • Since the admin can generate reports the process of selecting candidates will be easy.
  • The system is used to make smart and effective decisions for the organizations while selecting a candidate.
  • The system provides more accurate user performance data.
  • The system is helpful to achieve better productivity in the organization.

Limitations of the system

  • The major limitation of the system is that is they work purely online, and lacks the functionality to enable the user to save a copy of their resume in other word processing software like Microsoft Word.
  • Another limitation of the system is that they mostly offer a limited choice of formats. 

Future Scope of the system

  • The system is having currently a static base design that can be chosen by the user, according to their needs they can choose whatever resume type.
  • To increase the system enhancement and database security for the future.
  • Users can delete their account from the site, as they got hired or for some other reasons.

Conclusion

  • The portal has been successfully completed. The goal of the system is achieved and problems are solved. The package is developed in a manner that is user-friendly and required help is provided at different levels.
  • Different types of reports can be generated which help the management to take the correct decision and reduce the time delay which automatically increases the company’s work standards as well as the economical state of the company.
  • This system never decreases the manpower but helps the development of available manpower and optimizes the manpower by which the company’s standards and capabilities can be scaled to higher dimensions.

Download the complete Source Code of the Portfolio Management System MCA Final Year Project Using PHP, MySQL, HTML, CSS, Bootstrap, jQuery

Gym Fitness Management System Python Project using Django, HTML5, CSS, JS, MySQL

Introduction

  • The aim of creating this project is to bring every manual activity of the gym to the website or on the online platform.
  • This helps in making work easy for the gym staff which is lengthy and a little bit complex because of doing it on paper.
  • This website also helps the member of a gym, through this website the members can track their attendance manage their schedule, and many more things which we will discuss further.
  • It also allows guest users to apply for Gym membership directly via the website.
  • Trainers of the gym also can track their attendance and workout details of members via this website.
  • Trainers can prepare workout schedules and diet charts for members via this website.

Entities:

  • Admin
  • Trainer
  • Member
  • Guest

Project Profile

Requirement Gathering:

ADMIN:

Admin is the one who manages the whole website and has every access right to the website. Admin can do the following things:-

  • Admin can log in.
  • Admin can add, update or remove Gym Details.
  • Admin can manage the members and trainers of the Gym.
  • Admin can manage the attendance of members and trainers.
  • Admin can manage memberships.
  • Admin can sell Gym products.
  • Admin can provide fitness blogs and videos.
  • Admin can manage payments.
  • Admin can generate reports.

MEMBER:

Members are like clients of the Gym. Member can also access many things on a website like purchase products, view attendance, etc. member can do the following things:-

  • Member can log in.
  • Member can manage his/her profile.
  • Member can track his/her attendance.
  • Members can watch training videos and workout schedules and diet charts provided by Trainer.
  • Members can buy Gym products.
  • Members can manage payments for membership renewal.
  • Members can provide feedback for the website and Gym.

TRAINER:

Trainers are like employees of the gym. Trainers will do things like managing the workout schedule and diet chart of members. A trainer can do the following things:-

  • A trainer can log in.
  • A trainer can manage his/her own profile.
  • A trainer can view or track the attendance of members and his/her own.
  • A trainer can manage users’ workout schedules and diet charts.
  • Trainers can upload workout videos for users.
  • Trainers can give reward points to members on the basis of their weekly performance.

GUEST

Guests can only serve or see the gym website, he/she can do anything only after registering for the gym and website.
• Guest users can view the website.
• Guest users can register/Apply for a Gym membership

ER Diagram:

Existing System

  • Customer data is stored manually either in registers or in MS Excel.
  • Books are maintained to keep track of Customer attendance.
  • Payment transactions are kept in books.
  • Currently, the GYM does not have any advanced system to manage the GYM.

Proposed System

  • In the new system trainers and members can track their attendance from anywhere.
  • In the new system, a member can get his/her diet chart according to their workout plan.
  • In the new system, members can get a workout schedule from the trainer, while they also get rewards for points for achieving workout targets.
  • In this system, members can watch workout videos provided by their trainers which helps them to do exercise at home.
  • Here members can also purchase gym products.

Tools And Technology Used

FrontEnd: HTML5, CSS 2.1, JS
Backend: Mysql 5.5
Framework: Django 3.1 (Python 3.8)
Other Tools: Microsoft Powerpoint 2019, EDraw max 9.0, Microsoft Visio 2016, and Microsoft Word 2019

Data Dictionary

1) Table Name: User_Type

Table Description: Contains details of user type. It will give information about the type of user whether it is a member, trainer, or admin in the User_Master table.

2) Table Name: User_Master

Table Description: Contains details about users. It will contain all the basic information about users like name, email, gender, address, mobile no. etc along with the type of user.

3) Table Name: Plan_Master

Table Description: Contains details about membership plans. It will contain all the basic details about plans that a member can choose for a gym membership.

4) Table Name: Membership_Master

Table Description: Contains details about members’ memberships. It will contain all information regarding memberships of members according to their chosen plan.

5) Table Name: Trainer Details

Table Description: Contains details about the trainer. It will contain additional details about trainers along with details in the User_Master Table.

6) Table Name: Payment_Master

Table Description: Contains details about payments. It will contain the payment details of Memberships of a member

7) Table Name: Product_Master.

Table Description: Contains details about Gym products. It will contain basic information about products that the admin wants to sell and that a member can buy.

8) Table Name: Feedback_Master

Table Description: Contains details about feedback. It will contain feedback details given by members about the Gym.

9) Table Name: Workout_Master

Table Description: Contains workout details of members. It will contain members’ workout details like diet charts, workout schedules, workout videos, and reward points provided by trainers.

10) Table Name: Order_Master

Table Description: Contains Order Details. It will contain basic order details like which member has made the order, date of placing an order, delivery date, etc. of orders made by members for their purchase of products

11) Table Name: Order_Details

Table Description: It contains order Details. It will contain additional information about orders like the product purchased, the quantity of the product, the Price of the Product, etc. in relation to the Order_Master table.

12) Table Name: Attendance_Master

Table Description: Contains details about the attendance of users. It will contain day-to-day attendance details of members and trainers which will be added by admin.

Modules Functionalities:

ADMIN SIDE:

  • Login page for admin with validations. The email id Field Should not be empty. Email id should match the requested format which contains @ and (.)
  • Admin not allowed to login due to invalid username.
  • Change the Password page of Admin, the retyped password doesn’t match the validation Correct admin username and password:
  • Home page of Admin:
  • Admin dashboard. It Shows Side Panel which directs it to the selected page to be visited. The Page shows the direct link and information of User_type, Users, Trainer details, Attendance, and plans.
  • Add User Type: Admin is adding user type member
  • When the view tab of User type is clicked type of users is shown on this page
  • Add Users window can be opened from the side panel and the Admin can add a new user.
  • View Users window- All the users are shown here to the admin where the admin can take actions like edit and delete.
  • When the view part of Plans in the side menu is clicked plan details are shown.
  • Add Plans window-Admin can add new plan details in this window.
  • Admin can add membership details of the user, here validation is showing where the amount field is required.
  • When viewing a part of Membership Details in the side menu clicked Membership details table is shown
  • Attendance adds window- In add attendance window admin can add attendance details of users.
  • When view part of attendance in the side menu is clicked attendance details of users are shown
  • Then add part of Trainer Details is clicked, Admin can add details of the trainer.
  • View part of Trainer Details where Details of the trainer have been shown.
  • Add payment window is open when adding part of Payment Details is clicked, Admin can approve Payment Status.
  • When the view part of Payment details is clicked Payment Details is shown.
  • Add product window is shown when clicking on the add part of the Products.
  • When the view part of the Products tab is clicked all product details with price and quantity have been shown.
  • Add Workout Details Window – The admin can add Workout Details of a particular user by adding a diet chart, workout schedule, and workout videos for the user.
  • View the Workout Details window where all the details of a user’s workout(including diet chart and schedule) are shown.
  • View Order window – All the details with delivery status are shown in this window.
  • View Feedback window: Admin can view feedback and ratings given by users in this window.

TRAINER SIDE:

  • Trainer Login Page:
  • Trainer dashboard which contains information about trainers with Edit Profile and Change Password Link. It Shows Side Panel which directs it to the selected page to be visited. The Page shows the direct link and information on Attendance and Workout Details.
  • When Change Password Link is clicked, the trainer will be redirected to the Change Password Page where he/she can change their login password:-
  • Change Password Validations:-
  • When the My Attendance part of Attendance in the side menu is clicked attendance details of his/her own are shown:-
  • When the Members Attendance part of Attendance in the side menu is clicked attendance details of the member are shown:-
  • Dashboard Showing Add and View Option in Workout Menu of Side Bar :
  • Add Workout Details Window – The trainer can add Workout Details of a particular user by adding a diet chart, workout schedule, and workout videos for the member.
  • View Workout Details Window: Details of member workouts including diet chart, workout schedule, and total reward points are shown in this window.

GUEST SIDE:

  • HomePage:- The starting point of the website/first page of the website
  • About Options:-
  • About Us page giving information about GYM:-
  • FAQ Page:- It Contains all the frequently asked questions with their answers
  • Testimonial Page:- It contains all the reviews given by the members.
  • Contact Us Page:- It contains all the contact details of the gym.
  • When a user clicks on the Apply For Membership tab Registration page is opened which Collects user data for registration so that the user can make a login.
  • Registration Page Showing How to Apply for the GYM Membership.
  • Registration page displaying validation:-
  • After Successfully filling Registration Form, the User will be redirected to the Payment Confirmation Form which will show the user information along with the plan he has chosen while registering then the user has to choose how payment was done, enter transaction no. and has to upload Payment Receipt.
  • When User will successfully submit the payment confirmation form, they will be redirected to the Login page or can open it from Login Tab.
  • Login Page with Validation:-
  • Forgot password? – asking for a registered email ID
  • Password received by the customer through email.

USER SIDE:

  • After Successful Login User will be redirected to the Homepage. The Apply For Membership and Login heading is changed to My Account with Profile, Membership, Attendance, and Logout Options.
  • When the User Clicks on Membership, He/she will be redirected to the membership page which contains the membership details the user.
  • When the User Clicks on the Attendance option in the My Account Section he/she will be redirected to the Attendance Page which contains the attendance details of the user:-
  • Shop Page:- It contains all the products with details that the gym wants to sell.
  • Add to cart option on the product:-
  • Shop Page showing Add to Cart Option for a product:-
  • After clicking add to cart from Shop Page, Cart is opened which shows items in your cart.
  • If the Customer wants to shop for more than one product, he/she can click on Buy More and add other products also.
  • When the User clicks on Proceed to Checkout, the Checkout page is opened which shows order details and Billing details and gives the summary of your orders.
  • After clicking Place order, the user is provided with the appropriate order placed message and view order option. On clicking view order user will be shown all the details of his/her orders.
  • When the User Clicks on View Order, he/she will be redirected to My Orders Page which contains all the order details of orders made by the member.
  • When the user Clicks on More details, he/she will be redirected to the order details page which contains additional details about the order.
  • My Workout Page:- It will give the user his/her option to download his/her diet chart, workout schedule, and workout videos provided by the trainer
  • Blog Page:- It contains all the fitness blogs that users can read.
  • Homepage showing My Account Section having Options Profile, Membership, Attendance, Logout:-
  • On clicking the Profile Option in the My Account Section, the User will be redirected to the My Account Page which contains all details of the currently Logged In User like name, address, gender, email, mobile, etc. with the Edit Profile/Change Password Option.
  • When the User Clicks on Change Password, he/she will be redirected to the Change Password Page where the user can change his/her old password new password.
    Change password Validations:-
  • Showing Logout Option In My Account Menu:-
  • When the User Clicks on Logout, he/she will be redirected to Login Page.
  • Report of all the users registered with Dynamo Fitness.
  • Various Filters for user reports like reports based on user type, i.e. members or trainers, and reports based on gender.
  • Report after using the user type and gender filter it will show only gym members who are female as we used the user type filter as members and gender filter as female.
  • Report on Current plan and membership of the members it displays the name and plan type of members.
  • Membership report using start date filter for plans starting date.
  • The report shows the list of members whose memberships start in a selected month.
  • Filter based on plan title i.e. basic, standard, and ultimate plan.
  • list of members who are registered with the standard plan.
  • Report after using the print option, the report shows the member with their specific plan with a start date and end date of the plan.
  • Report for the feedback given by users with filters that are gender and ratings.
  • Report using a rating filter, it will display users with specific ratings.
  • Report showing list of users given rating 9.
  • Feedback report after selecting the print option.
  • PDF view of feedback report using the view pdf option.
  • Product order report showing user id with the product they ordered
  • A report showing a filter of product names with different products available.
  • Reports after applying the product name filter i.e. dumbells will show the product id and user id of the users who ordered them.
  • Report after using a filter with the Delivery status it displays the product which is delivered.
  • The attendance report shows the attendance of users that are members and trainers on day to day basis.
  • The filter of the Attendance report is based on the user type i.e. Member and Trainer.
  • The attendance report on the base of the trainer filter displays only trainer attendance.
  • Report after selecting the print option.
  • Date filter option for a report which shows the attendance of users of a specific date.
  • Report After Filter By Attendance Date and Gender

CONCLUSION

The entire duration of this project has been a great learning experience for us. It has introduced us to the working of real-life projects and taught us to face obstacles while developing them. By developing this web application, we hereby conclude that at Gym Management we have achieved our aim at the following:

1) Building a platform where people can apply for a GYM Membership at any place and start their workout activities even at Home.
2) We believe that this website has made it easier for the GYM Owner to manage the information regarding different aspects of the Gym.
3) This website has also made it easier for trainers to manage the workout activities of members. We also hope to expand the scale of the project and make it ubiquitous by developing it for all digital platforms.

Download the complete project on Gym Fitness Management System Project using Python, MySQL, and Django Framework.

Online E-Commerce System Project Using HTML 5, CSS 3, NodeJS and ExpressJS

Purpose

  1. To develop an online e-commerce system that will provide a platform for customers and sellers to meet and sell and purchase items. The Online e-commerce system shall accomplish the following as of achieving the major goal:
  1. To build a user-friendly business website, where users will be able to search for any product which is available nearby or anywhere in the world. By using an Online e-commerce system, it will be easy for sellers to sell products and save time and money. Doing business through this application will help to reach a maximum of customers and sellers. Creating a panel where a seller is able to upload their product’s full details and a customer can view and make a purchase as per their wish.
  1. To implement the system and check if it actually is able to provide benefit to the people.

Scope

The scope of this application is to build a user-friendly e-commerce website, where users will be able to purchase any product which is available on the website. By using the e-commerce system, it will be easy for sellers to make a sale and save time and money. Doing business through this application will help us reach a maximum of sellers and customers globally.

General Objective

To develop an online e-commerce system that will provide a forum for sellers and customers to interact with each other, and sell and purchase items.

Specific Objectives

  1. Create an online platform where sellers post items for sale through the online system.
  1. Create a panel where a customer can view products from a seller and make purchases and do payments through online payment systems, and later submit reviews about the service.

ER Diagram:

Data Flow Diagram:

UML Diagram:

Modules Description

Sign Up

1. It is used to register or to create a new account for a particular website.
2. It also allows the user to be a part of the website and also provides all the services of the website.

Log in

1. It is used to open a session with an account that is already created.
2. It is successful when your credentials (i.e., username and password) match with what is already stored in a database. This is called authentication.
3. It makes the site personalized for you.

About

1. This module gives an overview of the website.
2. It shows the website’s business, values, and commitments and its management.

Contact

This module allows the users to ask any queries related to their property or anything.

Search

This module is used for searching the posted auctions

Add Product

This module helps in posting Auctions

Product Function

1. Enable the customers to view posted products in their locality and also globally.
2. Enable the creation of accounts and logging in to the accounts
3. Enable users to log out of their accounts
4. Provide an interface for the seller to view the transactions, and add sellers and products to the system.
5. The seller should also have accounts where they will receive customer orders and respond to them.

Modules 

  • Login and new registration
  • Search: The search page will help users to search for the desired items using the search box.
  • Contact: This module will help users to contact the seller in case of any queries or issues that arise.
  • Add Product: This module will help the seller to add new products to the system

Summary

This NodeJS-based website is a reliable web application that saves time and money. This must be implemented in most of the information technology industries. It is user-friendly software, through which users can easily interact and easy to search for and buy products. This turns out to be great usage.

With the rapid growth of the internet and the world wide web, everything is going online. This website is developed by keeping in mind the easiness of interaction by the users so that they get a very user-friendly environment while surfing the website. Such compatibility of this website enables it to attract users to visit the website more frequently

The system is capable of maintaining details of various users, sellers, and products and storing all day-to-day transactions. The central concept of the application is to allow customers to search, compare and purchase products using the internet. The information pertaining to the products is stored on a NoSQL database on the server side. The Server process the customers and the orders and stores them in the database. 

Future involvement with the project

We will keep on improving our project in the future by adding more and more modules in the system as per the needs of the users. 

Limitations

Our project was limited in time and cost which is a limitation. If provided with more time and cost, we would have done better using the better infrastructure.

We developed the project on a local offline server, though we could have used an online one if provided with more cost.

Hardware & Software Used

Hardware

1. HP Notebook
2. i5 10th Gen CPU
3. 8GB RAM
4. 512GB SSD

Software

1. Visual Studio Code
2. Postman
3. NodeJS
4. ExpressJS
5. Google Firebase
6. AWS
7. HTML 5, CSS 3 & Javascript.

Library Management System BCA 4th Semester Minor Project using SQL and PHP

ACKNOWLEDGEMENT

We truly resolve to acknowledge the opportunity provided to us by the Institution, respected teachers, and family.

We intend to show our gratitude for all the support and guidance we got from our teachers, classmates, and all individuals who helped us at any point in this project.

This whole process we went through in bringing out this project was a great source of knowledge and valuable experience, which would for sure, come in handy for us in any future we will have to bring out another such project.

This has been a period of time over which we learned about technological and logical aspects of the field where we are going to land soon, we feel indebted for being so well equipped with all the knowledge and experience we gathered here.

Introduction 

Surface details:

Our project entitled “Library Management System” is designed to bring ease to both the library staff and the students seeking for issuing books.

It is designed with features that reduce the effort for the staff and increase convenience for the readers, Being a Web Based application, it is easy to Run and adapt in almost all conventional environments.

Any moderate user can easily learn and operate this system 

Scope:

This System can work fine for all most every library, where desired,

This cuts off a lot of human resources required to maintain the library, hence saving money too.

It has fluid UI and UX which can be learned and adapted quite quickly by any category of user.

This system extends its use outside the library with is easy to adapt interfaces for readers

Objective

The Objective of this System is to reduce effort and increase convenience in the management of libraries.

It allows users to hold a book for 24 hours so that no one can get it issued before they reach the library.

It will save time in the calculation of fine

Students will always stay notified about generated fines via their online accounts which they can access from anywhere.

  • It will make it easier to search for books.
  • It will help keep track of bookholders.
  • It will keep Libraries less crowded.
  • It will save money as fewer human resources will be required.

About the existing system

Currently, libraries need to maintain bulky files to record books and the individuals occupying them.

Fines are calculated manually by going through bundles of records.

Need to manually check for availability of books in the library

The process of issuing a book involves designated officials making entries in registers manually, which takes plenty of time.

Disadvantages of the Present System:

The current system is full of flaws:

  • A lot of Human Resources is required to maintain such a system much cost and hard to operate and maintain.
  • A lot of money is wasted in maintaining these records
  • Paper is wasted
  • A lot of time is consumed in the process of searching a book, making its entry, and retrieving any previous record.
  • Availability of books cannot be assured without physically searching the library
  • People need to travel to the library to know whether a book is available. 

Proposed System

The System we developed comes with all solutions to the drawback of the previous system.

Some of them are listed below:

  • Search books from anywhere.
  • Put the book on hold for 24 hours so that no one else can take it before you
  • Release the book if you don’t want to hold it anymore
  • A panel for users to check their hold and issued books
  • Easy login and registration System.
  • Automated Fine System
  • One-click book Issue
  • Easily return book
  • List of trending books.

Feasibility Study

This document enables proper decisions to be made over the progress of the project, by studying various aspects of feasibility associated with it

Such are listed below:

  • Cost: as it is a web-based project it needs to be hosted over the server to be accessed by users, but the efficiency which comes with the product shadows this cost, as it reduces money being spent on human resources
  • Time: The time invested in this project is also justifiable as keeping the yield into consideration.
  • Technical: All technological tools used to make this project are conventional easy-to-use ones, and they are easy to maintain too.

This project can be easily upgraded and maintained as it is designed in a standard manner and is easy to understand. 

Hardware and software information 

HARDWARE CONFIGURATION

  • System: Multimedia PC
  • Processor:  Pentium 4 or above
  • Memory: 512MB RAM or above
  • Hard Disk:  500GB
  • Keyboard: 104 standards
  • Monitor: SVGA          

SOFTWARE CONFIGURATION

  • Front end: HTML, CSS, JavaScript
  • Back end: SQL, PHP
  • Operating System: Windows/Linux

Design Phase:

ER Diagram:

Context Level Diagram:

First Level Data Flow Diagram:

Second Level Data Flow Diagram for User:

Second Level Data Flow Diagram for Admin:

 

DATA DICTIONARY 

Users Table:

Name

Type

Field-Size

Description

Example

Uid

INT

100

Unique ID for Users

0

name

VARCHAR

100

Name of user

XYZ

password

varchar

100

Password

XYZ

credit

INT

100

No.of books currently Occupied

0-5

U_type

varchar

100

Reader/admin

admin

Pic

varchar

100

photograph

Xyx.jpg

Email

Varchar

100

Email for identification

[email protected]

 

Books Table:

Name

Type

Field-Size

Description

Example

bookid

INT

100

Unique id of book

1

bname

Varchar

100

Name of book

Life of pie

stock

INT

100

Available copies

66

Author

Varchar

100

Name of author

ABC

Publication

Varchar

100

Publication name

BBC

Edition

Varchar

100

Year of publication

2013

Price

Int

100

Price of the book

2000

 Transactions Table:

Name

Type

Field-Size

Description

Example

Tid

INT

100

Unique id of the transaction

1

bid

INT

100

The ID of User Involved

1

uid

INT

100

The ID of Book Involved

1

Time

timestamp

100

Time of transaction

2018-07-02 19:55:11

Returned

INT

100

State(returned or not)

0

T_type

Varchar

100

Hold or issue

issued

Download the complete project on College Library Management System using SQL and PHP.

Professor Online Question Paper Submission to the Examination Cell ASP.Net Project

Introduction

Online Question paper submission is a web portal that is developed or implemented in the ASP.NET domain or platform. This project is helpful for the Professor to submit the question paper to the examination cell or to the Examiner from this site. In the current generation preparing the question paper and handovering in the examination cell is not that much security. This project is developed for a Professor to maintain his details, experience, and preparation of question paper and submit the same to the examiner. The examiner also gives his information, experience and takes approval from the administrator, and then selects the question paper. This project will work on the same line of online examinations; Apart from this, it contains much more additional information such as Course type, Department details, and other details of professors and examiners in this web portal.

For the examination cell, it is very difficult to identify whether the particular question paper is submitted or not. The online Question paper submission portal is implemented in 3 main modules. Professor module, Examiner module, and Admin module. Admin module will add multiple courses and departments under different branches so Professor can easily know the best details of about subjects. The professor module ought to register with the application and choose the course and upload the question paper to the site.

Scope of the Project

The scope of the project is used to manage the details of the professor, Examiner, and Administrator. The Professor and Examiners Sign up by providing the appropriate information and then take approval from the administrator. According to course-wise Professors prepares the question papers and send them to the examiner, then the examiner selects the question paper and submits it to the board. And all these records are stored in Online Question Paper Submission Database. 

Design of the Project:

ER Diagram:

Main Modules of the Project

Administrator

 He administrates by giving approval to Examiner and Professor’s Signup. He also creates Courses, Departments, and Designations in order to fetch the correct and appropriate question paper for that course and department.

Course Details

 It is created by the Admin and it consists of Details of specific courses like BCA, BBA, BCOM, and more. The professor sends the Question paper on the basis of the Course.

Department Details

 It is created by the Admin and it consists of Details about the entire department which is created. The Department section consists of the Department name and Address of that Department.

Designation Details

  It is created by the Admin and it consists of Details about the Designation of a particular professor. This section consists of  Designation names like Ass-professor, HOD, and so on, it also has a description section under the Designation name which helps us to know which particular department the professor’s designation is from. 

Professor’s Signup

 In this section, any professor can sign up. But the request is only approved by the Admin. This section consists of the Login name, name of the professor, password and confirms password to confirm, phone number of that particular professor-main ID, and at last the address of that professor.

Examiner’s Signup

 In this section, any Examiner can sign up. But the request is only approved by the Admin. This section consists of the Login name, name of the examiner, password, and confirm password to confirm, and here it consists of designation and department where the examiner can select any of the given designations and department. At last, it asks for the Address and a photograph of that particular Examiner.

Approval for both Professor & Examiner

 This action is performed by the Admin. He approves both professor and Examiner. 

Login for professor & Examiner

 A Professor who has been approved by the Admin can now log in to the Login section and the same for the Examiner too.

Details of Question paper

 Every Question Paper must be sent with appropriate details so as to know more about the paper at a single glance.

View and Edit the Question Paper

 It is viewed and Edited by the Examiner and it is submitted to the University.

Final Reports

It creates and shows all the database records of this project.

Screenshots of Online Question Paper Submission System:

  • Home Page
  • Admin Login Page
  • Admin Main Screen Lists Section
  • Admin Main Screen Create Section
  • Admin Main Screen Approval Section
  • Admin Department list
  • Admin Designation List
  • Course Creation Section
  • Department Creation Section
  • Designation Creation Section
  • Home Screen Signup Section
  • Professor Signup
  • Professor Approve Section
  • Professor Main Screen
  • Examiner Signup Section
  • Examiner Approve Screen
  • Examiner Approve Page
  • User Login Page
  • Examiner Main Screen
  • Examiner Document Viewing Screen
  • Professor New Question Paper Screen
  • Examiner Acknowledgment Screen

Conclusion

It is believed that in the future Online Question Paper Submission centralized document system with the concept of cloud technology will recede in importance as a strategic application to become a competitive necessity that must be adopted by most government departments.

India is striding smoothly towards integrated E-Governance.  In the next five years, situation will be entirely different.  Most companies are adopted cloud technology for the maintenance of documents.

Online Question Paper Submission creates a new trend in maintaining and verifying documents online and it reduces the workload. 

Future Enhancements

  • The news feed is essential for our day-to-day purpose; hence we will add a section about the news. There, we are going to display the news about examination dates, deadlines for submitting papers, etc.
  • We are going to add some more security to our system like an OTP number for verification of the Professor’s and Examiner’s Phone numbers.
  • Authentication of Professor and Examiner is also important, thereby uploading the College Approval Letter by Principal (Signed and Sealed), makes it Admin easy to verify them.
  • We will add a few more Image File Formats such as TIFF, GIF, PNG, JPEG, etc. in order to make Professor and Examiner upload photocopies easily.
  • To make a question paper, Professor has to be experienced; therefore we will add a new section while signing up called Years of Experience. In that section, the professor has to enter how many years of experience he/she has in the teaching profession.
  • Live communication between Professor and Examiner makes it easy to fix the problems; therefore we will add live messaging on the portal.

Download the complete asp.net, vb.net project code, and SQL database on the Question Paper Submission project.

IOT Solution for Vehicle Maintenance and Report Generation System

INTRODUCTION

  • Many automotive manufacturers are now moving towards an IoT platform for manufacturing and for service purposes.
  • The main advantages of using IoT in cars are Optimized maintenance and logistics.
  • Our idea is to monitor vehicle status (fuel, efficiency/Km, battery, oil levels, etc..,.) to the customer as well as the manufacturer.

CONCEPT

  • The main aim of every car manufacturer is to increase the life of the car and it’s crucial to maintain the car in a good condition to achieve it.
  • Many problems in vehicles arise due to improper maintenance. Many lose track of their service status and it’s a tiring process to keep in touch with every customer in a large automotive industry.
  • If we maintain a system, that automatically updates the vehicle’s conditions periodically to a specified server, and the system will generate a report, that will be forwarded to the customer and the service team, a lot of manual work will be removed.
  • We as a team provide an IoT solution for vehicle maintenance and report generation system.

FLOW DIAGRAM-FUNCTIONAL DECOMPOSITION

  • Our Vehicle Maintenance and Report Generation system collects data from the sensors available in the car itself and reports it to a transceiver module(ESP8266) which is connected to a database in the cloud.
  • when new data is updated/inserted into the table an event is triggered. This event updates the information in the dashboard, which will be displayed to the customer and manufacturer.
  • Then a weekly/monthly/yearly report generation event is triggered, which will mail the report to the specified recipient.

FUNCTIONAL DECOMPOSITION

Data collection:

The data is collected from the sensor stream of the car. This data is redirected to the ESP8266 module. The ESP8266 is connected to the server, that is allotted to the car. The ESP8266, when all data is collected, converts it into a JSON file. Then the server sends a post request to the server.

Event trigger:

Many database servers provide pl/SQL-based triggers. Here an Update and Insert trigger is created for the table. Oracle server provides a wide range of PL/SQL functions. The IP of ESP8266 is connected to the oracle server, which on periodic updates in the table triggers an event.

Dashboard:

The dashboard is created using HTML and CSS and deployed in the cloud using the NODE JS framework.

FUNCTIONAL SPECIFICATION

Hardware:

ESP8266 CP2101 module(CAR)
ESP8266 CP2101 module(HOME)

Programming Language:

SQL
Javascript (Node JS)
C++(Arduino .ino)
HTML CSS

Dashboard

The Vehicle Maintenance and Report Generation System dashboard are developed using Adafruit.io. This website provides dashboard development for MQTT-based devices

University Leave and Outing Pass Automated System Application

Purpose of the Project:

This Project is a leave/outing pass automated system designed for Educational Universities. This system is an end-to-end module that enables a user (Student) to raise a request and an admin (Mentor) to approve/decline it. This is a robust system where Parent Verification, In-Out Time recording, and Data Security have been taken care of. This Project is built to be a secure, flexible, unique, transparent, and user-friendly environment that aims to digitize the whole process thus removing fake paper trails.

Feasibility Study:

The project has been undertaken after the feasibility study, which paves the way for deployment, and phase development.

Scope of the Project:

The scope of the Automated System is designed to run on the University server and to allow students to raise requests for their leave, trace the request status, and modify them. On the Mentor Dashboard, the software also allows the Mentor/ Mentor Coordinator to view requests, and approve/decline requests. Whereas on the Hostel Dashboard, the Warden/ Deputy Warden and Hostel Supervisors will be able to view and grant leave passes to the students.

This Automated System will provide ease to all the actors – students, mentors, hostel authorities, and security services in regard to leaving/outpassing sanctions and will ultimately eliminate the paperwork.

Overall Product Description:

Product Perspective:

It will provide a way in which existing paper-based work can be supplemented with the end-to-end robust leave management system. The system can be used independently of the platform and device, be it on a smartphone, tablet, or computer.

Product Functionality:

The server will be responsible for storing each request generated, generating one-time passwords, generating QR Codes E-Pass for authorized requests, receiving and authenticating requests, generating statistics at the needs of each audit, and maintaining and verifying security and user privacy. This server can also potentially contact all authorized students by email to give them username information, passwords, server address, OTP code, updates to the users from the Mentors/ Hostel Services, etc.

Process Flow – Student:

  • depicts how the student raises the request and the activity which is continued after the review from the mentor.
  • depicts how the Mentor/Warden/Supervisor approves/declines the requests.
  • depicts how the Security guard can verify the leave request the student displays.

Upper Classes and Characteristics:

It is anticipated that three types of users will use the Licensed Software defined in this SRS.

  1. IT staff/ Software Development Cells are expected to deploy and configure the System using the defined system interfaces. This will include running the whole system and maintaining software after the handover and deployment of the project.
  2. The second type of user of the Hostel Warden/ Deputy Wardens / Hostel Supervisors and Managers is expected to understand and use correctly the software interfaces defined with the appropriate design documentation.
  3. Finally, it is expected that any student accorded with Hostel Services within the domain of Vellore Institute of Technology may access all of the leave request information such that the request is independently verifiable. This will include a web application presented using Hyper Text Markup Language (HTML) to allow a user to raise their request that has been registered under review including the previous requests history.

Working Environment:

The Automated System software is directly made as a web application, so the computer hosting must be capable of running HTML and should have internet. The system will be uploaded to the University server, in order to make it accessible for all the students, faculty mentors, and wardens.

Design and Implementation Constraints:

The Application provides an end-to-end leave management system that copes with malicious attacks provided certain constraints are met. Principally, all necessary steps should be taken to protect the System from unguarded attacks by using physical, network, storage, and user security protection. These safeguards should be penetration tested by the SDC to ensure viability.

User Documentation:

The users are the students or faculty/staff of the university who are authorized by SDC, they will be able to raise/ view/ approve/ disapprove requests on the server. The application client will be available free of charge, and any purchase of the server software will be authorized to distribute it to their users.

Assumptions and Dependencies:

 This software in its initial phases of development depends on a few third-party commercial applications or any assumption. Student Development Team will take care of all the assumptions and dependencies. It will be the responsibility of SDC to purchase/ develop the dependency as per the University IT norms.

System Features:

Login:

This is used to login and maintain security by authenticating the users

1. Should accept the user name password
2. A case-insensitive comparison is done for a user name and a case-sensitive comparison is done for a password
3. If the correct user id and password are supplied then, Main Menu should be displayed
4. If an invalid user id or password is entered then the system should display the error message “Invalid ID or password” and should quit the application.
5. Username – Students – Registration Id Faculty – Employee Id Staff – Employee Id
6. VTop Login Credentials can be used in the further enhancements

Mentor’s Portal:

This feature allows mentors to work out the leave/vacation requests.

1. Can approve a request.
2. Can decline a request.
3. Can edit the request.
4. Can verify the request.

Warden’s Portal:

This feature allows the warden to authenticate the requests

1. Is able to view all requests for outpass.
2. Can reconsider requests

Hostel Supervisor’s Portal:

This feature allows supervisors to issue outpasses to the students

1. Can issue outpasses to students.
2. Can deny the issue of an outpass.
3. Can send a request for reconsideration to the warden.

Student Portal:

This feature will allow students to raise a request for an outing/extended outing/leave.

1. Can raise requests of respective categories.
2. Would receive a system-generated outpass

External Interface Requirement:

User Interfaces:

Login Interface – The login interface consists of the student username and password fields, Students can log in with the same VTop Credentials.

The login interface for the faculty and staff consists of the faculty/ staff employee id and password. Their credentials will also be the same as those of VTop.

Hardware Interfaces – Hardware requirements include a laptop or a desktop or a smartphone with proper connectivity to access the system. Other than above mentioned, no hardware is required.

Software Interfaces – The software is based on an application interface. The Application will interact with the University Server with regard to user verification and information retrieval.

Operating System

Ubuntu

Programming Language

HTML, PHP, CSS, JavaScript

IDE

Visual Studio Code

Database

InnoDB

Hosting Base

Amazon Web Services

Communication Interfaces – This software would be functional on an ethernet connection or a wireless connection.

Cost Calculation:

SOFTWARE COST ESTIMATION:

For any software project under development, it is indispensable to know how much it will cost to develop and how much development time will it take. The project scope must be established in advance and software metrics are used as a support from which evaluation is made. The project is broken into small PCs which are estimated individually. Several estimation procedures have been developed to monitor the project’s progress, so developers and product managers can assess whether the project is progressing according to the procedure and take corrective actions, if necessary.

STATIC, MULTIVARIABLE MODELS:

Static, multivariable models depend on several variables describing various aspects of the software development environment. In some models, several variables are needed to describe the software development process, and the selected equation combines these variables to give an estimate of time and cost.

WALSTON and FELIX developed the models at IBM to provide equations to give a relationship between lines of source code with effort and duration of development.

For our software project, the lines of code (LOC) sum up to 5223, which becomes 5.223 KLOC.

So, according to the WALSTON-FELIX model, we need to hire 24 engineers per month and require 7 and half months to develop our project.