E-Healthcare Advisor Java Project

Abstract:

E-healthcare advisor is a project developed to provide internet based health care information system. This application helps the user to identify certain diseases by answering certain questions asked by the patient.

Introduction:

E-healthcare advisor is a web based application which acts as a communication bridge between the doctor and patient. This application maintains a centralized repository of all information related to diseases and medicines.

E-healthcare application provides online service to the users. By using this application the user need not go to any clinic and meet any doctor. This application is based on the diagnose received by the user and the user will be getting some suggestion of medicines that are available in the local chemist without prescription with an advice to  visit the doctor.

Users/patients need to get registered to this application. They can  simply open the E-Healthcare website and send the request for medicines by  mentioning their disease. It maintains the data and information in a proper way. One can easily browse through the various details using the well defined interfaces provided by the system.

Objective:

To provide online service to the users without wasting time. To increase the performance and serve thousands of people in mille seconds.

Modules:

Administrator:

Administrator related functionalities are performed in this module. Administrator manages the entire application and manages all the Patients and non members details. Administrator is authorized to add, delete and edit, User details, Medicines and Diseases Details.

Patients:

Patients should register to the website. User can send the request to the medicines mentioning their disease details.

Non Members:

In this module non members can also visit the web site. They can get all the information about the diseases and medicines.

Report:

This module allows administrator to generate reports based on different criteria such as Diseases and Medicines.

Software Requirements:

Language                                :           Java

Web technologies                   :           JEE (Serve lets/JSP)

Front-end Design                    :           Html, CSS, JSP

Database                                 :           Oracle 10G

Scripting                                  :           JavaScript, Ajax

Browser                                   :           IE 6.0/ Mozilla

Operating System                   :           Windows/Linux

Tender Management System Java Project

Abstract:

Tender management system is a project  that provides a interface between contractors and state government officials. This system makes the communication easy. This system provides information about the tenders and all the updates are provided.

Introduction:

Tender management system is a web based project which acts as interface between contractors and state government officials. The information between both the contractors and state government will be stored in this management system. State government will use this system for opening a tender for submission.

Tender management system is a user friendly system, that allows the builders to checkout with the details of the tenders. In this management system builders can check the tender details, submit a tender, view results, evaluation process.

Contractors can open a tender, evaluate a tender, compare tenders submitted and generate reports. Completion of work can also be traced from the system. This system also manages the data regarding the transaction in a very secure way.

Objective:

The main objective of this tender management system is to provide information which is secured and updated about tenders to those builders and contractors.

Modules:

  • Administrator (system admin) module:

Administrator related functionalities are provided in this module. All the trades and contractors history is maintained and visible to admin.

  • Government PWD users module:

Contract will be approved first by PWD users and then by Government senior officers. Transactions of all the tenders submitted by all the contractors must be maintained and visible to PWD users. New registration approvals by Government PWD, validated by email and SMS.

  • Contractors/Builders module:

Builder/ Contractors should be able to submit a tender of his past projects, Overall bid cost, Material used, Timeline, etc. All the project details must be visible to the users, this details must have a link to tender corresponding. Contractors should be able to view status of his bid online.

  • Government Senior Officers module:

An overview status chart for Government senior Officers with number of upcoming tenders, currently running tenders, number of contractors in the approved tenders.

  • Reports:

Admin, Government PWD and Government Senior Officers can access this module and generate the reports based on the requirements.

Software requirements:

Operating System                                 :           Windows Xp.

Technology                                           :           Java and J2EE

Web Technologies                                 :           Html, JavaScript, CSS

Web Server                                           :           Tomcat 5.5

Database                                              :           Oracle 10G

Java Version                                         :           JDK1.6

Airline Company Case Study DBMS project

1 Data modeling design

In this step, you’ll model the data requirements of your Airline Company case study system. You deliverable for this step will be the entity types and relationship types that describe your case study system. You must include an ER diagram drawn using the Dia drawing application as prat of your deliverable for this step.

2 Relational Database Schema Development

In this step, you’ll produce a set of relational database schema from your ER diagram. Your schema must identify the the tables required with the table schema: the table attributes along with their domains, primary key constraints, alternate key constraints, foreign key constraints, and any general column or table constraints. Be sure also to specify whether attributes are nullable.

In this step, you will also ensure that your tables are in 3NF.

Your deliverable for this step is an English language description of the database schema. You should include the functional dependencies that you identified for your tables as evidence that your tables in 3NF. You are not to implement the tables using SQL for this deliverable.

3 Relational Database Implementation

In this step, you will implement the table schema developed in step 2, using the Postgres SQL DDL language. Your deliverable will be a Postgres SQL DDL script which when run in Postgres creates the tables for your case study.

4 Table Population

In this step, you’ll create a data set for your database. Your deliverable will be a Postgres SQL DML script which when run, inserts your data set into the database tables and also a text document with the data presented in a tabular format.

5 Database Operational testing

In this final step, you’ll create a Postgres SQL DML script which performs a set of queries on your populated database.

Each case study has a set of sample queries. Choose any ten of these queries and implement them. Your deliverable will be a Postgres SQL DML script, which when run, performs the queries on your database as well as a text document with the query results presented in a tabular form.

Work In Progress (WIP) Java Project

Work In Progress  (Production and Stores Accounting System)module will accept the process sheet details from the Methods department. By using this information, the PPC prints the documents for required work order for the given Number. The new Work order is launched as per the Number with the Work In Progress status ‘R’. The cost center, machine code & batch quantity are also chosen.

When a new work order is to be launched WIP forwards Material Requisition to Material Management. Then MM, in turn, propels the material requisition to the Store, to confirm the availability of the material. If the required material is existing, Store mails Material Requisition Issue to WIP so that a new Work order may be successfully launched.

If the material is withdrawn from the store for a new work order, it indicates that the Work order is ‘ready for loading’ and the status of the WIP is updated to ‘R’ (Ready for Loading). When the Work order is loaded to the machine, the WIP status is altered to ‘L’ (Loaded) from the shop. When a particular operation is in progress then the status is reorganized as ‘N’ (Not Completed) by SFM module.

In the SFM module itself, the machine card/labor card is booked for that work order with respect to Operation number. When a Work order is completed, the WIP status is updated as ‘C’, which indicates the completion of the Operation.

Inspection of manufactured parts is done not only after each operation but also after the completion of the final operation. When the PPC offers the component for each operation then WIP status is updated as ‘I’. After the completion of the final operation for that particular Work order, the refined component is credited to the store & the WIP status is updated as ‘F’. Hence by screening the status of WIP user can predict the phase of the work order.

Software Requirements:

Operating System: Windows 7

Technology             :  Java/J2EE(Servlets,JSP,JDBC)

Web Technologies  :  Html,Javascript,CSS

Web Server: Linux ad-hoc server

Database: Oracle 11G(Grid Computing), Oracle 9I  (forms and reports)

Software ’s: JDK 1.6

Hardware Requirements:

Hardware: Pentium based systems with a minimum of P4

RAM: 1GB (minimum)

Download the attached Work In Progress (WIP) Java Project Code & Database.

Issue Tracking System Java Project

Abstract

Issue Tracking for Improving Software Reliability is an automated system that can be useful to admin and developers in any functional organization. Issue Tracking System gives the facility to define the tasks in the organization and also allows the admin to track the issues spent by the developer for that particular task. It can help admin for Issue estimation per project or application.

This project aims at creation of Issue Tracking System. This project will be accessible to all developers and its facility allows developers to focus on creating the database schema and while letting the application server define table based on the fields in JSP and relationships between them. This system provides the following facilities.

Existing System:

In manual system to solve an issue we have to contact the person directly and provided solutions can be viewed by only that person so it will take time.

Drawbacks of Existing System:

  • It time consuming process.
  • User satisfaction is less.
  • We can’t get more solutions to one problem
  • Less efficient.

Proposed System:

Issue Tracking for Improving Software Reliability is an automated system that can be useful to admin and developers in any functional organization. Issue Tracking System gives the facility to define the tasks in the organization and also allows the admin to track the issues spent by the developer for that particular task.

Advantages of Proposed System:

  • Improve the quality of software
  • Increase satisfaction of users and customers
  • Ensure requests accountability
  • Improve communication in the team and also to customers
  • Increase of productivity of the team
  • Reduce expenses.

Modules:

Admin:

This module has the entire access to all other modules, assign tickets and update tickets.

Developer: 

Developer can access the task or issue assigned by the admin, view assigned tickets and upload patch files. Developer can view the issue list assigned by the admin.

Guest:

Guest can access to view tickets, update tickets and upload patch files.

Issues:

Admin, Developer and Guest can access this module and to change the status.

Technology:

Soft Ware Requirements:

Operating System                :            Windows XP/7/8

Server Side                           :           JSP with Tomcat Server

Client Side                            :            HTML ,JavaScript

Services                                 :            JDBC

Database                               :            My SQL

IDE                                        :             Net Beans 7.4

Campus Activity Portal Java Project

An “Campus Activity Portal” is a collection of Web forms, images, videos and other digital assets that is hosted on one or several Web server, usually accessible via Campus activity Portal is an application would be used by any branch and any year students, programmers, professors or any other staff of college.

This application provides information about the college and about departments  presents in the college and also provides all the possible soft copies of lecture  notes, all available useful e­books of each and every subject, all subjects old  question papers, syllabus copies, practical titles and all the material that any  student want during his engineering.

One additional feature of this application is “MESSAGE BOX” where students can shout about their queries and problems which are visible to all the members who are accessing this application so if any members have the solution they can put the solution on the same MESSAGE BOX. Anybody using this application would be able to post his / her queries and reply to other peoples post.

This forum would be handled by an administrator. The office staff and other staff member can upload their notices on particular branch section which will visible to all the student of that with the help of this web based application, a user can use a single account to access the notes. Faculty can also post notes in pdf, e­books, word documents, lecture videos and important notices through intra­net gateways. Student who want to send feedback or suggestion using MESSAGE. In our project database has been added. The working of the project is as follows.

The first page provides several links. The Home page contains several information about the site like campus, management, facilities, infrastructure, sports, placements etc. User Login module helps the user to login to the application. For that he must type the username and password correctly.

The login provision in this page helps the already registered user to directly access the application. In the Login link a  student, staff, administrator can login using the appropriate Username and  password, through which they can upload or access soft copies of notes i.e. E- books, pdf, word documents, notices etc. The flash news and the events corner display the latest developments, announcements and events associated with the college activities. The administrator displays notices.

Detect letters S, T, U and colour them red

Project: Detect letters “S”, “T”, “U” and colour them red

Domain: Analysis for Mobile Computing Project

Steps of the project:

  • implementation of a web‐based application using the Java programming language.
  • Initially, the application allows the uploading of an image file(jpeg) toexecution environment
  • Later it executes a transformation by applying template matching algorithm
  • The result of the transformation is then downloadable from the provided web site.

MobCom_Example_Image_Letters_1 (1)Main task:

  • Implement a web‐based Java application. Generate a Web Application Archive (.war file) and upload it to the execution environment (will be provided by university).
  • As execution environment use Apache Tomcat v. 8.0.26; Java SE v. 8u60 64 bit on a Linux system.
  • Main functionality of application (included in .war file):
  • Provide a webpage for uploading files (image files) to execution environment
  • Provide a Servlet for processing the individual task
  • The result of the individual task must be displayed in the provided webpage
  • General workflow of your application: Upload file to server, process the application logic to solve the task and return the result (image file) to the requesting browser (see illustration below)

Analysis for Mobile Computing Project

Just for idea sake:

To access your application use following structure:

http://<server ip>:8080/<group ID>/<application name>

General Specification:
For imaging tasks use jpeg as image format, picture size 640×480 pixel

Documentation:

  • For documentation of the project use Javadoc functionalities inside source code.
  • Generate HTML representation of the documentation and provide it inside the .war file you will upload to the demonstration system.
  • The documentation must describe application logic (i.e. functionality, classes, methods, attributes) and a manual to use the application in detail.

Restrictions:

  • Use no other libraries than provided by Java SE (i.e. no additional libraries for image processing permitted).

Home Improvement System Management Portal

Employee signup: Employee sign up(registration form) should not be there. We can assume that admin will maintain employee userid and password details. Query to insert userid and password details into database by admin should be there. Employee login only should be provided. Change password, Forgot password with security questions can be added.

Online Application:

Middle name and Address line 2 should not be mandatory.

State – update it to drop down with list of states from the word doc attached

Application Search – Search can be done with entering only one field i.e. only date can be given and search can be done with name and status as blank.(Please show that in video file)

Review/Modify application: Button ‘Save and go to Edit project’ not there.It is displayed only when there is a project created for the application.

New Project:

  • All applications which are approved and with no project created from the database should be displayed in the table. Using the ‘Last Name’ search option, one record corresponding to the value in search field should be displayed.

For example if there are three records a,b,c in the database with status approved, and record b has project created then recordsa,c should be displayed in the new project search page. When I give ‘a’ in last name field, only record ‘a’ should be displayed instead of all 2 records.

  • If no application corresponding to search field are present ‘ No Approved application with given last name found’ should be displayed.
  • Remove ‘Project Assigned’ search option.
  • Address displayed in table should be address line 1 instead of city.
  • Application ID should be added as first field. Name and address fields details should as per application page.

Name – First Middle Last

Address – Line 1, Line 2, City, State, Zip

  • Quantity field should allow characters – to enter units (e.g. lbs, meters etc)
  • Material and quantity table should automatically add another empty row if the entire table is filled.

Add Volunteer:

Name and address fields should be as per application page.

Name – First Middle Last

Address – Line 1, Line 2, City, State, Zip

 

View/Modify Volunteer Details

Volunteer Search:   Can you show me the record being displayed when only one search field is given for example only Volunteer name and no Organization details given.

  • Skill and email fields are not displayed correctly in the table.

Assign Volunteer and Modify Volunteer:

Functionality developed for these pages is not clear.

First after projects are created we will assign volunteers to the projects. To make any modifications to the volunteers assigned to the projects we go to View/Modify volunteers tab.

Assign volunteers:

All projects with no volunteers assigned should be displayed in the projects table.

Skill and organization search fields should be added to ‘Assign Volunteers’ page. Based on the values given for search fields Volunteers details should be displayed in the table. We then select the volunteers and update task and house captain fields and hit the button ‘assign’.(Please refer mockup screens document again for reference)

Modify Volunteer:

In this page volunteers assigned to the project should be displayed. Buttons ‘Unassign’, ‘add volunteers’, ‘save’ and ‘cancel’ should be there. (Please refer mockup screens document again for reference)

Add Sponsor:

Name and address fields should be as per application page.

Name – First Middle Last

Address – Line 1, Line 2, City, State, Zip

 

Volunteer Login:

Volunteer sign up page is not shown. Volunteer login should have name and password instead of phone no. Forgot password and security questions to be added. Sample pages shown below.

Volunteer Home page:

Please print message “Welcome To Home Improvement System Management Portal !!”

Message mentioned above should be displayed after May 1st of current year. This is to set activation of the volunteer for current year one day program (held on last Saturday of April). If ‘Yes’ is selected then volunteer is participating in current year program and he is active for year 2016(May 1st 2015 to May 1st 2016). If volunteer is active for current year, “Thank You for registering for current Year one day event. Project details can be seen in the next tab” should be displayed.

Volunteer Home page

Personal Details:

Name and address fields should be as per application page.

Name – First Middle Last

Address – Line 1, Line 2, City, State, Zip

Assigned Project:

Address of the project, Time – 9:00 am, Date – April 25,Year of registration, Task assigned fields should be present in the table. These should be displayed if registered for current year. If not, ‘No project assigned’ message should be displayed.

Project Materials: Below fields should be displayed. Name is the name of home owner of the project. Address is the address of the home for which project is created(name and address from application form). Same as table from View/modify project page

 

Navigation:

Online Application

Once the online application is submitted and the pop-up saying inserted is shown, the page is redirected to the home page. It should either display a message saying “Your Application has been submitted successfully“. It should not be directed to the home page.

Employee Login

After employee gives his credentials i.e., username and password to login, the home page of the employee is left blank. Instead it should display a message saying “Welcome back (name of the employee) !!

New Application under Employee Login:

After the employee submits the “New Application”, the employee is signing out and is redirected to the initial home page i.e., Home Improvement Portal home page. The employee should not log out until he selects the logout button and also after the New Application is submitted, the employee should get a message saying that ” The Application for ” the homeowner’s first name and last name” has been submitted successfully“.

Review or Modify Application under Employee Login:

After the search criteria is given and the modifications are made and changes are submitted the page is redirected to the initial “review or modify application page” where no search criteria is given. It shouldn’t be like this. Once the changes are submitted, the application should direct the page to the list the applications shown in the table as per the search criteria given previously.

View or Modify Volunteer under Employee Login:

After the search criteria is given and the changes are made and submitted, the employee should land back again on the same page with project details and volunteers assigned details now displaying the changes to the volunteers.

Assign Volunteers under Employee Login:

After a volunteer is added and the pop-up is displayed the page is redirected to the employee home page. Instead it should return back the Project TABLE page displaying projects for which no volunteers are assigned.

Finding Missing People Using Image Processing

Title of the Project: Finding Missing   People Using Image Processing

Domain: IMAGE PROCESSING

Abstract One main objective of the project is to develop a missing children (people) find application that can be helpful for the common people whose beloved ones have been abducted missed, or rescued by the people.

In this Finding Missing People Using Image Processing application or website we provide person with entire data base of the missing children, so that the police can track about the whereabouts or file a case pertaining to the issue.

And the children found (known or unknown) details are uploaded by the police or by an appointed agent.

Entering details of the children like height, age, etc is a lengthy process and the search output is not efficient.

So to avoid this ambiguity we use image processing technique here, a person can upload a picture of whose information is to be known.

This Image will be mapped or compared with the images in the database and case details status etc can be displayed.

The time efficiency is more and output is also efficient.

Healthcare Hospital System Java Project

The main goal of the Healthcare Hospital System project is to view the hospital statistics by Directors and management or by those who are authorized to see it. Information included in this project is all users registration, payments,  consultation statistics, pharmacy, surgery, transplants, equipment’s, patients and doctors, healthcare bill, multi valued diagnosis, preventive health care, corporate counseling, welfare programmers, claims administration, patient care co-ordination, doctor achievements, staff details and Human Resources.

The attributes  included  in the hospital system are street address, city, county, zip code, birth date, admission/discharge dates, date of death, social security numbers,  record numbers, health plan beneficiary numbers, account numbers, telephone numbers, fax numbers, e-mail addresses. As the information about the patient is already stored in the database, it is easy to retrieve back and to identify the concerned doctor to the patient.

The best way to achieve cost goal is to analyze and interpreting the data and to produce visualization reports.

Project Requirements and Thoughts

  • Identify a topic of interest and run with it!
  • Identify a topic of interest and run with it! Pick a topic that will keep you interested and motivated over the next 14 weeks.
  • Ask the following question: Which answers am I trying to mine or solve?
  • Formulate a hypothesis question. Additional hypothesis questions are encouraged (maximum of 3 questions) are encouraged.  A hypothesis question contains both a null and alternative question.
  • What kind of data is being mined?  Where does the data originate? Can the data be imported into a database (i.e. for formulating updated queries).
  • List Class and/or Concepts related to characteristics and discriminations.
  • Is you project identifying patterns, associations, and/or correlations.
  • Within the project, statistics (e.g. central tendency, range, IQR, variance, etc.) should be presented.
  • Does your dataset contain outliners, if so, please identify them.
  • Projects should list attributes (e.g. nominal, binary, ordinal, and/or numeric)
  • If possible, data should be presented visually (iPython, R, MatLab, Excel, etc.).
  • Was the collected data consider of good or poor quality?
  • Does the data contain missing values or noisy data?
  • Does the dataset contain redundant data? If so, how did you remove duplicated values?
  • When analyzing the data, did you perform OLAP or OLTP processing?
  • Which data models were used for your project (e.g. Stars, Snowflakes, or Fact Constellations)?
  • If OLAP processing was used, did you incorporate bitmap or join indexing into the processing?
  • Did did you determine the size of your data set?