Medical Center Management System (Devoloped using Java and MySQL)

This system is designed and developed with the intention of meeting the essential functionalities of a medical center. This system is developed using Java and MySQL by me and another four students as the second year second semester ITP project.

The receptionist,pharmacist,doctors,lab assistant and admin can log in and access the system using their username and password.

Basically,

A pharmacist can,

1.Add a drug to the inventory

2.Update received order details

3.Update the inventory when issuing drugs and send an alert to the suppliers when a drug is reaching its marginal level.

4.Suggest alternatives when the prescribed drug is not available.

5.Generate pharmacy and inventory related reports

A doctor can,

1.Prescribe drugs and medicine to a patient

2.View and update the medical history of the patient

3.Generate patient related reports

A receptionist can,

1.Register a patient

2.Deal with the payments and billing

3.Add/Reschedule/Cancel appointments

4.Manage sessions

5.Generate appointments and sessions related reports

6.Generate bills

A lab assistant can,

1.Update the system with the lab report details

2.Generate lab reports

An admin can,

1.Manage employee details

2.Create users

3.Manage assets

3.Calculate salaries

4. Generate salary reports

Going beyond our clients requirements we could implement a method to send a text message to the patient's given mobile number when an appointment is made.

Medical Center Management System

Below are some key interfaces of our medical center management system.

Comments

NoSQL vs SQL

I am sure most of you all are familiar with SQL database and have worked with MYSQL, Oracle or other SQL databases. And obviousely you must have heard of "NOSQL" as well. So in this blog post we'll see what this NoSQL is and the key differences between NoSQL and SQL. What is "NOSQL"? NOSQL stands for Not Only SQL.It is an approach to database design that can accomodate a wide variety of data models. NoSQL doesn't have a predefined schema and used for big data and real time web applications. There are several types of database types. 1.Key-Value : Stores data as key value pairs Ex: Redis, Riak, Memcached 2.Document : Stores data as documents (JSON,BSON,XML) Ex: MongoDB 3.Column : Stores data in column families as rows have many columns assosiated with. Ex: Cassendra 4.Graph : Stores entities(nodes) and relationships(edges) between them and represent it in a graph. Ex: Neo4j Benefits of NoSQL Basicall

Getting started with React js

In this blog post, I'm gonna explain you all about React js, a javascript technology that is used to create interactive single page applications.

New features of Java 10

Hello all! In this blog post I am gonna tell you about the new features of java 10.I am pretty sure all of you have heard of Java 10! Well, some of you might have dive in to Java 10 as well. Noo? Then this blog post will be a good beginning for you to learn about java 10 and its new exciting features. I am not gonna tell you about all the features but I will be focusing on the features that I found more interesting. 1.Local Variable Type Inference Java 10 onwards Java also will have the 'var' keyword like JavaScript. This allows you to specify a variable without mentioning the data type of that particular variable but Java compiler will identify the real data type of the variable you declared.And also note that this 'var' keyword can only be used when defining variables inside methods and variables inside blocks.Although Java 10 allows the users to define variables with 'var', that doesn't make Java a dynamically typed language because once the ty

Blog of Sachini Epa

Search This Blog