Medical Shop Management System Java Project using Oracle Database

Introduction

This is software that aims at easy management of medical stores. In the market, a lot of work is done manually. In this era of the computer revolution, where everything is digital, data management and operation also need to be computerized. The existing manual database management system is more problematic and tedious. The calculation of data is not always accurate. The computerized system would reduce the complexity of managing the records and making them secure and easy to access, and get any type of information like the product detail, patient, etc in an easy manner by a quick search.
This system keeps the records of medicines such as medicine name, MRP, MFG, expiry date, quantity in stock, etc. The software also generates patient or customer reports as print out for later reference. After booking the patient order, our stores provide the medicines by hand or home delivery together with the proper bill generated by this software.
This software focuses on high security so that no unauthorized user can make a random transaction. Only the person provided with the proper user ID and password can do the billing or see the reports. And then for signing up as a new user it requires an Authentication number is required which is only owned by the owner of the store. So that no random person can signup for the account.
The software provides two levels of security. As “only billing rights” and “managing rights” so that a person or staff or helper who is appointed for only billing purposes can not manipulate the data stored in the database. But the administrator who has the managing right can have complete access to the data.

Objectives:

The main objective of this software is to provide an easy way to submit information about medicines and some other information as well.
It also facilitates deletion or modification or searching of all information very easily. The system is also helpful for generating reports and statuses. The medical shop management system is software that processes computerized information and manages all the record of medicines which is under medical shop management.
The aim of this project is to make possible easy all the manual errors and problems by automating them, which the users are facing at different levels of management in medical stores as well as provide a high level of security for the data.

ER Diagram:

So in this project, we try to do the best of our effort and hard work to cover some parts of the system process.

Fast Query Process:-

Computerization of the query process is more economical than that of manual processing because the query is updated and stored instantly without any calculation mistakes here we have to just update the product master table or customer master table but in a manual process, we have to change all the records.

Entry new Records:-

Maintaining the records of new entry becomes very easy because every day there are new medicines coming into the market which has a huge demand in the market. So, it’s important to stay updated for patients’ health sake.

Maintenance of all of the records:-

Medical shop management helps in updating all the records from time to time.

Issuing reports:-

Issuing reports issues from the completion of the updating of all tables or records. Here reports issue status is maintained by which we know how much patient comes for medicines, we generate reports of stock status after updating the stock records, etc.

Highly secure:-

This software is highly secure because in the absence of authorized persons, nobody can provide medicines because they have a unique id or password to edit their records which are protected also.

Input or Output Screen Design

  • If the user clicks on generate report then the report page is visible otherwise log it is done according to the user´s rights provided.
  • Generate Report: Provides Report of the customer or patient for future reference and allows us to keep it as a Hard Copy.
  • A new user can get signed up by an authorized person for using this software.
  • The Main menu contains all quick links. In the menu bar, the user can jump to the desired location, saving his/ her time.
  • Search for the desired medicine quickly for modification or deletion.
  • View the stock as Table
  • Keep track of all the transactions by easily checking out the Sales Report
  • Hassle-Free Billing.
  • Easily Customize the purchases.

Download the complete project on Medical Shop Management System in Java & Oracle database using AWT and Swing with ODBC

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.

Decision Model for Prediction of Movie Success Rate Data Mining J Component Project

ABSTRACT

The purpose of this Movie Success Rate Prediction project is to predict the success of any upcoming movie using Data Mining Tools. For this purpose, we have proposed a method that will analyze the cast and crew of the movie to find the success rate of the film using existing knowledge. Many factors like the cast (actors, actresses, directors, producers), budget, worldwide gross, and language will be considered for the algorithm to train and test the data. Two algorithms will be tested on our dataset and their accuracy will be checked.

 LITERATURE REVIEW

  • They developed a model to find the success of upcoming movies based on certain factors. The number of audience plays a vital role in a movie becoming successful
  • The factorization Machines approach was used to predict movie success by predicting IMDb ratings for newly released movies by combining movie metadata with social media data
  • Using the grossattribute as a training element for the model. The data are converted into .csv files after the pre-processing is done
  • Using S-PLSA – the sentiment information from online reviews and tweets, we have used the ARSA model for predicting the sales performance of movies using sentiment information and past box office performance.
  • A mathematical Model is used to predict the success and failure of upcoming movies depending on certain criteria. Their work makes use of historical data in order to successfully predict the ratings of movies to be released
  • According to them, Twitter is a platform that can provide geographical as well as timely information, making it a perfect source for spatiotemporal models.
  • The data they collected was gathered from Box Office Mojo and Wikipedia. Their data was comprised of movies released in 2016
  • Initially having a dataset of 3183 movies, they removed movies whose budget could not be found or missed key features in the end a dataset of 755 movies were obtained. After Key feature extraction was completed.
  • some useful data mining on the IMDb data, and uncovered information that cannot be seen by browsing the regular web frontend to the database.
  • According to their conclusion, brand power, actors or directors isn’t strong enough to affect the box office.
  • Their neural network was able to obtain an accuracy of 36.9% and compromising mistakes made within one category an accuracy of a whopping 75.2%
  • They divided the movies into three classes rise, stay, and fall finding that support vector machine SMO can give up to 60% correct predictions
  • The data was taken from the Internet Movie Database or IMDb as the data source, the data they obtained was from the years 1945 to 2017.
  • A more accurate classifier is also well within the realm of possibility, and could even lead to an intelligent system capable of making suggestions for a movie in preproduction, such as a change to a particular director or actor, which would be likely to increase the rating of the resulting film.
  • In this study, we proposed a movie investor assurance system (MIAS) to aid movie investment decisions at the early stage of movie production. MIAS learns from freely available historical data derived from various sources and tries to predict movie success based on profitability.
  • The data they gathered from movie databases was cleaned, integrated, and transformed before the data mining techniques were applied.
  • They used feature, extraction techniques, and polarity scores to create a list of successful or unsuccessful movies. This was done by gathering the data using IMDb and YouTube.

PROBLEM STATEMENT

in this Movie Success Rate Prediction project, The method of using the ratings of the films by the cast and crew has been an innovative and original way to solve the dilemma of film producers. Film producers have often trouble casting successful actors and directors and still trying to keep a budget. Looking at the average ratings of each actor and director together with all the films they participated in should be able to give the producer a good idea of who to cast and who not to cast in a film that is to be out right now.

Implementation:

  • Data Preprocessing & Correlation Analysis
  • Application of Decision Tree Algorithm
  • Application of Random Forest Algorithm

RESULTS & CONCLUSION

After testing both the algorithms on the IMDb dataset i.e. Decision Tree and Random Forest algorithm, we found that the Random Forest algorithm got a better accuracy (99.6%) on the data rather than the decision tree algorithm in which we obtained just 60% accuracy.

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.

Book Reading Event System MVC App Using ASP.Net SQL & Bootstrap

This Book Reading Event App is a combination of tools and processes that manage book-reading events across India. A book reading event where book lovers come together for a community reading of their favorite book. One or more readers read the book loudly and optionally people even play roles from the book.

INTRODUCTION

A book reading event app is an online web application that is a single-point entry for all book lovers across India. Any registered and verified user who wants to keep a book reading event can create an event, invite people they know by specifying their email ids, or can keep the event open for all. The invited people need not be registered users. Due to some problem, if someone is not able to create an event, s/he can ask some other registered user to keep an event on their behalf of her/him. The registered user can check for the public events happening by just browsing into to portal and for private events, one can check the invited list of events by logging into the portal as well as by checking their invitation mail. Admin can see all the events (whether it is public or private) and all the registered users. As per the requirement, the admin can Edit as well as Delete any future public or private event details.

OBJECTIVE

The objective of this Book Reading Event System Project was to manage all the book reading events properties created by one user and send an invitation to the guests by entering their email ids or by keeping an event public. Managing these resources may itself be sufficient enough to give any user a big jump in terms of efficiency. The objective was to build a web application for people that makes use of it to manage their hectic schedule and make the best use of it in a smooth and efficient manner.

FUNCTIONALITY

The project will manage the intellectual property by creating a database of all the users and events, helping users to create an event, edit the event details, delete an event, add comment(s) on the event, invite the guest(s) for the event and to see any book reading event details happening around. Admin simultaneously verifies details of events as well as users. Admin can also edit and delete the event whenever required. Book Reading Event App has two types of users: Registered users, and Admin users.

Registered users are the normal user of the application who has the following rights:

  • View Past and Upcoming Public events
  • Log in to the system using “Email id” and “Password”
  • Create an Event and send the invites by specifying email ids
  • Edit the events created by him/her
  • View the events invitation list along with the details
  • View the list of events created by him/her
  • Add Comments to the Event

Admin Users have all rights throughout the application as follows:

  • View Past and Upcoming Public events
  • Log in to the system using “Email id” and “Password”
  • Create an Event and send the invites by specifying email ids
  • Edit any upcoming event’s detail
  • View the events invitation list along with the details
  • View the list of events created by him/her
  • Add Comments to the Event
  • View list of all the users
  • View a list of all the events

METHODOLOGY AND APPROACH

The following technologies were used for building this project:

  • Frontend – Hypertext Markup Language (HTML) CSS (Cascading Style Sheets), JavaScript, Bootstrap
  • Backend – ASP.NET (Active Server Page) Model View Controller (MVC)
  • Database – Structured Query Language (SQL) Server
  • Framework – Entity framework is used to connect to the database which helps in object-relational mapping

This project is built in an MVC pattern where M is the model which determines the classes, V is a view that determines views shown to the user and C stands for the controller which is used to handle the request. This project follows three layered architecture. The first layer is the presentation layer which includes views, and the second layer is the business layer which includes the services which work as a mediator between the presentation and data access layer. And the third layer is the data access layer which directly interacts with the SQL server database using entity framework and code first approach.

OBSERVATIONS

Graphical User Interface (GUI) – The website contains many links and tabs for various requirements like Create Event, Edit Event, View Invitations, etc. The users of the application consist of users from India. It will lay stress on each

page’s layout and the features to be depicted on that page.

HOME PAGE:

This is the first landing page. Any user can see the Public Book Reading Events without logging into the system by using the Past Events and Upcoming Events links. The past Events link redirects to the Past Public Events and the Upcoming Events link redirects to the Upcoming Public Events along with their details.

PAST EVENTS:

This page is landing by clicking on Past Events on the home page. Any user can land on this page without logging into the system. But one cannot add comments without logging into the system. Users can see the list of Past Public Events along with the details of each event. The working of Upcoming Events on the home page is the same.

A registered user or admin can log in using their credentials.
Depending on the type of user, s/he will have access to various functionalities of the application. In case the email id and password typed by the user do not match any record in the database, a login failure message will be displayed. If not registered already, a user can sign up by clicking on “Signup”.

USER SIGN UP

A user can register using their credentials. After successful registration user will be redirected to the login page. In case of failing the validation requirements of email id or password, a failure message will be displayed. If registered already, a user can log in by clicking on “Login”.

HOME PAGE AFTER LOGIN:

This is the landing page after the user logs in to the system. PAST EVENTS redirect to the page containing the list of past events which either the user invited, or was a public event. UPCOMING EVENTS redirects to the page containing the list of upcoming events to which either the user is invited, or it is a public event.

Navigation bar: Contains the button for CREATE EVENT, MY EVENTS, INVITATIONS, HELP, USER DETAIL and
LOGOUT functionalities.

Only user with Administrator rights has some additional button for some additional functionalities available in the navigation bar are ALL USERS and ALL EVENTS button.

CREATE EVENT:

Users can create a new event. The user just needs to enter some necessary details like Title, Date, Location, Time, Type of event, and some other optional details like Description, and Other Details. Users can invite guests to the event by entering their email ids separated by a comma. Users must provide the creator id for whom they are creating the event. If the user wants to create an event for himself/herself only, then he/she can check the creator id by clicking on DEAR – XXXXX. If the user is creating an event for someone else, then the admin will verify the details with whose creator id has been entered. If the BACK TO LIST button is clicked, the user will be redirected to the HOME PAGE.

MY EVENTS:

Users can see the complete list of events created using their own creator id. From here user can Edit/Delete his/her any upcoming event by clicking on the Edit/Delete button. Users can also create events by the button provided just under the tile MY EVENTS.

COMMENT. And can also see the comments posted by others in the COMMENTS section. The comments in the COMMENTS section are shown anonymously sorted by date and time.

EDIT EVENT:

Users can edit the details of any upcoming events from the list of events provided on the MY EVENTS page. Users can edit any of the details provided in create event form except the creator id. The layout of the page is exactly the same as CREATE EVENT page. Users can return to the MY EVENTS page using the BACK button.

INVITATIONS:

Users can see the complete list of events to he/she is invited. The list of events being shown is sorted by the date and time of the event. As this page proved to be much helpful to users in order to plan their future activities. By clicking on the DETAILS button, the user will be redirected to the EVENT DETAILS page. On the EVENT DETAILS page, users will find some additional information regarding the events such as the type of event(public/private), the number of invitees invited, and the creator of the event.

EVENT DETAILS:

Users can see all the available information regarding the event he/she invited to by clicking on the Details button available on the INVITATIONS page. Here one can find some additional information such as the type of event(public/private), the number of invitees invited, and the creator of the event. Users can also add comments for this particular event by clicking on ADD

USER DETAILS:

Users can check his/her own details by clicking on the DEAR – XXXXX button. One needs to check their user id for creating their event, so here they can find it out. Here the button name is extracted from the email id by which the user has login into the system. As it is clearly visible from the image, if someone logged into the system with [email protected] then the name before @ is shown after the Dear – button like “Dear – XXXX”. The name visible in the button is the extracted from user’s email id leaving the part from @ symbol.

ALL USERS – ADMIN ONLY:

Only users with administrator rights can access this page. This page can be accessed by clicking on the button ALL USERS available in the navigation bar. On this page, the admin user can see the whole list of users who may or may not be an admin. Admin can see each user’s name, id, and email id.

ALL EVENTS – ADMIN ONLY:

Only users with administrator rights can access this page. This page can be accessed by clicking on the button ALL EVENTS available in the navigation bar. On this page, the admin user can see the complete list of events. The list contains both public as well private events. The list contains both past and upcoming events. The events in the list are sorted by date and time. Admin can use create event functionality here also by clicking on CREATE NEW EVENT button.

Admin can see details like Title, Date, Location, Start Time, Type of Event, Duration, Description, Other Details, No. of Invitees invited, and Creator id of all the events. For some specific requirements, the admin can see the details for a particular event by clicking on the DETAILS button available in that event’s particular row which will be redirected to the EVENT DETAILS PAGE as shown before. Admin can not only edit the events created by him/her but also edit events created by other users/admins. Admin can edit any upcoming event by clicking on the EDIT button for that particular event which will redirect to the EDIT EVENT page. Admin can also edit the creator id for the event.

After being done with the usage of the portal, the user/admin can log out from the system by clicking on the LOGOUT button available in the navigation bar. After clicking on the LOGOUT button, the user will be redirected to the HOME PAGE. Users can again use the system any number of times by logging into the system using the same credentials used for the first time.

CONCLUSION

This Book Reading Event system is a user-friendly software that can be used in any locality for any user to arrange the event and to send an invite to guests just by entering their email ids. Due to some problem, if someone might not be able to create an event and send an invite or somebody might not have email ids available for all the guests, in this case, the book reading event app provides functionality to a user to create an event on behalf of someone else and it will be verified by an admin before sending an invitation to the guests and posting that event on the portal.

Allowing all the users to have access to such web-based application software can help anyone who wants to keep an event busy with the preparation of the event can easily send invitations to the guests and save his/her time. Further, this software can be developed to add more functionalities in the future, like setting a reminder for the events and notifying the user time by time, and setting a flag for the events one is interested in. This project can be further extended to keep any event (i.e., House-Party, Get to Gather) and not just only for book reading. The sheer possibility of scaling this application is immense and will definitely go to be proven the most useful software in the future times.

Online Food Ordering System Project Synopsis using PHP

About the Project:

The reason behind Online Food Ordering System is that there is a lot of information to be maintained and has to be kept in mind while running the business. For the reason we have provided the features present system is partially automated actually the existing system is laborious as one has to enter the same information at three different places.

Motivation:

The records were never used to be lots of difficulties in associating any particular transaction with the particular context.
If any information was found to be it was required to go through the different registers, document there would never exist anything like report generation. With the help of this system, people can easily order food. It can also ensure that. People don’t waste their precious time and use their time productively in other works.
This system proves to be more effective and reliable than other traditional systems. however one needs to take care of small parameters like server breakdown while this system is implemented.

Basic Structure:

Technology Used:

a) Hardware:

  • 1 TB storage
  • 8 GB RAM desktop

b) Software:

  • Notepad++ (for code)
  • Web browser
  • Operating System (Windows, Linux)

c) Language Used:

  • HTML
  • CSS
  • PHP
  • JAVASCRIPT

Choice of programming language:-

So many programming languages were put into consideration in the cause of designing this software. A lot of factors were also considered which include online database access, data transmission via networks, online database retrieval, online data capture, multi-user network access database security, etc.

Features

Take Away Ordering. Takeaway ordering is a win-win solution for restaurant owners and customers.

  • Pre-Orders
  • Catering Orders
  • Scan & Order
  • Unique Webpage
  • Social Media Sharing
  • Search Engine Optimization
  • Combo Deals

Available Applications

  • Foodpanda
  • Zomato
  • Faasos
  • Deliveroo
  • Dunzo
  • Grubhub
  • Swiggy
  • User Interface

Advantages

  • Makes the ordering process easier
  • Efficient customer ordering management
  • No-cost marketing.
  • Better customer data
  • The convenience of mobile ordering
  • Greater reach

Disadvantages

  • Deliverymen put themselves in danger
  • Disguised increased expense
  • Juggling with your health
  • Unsuccessful payment resulting in delayed food delivery

RESULTS:

Basically, the users targeted:

  • There will be a lesser requirement for staff at the back counter.
  • The system will help in the reduction of labor costs involved and also reduce the space required to set up a place like a cafeteria in restricted areas.
  • As it is an automated system is less probable to make any mistakes.
  • The customers can avoid the long queue a the counter, with a reasonable speed of execution and maximum throughput.

METHODOLOGY:

The simulation first starts with the customer entering his/her credentials(name, ID, and password). Once that has been verified the customer can place an order specifying the quantity of ordering food requirement. Now we get a window that displays the order number, customer ID, price, food name, and quantity. Once the customer finalizes his/her order they are redirected to the payment window where the total price is displayed and the customer can choose the payment option. The customer will get the confirmation message.

The above-mentioned simulation will flow with respect to the customer’s overview. Now if you are an admin you can select the normal login option and can enter the admin portal. Once you enter the admin portal you can add or reduce the food or update food or their price. Once the selected option is carried out to the end result that added item list will be displayed and if you have deleted the food the particular food will disappear.

CONCLUSION:

The online food ordering system is developed so that customers can order food and avoid the hassles of waiting for the order taken by the waiter. Using the application, the end user registers online and reads the E-menu card to order food online. Once the customers select the required food item the chef will be able to see the results on the screen and start processing the food. This application nullifies the need for a waiter or reduces the workload of the waiter.
The advantage is that the in a crowded restaurant there will be chances that the waiters are overloaded with orders and are unable to meet the requirement of customers at a time. Therefore by using this application users can directly order their food online.

Full Stack Project on Restaurant Selection based on Reviews and Ratings

This Website ultimately relies on its users to post reviews, which can be rather subjective and not entirely accurate. Moreover, negative and inflammatory reviews tend to attract significantly more attention than positive reviews. For example, if a restaurant gets 10 positive reviews and just 1 negative review, most people will often scroll down to the negative review and read what it says. This means that even a single bad review can put a business in a bad light. This can pollute their online presence and potentially cause some loss in revenue.

Brief about the Project:

So, the project is titled Review-based Restaurant Selection, where this website will deal with the top-rated and best-reviewed Restaurants present in Mathura.

So, with the help of this website, potential customers weed out their choices of restaurants in Mathura.

Objective

“Review based Restaurant Selection” is the way of giving/providing information related to the best-rated Restaurant in Mathura, because Online review sites have transformed the way we do business and the way your customers make decisions.

 Modules used in the project: 

Detailed Description of Pages

Home Page The home screen consists of a screen where one can browse through the page for getting information about the usefulness of the web page

Home Page

Top 6 Restaurant Page: The screen consists of a screen where one can browse through the top 6 best-Rated Restaurants present in Mathura.

Write Your Review: The user can also Write a Review of any stuff for any Restaurant Present in Mathura Because public opinion matters

Products Page

Review of the Day: – Here on the Screen some Review Added by the user will be shown.

Review of the Day Page

Requirement-: 

Hardware:

  • Personal computer (any configuration)

Software:

  • Brackets source code editor

Technologies used:

  • Full Stack Technology –
  • HTML
  • CSS
  • Bootstrap

Web Page Details

  1. Home Page
  2. About Us
  3. Top 6 Restaurants present in Mathura
  4. Write a Review
  5. People Reviewed

Future Aspects

  1. We can add a query box
  2. We can add the review of the newly opened Restaurant

We can add an SMS tool so that information about the Restaurant can be provided using SMS.

Travel and Tourism Analysis Data of Hotels using Big Data Hadoop

Name/Title of the Project

  • Travel and tourism analysis data of hotels using the Hadoop environment system.
  • Tourist Analysis Using Big Data (Tourist Place Recommendations Dataset)
  • Tourism Behaviour Analysis Using Hadoop (Big Data Analysis)

Problem Statement

Throughout the years the tourism industry was dependent on intermediaries, who enabled the interaction between the suppliers and the customers. The internet age changed the complexity of tourism distribution, enabling the entry of new virtual intermediaries characterized by a strong competitive advantage over other players in the sector.

Recommender systems are categorized into

1. Content-based system: With this, item recommendation is analyzed then it retrieves the information and filters this for research. For example, if the tourist goes to hill stations more often, then the database contains “hill station” as a recommendation

2. Collaborative filtering systems: They rely on similar factors of users or items. Preferences of different users for the same item are recommended by the system.

There are many challenges in designing and executing a Personalized Tourist Travel Package Recommendation System.

1. Usually Travel packages are location-based so they are pertained to space or time to reach the destination. For example, the package contains locations that are geographically near and also vary season-wise.
2. The older recommendation method is dependent upon rating and the travel data may not consist of this sort of rating.

Introduction/Feasibility Study

According to the World Travel & Tourism Council, in 2008 travel and tourism were equivalent to 9.9% of the total world GDP. The tourism industry is growing despite all the risks faced in recent years: terrorism, health fears related to avian flu, and high oil prices. The World Tourism Organization (WTO) reports that in 2006 international tourism arrivals reached its record of 842 million: a 4.5% growth compared with the previous year (http://www.unwto.org). This number even exceeded previous long-term forecasts. For the following years, the WTO predicts constant growth, reaching 1.6 billion international arrivals in 2020. According to the WTO, in the last four years, the biggest tourism arrival growth occurred in the Middle East, followed by Africa and Asia, and finally Europe, while a sharp decline has been observed in the Americas. Europe, however, still accounts for the biggest market share of international arrivals. Tourism has thus a great influence on the world economy and it is important for the European market to maintain its leadership position. This can only happen if the industry will keep up with the newest technology innovations and will be able to quickly adopt them. Internet is especially relevant for the tourism industry due to its worldwide coverage, enabling direct worldwide interaction with tourists

Below are the modules required to develop this project and create an application user form:

1. Administrator authentication/module: This module is mainly based on admin.
2. User Registration: This module covers the details about the registration of users they can be registered by themselves by adding data like name, password, email id, and further details.
3. Package Modules: Users can view different tour packages available for tourists.
4. Testimonials module: This is the module where passengers can post feedback after the journey and they can share their experience.
5. Payment & Search Module:
a. Pay payment through PayPal.
b. Pay payment through draft, credit & debit cards, UPI, and net banking.
c. Search city-wise hotels, flights, packages, buses, rails, and events.
6. Routes module; This will display the route information of the source location and destination location. Users can also check the best routes for their destination. From this module user can also get information related to various routes connecting sources and destinations, For each route, information such as source, destination, fare, reservation details, pick-up points, etc. are provided.
7. Reservations module: This module is for passengers/customers where passengers can reserve their seats by making payments.

Hardware & Software Used

Software Used:

1. HADOOP environment system that acts as a tool for analysis & recommendations to tourists.
2. Technology: Java
3. Web Technology: HTML, Javascript, and CSS.
4. Database used: MySQL5.0

Hardware Used:

1. A portable PC or a working laptop.
2. A minimum RAM of 8GB or 32 GB hard disk drive.
3. Intel Core-i5 Processor, 8th Generation(minimum)

With this project, I am developing a tourism management system first by creating a user login and password form with the help of java language and some of the python frameworks which will be used for developing the code and then, giving recommendations on famous tourist places to visit in a particular area or throughout our country(India) based on user’s search history on the system. It will be a simple static web application type system with not that much of looking feel.

Responsive Crypto Site System Full Stack Web Development Project

ABSTRACT

Website Design and learning Frontend and Backend designing were the main objectives of this internship. Develop a web-based application, there are several programming languages that can be used. For example, HTML3, HTML4, HTML5, CSS, Bootstrap, JavaScript, etc. For example- PHP, Java, etc. Nowadays there are also some frameworks that are used vastly. It is also called MVC. Solving real-life problems was a key issue. This report takes us through all the details of Watsonisite. Watsonisite is a Crypto site, that includes information about cryptocurrencies, the trends, the price, and the performance of the particular cryptocurrency.

Problem Statement

To develop a completely responsive Crypto site that includes information about different kinds of cryptocurrencies, the trends, the price, and the performance of the particular cryptocurrency. It also shows the ratings of each cryptocurrency and reviews from the users. It informs the user about the constant change in prices of different types of crypto. The usage of the concept of live value tracking of various cryptocurrencies means that the user can constantly stay up to date with the change in values by the minute and plan his investment accordingly. It provides an excellent means of connecting a new user to crypto and the trend with which its value goes up or down, giving him an idea about the crypto industry.

Existing System:

  • The last 5 years have seen a massive growth of cryptocurrencies in terms of the volume generated and the popularity of these currencies.
  • Due to the recent massive growth of crypto, the industry still hasn’t completely caught up with the demand of the market in terms of making a user-friendly, and fully functional informative website.
  • In terms of user retention on the website, an attractive graphical interface with pictures and information presented in a good, neat, readable format is essential in order to make the users feel content with the information given to them.
  • There is also a lack of consistently updating real-time prices on each of the cryptos, making most of the websites available today for crypto highly unreliable.

Proposed System:

  • The utilization of a concept such as dynamically updating the crypto values of each kind of currency at regular intervals helps the user track the market values for each kind of currency.
  • Even though the website is not designed to assist the user with his investment directly, it indirectly helps him or her with their investments by providing other useful services.
  • There is a feature implemented in the website consisting of a login page with the ability to  
  • log in with either your Google or Facebook account or any other email address in case the user does not have either of the two.
  • This provides a sense of privacy to the user and the ability to log in from anywhere and check the status of crypto at any point in time
  • The website also provides assistance and helps the users with a Cryptocurrency mining server, a Cryptocurrency trading bot, tracking cryptocurrency stats over time, etc.

The objective of the System

  • The website was designed aimed to overcome the shortcomings that the existing system possessed.
  • One of the major objectives of this designed system was to have a good-looking, properly functional, neatly organized, and descriptive website that aimed at providing the best informative service to its users.
  • We were able to achieve this by using simple, open-source software tools and utilizing them to the best of our abilities in order to design a product that would excite people to come back and visit, either for getting an idea about their next investment or to someone to get some basic knowledge about crypto and slowly getting their feet into the deep waters of crypto.

DESIGN ANALYSIS

USER RESEARCH

It was a new learning experience for me as I chose this project because I wanted to know how cryptocurrency websites work and what problems users were facing. So, I conducted user research to understand what pain points they had and empathize with them to understand exactly how they feel.

DESIGN PROCESS

Once we performed a market analysis on the problems that the various users of crypto websites were facing, the next step in order to design a crypto website was to understand the outline and visualize what the final website would look like.
This helped we could get an idea as to what tools had to be used with the web design and we could update ourselves with those tools if and when necessary, in order to make the website as user-friendly and informative as possible.
We then had to make sure that the website that was made was compatible with both phones and laptops because the user who has no access to a laptop at the moment should also be able to access it conveniently.

REQUIREMENT ANALYSIS

  • MySQL
  • NODE JS
  • Notepad++ Editor
  • Processor: Intel core i5 processer
  • Memory: 6 GB
  • Hard Disk: 40 GB

SNAPSHOTS

  • “HOME PAGE” OF THE CRYPTO SITE SHOWING LIVE PRICES USING A MOTION SLIDER
  • DIFFERENT CRYPTO COINS SHOWING LIVE PRICES
  • THE “ABOUT US” SECTION DESCRIBES THE REASON TO CHOOSE US FOR INFORMATION
  •  THE “SERVICES” SECTION SHOWS OTHER FEATURES THAT CAN BE USED FROM OUR WEBSITE
  • THE “REVIEW” SECTION SHOWS WHAT USERS SAY ABOUT OUR INFORMATION
  • DIRECT CONNECTION TO SOCIAL NETWORKING SITES AND CONTACT INFORMATION
  • LOGIN PAGE FOR USERS
  • SIGNUP PAGE FOR NEW USERS
  • OPENING THE WEBSITE ON A MOBILE PHONE