Hospital Management System (Using Database)

Hello Everyone,

Today, I am gonna publish my first database project which is based on hospital management.

Here’s a brief video on it:

It involves the below list of tables (with mentioned structure):

  1. PATIENT:
Column Datatype
PAT_ID VARCHAR2(10 CHAR)
PAT_NAME VARCHAR2(60 CHAR)
PAT_GENDER VARCHAR2(2 CHAR)
PAT_ADDRESS VARCHAR2(100 CHAR)
PAT_NUMBER NUMBER(11,0)
PAT_DOC_CODE VARCHAR2(10 CHAR)

2. PATIENT_DIAGNOSIS:

Column Datatype
DIAG_ID VARCHAR2(10 CHAR)
DIAG_DETAILS VARCHAR2(200 CHAR)
DIAG_REMARKS VARCHAR2(200 CHAR)
DIAG_DATE DATETIME
PAT_ID VARCHAR2(10 CHAR)

3. DOCTOR:

Column Datatype
DOC_CODE VARCHAR2(10 CHAR)
DOC_NAME VARCHAR2(60 CHAR)
DOC_GENDER VARCHAR2(2 CHAR)
DOC_ADDRESS VARCHAR2(200 CHAR)
DOC_DESIGNATION VARCHAR2(30 CHAR)
DOC_NUMBER NUMBER(11,0)

4. BILL:

COLUMN DATATYPE
BILL_NO INTEGER
PAT_ID VARCHAR(10 CHAR)
PAT_NAME VARCHAR2(60 CHAR)
PAT_GENDER VARCHAR2(2 CHAR)
PAT_ADDRESS VARCHAR2(100 CHAR)
DOC_NAME VARCHAR2(160 CHAR)
AMOUNT NUMBER(19,9)

 

Please find below the lucid chart for better explaination:

 

 

 

 

 

 

 

 

 

 

 

 

I have provided sql files for table creations which includes the sample data to be inserted for PATIENT, PATIENT_DIAGNOSIS and DOCTOR.

Apart from this, I have also included the trigger/sequence file which includes the trigger/sequence creation statements along with the sample insertions for fine table in which we only need to insert value for columns BILL_NO and AMOUNT and the remaining details are fetched automatically using triggers from the status tables ( PATIENT, PATIENT_DIAGNOSIS and DOCTOR).

 

Here’s the link for all files: CLICK HERE (Github Repository)

If you liked the stuff, please leave positive comment and in case you have any feedback, feel free to share that in comments!

Starting Basics for running a bash script

First of all you need to open the terminal [Ctrl + Alt + T] OR Konsole [for kubuntu]

Type in “pwd” to get the present working directory.

Then use cd to change the directory location to the location of your script.

 

For example:

$ pwd
/home/sh.gulati
$ cd Desktop/test

 

I have changed the directory to Desktop/test/ because my script test.sh lies inside test folder.

So, as now we are in the directory which contains our script file we need to edit it and write something inside it.

As the beginning program, we start with echo command.

Contents of my test.sh:

#!/bin/bash
echo "This is my first Bash script!!"

 

Now to run this script, we first need to give execute permissions to our script, for that we need to type the following command in terminal:

chmod +x test.sh

Now in order to run it, type in terminal:

./test.sh

And you will get the output as:

This is my first Bash script!!

which was the expected output as echo prints the things you write inside it.

 

More about echo:

Echo can be used in 3 ways:

echo statement
echo 'statement'
echo "statement"

However, both 3 of them the output will vary!

For example:

I set a variable named test=”Blogging”

Now for all the 3 types:

#!bin/bash
echo $test Simplified
echo '$test Simplified'
echo "$test Simplified"

 

Output for the above statements:

 

Blogging Simplified
$test Simplified
Blogging Simplified

As you can see while using single quotes we are unable to print the variable value.

Note:

1 more thing is to be kept in mind while using echo without any quotes that if we want to use special symbols we need to add an escaping character infront of it in order to get it printed without getting error.

For example:

echo testing (here)
gives me an error!
Whereas:
echo testing \(here\)

will run without any problem when we use \ as escaping character.

 

Check out the next post to continue learning bash scripting.

Hope you have a good day! 🙂