Category: MCA Projects

MCA Projects available here are implemented in asp.net, java, Visual basic and C++, php . MCA final year students can use these topics as reference for mini and major projects. Students can download list of MCA Projects with documentation for free download.

Posted on

Online Event Planning System Java Project

Project Title: Online Event Planning System.

Project Description: Online Event Planning System is a web based project which act as a bridge between users and Event planners. As people spend lots of money and time for booking Events, Parties and Weddings and any other functions.

By this application the time of the user reduces because they can access any information related to event Address/venue/Hall. From the remote place.

So that we are trying to make a web project that includes all the planning’s for the food, venues, invitation cards, Photography and all Event related things can be done on time. This project is developed to make the users comfortable to enjoy each and every function along with their family, friends,relatives and colleagues..

Goals and Objectives:-

  • The main aim of this project is to provide the information regarding Events and  the information about the Booking of users choice.
  • Online Users can submit their queries by giving the Event destination, tentative date, number of guests, contact number etc.
  • Event themes are available in the websites.
  • There is a facility to book caterers, decorators, photographer and all function related categories/ facilities.
  • Mailing facility to reply clients.
  • Different venues are available for the choices.
  • To provide the functionality of online Booking and Cancellation.
  • To provide the information of status of catering, facilities available.
  • To provide the facility to maintain the records of users.
  • Information can be easily accessed.
  • This system will save the time of the Users.

Intended Audiences or Beneficiaries:-

The Online Event Planning System is a Event services provider that offers Event plans and services.
Online Event Planning System deals with the information System for Bookings.

This project explains about the booking of the Event/Function Places from a short event to a complete combination of activities, including meetings, conferences, exhibitions, weddings, birthdays etc.

This website helps any authorized person to book the places from internet and also shows the availability of a particular requirement at the chosen date and time.

Services to be provided:-

By using this Web Application we provided all the information which is required to book a venue/Hall.
So a user can access information easily from anywhere using internet.
And we also provided some service details like.

Service Details: when the user clicks on this module he/she will be informed about the detailed services offered by the website. This website also provides various bookings such as for photographers, transporters, Flower decoration, Audio System, DJ, Lightning and Video Recording etc.

Methods:

  • First of all we studied of existing system.(which is manual)
  • Then find out what are the problems are in existed system.
  • Now the problems can be solved using this web application
  • And provided a better mediator between user and venue owner.
  • Build a web based system.
  • The project is to develop customize software package for reducing the manual problems.
  • It should deals with the online Wedding Planning as well as cancellation.

Anticipated Phases, Milestones, and Schedule.

Phases:

  • Title Finalization
  • Synopsis submission
  • Design completion
  • Model/Work completion
  • Two paper presentation on project
  • Project report writing & submission
  • Project exhibition at BMIT

Project Schedule:

  1. Title Finalization : 1 Day
  2. Synopsis submission : 15 Days
  3. Design completion: 15 Days
  4. Model/Work completion: 3 Months
  5. Two paper presentation on project : 15 Days
  6. Project report writing & submission : 15 Days
  7. Project exhibition: 15 Days

Required Systems and Equipment:

Software requirements

Operating System : ANY With a Web Browser
Interface : Java Programming
IDE : My Eclipse/Spring source
Database : MySQL
Documentation Tool : Ms Office.

Hardware requirements

Processor : Standard processor with a speed of 1.6 GHz or more
RAM : 256 MB RAM or more
Hard Disk : 20 GB or more

Posted on

Online Student Feedback System Project Synopsis

The purpose of Online Student Feedback System is to provide Periodical feedback by students about the course conduction.

Abstract:

“Online Student Feedback System” is generally used by four kinds of users:

1. Admin
2. Student
3. Staff (faculty of each course)
4. Coordinators (M.Tech, M.Sc., MCA)
5. Chairman

  • Each user has their own login id and password.
  • All of these users are to be provided different access rights.
  • Chairman and Admin will be able to view the statistics generated by the system.
  • Faculty will provide access to students for giving feedback
  • Students will fill in the feedback form.

Project Detailed Description:

Semester beginning

Ist month:

  • At the beginning of the semester coordinators enter list of the courses and faculties.
  • Faculty will create list of students in the course.

Month 2 to end of the semester:

  • Each faculty will give permission to students (who have regularly attended the classes) in the course to provide the feedback.
  • Students will login and give the feedback (they will fill the feedback form).
  • Preparation of statistics by the system
  • For each course, for each question, find the percentage of the students who ticked on ‘just right’
  • Overall statistics can be mailed to admin and Chairman month after month.

Initial stage:

1. Creating the login-id:

  • Admin will give the login id and password for the faculty and the coordinators.
  • All other users, Faculties will all register into the system, once.
  • When a student gets admitted they will be provided login and password to register into the system.
  • Login id of the students could be their register numbers (which is available at the time of admission)

2. Different permission for different users:

Faculties:

  • The faculty will create the list of the students who opted the course.
  • At the end of each month, Faculty will give the permission to student who are regular, to give the feedback for that course during that month.

Students :

  • Students can register to the system.
  • At the end of every month, when the student login, they get to know the list of courses for which they can provide feedback. They complete the feedback.

Coordinators :

  • At the beginning of the semester, prepare the course list and the corresponding faculty

Chairman and Admin :

They have the permission to see the overall statistics prepared by the system, using the feedback forms submitted by the students.

SYSTEM REQUIREMENTS:

Hardware Requirements

  • Processor: Windows 8.
  • Primary Memory: 2 GB RAM.
  • Hard Disk: 100 GB.
  • The above specified requirements are the minimum required to run the application

Software Requirements

  • Language used: Visual Basic (VB)
  • Database: M.S.Access
  • Platform : windows 8
  • Tools used: Visual Studio 2010.

Conclusion:

The “Online Student Feedback System” will be helpful for the students as well as the Chairman. Students are free to express their opinion on the course conduction and Chairman has the opportunity to know the manner in which the courses are conducted and perhaps advise the faculty in case the feedback is not satisfactory.

Download this Online Student Feedback System .Net Project Synopsis Code and Database Files.

Posted on

A Project Report on E-learning

Preface

  • This Website is Provide to the E-Learning in Higher Secondary School.
  • This E-learning Website Can be Also Provide Information About Question.
  • The User can get the Online Learning about Question.
  • This is a static dynamic website designed to E-learning.
  • The User can also fill own registration form.

Acknowledgement

We are very grateful and thankful to professors of my college. who give me a good guidance and gives suggestion about each and every topic which we study and research. They give me guidance about my current E-learning project.
We also thankful to my friends. who give me support to help to complete this project. And solve my all difficulties.
We are taking this opportunity to express our gratefulness to the principal and All staff.

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

Thank you to all person involved in this E-learning project.

Drawback of Existing System

  • As Current System is Window base So It’s Very Difficult.
  • Time-consuming Problem.
  • Only One Person is work at a time.
  • Difficult to Work For E-Learning Time Duration.

Need for new System

  • To E-learning Process Work Is Fast.
  • Reduce The Time Period for E-learning.
  • Paper work to be Remove.
  • Information stored in the database, which provides data security.

Tools & Technology

Software Requirement

1. FRONTEND:- PHP Version 5.2.6.
2. BACKEND:- My SQL.
3. BROWSER:- Google Chrome & Mozilla Firefox.

Hardware Requirement

1. Pentium(R) Dual-Core CPU.
2. 512 MB RAM for windows XP/windows7/windows8.
3. 20 GB HDD.

Data Flow Diagram

Context Level DFD

0 Level DFD for User

First Level DFD For Admin

Second Level DFD For Admin

Hierarchy Diagram

Data Dictionary

Registration Table

Sr No   Field Name     Field Type                   Field Size      Constraints
1 User_Id Int 06     A.I/P.K
2 Name Varchar 20 Not  Null
3 Address Varchar 50 Not  Null
4 Country Varchar 25 Not  Null
5 Email Varchar 30   Is_Unique
6 Password Varchar 20 Not  Null
7 Birth date Date Not  Null
8 Gender Varchar 6 Not Null
9 Pincode Int 6 Not  Null
10 Mobile Varchar 10 Not  Null

User Login Table

Sr. no Field Name Field Type Field Size Constraints
1    User_Id Int 6 A.I/P.K
2 Email Varchar 30 Not Null
3      Password Varchar 20 Not Null

Admin Login Table

Sr. no Field Name Field Type Field Size Constraints
1 Id Int 6 A.I/P.K
2 Email Varchar 30 Not Null
3      Password Varchar 20 Not Null

Feedback Table

Sr. no Field Name Field Type Field Size Constraints
1 Id Int 6 A.I/P.K
2  Name Varchar 20 Not Null
3 Email Varchar 30
4   Comment Text Not Null

Add Question Table

Sr. no Field Name Field Type Field Size Constraints
1 Id Int 10 A.I/P.K
2 Q_ Name Varchar 200 Not Null
3 Q_Category Varchar 50 Not Null
4 Q_Cont Text Not Null

Form Design

Home Page


  • About Us Page
  • Education Page
  • Registration Page
  • Contact Us Page
  • User Login Page
  • Course Home Page
  • B.C.A Page
  • B.com Page
  • B.A Page
  • Admin Login Page
  • Admin Home Page
  • Registration Report
  • Login Report
  • Feedback Report
  • Change Admin Password
  • Add Question Page

Bibliography

During the development of E-learning project, We have gone through the following books and websites.

Books:-

• HTML, JavaScript, DHTML and PHP
• HTML using CSS

Websites:-

• Www.Google.com
• Www.W3schools.com
• Www.pustakalaya.com

Posted on

A Project Report On Online Certified Course

 Preface

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

Acknowledgement

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

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

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

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

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

Project Profile

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

Software Requirement:-

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

Drawback of Existing System

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

Need for new System

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

Data Flow Diagram

Context Level Diagram

0’Level DFD for User

O’Level DFD for Admin

DATA Dictionary

REGISTRATION TABLE

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

ADMIN LOGIN TABLE

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

NEWS TABLE

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

FEEDBACK TABLE

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

COURSE TABLE

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

Form Layout

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


Admin Home Page


Add Course Page


Update News Page


Admin Change Password


Feedback Suggession Page
Feedback Report
Registration Page

 

Posted on

A Project Report On Online Job Portal

Project introduction & Profile

Job portal is an application which connects employer and job seekers where employers are the source of the resources and the job seeker can find and apply for their targeted job. This document provides details about the entire software requirement specification for the online job portal.

Preface

  • This Job Portal website is providing to the online job portal system.
  • This website can be also providing information about online job.
  • The customer can get the online registration.
  • The Job Portal web application can be used by any employee to apply job and any employer are post to job.

Drawback of Existing system

  • Existing system are a failing in providing quick operation
  • Cost is high as well.
  • Processing very lengthy and time consuming.
  • More time consume for before generation.

Need for new System

1. Proposed Job Portal system consists of 3 modules: Job Seeker, Employer and Administrator.

2. Online Job Portal will provide the fast operation and low cost expense than old system.

3. Easy job search, which is a job seeker need

SOFTWARE REQUIREMENT

Operating System : Window XP, Windows 7
Front –End : HTML, Java Script, PHP
Back-End : PHP, MYSQL
Supporting Server : Apache Tomcat 5.5 , WampServer

Hardware Requirement

Processor : Intel Pentium IV,2.4 GHz
RAM : 512 MB
Hard Disk Drive : 40 GB
Video : 800*600,1024*768 256 colors

Data flow diagram

First level DFD (continue)


DATABASE RELATIONSHIP


Data dictionary

Employees Table

FIELD TYPE NULL EXTRA PRIMARY KEY
Ee.id Int(4) NO Auto increment YES
Ee_fnm Varchar(40) NO – NO
Ee_pwd Varchar(10) NO – NO
Ee_gender Varchar(1) NO – NO
Ee_email Varchar(30) NO – NO
Ee.Add Varchar(300) NO – NO
Ee_phno Varchar(10) NO – NO
Ee_mobileno Varchar(10) NO – NO
Ee_current_location Varchar(20) NO – NO
Ee_annual_salary Int(10) NO – NO
Ee_current_industry Varchar(20) NO – NO
Ee_qualification Varchar(10) NO – NO
Ee_profile Varchar(10) NO – NO
Ee_resume Longtext NO – NO

Employers table:

FIELD TYPE NULL EXTRA PRIMARYKEY
Er_id Int(4) NO Autoincreament YES
Er_fnm Varchar(30) NO – NO
Er_pwd Varchar(10) NO – NO
Er_company Varchar(30) NO – NO
Er_add Varchar(100) NO – NO
Er_ph Varchar(10) NO – NO
Er_email Varchar(30) NO – NO
Er_company_profile Varchar(300) NO – NO

Contact table

 

FIELD

  

TYPE

  

NULL

  

EXTRA

  

PRIMARYKEY
Cont_id Int(4) NO Autoincreament YES
Cont_fnm Varchar(30) NO – NO
Cont_email Varchar(20) NO – NO
cont_query Varchar(300) NO – NO

Job table

 

FIELD

  

TYPE

  

NULL

  

EXTRA

  

PRIMARYKEY
J_id Int(4) NO AUTOINCREAMENT YES
J_category Varchar(40) NO – NO
J_owner_name Varchar(30) NO – NO
J_title Varchar(30) NO – NO
J_hours Float(3,1) NO – NO
J_salary Int(10) NO – NO
J_experience Int(3) NO – NO
J_discription Varchar(300) NO – NO
J_city Varchar(20) NO – NO
J_active Int(1) NO – NO

Application table:-

 

FIELD

  

TYPE

  

NULL

  

EXTRA

  

PRIMARYKEY
A_id Int(4) NO Autoincreament YES
A_uid Varchar(30) NO – NO
A_jid Varchar(30) NO – NO

Category Table:-

 

FIELD

  

TYPE

  

NULL

  

EXTRA

  

PRIMARYKEY
Cat_id Int(4) NO Autoincreament YES
Cat_nm Varchar(30) NO – NO

Screen Shots

Job Portal Home Page


Employee Registration Page


Admin Page


Manage Job Page


Add Category Page


Recent Contact Page


Job Post Page

Posted on

A PHP Project Report & Source Code on E-Shop

Acknowledgement

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

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

Project Profile

Project Title: Online Shopping System

Hardware Requirement:- 

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

Software Requirement:- 

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

Need For New System

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

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

Data Dictionary:

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

HOME PAGE


USER LOGIN


Advertise Form


CUSTOMER REGISTRATION


CUSTOMER ORDER


ABOUT US
CONTACT US
ADMIN LOGIN
ADMIN FORM
CUSTOMER ORDER REPORT

 

Posted on

E-Books Download PHP Project

PREFACE

The age of information has gone; The correct area is the Age of The Knowledge. This having knowledge would be higher resources from the society & at the same time would be earning the higher returns. But Knowledge is important to student, it is made mandatory for M.sc IT & CA  Students to work on a practical at some industrial organization & develop a comprehensive project.

Here is the detailed report on the project “E-Books Download” prepared. It is  developed on PHP & MYSQL with tables and forms. At last would only like to say that the practical education at COLLEGE has been very knowledgeable experience for us. we have tried my level best to produce the best output.

ACKNOWLEDGEMENT

The present of this PHP Project report gives us the feeling. As the final frontier achieving a Msc IT& CA, the actively of going through industrial orientation has bridged the gap between the academics and practical and real life work for us. It has prepared us to apply ourselves to become good IT professional. Naturally, it requires lot of people support to complete this project. We take this opportunity to acknowledge their supports to us.

We are specially Thanks to “Mr. ” Director of our college to give us opportunity to develop a project.

We sincerely thank our department for the academic advancement, it has finally provide us and opportunity for project work. We thank Mr. and head of department for their support through the E-Books Download project.

PROJECT PROFILE

Operating System: Windows XP & onwards

Technology Used:  HTML, JavaScript, CSS, PHP

Editor : Dreamweaver 8

Database: MySql

Diagrams

Activity Diagram For User


Activity Diagram For Admin


Data Flow Diagram (Dfd)
E-R Diagram
Usecase Diagram For Admin
Usecase Diagram For User

Output Screens:

DataBase Structure

  • Admin Table
  • Register table
  • BooksInfo
  • Categories
  • Feedback
  • BackGround
  • Photo

Home Page

In Home Page user can see the books photo, links related to site, last added Books, and Login Form.Home page Contains The Header And Footer That Contain The Different Link.

Registration Form

If User Want to Member then user need to fill up all the Details Which are Display in register Form.
After Fill up All The Information user Can Purchase the Books.

About Us

  • This Page Contain The Site Information like What’s Purpose,What’s Provides .
  • Contact Us
  • This Page Contain The Contact Us.

Help

Help Related To The Site like How to Login,How To Join,How To Purchase E-Books…
.
If User Login Then Page Will be (User Home)


Here User see the Different Categories From Which user Can select for EBooks Purchase.
Different links are Display in this page from which user can select , like feedback , logout etc.

If User Select Categorie Then Page

  • EBooks are Display related to the selected Categories
  • User Can Purchase The EBooks by Just Clicking on the Add To Card link.
  • Author name,Publisher,edition,size of EBooks are Display In This Page.

Feed Back Form

If User Want To send feedback then user need to fill up all the Details which are Display in Feed back Form like name, E-Mail, And Comments.

Change Profile

  • Here User Can See the his profile .
  • User Can also change the profile in this page.

Change Profile Photo Form

If User Want to change His Profile Photo then Must Need To Browse New Photo in this Page.

Change user Password

  • User Can Change The ID and Password in This Page.
  • User Need To Add old ID and old Password For Changing Password.

If Admin Login Then Page Will be( Admin Home)

Different links are Display from which admin can select any option.

Edit/Delete Books

  • Admin see all the EBooks With Edit And Delete Links.
  • Title, Categorie, author, publisher, price, size of EBooks Are Also Display in This Page.

Edit / Delete Categories

  • This Page Display all The Categories With Edit and Delete Links.
  • Admin Can Delete Multiple EBooks By Selecting More EBooks.

Add Books

  • Admin Need To Fill up All the Books Information for Uploading a New Books.
  • Admin can add the EBooks through this page.

Add Categories

Admin can add/edit the categories through this page.

View User Info.

  • Admin see all the user information in this page.
  • Admin can delete the User by clicking on delete link.

View Feedback

  • Admin see the Feedback in this page.
  • Admin can delete the feedback send by user.

Change Admin Password

Admin can change the ID and Password in this page.

Change About Us.

Admin can Change The About By Using This Page.

Change Background image

Admin Can Change The Site Background By Browsing Background Image in This Page.

Change Home Page Photo.

Admin can Change The Home Page Photo in this Page.

Bibliography

Following EBooks were referred to during the development of the project:

  • Introduction to website development
  • Website using PHP
  • MYSQL Database Management System
  • Professional guide to JavaScript

Following Websites were referred to during the development of the project:

  • http://www.php.net/
  • http://www.learnjavascript.net/
  • http://www.sourcecode.com/

Following EBooks were referred to during to the development of the project:

  • Beginning PHP, Apache
  • MYSQL® Web Development
  • PHP Manual
Posted on

A Project Report on Hospital Management System

This Hospital Management System software is designed and developed to the specific requirements of any hospital to provide better services to patient and also to reduce the manual workload on staff and most important to maintain the case history of patients, their diagnosis process and also for consultation purposes.

This software provides with the following modules:

  • Administration
  • Reception
  • Finance Department / Accounts
  • Stores & Pharmacy
  • Diagnosis
  • Enquiries

The significant features of all the above modules are listed below:

Administration:

This is a very important module and has to be handled by only the authorized persons.

This module is basically used to maintain all that data which is mostly a one-time entry and based on this data only the total software modules will function.

The important Features of this module are :

It provides the client to

1. Specify the services available with them – like Floors, Wards, Rooms, Beds, ambulance, catering and all such other types of services, which the hospital provides.

2. Specify the different types of Departments / Sections with their respective hierarchy of staff.

3. Recruit staff and also visiting Doctors/ Surgeons, their specialization, and availability. activities relating to payroll.

Reception:

Handling the Front office / Reception activities like

Patient Registration
Renewal for O.P
Billing for O.P
Doctor/Surgeon Availability

Diagnosis:

This is a very important module that takes care of patient’s medication details i.e. case history.

The Doctor or the respective hierarchy will enter the diagnosis process and any important note or remark.

All the data that is maintained in the system can be retrieved, as required, from the case history of the patient.

Data pertaining to patient including Scan images, video clips, medication details can be maintained in the system.

Stores & Pharmacy:

This module takes care of the stock of medicines to be maintained in the hospital.

It checks the re-order level of the stock and informs the respective personnel about the status of the stock.

It ensures that there is always availability of medicine in the stores.

Keeps track of the information of distributors area wise and also provides with a report from whom the medicine is mostly purchased.

The pharmacy plays a very important role in the hospital. Through this the medicines to the patients are given. The bill is automatically updated in the patient’s account. The out- patient bill is given to the patient and the amount will be collected at the Pharmacy. In-patient bill will be collected by the Finance Dept, which in turn comes from the Pharmacy.

The indent placed from the pharmacy is given to the stores dept immediately and based on that they can take a decision for purchase of the medicines.

Accounts:

This module maintains the total information relating to the bill and receipts maintained within the hospital.

The salary for the staff is handled by the Accounts Dept.

The bills produced from the pharmacy and all other sections maintained here.

Some important registers maintained are as follows.

Registers Maintained:

Daily Collection Register
Purchase Register
Receipts & Payments Register
Cash Register
Bank Register
Patient Register
Services Register

Different reports based on the queries are being generated to assist the management in getting qualitative reports.

Enquiries:

This is very helpful at the reception to find out the details available in the hospital.

Through this module the information relating to patients, services available, doctors / surgeons availability, cost of different tests conducted in the hospital etc.

Pharmacy:

This module supports for 2 users to work. One is Administrator (for Pharmacy) and the other is a normal Pharmacy User. The menu options given for both user logins are listed below.

Pharmacy Administrator User:

• Pharmacy

• Distributor

• Stock Master

• Transactions
a) Purchases
– Order Form
– Delivery Challan

• Reports
a) Medicines
– Medicine wise Stock Details
– Required Medicines
– Expiry Medicines

b) Distributor
– Medicine wise Distributor Details
– Distributor wise DC Details
– Distributor wise Order Details

c) Stock
– Dead Stock
– Less Stock
– Re-Order

• Transaction Based
a) Purchases Report
– Monthly
– Weekly
– Daily

b) Sales Report
– Monthly
– Weekly
– Daily

Pharmacy User:

• Sales
– to Patients
– to Outsiders

• Medicine Details
–  Medicines Required
–  Less Stock (than ROL)

• Enquiries
a) Stock
– Available
– Required

b) Patients
– Prescribed Medicines

Collection Center:

This is the place where the patient pays any type of bill in the hospital and also it is this place where all the information of patients, their bills etc.. are maintained.
Menu for this login is listed below.

• Patient Details
a) Bill Details
– OP Registration
– OP Renewal
– Pharmacy
– Tests Conducted
b) Discharge Certificate

• Distributor Details
a) Bill Details
b) DC
c) Invoice

• View
a) Patient Details
b) Visit Details
c) Tests conducted
d) Bill Details
e) Discharge Details

f) Fee Details
g) OP Registration & Renewal
– OP General
– OP Renewal
– OP company
h) Test Fees

i) Company Details

j) Distributor Details
k) Bill Details
– Invoice Details
– DC Details
l) Address Details

Doctor User:

• Diagnosis
– Preliminary Tests
– Prescription
– Case History
– Direct to Specialist
– Direct to Collection Centre

• View
a) Patient Details
– Registration Details
– Case History
– Prescription Details

b) Test Details

c) Specialist Details

Font Applied For The Project :

Font Name: Times New Roman
For Titles:
Size: 12, Italic
Size: 10, Bold

System Requirements:

SERVER:
RAM : 2 GB (minimum)
Operating System : Windows
RDBMS : Oracle
Software : Microsoft ODBC for Oracle installed

CLIENTS:
RAM : 2 GB (minimum)
Operating System : Windows
RDBMS : Oracle – Client
Software : Microsoft ODBC for Oracle installed

Posted on

Hospital Management System Project Synopsis

This Hospital Management System package is used to automate all the activities of the Hospital. It includes all features which are regularly used in the Hospitals and also it provides with more features like  query based reporting system, reports maintained for Administrative purposes.

The main modules in this system are:

  1. Administration
  2. Accounts
  3. Reception
  4. Diagnosis
  5. Stores
  6. Enquiries

The important tasks of each module are as follows.

Administration:

This is the main module of the entire Hospital Management System software. Any important classification of data has to be started from here. If any new Service has to be added then it has to be done from this module. Basically all main data which ever is required has to be entered from this module. Employee Appointment, Resignation, Visiting Doctor appointment, Attendance of all the staff, Lab and Ward service information,etc.

The user in the module can access any information requiring be changing or viewing. The reports that are generated will be for the support of the management.

Accounts:

All the financial accounting required in the hospital is managed and maintained using this module. Bill or any transaction information relating to financial terms will be updated to the database and will be accessed in this module for entry in the respective ledgers or records so as to produce a report on all the transactions that take place in the hospital.

Query based reports are available to retrieve based on the selection of the user requirements such as  Reports having the details of how much money is spent on procuring medicines to pharmacy for a period of any duration, etc.

Reception:

This module is used to enter the details of the patients who come in as Out Patient(OP) and based on the information of the doctor they will be admitted as In Patient(IP). Once the patient registers as OP a number will be given to the patient based on the  treatment required and availability of the respective doctor. Once the patient registers and the time allocated for visiting doctor then the process of diagnosis starts.

 Diagnosis:

This module will help the doctor to update the patient diagnosis information in the case sheet of the patient. It also helps to keep track  of the patient medication process to update the condition  of the patient by verifying past cases, if any.

Posted on

Complete Hospital Management System Synopsis

The main aim of developing this Complete Hospital Management System is to provide best software to Hospitals to provide end to end solution for various departments. We have divided the Complete application into 7 major modules, Those are listed below:

1. Administrator
2. Patient Management
3. Materials Management
4. Laboratory Management
5. Employee Management
6. Financial Accounting
7. Operations Management

Each Module is divided into Sub Modules:

Administrator Module

In This module only admin people entered through Password and able to change or update as well as assign the responsibility to anyone. This module is further sub-divided into Doctor Registration, Employee Registration, Appointment Scheduling, and Hospital Administration

Doctor Registration:- In this sub-module all the information regarding the doctor are stored ex. Doctor ID, doctor name, highest qualification, specialization, as well as availability.

Employee Registration: -In this sub-module all the information regarding the employee is stored. Ex. Employee ID, Employee name, Employee address, Employee joining date.

Appointment Scheduling: – In this sub-module all the information regarding the appointment to the patient with the doctor are stored.

Hospital Administration: – In this sub-module all the information regarding Hospital Details

Patient Management:

In this module, all the information regarding patient are stored. This module is divided into various sub-modules. Inpatient Registration, Out-Patient registration, Itemized Patient Billing, Electronic Medical Records/Clinical History, Online Registration.

Materials Management

This module contain information related to complaint, equipment, Assets, Stock & others items maintenance management and keeps track of AMC of the equipments and the services offered by the vendor / manufacturer. This module is sub-divided into General Store Management, Inventory Management, Pharmacy Management, Blood Bank Management.

Laboratory Management

The Laboratory module is a sophisticated computer data management system designed to handle a large amount of data quickly and efficiently for all Pathology Laboratory disciplines, Clinical Pathology, Microbiology, Hematology, Serology, Cytology, Radiology, Biochemistry, and Neurology.

Employee Management

In this module, all the information regarding Employee is soared. This module is divided into various sub-modules; Attendance Management, Payroll Management. The employee management system incorporates attendance for staff, calculation of working hours, and daily, weekly, monthly and yearly analysis. The application accommodates all aspects of scheduling by assigning and maintaining records about different shifts and duty timings, hacking for scheduling conflicts with patient’s schedule, physician schedules, equipment availability and room availability. The employee management system incorporates attendance for staff, calculation of working hours, and daily, weekly, monthly and yearly analysis. The application accommodates all aspects of scheduling by assigning and maintaining records about Different shifts and duty timings, checking for scheduling conflicts with patient’s schedule, physician schedules, equipment availability and room availability.

Financial Accounting:

• Cash Book
• Bank Book
• Ledger Book
• Receipt/Payments
• Journal Voucher
• Insurance
• Invoice
• Purchase Orders
• Records

Operations Management:

In this module, all the information regarding all the available OPD. This module is sub-divided into Housekeeping, Ward Management, Bed Management, Operation Theater, Manager Assistant, Doctors Workbench, and Nursing Workbench.